Microsoft Excel Advanced 2016

Video description

Become a Microsoft Excel expert with this easy-to-follow course featuring 9-hours of professionally produced videos

About This Video

  • Discover practical methods for financial and statistical functions
  • Become a Microsoft Excel expert and effectively use it for data analysis

In Detail

Through 57 lectures and over 9-hours of content, this course will take you through using functions in everyday work environments. Professional financial functions are covered including payments, future value, and depreciation. Students will learn statistical functions such as averages, percentiles, and regression.

In order to improve efficiency, students will also cover connecting to external data—such as other workbooks or web data—and tables including style, selection, and sizing. Pivot tables and data analysis are key concepts for work environments.

To aid reporting, students will learn about surface charts, stock charts, radar charts, bubble charts, and graphs.

After completing this course, students will be able to create colorful charts and databases that communicate data and financial records efficiently and effectively. Students will be able to apply data to various reporting forms (such as tables, graphs, and pivot tables) in order to show important analyses such as depreciation, percentiles, and regression for use with planning. Students who finish this course will have advanced knowledge of the versatility of Excel that is immediately applicable to work requirements.

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:07:35
    2. Course Structure 00:04:59
  2. Chapter 2 : Functions
    1. Functions - Part 1 00:15:41
    2. Functions - Part 2 00:10:44
    3. Autosum 00:06:22
  3. Chapter 3 : Date and Time Functions
    1. How Date and Time Works 00:11:21
    2. Basic Date and Time Functions 00:11:57
    3. Complex Date and Time Functions 00:14:45
  4. Chapter 4 : Text Functions
    1. Using Text Functions - Part 1 00:14:39
    2. Using Text Functions - Part 2 00:15:07
  5. Chapter 5 : Logical Functions
    1. Using Logical Functions 00:11:15
    2. Exercise 01 00:02:21
  6. Chapter 6 : Lookup Functions
    1. HLOOKUP Function 00:15:17
    2. VLOOKUP Function 00:08:57
    3. Exercise 02 00:06:06
  7. Chapter 7 : Financial Functions
    1. Financial Functions and Terminology 00:11:20
    2. Personal Financial Functions 00:10:42
    3. Professional Financial Functions 00:07:48
    4. Depreciation 00:05:15
    5. Exercise 03 00:01:45
  8. Chapter 8 : Statistical Functions
    1. Statistical Functions for Description - Part 1 00:14:24
    2. Statistical Functions for Description - Part 2 00:14:27
    3. Statistical Functions for Forecasting - Part 1 00:12:17
    4. Statistical Functions for Forecasting - Part 2 00:12:29
    5. Exercise 04 00:01:44
    6. One Click Forecasting 00:09:17
    7. Statistical Functions for Inference 00:12:52
  9. Chapter 9 : Connecting to External Data
    1. Connecting to Other Workbooks 00:15:21
    2. Connecting to Access Databases 00:15:20
    3. Connecting to Web Data Sources 00:10:11
    4. Get and Transform 00:15:07
    5. Exercise 05 00:05:57
  10. Chapter 10 : Tables
    1. Introduction to Tables 00:12:04
    2. Working with Tables 00:10:38
    3. Table References 00:08:10
    4. Table Styles 00:05:00
    5. Exercise 06 00:01:40
  11. Chapter 11 : Pivot Tables
    1. Introduction to Pivot Tables 00:11:01
    2. Working with Pivot Tables 00:14:58
    3. Filters and Slicers 00:14:23
    4. Pivot Charts 00:08:43
    5. Exercise 07 00:02:49
  12. Chapter 12 : Data Analysis
    1. What If Analysis 00:13:39
    2. Scenario Manager 00:10:28
    3. Goal Seek 00:07:10
    4. Solver 00:12:29
    5. Exercise 08 00:01:34
  13. Chapter 13 : Graphs and Charts
    1. Area Charts 00:06:42
    2. Surface Charts 00:04:45
    3. Radar Charts 00:05:12
    4. Bubble Charts 00:07:07
    5. Sparklines 00:09:58
    6. Stock Charts 00:10:36
    7. Exercise 09 00:03:57
  14. Chapter 14 : Excel Web App
    1. Introduction to Excel Web App 00:10:48
    2. Using the Excel Web App 00:11:31
  15. Chapter 15 : Course Conclusion
    1. Closing Message 00:00:46

Product information

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