Microsoft Excel 2016 Advanced Training Master Class
4.1 (24 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
659 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel 2016 Advanced Training Master Class to your Wishlist.

Add to Wishlist

Microsoft Excel 2016 Advanced Training Master Class

The ultimate next step for anyone interested in supercharging their MS Excel and data analysis skills
4.1 (24 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
659 students enrolled
Created by Simon Sez IT
Last updated 6/2017
English
English
Current price: $10 Original price: $75 Discount: 87% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 9 hours on-demand video
  • 4 Articles
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Working with dates and times
  • Averages, percentiles, and LINEST functions
  • Calculating depreciation
  • Inserting and formatting tables
  • Sparklines and data bars
  • Pivot charts
  • How to import and export data to and from Excel
  • Create and effectively use pivot tables
  • How to use Excel for data analysis
  • Discover practical methods for financial & statistical​ Functions
  • Using financial functions to determine payments
  • Practice what you learned with included exercise files
View Curriculum
Requirements
  • Microsoft Excel 2016 desktop version for Windows installed and ready to use on your computer.
Description

Become a Microsoft Excel expert with this easy to follow course featuring 9-hours of professionally produced videos. Exercise and 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
  5. Printable course transcriptions to follow along and take notes
  6. Certificate of completion

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.

** Updated July 2017. English close captions added

** Updated June 2017. Course transcripts now available.

Who is the target audience?
  • Users with basic knowledge of Excel 2016 and those upgrading from previous software versions
  • Users who have a foundation of Microsoft Excel and seeking to advance their Excel 2016 knowledge.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
61 Lectures
09:03:04
+
Introduction to Excel 2016 Advanced Course
6 Lectures 16:41

Essential Information for a Successful Training Experience
01:53

Excel 2016 Advanced Course Exercise Files
00:26

Excel 2016 Advanced Course Demo Files
00:26

Downloadable Course Transcripts
00:20

Course Structure
04:59
+
Functions
3 Lectures 32:47
+
Date and Time Functions
3 Lectures 38:01

Basic Date and Time Functions
11:56

Complex Date and Time Functions
14:45
+
Text Functions
2 Lectures 29:45
Section 3 - Quiz
2 questions

Using Text Functions - Part 1
14:38

Using Text Functions - Part 2
15:07

Section 4 - Quiz
3 questions
+
Logical Functions
2 Lectures 13:34

Exercise 01
02:20

Section 5 - Quiz
3 questions
+
Lookup Functions
3 Lectures 30:19
HLOOKUP Function
15:17

VLOOKUP Function
08:57

Exercise 02
06:05

Section 6 - Quiz
1 question
+
Financial Functions
5 Lectures 36:48
Financial Functions and Terminology
11:20

Personal Financial Functions
10:41

Professional Financial Functions
07:48

Depreciation
05:14

Exercise 03
01:45

Section 7 - Quiz
3 questions
+
Statistical Functions
7 Lectures 01:17:27
Statistical Functions for Description - Part 1
14:23

Statistical Functions for Description - Part 2
14:27

Statistical Functions for Forecasting - Part 1
12:16

Statistical Functions for Forecasting - Part 2
12:29

Exercise 04
01:44

One Click Forecasting
09:16

Statistical Functions for Inference
12:52

Section 8 - Quiz
4 questions
+
Connecting to External Data
5 Lectures 01:01:56
Connecting to Other Workbooks
15:21

Connecting to Access Databases
15:20

Connecting to Web Data Sources
10:11

Get and Transform
15:07

Exercise 05
05:57

Section 9 - Quiz
4 questions
+
Tables
5 Lectures 37:29
Introduction to Tables
12:04

Working with Tables
10:37

Table References
08:09

Table Styles
04:59

Exercise 06
01:40

Section 10 - Quiz
4 questions
5 More Sections
About the Instructor
Simon Sez IT
4.4 Average rating
12,183 Reviews
307,119 Students
117 Courses
300,000+ Students | Wordwide Use 180 Countries |120+ Courses

Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With 80+ courses and 4,500+ video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 300,000 Udemy students in over 180 countries, Simon Sez IT is the preferred eLearning choice for individuals and businesses everywhere.