Microsoft Excel 2016 Intermediate
Course

Microsoft Excel 2016 Intermediate

This video course with practice exercises is for people with basic Microsoft Excel experience who would like to brush up on their skills with more features, tips and tricks.

Simon Sez IT
Updated May 15, 2019

Course Overview

Continue your Microsoft Excel journey with Excel 2016 intermediate course. If you've been meaning to brush up on your Excel skills but weren't sure where to start, our expert authors make this complex subject easy to digest. This bundle includes 4.5 hours of video instruction and practice downloadable exercise files.

Target Audience

Administrators, Graduates, people in Financial Services, Accountancy.

Learning Objectives

In this course you will learn:

  • Tips and tricks to make the most of the ribbon
  • Hotkeys and different views in Excel
  • INDEX, MATCH
  • VLOOKUP, HLOOKUP
  • INDIRECT and OFFSET
  • Named Ranges
  • Dynamic functions and how they work
  • More advanced charts like Waterfall and Sunburst
  • Detailed chart formatting
  • PivotTables, Pivot Charts, slicers and Power Query