• MS Office 2019 FAQ

    All computer desktops in classrooms and public access spaces are installed with MS Office 2019. All new or replacement staff desktop computers and laptops are also installed with MS Office 2019. Except for use of onedrive, there is no difference with MS Office 2016.

  • The first time you launch an MS Office application you have two options:

    • Open Other Workbooks/Documents, to locate an existing file.
    • Blank workbook/document, to create a new file.

    Thereafter, you can open a file from the Recent list, This PC, or Browse.

    Open a file

    Top Tip: You can keep a file at the top of the Recent list; hover over the file you want to keep and click the pin icon. To save a file, choose save to This PC, or Browse.

    In MS Office 2016, advanced formatting options are available in new task panes. Right click your object, for example, a picture or chart element. Make your selection from the shortcut menu. The new Format pane appears with options that are tailored for the selected object.

    Format chart

    Clip Art has been replaced with Bing-powered images.

    Click Insert, Online Pictures.

    Insert Online Pictures

    When using images from Bing, you are responsible for respecting copyright, and the license filter in Bing can help you choose which images to use.

    You can collapse or expand parts of a document with just a click.

    Comments now have a Reply button. And when a comment is addressed and no longer requires attention, you can mark it as done.

    You can insert online videos and watch in Word, without having to leave the document.

    When you click a chart, you’ll see a simpler Chart Tools ribbon. With just a Design and Format tab, it should be easier to find what you need. 

    Three new chart buttons let you quickly pick and preview changes to chart elements (like titles or labels). See Format your chart.

    Excel now recommends the most suitable charts for your data. Give this feature a try when you create your first chart.

    The Quick Analysis tool lets you convert your data into a chart or table in two steps or less. See Analyze your data instantly.

    Flash Fill is like a data assistant that finishes your work for you. To see when this feature comes in handy, see Split a column of data based on what you type.

    Picking the right fields to summarize your data in a PivotTable report can be a daunting task. Now you can get some help with that. When you create a PivotTable, Excel recommends several ways to summarize your data, See Create a PivotTable to analyze worksheet data.

    The new Excel Data Model lets you create PivotTables based on multiple tables in Excel. By importing different tables, and creating relationships between them, you’ll be able to analyze your data with results you aren’t able to get from traditional PivotTable data. See Create a Data Model in Excel.

    Visit the Microsoft Office Training Center. IT Training team provide self paced study units for staff and students.