Microsoft Excel Advanced 2019

Microsoft Excel Advanced 2019

by Simon Sez IT
Released August 2019
Publisher(s): Packt Publishing
ISBN: 9781839219832

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Video description

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.

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

Audience

This course is designed for those who have basic knowledge of Excel 2019/365 and those upgrading from previous software versions

About The Author

Simon Sez IT: Simon Sez IT has offered technical courses for individuals, small businesses, and Fortune 500 companies since 2008, with thousands of employees who can benefit from the easy-to-learn and hands-on software training. It offers over 8,000 video tutorials on a range of software programs.

Simon Sez IT ensures stress-free eLearning and enhanced employee productivity—whether you implement new software or a technological upgrade in your work environment. With over 600,000 students from 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses worldwide.

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
    2. Course Structure
  2. Chapter 2 : Functions
    1. Functions - Part 1
    2. Functions - Part 2
    3. Autosum
  3. Chapter 3 : Date and Time Functions
    1. How Date and Time Works
    2. Basic Date and Time Functions
    3. Complex Date and Time Functions
  4. Chapter 4 : Text Functions
    1. Using Text Functions - Part 1
    2. Using Text Functions - Part 2
  5. Chapter 5 : Logical Functions
    1. Using Logical Functions
    2. Exercise 01
  6. Chapter 6 : Lookup Functions
    1. HLOOKUP Function
    2. VLOOKUP Function
    3. Exercise 02
  7. Chapter 7 : Financial Functions
    1. Financial Functions and Terminology
    2. Personal Financial Functions
    3. Professional Financial Functions
    4. Depreciation
    5. Exercise 03
  8. Chapter 8 : Statistical Functions
    1. Statistical Functions for Description - Part 1
    2. Statistical Functions for Description - Part 2
    3. Statistical Functions for Forecasting - Part 1
    4. Statistical Functions for Forecasting - Part 2
    5. Exercise 04
    6. One Click Forecasting
    7. Statistical Functions for Inference
  9. Chapter 9 : Connecting to External Data
    1. Connecting to Other Workbooks
    2. Connecting to Access Databases
    3. Connecting to Web Data Sources
    4. Get and Transform
    5. Exercise 05
  10. Chapter 10 : Tables
    1. Introduction to Tables
    2. Working with Tables
    3. Table References
    4. Table Styles
    5. Exercise 06
  11. Chapter 11 : Pivot Tables
    1. Introduction to Pivot Tables
    2. Working with Pivot Tables
    3. Filters and Slicers
    4. Pivot Charts
    5. Exercise 07
  12. Chapter 12 : Data Analysis
    1. What If Analysis
    2. Scenario Manager
    3. Goal Seek
    4. Solver
    5. Exercise 08
  13. Chapter 13 : Graphs and Charts
    1. Area Charts
    2. Surface Charts
    3. Radar Charts
    4. Bubble Charts
    5. Sparklines
    6. Stock Charts
    7. Exercise 09
  14. Chapter 14 : Excel Web App
    1. Introduction to Excel Web App
    2. Using the Excel Web App
  15. Chapter 15 : Course Conclusion
    1. Closing Message

Product information

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