Microsoft Excel 2016 Advanced Training Master Class

Last updated 12/2022MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHzLanguage: English | Size: 3.00 GB | Duration: 12h 7m

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

What you'll learn

Working with dates and s

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 detee payments

Practice what you learned with included exercise files

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 Bners

Learn how to import and export data to and from ExcelLearn how to create various charts and graphsEffectively create and use functions and formulasImport and export data Create and effectively use Pivot TablesHow to use Excel for data analysisDiscover practical methods for financial & statistical functions This course includes: 9-hours of video tutorialsOver 50 individual video lectures

Exercise files to practice what you learnedDemo files used by the trainerPrintable course transcriptions to follow along and take notesCertificate of completionThis 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 OverviewThrough 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.Here’s what our students are saying…"This is an excellently pieced together information. Beautifully explained with lots of examples and external resource areas for the nerds. I highly recommend this course for anyone whose intention is to learn Excel.” - Frank Uchegbu"Greatly explained and great zoom in of the working area."- Jorge Tech"Very detail and advance. The exercise and solution sheets help greatly in understanding and familiarisation of the lessons. Highly recommended for users getting to know Excel in details."- John ChanDid you know?Simon Sez IT teaches all sorts of software, including:- Microsoft Excel- Microsoft PowerPoint- Microsoft Word- Microsoft Project- Microsoft Outlook- QuickBooks- Photoshop Elements- Web Development Languages- And so much more!Just search "Simon Sez IT" to see our full list of individual courses and incredible value multi-course bundles on Udemy.

Overview

Section 1: Introduction to Excel 2016 Advanced Course

Lecture 1 Prerequisites of the Course and Version of Excel

Lecture 2 WATCH ME: Essential Information for a Successful Training Experience

Lecture 3 ME: Excel 2016 Advanced Course Exercise Files

Lecture 4 ME: Excel 2016 Advanced Course Demo Files

Lecture 5 able Course Transcripts

Lecture 6 Course Structure

Section 2: Functions

Lecture 7 Functions - Part 1

Lecture 8 Functions - Part 2

Lecture 9 Autosum

Section 3: Date and Functions

Lecture 10 How Date and Works

Lecture 11 Basic Date and Functions

Lecture 12 Complex Date and Functions

Section 4: Text Functions

Lecture 13 Using Text Functions - Part 1

Lecture 14 Using Text Functions - Part 2

Section 5: Logical Functions

Lecture 15 Using Logical Functions

Lecture 16 Exercise 01

Section 6: Lookup Functions

Lecture 17 HLOOKUP Function

Lecture 18 VLOOKUP Function

Lecture 19 Exercise 02

Section 7: Financial Functions

Lecture 20 Financial Functions and Teology

Lecture 21 Personal Financial Functions

Lecture 22 Professional Financial Functions

Lecture 23 Depreciation

Lecture 24 Exercise 03

Section 8: Statistical Functions

Lecture 25 Statistical Functions for Description - Part 1

Lecture 26 Statistical Functions for Description - Part 2

Lecture 27 Statistical Functions for Forecasting - Part 1

Lecture 28 Statistical Functions for Forecasting - Part 2

Lecture 29 Exercise 04

Lecture 30 One Click Forecasting

Lecture 31 Statistical Functions for Inference

Section 9: Connecting to External Data

Lecture 32 Connecting to Other Workbooks

Lecture 33 Connecting to Access Databases

Lecture 34 Connecting to Web Data Sources

Lecture 35 Get and Transform

Lecture 36 Exercise 05

Section 10: Tables

Lecture 37 Introduction to Tables

Lecture 38 Working with Tables

Lecture 39 Table References

Lecture 40 Table Styles

Lecture 41 Exercise 06

Section 11: Pivot Tables

Lecture 42 Introduction to Pivot Tables

Lecture 43 Working with Pivot Tables

Lecture 44 Filters and Slicers

Lecture 45 Pivot Charts

Lecture 46 Exercise 07

Section 12: Data Analysis

Lecture 47 What If Analysis

Lecture 48 Scenario Manager

Lecture 49 Goal Seek

Lecture 50 Solver

Lecture 51 Exercise 08

Section 13: Graphs and Charts

Lecture 52 Area Charts

Lecture 53 Surface Charts

Lecture 54 Radar Charts

Lecture 55 Bubble Charts

Lecture 56 Sparklines

Lecture 57 Stock Charts

Lecture 58 Exercise 09

Section 14: Excel Web App

Lecture 59 Web App - Part 1

Lecture 60 Web App - Part 2

Section 15: Conclusion

Lecture 61 Closing Message

Section 16: Extras

Lecture 62 EXTRA LESSON: Getting Started with Power Pivot and Power Query in Excel Webinar

Lecture 63 EXTRA RESOURCE: The Most Frequently Used Excel Shortcuts - Infographic

Section 17: Bonuses

Lecture 64 Ten Excel Tips and Tricks - Part 1

Lecture 65 Ten Excel Tips and Tricks - Part 2

Lecture 66 Ten Excel Tips and Tricks - Part 3

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.

HomePage:

https://www.udemy.com/course/microsoft-excel-2016-advanced-training-master-class/