Microsoft Excel Advanced 2019

Video description

Learn and master Excel 2019 by learning advanced functions and formulas

About This Video

  • Learn and understand advanced Excel features that delve into high-level consolidation, analysis, and reporting of financial information
  • Learn and master advanced charting and graphing in Excel

In Detail

Get beyond the basics and supercharge your current skill level in Excel. With this 9-hour, expert-led video training course, you’ll gain an in-depth understanding of more advanced Excel features that delve into high-level consolidation, analysis and reporting of financial information.

Upon completion of this course, you'll be able to create charts that have an impact from databases that communicate data and financial records efficiently and effectively.

You will be able to report data in various formats including: tables, graphs and PivotTables. Once completed you'll have advanced understanding of Excel that will positively impact your professional capability.

Publisher resources

Download Example Code

Table of contents

  1. Chapter 1 : Introduction to Excel 2016 Advanced Course
    1. Prerequisites of the Course and Version of Excel 00:06:34
    2. Course Structure 00:04:20
  2. Chapter 2 : Functions
    1. Functions - Part 1 00:13:39
    2. Functions - Part 2 00:08:04
    3. Autosum 00:06:00
  3. Chapter 3 : Date and Time Functions
    1. How Date and Time Works 00:10:00
    2. Basic Date and Time Functions 00:09:44
    3. Complex Date and Time Functions 00:10:38
  4. Chapter 4 : Text Functions
    1. Using Text Functions - Part 1 00:12:21
    2. Using Text Functions - Part 2 00:12:12
  5. Chapter 5 : Logical Functions
    1. Using Logical Functions 00:09:44
    2. Exercise 01 00:01:58
  6. Chapter 6 : Lookup Functions
    1. HLOOKUP Function 00:14:02
    2. VLOOKUP Function 00:07:57
    3. Exercise 02 00:05:37
  7. Chapter 7 : Financial Functions
    1. Financial Functions and Terminology 00:08:52
    2. Personal Financial Functions 00:09:18
    3. Professional Financial Functions 00:07:24
    4. Depreciation 00:05:04
    5. Exercise 03 00:01:37
  8. Chapter 8 : Statistical Functions
    1. Statistical Functions for Description - Part 1 00:13:32
    2. Statistical Functions for Description - Part 2 00:13:44
    3. Statistical Functions for Forecasting - Part 1 00:11:54
    4. Statistical Functions for Forecasting - Part 2 00:11:46
    5. Exercise 04 00:01:46
    6. One Click Forecasting 00:08:56
    7. Statistical Functions for Inference 00:11:09
  9. Chapter 9 : Connecting to External Data
    1. Connecting to Other Workbooks 00:13:09
    2. Connecting to Access Databases 00:12:50
    3. Connecting to Web Data Sources 00:07:52
    4. Get and Transform 00:14:26
    5. Exercise 05 00:05:06
  10. Chapter 10 : Tables
    1. Introduction to Tables 00:12:13
    2. Working with Tables 00:10:41
    3. Table References 00:08:31
    4. Table Styles 00:05:33
    5. Exercise 06 00:01:21
  11. Chapter 11 : Pivot Tables
    1. Introduction to Pivot Tables 00:09:50
    2. Working with Pivot Tables 00:12:43
    3. Filters and Slicers 00:12:25
    4. Pivot Charts 00:08:31
    5. Exercise 07 00:02:29
  12. Chapter 12 : Data Analysis
    1. What If Analysis 00:10:15
    2. Scenario Manager 00:11:22
    3. Goal Seek 00:07:26
    4. Solver 00:12:01
    5. Exercise 08 00:01:43
  13. Chapter 13 : Graphs and Charts
    1. Area Charts 00:06:40
    2. Surface Charts 00:04:41
    3. Radar Charts 00:05:21
    4. Bubble Charts 00:07:19
    5. Sparklines 00:09:33
    6. Stock Charts 00:09:06
    7. Exercise 09 00:03:33
  14. Chapter 14 : Excel Web App
    1. Introduction to Excel Web App 00:10:08
    2. Using the Excel Web App 00:09:53
  15. Chapter 15 : Course Conclusion
    1. Closing Message 00:00:48

Product information

  • Title: Microsoft Excel Advanced 2019
  • Author(s): Simon Sez IT
  • Release date: August 2019
  • Publisher(s): Packt Publishing
  • ISBN: 9781839219832