Practical Excel 2016 – Intermediate & Advanced

Leverage the magic of Excel 2016! Super-charge your productivity & recession-proof your job by becoming a master user.
3.9 (27 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.
246 students enrolled
$19
$25
24% off
Take This Course
  • Lectures 82
  • Length 6 hours
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 11/2015 English

Course Description

This course takes up where the Practical Excel 2016 Fundamentals 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…

What are the requirements?

  • Microsoft Office 2016

What am I going to get from this course?

  • 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)

What is the target audience?

  • Any competent Excel users who aspire to becoming Excel “power users”

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction to Course
Welcome to Intermediate & Advance Course
Preview
01:05
How to download Exercise Files and Handouts
Article
REMINDER: Turn on HD
1 page
Section 2: Summarizing Functions
COUNTIF, SUMIF, AVERAGEIF
Preview
07:27
COUNTIFS, SUMIFS, AVERAGEIFS
07:45
Section 3: Math Functions
Intro to Math Functions
Preview
00:51
INT, ROUND, CEILING, FLOOR
03:13
ABS, SQRT, SUMSQ
02:33
LN, EXP
03:28
RAND, RANDBETWEEN
03:27
Section 4: Text Functions
Intro to Text Functions
Preview
01:25
LOWER, UPPER, PROPER
01:07
TRIM, VALUE
04:42
Concatenating
02:53
Parsing with Text to Columns
03:39
Parsing with Text Functions
11:45
Flash Fill
Preview
05:53
Section 5: Dates and Times Functions
Intro to Dates and Times in Excel
05:17
Y2K
02:07
TODAY, NOW
01:23
YEAR, MONTH, DAY, WEEKDAY
04:06
DATEDIF
Preview
03:13
DATE, DATEVALUE
04:23
NETWORKDAYS, WORKDAY
02:28
Section 6: Statistical Functions
Intro to Statistical Functions
Preview
01:24
MIN, MAX
01:29
MEDIAN, QUARTILE, PERCENTILE
04:10
STDEV, VAR
03:32
CORREL, COVAR
04:04
RANK, LARGE, SMALL
03:58
New Statistical Functions
01:32
Section 7: Financial Functions
Intro to Financial Functions
00:44
PMT
02:12
NPV, XNPV
03:33
IRR, XIRR
03:08
Section 8: Reference Functions
Intro to Reference Functions
00:49
INDEX
02:33
MATCH
03:43
OFFSET
04:49
INDIRECT
03:47
Section 9: Logical Functions
Intro to Logical Functions
00:41
IS… Functions
05:34
IF… Functions
01:23
Section 10: Advanced Formula Tools
Range Names 2
07:11
R1C1 Notation
03:34
Auditing Formulas
07:14
Evaluating a Formula
05:23
External Formula References
04:21
Array Formulas
09:39
Section 11: Importing External Data
Intro to Importing External Data
01:28
Importing Data from a Database
07:40
Importing Data from a Text File
05:58
Importing Data from the Web
Preview
04:17
Importing Data from Saved Connections
03:20
Section 12: Data Analysis Tools
Intro to Data Analysis Tools
00:54
Quick Analysis
Preview
02:25
Tables
15:12
Pivot Tables 1
09:26
Pivot Tables 2
10:58
Slicers
03:08
Consolidating
05:12
Subtotals
04:32
Data Tables
10:17
Forecasting
03:19
Goal Seek
04:23
Solver
07:13
Section 13: Power BI
Intro to Power BI
Preview
02:13
Data Model
09:18
Power Query
05:09
Power Pivot
10:45
Power View
04:34
Power Map
03:06
Section 14: Adding Professional Touches
Intro to Adding Professional Touches
00:39
Data Validation
06:29
Protecting Worksheets and Workbooks
04:03
Custom Views
02:22
Scenarios
04:22
Outlining
03:36
Developer Ribbon
01:15
Using Form Controls
08:50
Recording a Macro
03:07
Section 15: Conclusion to Course
Conclusion to Excel 2016 Intermediate and Advanced Course
Preview
00:58

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Optima Train, Practical Training for Today's Knowledge Worker

Optima Train is a US-based training company using cutting-edge adult learning methodology to make our customers more effective in the workplace.

Optima Train has the most comprehensive coverage of content created by experts with deep knowledge of how applications are used in the workplace.

We are intricately linked to our customers. While most training companies have a tool-centric approach that leads to relatively low knowledge retention, Optima Train has a results-oriented approach.

Ready to start learning?
Take This Course