Excel 2016 Intermediate
IC0974

Excel 2016 Intermediate

This course takes you well beyond the beginner stage to become an Excel power user. Learn the additional advanced skills you need to become more valuable at work. You will learn more advanced ways of working with data, how to master charts and graphs and how to work with dynamic formulas and named ranges. The course includes great exercise files as takeaways.

New Course - Not Enough Reviews Yet

Course Goal

  • Start your journey in data analysis in Excel
  • Learn all about LOOKUP functions and INDEX MATCH
  • Master dynamic formulas
  • Bring your data to life with brilliant charts and graphs
  • Start using PivotTables and Power Query

Audience

  • All

Exam/Certificate


Lesson Plan

2
Reviewing Excel Terminology
3
Tips and Tricks in the Ribbon
4
Escaping the
5
Common Hotkeys
6
Special Hotkey Commands
7
Defining Your Excel View

8
Defining Lookups and Arrays
9
Using VLOOKUP and HLOOKUP
10
Using MATCH
11
Using INDEX
12
Mixing LOOKUPS, INDEX, and MATCH

13
What is important to you?
14
Simple and Quick Name Definitions
15
Accessing and Using the Name Manager
16
What can Names do?

17
What is a Reference?
18
Using Indirect
19
Using Offset
20
Using Row, Column, and Cell
21
Creating Dynamic Named Ranges
22
Best Practices Regarding Dynamic Functions

23
Charts and Graphs Terminology
24
Line, Scatter, and Bar Charts
25
Radar and Surface Plots
26
Waterfall, Pie, and Sunburst Charts
27
The Box and Whisper Plot and Histograms (Statistical)
28
Chart Formatting In Detail
29
Mixing Chart Types
30
The Bing Maps App

31
How Do You Know If You're Working With Data?
32
Introducing DataTables
33
Excel Data Model Relationships
34
Data Slicers
35
PivotTables
36
Power Query / Get And Transform
37
Pivot Charts
38
The GETPIVOTDATA Function

39
Course Summary
40
Practice Exercise files - download

Instructor

Simon Calder

4.8 Average Rating

4 Reviews

49 Students

5 Courses

Simon Calder

President

Simon Sez IT makes business and technical software simple to learn. We teach people to use the most popular business software including Microsoft Office, Microsoft Project, Photoshop, Web Design and QuickBooks. We've been teaching online for over ten years.

It all started when the owner, Chris "Simon" Calder was working as a Project Manager in IT for one of Los Angeles most prestigious cultural institutions, LACMA. He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course which he sold on DVD via eBay. Fast forward to now and Simon Sez IT has taught hundreds of thousands of students through its online course platform and popular YouTube channel.


More Courses by Simon Calder:

Complete Excel 2019 for Beginners
Complete Excel 2019 for Beginners

This Excel course is perfect for those who are new to Excel and who are using Excel 2019 or Excel 365 editions. In th...

5.0

Average Rating

Excel 2019 Advanced
Excel 2019 Advanced

Move your knowledge beyond the basics and supercharge your Excel capabilities. With this 8-hour, expert-led video tra...

5.0

Average Rating

Excel VBA Programming for Beginners
Excel VBA Programming for Beginners

Do you work with data in Excel every day? Do you want to take your skills to the next level and improve your efficien...

4.0

Average Rating

View All Courses

Student Feedback

New Course - Not Enough Reviews Yet

Annual Subscription to All Courses
$1599

Or subscribe to this course for

$219


Training 5 or more people?

Unlimited access for your entire SAP team including admin platform and premium reporting.

SAP Training for Businesses

Language: English
Level: Intermediate
Duration: 4.5 hours
Type:  Instructor-led
Release: Enterprise Software
Category: Business Productivity

SAP students

51

student views.
Join them!


Related Courses