Take this
course

Office Productivity / Microsoft

Microsoft Excel 2016 Advanced Training Master Class

The ultimate next step for anyone interested in supercharging their MS Excel and data analysis skills

Description

Become a Microsoft Excel expert with this easy to follow course featuring 9-hours of professionally produced videos. Exercise and instructor demo files included.


  • Practice what you learned with included exercise files
  • Detailed easy instruction to master Microsoft Excel 2016
  • A full 9-hours of professional video instruction
  • 60+ easy to follow how-to videos
  • Everything explained step-by-step for quick comprehension
  • The next step after completing Microsoft Excel 2016 for Beginners
  • Learn how to import and export data to and from Excel
  • Learn how to create various charts and graphs
  • Effectively create and use functions and formulas
  • Import and export data 
  • Create and effectively use Pivot Tables
  • How to use Excel for data analysis
  • Discover practical methods for financial  & statistical functions


This course includes:

  1. 9-hours of video tutorials
  2. Over 50 individual video lectures
  3. Exercise files to practice what you learned
  4. Demo files used by the trainer


This course is designed for students that are already familiar with Excel, but wish to improve their skills and open the possibilities with this versatile spreadsheet program. Bring your basic knowledge of Excel 2016 and learn how to reach the next level of database tracking and reporting.


Contents and Overview

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


In order to improve efficiency, students will also cover concepts for connecting to external data like other workbooks or web data; tables including style, selection and sizing. Pivot tables and data analysis will be key concepts helpful to the work environment.


For help with reporting, students will learn surface charts, stock charts, radar charts and bubble charts and graphs.


Upon completion of 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 like tables, graphs and pivot tables in order to show important analysis like depreciation, percentiles and regression for use with planning. Students who finish this course will have an advanced knowledge of the versatility of Excel that is immediately applicable to their work with the database.

Full details

Curriculum

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

Skills

  • Microsoft Excel

Similar Courses

More Courses by this Instructor