Excel 2019 Advanced
IC0971

Excel 2019 Advanced

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

1  Reviews   5.0 of 5.0

Course Goal

  • Take your spreadsheet knowledge to the next level
  • Learn to use statistical and 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

3
Functions - Part 1
4
Functions - Part 2
5
Autosum

6
How Date and Time Works
7
Basic Date and Time Functions
8
Complex Date and Time Functions

9
Using Text Functions - Part 1
10
Using Text Functions - Part 2

11
Using Logical Functions
12
Exercise 01
13
Exercise 01 Answer spreadsheet

14
HLOOKUP Function
15
VLOOKUP Function
16
Exercise 02
17
Exercise 2 Spreadsheet
18
Exercise 02 Answer spreadsheet

19
Financial Functions and Terminology
20
Personal Financial Functions
21
Professional Financial Functions
22
Depreciation
23
Exercise 03
24
Exercise 03 Spreadsheet
25
Exercise 03 Answer Spreadsheet

26
Statistical Functions for Description - Part 1
27
Statistical Functions for Description - Part 2
28
Statistical Functions for Forecasting - Part 1
29
Statistical Functions for Forecasting - Part 2
30
Exercise 04
31
Excercise 04 Spreadsheet
32
Exercise 04 Answer Spreadsheet
33
One Click Forecasting
34
Statistical Functions for Inference

35
Connecting to Other Workbooks
36
Connecting to Access Databases
37
Connecting to Web Data Sources
38
Get and Transform
39
Exercise 05
40
Exercise 05 Answer Spreadsheet

41
Introduction to Tables
42
Working with Tables
43
Table References
44
Table Styles
45
Exercise 06
46
Exercise 06 Spreadsheet
47
Exercise 06 Answer Spreadsheet

48
Introduction to Pivot Tables
49
Working with Pivot Tables
50
Filters and Slicers
51
Pivot Charts
52
Exercise 07
53
Exercise 07 Spreadsheet
54
Exercise 07 Answer Spreadsheet

55
What If Analysis
56
Scenario Manager
57
Goal Seek
58
Solver
59
Exercise 08
60
Exercise 08 Spreadsheet
61
Exercise 08 Answer Spreadsheet

62
Area Charts
63
Surface Charts
64
Radar Charts
65
Bubble Charts
66
Sparklines
67
Stock Charts
68
Exercise 09
69
Exercise 09 Spreadsheet data file
70
Exercise 09 Answer Spreadsheet

71
Introduction to Excel Web App
72
Using the Excel Web App

73
Closing Message

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

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

5.0

Average Rating

Reviews

Annual Subscription to All Courses
$1599

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: 8.00 hours
Type:  Instructor-led
Release: Enterprise Software
Category: Business Productivity

SAP students

444

student views.
Join them!


Related Courses