Last updated 1/2022
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.81 GB | Duration: 10h 6m
The ultimate next step for anyone interested in supercharging their MS Excel and data analysis skills
What you’ll 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
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 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 DOWNLOAD ME: Excel 2016 Advanced Course Exercise Files
Lecture 4 DOWNLOAD ME: Excel 2016 Advanced Course Demo Files
Lecture 5 Downloadable 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 Time Functions
Lecture 10 How Date and Time Works
Lecture 11 Basic Date and Time Functions
Lecture 12 Complex Date and Time 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 Terminology
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
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/
DOWNLOAD FROM RAPIDGATOR.NET
DOWNLOAD FROM RAPIDGATOR.NET
DOWNLOAD FROM UPLOADGIG.COM
DOWNLOAD FROM UPLOADGIG.COM
DOWNLOAD FROM NITROFLARE.COM
DOWNLOAD FROM NITROFLARE.COM