Excel 2016 Advanced

Leverage the magic of Excel 2016! Super-charge your productivity & recession-proof your job by becoming a master user.

3.80 (70 reviews)
Udemy
platform
English
language
Microsoft
category
instructor
Excel 2016 Advanced
401
students
4 hours
content
Aug 2017
last update
$19.99
regular price

What you will learn

How to use intermediate to advanced Excel functions from various categories (counting/summing/averaging, math, text, date/time, statistical, financial, reference, and logical) to solve practical problems

More advanced tips for working with formulas, including formula auditing and formula evaluation

How to use Excel’s many powerful tools for data analysis, including tables, pivot tables, data tables, Goal Seek, and Solver

How to use Excel’s tools for importing external data from databases, text files, and the Web

How to use a number of intermediate to advanced tools for adding professional touches to your spreadsheets, including data validation, workbook/worksheet protection, scenarios, form controls, and recording macros

An introduction to several tools new to Excel 2016, including Flash Fill for text pattern recognition and several data analysis tools (Quick Analysis, the Excel Data Model, and the PowerPivot and Power View add-ins)

Description

This course takes up where the Excel 2016 Beginners course leaves off. It covers a wide variety of Excel topics, ranging from intermediate to an advanced level. You will learn a wide variety of Excel functions, tips for creating readable and correct formulas, a number of useful data analysis tools, how to import external data into Excel, and tools for making your spreadsheets more professional. To learn Excel quickly and effectively, download the companion exercise files so you can follow along with the instructor by performing the same actions he is showing you on the videos.

***** THE MOST RELEVANT CONTENT TO GET YOU UP TO SPEED *****

***** CLEAR AND CRISP VIDEO RESOLUTION *****

***** COURSE UPDATED: February 2016 *****

“As an Accountant, learning the Microsoft Office Suite really helps me out. All of the accounting firms out there, whether Big 4 or mid-market, want their employees to be well-versed in Excel. By taking these courses, I become a stronger candidate for hire for these companies." - Robert, ACCOUNTANT

There are two questions you need to ask yourself before learning Excel. 1. Why should you learn Excel in the first place? 2. What is the best way to learn?

The answer for the first question is simple. Over 90% of businesses today and 100% of colleges use Excel. If you do not know Excel you will be at a distinct disadvantage. Whether you're a teacher, student, small business owner, scientist, homemaker, or big data analyst you will need to know Excel to meet the bare minimum requirements of being a knowledge worker in today's economy. But you should also learn Excel because it will simplify your work and personal life and save you tons of time which you can use towards other activities. After you learn the ropes, Excel actually is a fun application to use.

The answer to the second question is you learn by doing. Simple as that. Learn only that which you need to know to very quickly get up the learning curve and performing at work or school. Our course is designed to help you do just that. There is no fluff content and the course is packed with bite-sized videos and downloadable course files (Excel workbooks) in which you'll follow along with the instructor (learn by doing).

If you want to learn Excel quickly, land that job, do well in school, further your professional development, save tons of hours every year, and learn Excel in the quickest and simplest manner then this course is for you!

You'll have lifetime online access to watch the videos whenever you like, and there's a Q&A forum right here on Udemy where you can post questions.

We are so confident that you will get tremendous value from this course. Take it for the full 30 days and see how your work life changes for the better. If you're not 100% satisfied, we will gladly refund the full purchase amount!

Take action now to take yourself to the next level of professional development. Click on the TAKE THIS COURSE button, located on the top right corner of the page, NOW…every moment you delay you are delaying that next step up in your career…

Content

Introduction to Course

Welcome to Intermediate & Advance Course
How to download Exercise Files and Handouts
REMINDER: Turn on HD

Summarizing Functions

COUNTIF, SUMIF, AVERAGEIF
COUNTIFS, SUMIFS, AVERAGEIFS

Math Functions

