Excel 2016 Advanced
IC0973

Excel 2016 Advanced

Go beyond the basics and supercharge your Excel capabilities. With this expert-led training course, you’ll gain an in-depth understanding of the most useful and advanced business features of Microsoft Excel that can help you delve into high-level data consolidation, analysis, and reporting of financial information.

New Course - Not Enough Reviews Yet

Course Goal

  • Take your spreadsheet knowledge to the next level
  • Learn to use statistical functions
  • Master financial functions
  • Master data analysis tools such as PivotTables and Pivot Charts
  • Put Scenario Manager Goal Seek and Solver to work

Audience

  • All

Exam/Certificate


Lesson Plan

2
Course Structure
04:59 mins

3
Functions - Part 1
15:41 mins
4
Functions - Part 2
10:44 mins
5
Autosum
06:22 mins

6
How Date and Time Works
11:20 mins
7
Basic Date and Time Functions
11:56 mins
8
Complex Date and Time Functions
14:45 mins

9
Using Text Functions - Part 1
14:38 mins
10
Using Text Functions - Part 2
15:07 mins

11
Using Logical Functions
11:14 mins
12
Exercise 01
02:20 mins

13
HLOOKUP Function
15:17 mins
14
VLOOKUP Function
08:57 mins
15
Exercise 02
06:05 mins

16
Financial Functions and Terminology
11:20 mins
17
Personal Financial Functions
10:41 mins
18
Professional Financial Functions
07:48 mins
19
Depreciation
05:14 mins
20
Exercise 03
01:45 mins

21
Statistical Functions for Description - Part 1
14:23 mins
22
Statistical Functions for Description - Part 2
14:27 mins
23
Statistical Functions for Forecasting - Part 1
12:16 mins
24
Statistical Functions for Forecasting - Part 2
12:29 mins
25
Exercise 04
01:44 mins
26
One Click Forecasting
09:16 mins
27
Statistical Functions for Inference
12:52 mins

28
Connecting to Other Workbooks
15:21 mins
29
Connecting to Access Databases
15:20 mins
30
Connecting to Web Data Sources
10:11 mins
31
Get and Transform
15:07 mins
32
Exercise 05
05:57 mins

33
Introduction to Tables
12:04 mins
34
Working with Tables
10:37 mins
35
Table References
08:09 mins
36
Table Styles
04:59 mins
37
Exercise 06
01:40 mins

38
Introduction to Pivot Tables
11:01 mins
39
Working with Pivot Tables
14:58 mins
40
Filters and Slicers
14:23 mins
41
Pivot Charts
08:42 mins
42
Exercise 07
02:48 mins

43
What If Analysis
13:38 mins
44
Scenario Manager
10:27 mins
45
Goal Seek
07:10 mins
46
Solver
12:29 mins
47
Exercise 08
01:33 mins

48
Area Charts
06:42 mins
49
Surface Charts
04:45 mins
50
Radar Charts
05:12 mins
51
Bubble Charts
07:06 mins
52
Sparklines
09:58 mins
53
Stock Charts
10:35 mins
54
Exercise 09
03:57 mins

55
Introduction to Excel Web App
10:47 mins
56
Using the Excel Web App
11:31 mins

57
Closing Message
00:49 mins
58
Course files for download - zip
59
Course Exercise files for download - zip

Instructor

Simon Calder

4.8 Average Rating

12 Reviews

87 Students

12 Courses

Simon Calder

Teaching Business Software

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...

4.8

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 2016 Intermediate
Excel 2016 Intermediate

This course takes you well beyond the beginner stage to become an Excel power user. Learn the additional advanced ski...

New Course - Not Enough Reviews yet

View All Courses

Student Feedback

New Course - Not Enough Reviews Yet

Subscribe to All Courses
Subscribe

Or subscribe to this course for

$395


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: Expert
Duration: 9 hrs
Type:  Instructor-led
Release: Enterprise Software
Category: Business Productivity

Related Courses