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

Book a demo Try it for free

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

Related learning

Microsoft Excel 2016 BeginnersCourse ⋅ 540 mins

Microsoft Word 2016 Beginner to Intermediate LevelCourse ⋅ 180 mins

Excel 2007 IntermediateInteractive ⋅ 144 mins

Microsoft Excel 2013 BeginnersCourse ⋅ 600 mins

Explore more technology skills

IT Software

Web Design and Development

Data & Analytics

Design and Animation

Gaming and Games Development

Devops, Networking and Security

Programming and Web Development

Computer Science and Engineering

Simon Sez IT

GLOBAL

Self-paced, affordable software training is what Simon Sez IT is all about. They teach people to use the most popular business software including Microsoft Office, Microsoft Project, Photoshop, Web Design and QuickBooks®️. Their approach to teaching comes from their passion to fully explain how something works. They don’t skirt around the edges. With 50+ courses and over 1000 learning resources now available in Go1 globally, Simon Sez IT makes business and technical software simple to learn. From Excel to photo editing, their step-by-step tutorials will kickstart your software skills and help you learn IT. Simon Sez IT is based in the US, however all of their content is globally relevant.