For information on course costs and booking onto a course, please click here. For any queries please contact us on business@nptcgroup.ac.uk or call: 0330 81 88 100Welcome, Guest

Microsoft Excel 2019 Advanced

Course Overview

Get beyond the basics and supercharge your current skill level in Excel. With this expert-led video training course, you'll gain an in-depth understanding of more advanced Excel features that delve into high-level consolidation, analysis and reporting of financial information.

Learning Objectives:

In this course you will learn:

  • What's new/different in Excel 2019
  • Advanced charting and graphing in Excel
  • How to use detailed formatting tools
  • Lookup and advanced lookup functions
  • Financial functions including calculating interest and depreciation
  • Statistical functions
  • Connecting to other workbooks and datasets outside of Excel e.g. MS Access and the web.
  • How to create awesome visualizations using sparklines and data bars
  • Mastery of PivotTables and Pivot Charts
  • Scenario Manager, Goal Seek and Solver
  • Advanced charts such as Surface, Radar, Bubble and Stock Charts

Course Format:

  • This is a video-led course.
  • This course includes practice exercise files.
  • This course is suitable for Windows users.