Intro to Math Functions
INT, ROUND, CEILING, FLOOR
ABS, SQRT, SUMSQ

Text Functions

Intro to Text Functions
LOWER, UPPER, PROPER
TRIM, VALUE
Concatenating

Dates and Times Functions

Intro to Dates and Times in Excel
Y2K
TODAY, NOW
DATEDIF

Statistical Functions

Intro to Statistical Functions
MIN, MAX
MEDIAN, QUARTILE, PERCENTILE
STDEV, VAR

Financial Functions

Intro to Financial Functions
PMT

Reference Functions

Intro to Reference Functions
INDEX
MATCH

Logical Functions

Intro to Logical Functions
IS… Functions
IF… Functions

Advanced Formula Tools

Range Names 2
R1C1 Notation
Auditing Formulas

Importing External Data

Intro to Importing External Data
Importing Data from a Database
Importing Data from a Text File
Importing Data from the Web
Importing Data from Saved Connections

Data Analysis Tools

Intro to Data Analysis Tools
Quick Analysis
Tables
Pivot Tables 1
Pivot Tables 2

Power BI

Intro to Power BI
Data Model
Power Query
Power Pivot
Power View
Power Map

Adding Professional Touches

Intro to Adding Professional Touches
Data Validation
Protecting Worksheets and Workbooks
Custom Views
Scenarios
Outlining
Developer Ribbon
Using Form Controls
Recording a Macro

Conclusion to Course

Conclusion to Excel 2016 Intermediate and Advanced Course

Reviews

Jesse
December 20, 2020
Cursus voldeed aan verwachtingen. Kort en duidelijke uitleg over Excel functionaliteiten en hun mogelijke toepassingen.
Serhat
July 30, 2018
In short the training is good enough for beginners may be also for intermadiate users but I am not sure it is for persons looking for advanced Excel. Most part of the training can be easly find in help but these are not enough. There should be more real world examples.
Phil
April 13, 2018
I like the fact that the video and lecture are easy to follow and the accompanying data files are good to follow along.
Arnold
October 10, 2017
This is a "mildly" intermediate course and not an "advanced" course (as indicated in the title for the course) by any means. There's no coverage of arrays, nested IF and other important advanced functions, and some of the discussions are simply "not thorough". However, some of the sections, like the Tables Section and other sections are interesting, helpful, and instructive. Other sections provide very good illustrations & examples; I did like the course overall, as it provides a good review of intermediate and some advanced topics; but, to reiterate, my main problem with the entire course, is that if you're going to call it an "advanced" course, then have it be that.
Robert
July 31, 2017
Not what I was looking to learn about. Most aspects of this Excel course were too complex or irrelevant for my particular personal goals and needs. Tutor did explain topics clearly, however examples were too generic for my own application and implementation but I did increase some basic Excel Skills
Deena
April 4, 2017
Very well done. Discusses topic to be reviewed, explains the functionality, and demonstrates it so you can see how it works with data
Kyne
January 17, 2017
Excel is the prime example of "I don't know what I don't know". This course unlocks a lot of functions that you wouldn't otherwise know even existed. Very impressed, can see some real efficiency gains here!
Stephen
July 8, 2016
So far I have already learned some great things through this course. I already know the basics of Excel, and so what I have learned so far has been a huge boost.
Tanya
March 21, 2016
This course is very interactive and covers a broad range of intermediate and advanced functions in Excel.
Jose
February 29, 2016
Having short videos explaining practical ways to use different functions in Excel helps me greatly to complete the course whenever I have some free time within tasks at work. The Video Example Templates help me a lot as well in applying the lessons at the same time I watch the videos.

Charts

Price

Excel 2016 Advanced - Price chart

Rating

Excel 2016 Advanced - Ratings chart

Enrollment distribution

Excel 2016 Advanced - Distribution chart

Related Topics

655837
udemy ID
10/30/2015
course created date
3/22/2020
course indexed date
Bot
course submited by