Microsoft Excel - What’s New!

Find out about excels latest features and how you can use it.

Description

This course covers the latest released features in Excel including:

  • Smarter caches
  • Reduced the number of queries
  • Column type indicator in Query Editor preview column headers
  • Remove blanks via Column Filter menu
  • Reorder Queries and Query Groups inside Query Editor via drag and drop gestures
  • Convert Duration values to Years
  • Hints for “sample input values” in the “Change Type with Locale” dialog
  • Support for whitespace and line feeds in the Query Editor preview
  • Ability to disable previews from the Navigator window

Prerequisites

Anyone with Excel experience.

Target audience

This course is intended for students who are experienced Excel users who want to take advantage of excels latest functionality.

Similar courses

Learn how to use Microsoft Excel to create spreadsheets and workbooks that you can use to store, manipulate, and share your data. This course is intended for students who wish to gain the foundational understanding of Microsoft Excel.

More Information

Gain the knowledge and skills to become familiar with advanced data-management features and functionality of Microsoft Excel. You will automate some common Microsoft Excel tasks, apply pivot analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data.

More Information

This course will provide you with a comprehensive introduction to Microsoft Excel Tables, PivotTables and PivotCharts. Creating a PivotTable from a list of data in Excel is an excellent way to analyse the information collected. This course covers how to create a PivotTable and chart the results within in a PivotChart.

More Information