0

ecommerce/course.login

ecommerce/course.or, ecommerce/course.create_accountCreate an account in checkout page
Excel

Advanced Excel

Get 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-relevant advanced features of Microsoft Excel. In this course, we’ll dive into high-level consolidation, analysis, and reporting of financial information.

4.6
(452 ratings) 980 students



Enroll now


What you will learn

What’s new/different in Excel 2019
Advanced charting and graphing in Excel
How to use detailed formatting tools
Lookup and advanced lookup functions
Financial functions including calculating interest and depreciation
Statistical functions
Connecting to other workbooks and datasets outside of Excel, e.g. MS Access and the web.
How to create impressive visualizations using sparklines and data bars
Mastery of PivotTables and Pivot Charts
Scenario Manager, Goal Seek and Solver
Advanced charts such as Surface, Radar, Bubble and Stock Charts

Who should take this training

Prerequisites

  • Microsoft Excel 2013+ or Office 365 (Some features may not be available in earlier versions)
  • Experience with Excel formulas is recommended, but not required (we'll review the fundamentals)

Target audience

  • Excel users who want to learn how to write advanced formulas from scratch. Anyone hoping to expand their analytics skill set, work efficiently with data, and take their career to a new level.

About this training

  • Course Formats

    This is a video-led training course. You can preview some videos in the pane above. This course includes practice exercises so you can practice as you learn. This course is suitable for Windows users.

    This course is also suitable for Office 365 users.

Course Language : EN
On-demand video
Full lifetime access to videos
Downloadable resources
Assignments
Certificate of Completion
Enroll now

Training options

Only Videos

$ 30

  • Full lifetime access to videos
  • Downloadable resources
  • Certificate of Completion
  • Hours of Individual Coaching

Blended

$ 290

  • Full lifetime access to videos
  • Downloadable resources
  • Certificate of Completion
  • 10 Hours of Individual Coaching
Save 10%

Blended

$ 520 $ 495

  • Full lifetime access to videos
  • Downloadable resources
  • Certificate of Completion
  • 20 Hours of Individual Coaching
Save 20%

Blended

$ 810 $ 648

  • Full lifetime access to videos
  • Downloadable resources
  • Certificate of Completion
  • 30 Hours of Individual Coaching

Course Content

1. Introduction to Excel 2019 Advanced
1.Introduction to the Course 06:39 mins
2. Course Structure 04:20 mins
2. Functions
1. Functions - Part 1 13:39 mins
2. Functions - Part 2 08:04 mins
3. Autosum 06:02 mins
3. Date and Time Functions
1. How Date and Time Works 10:00 mins
2. Basic Date and Time Functions 09:44 mins
3. Complex Date and Time Functions 10:38 mins
Date Functions - Example 1
Date Functions - Example 2
4. Text Functions
1. Using Text Functions - Part 1 12:21 mins
2. Using Text Functions - Part 2 12:12 mins
Text Functions - Example 1
Text Functions - Example 2
5. Logical Functions
1. Logical Functions 09:45 mins
Exercise 01 - Practice 01:58 mins
Exercice 01
Answer Exercise 01
Logical Functions - Example 1
Logical Functions - Example 2
6. Lookup Functions
1. Lookup Functions - Part 1 14:02 mins
2. Lookup Functions - Part 2 07:57 mins
Exercise 02 - Practice 05:37 mins
Exercice 02
Answer - Exercise 02
Lookup Functions - Example 1
Lookup Functions - Example 2
Lookup Functions - Example 3
7. Financial Functions
1. Financial Functions and Terminology 08:52 mins
2. Personal Financial Functions 09:19 mins
3. Principal and Interest Payments 07:24 mins
4. Depreciation 05:04 mins
Exercise 03 - Practice 01:37 mins
Exercise 03
Answer - Exercise 03
Financial Functions - Example 1
Personal Financial Functions - Example 1
Personal Financial Functions - Example 2
8. Statistical Functions
1. Statistical Functions for Description - Part 1 13:32 mins
2. Statistical Functions for Description - Part 2 13:44 mins
3. Statistical Functions for Forecasting - Part 1 11:54 mins
4. Statistical Functions for Forecasting - Part 2 11:46 mins
Exercise 04 - Practice 01:46 mins
One Click Forecasting 08:57 mins
Statistical Functions for Inference 11:09 mins
Exercise 04
Answer - Exercise 04
Statistical Functions for Inference Sample
9. Connecting to External Data
1. Connecting to Other workbooks 13:09 mins
2. Connecting to Access Databases 12:50 mins
3. Connecting Web Data Sources 07:52 mins
4. Get and Transform 14:26 mins
Exercise 5 05:06 mins
Connecting to Web Data
Access Database Conncetion
10. Tables
1. Introduction to Tables 12:13 mins
2. Working with Tables 10:41 mins
3. Table References 08:31 mins
4. Table Styles 05:33 mins
Exercise 06 - Practice 01:21 mins
Exercise 06
Answer - Exercise 06
Tables - Sample 1
Tables - Sample 2
Tables - Sample 3
11. Pivot Tables
1. Introduction to Pivot Tables 09:51 mins
2. Working with Pivot Tables 12:43 mins
3. Filters and Slicers 12:25 mins
4. Pivot and Charts 08:31 mins
Exercise 07 - Practice 02:29 mins
Exercise 07
Answer - Exercise 07
12. Data Analysis
1. What If Analysis 10:15 mins
2. Scenario Manager 11:22 mins
3. Goal Seek 07:26 mins
4. Solver 12:01 mins
Exercise 08 - Practice 01:43 mins
Exercise 08
Answer - Exercise 08
13. Graphs and Charts
1. Area Charts 06:41 mins
2. Surface Charts 04:41 mins
3. Radar Charts 05:21 mins
4. Bubble Charts 07:19 mins
5. Sparklines 09:33 mins
6. Stock Charts 09:06 mins
Exercise 09 - Practice 03:33 mins
Exercise 09
Answer - Exercise 09
Surface Charts - Sample
Radar Charts - Sample
Bubble Charts - Sample
Stock Charts - Sample
14. Excel Web App
Web App - Part 1 10:08 mins
Web App - Part 2 09:53 mins
15. Course Conclusion
Closing 00:50 mins
Quiz

Request more information

Similar courses

Join our mail list for news