Excel 2016 Advanced
4.4 (32 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.
186 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel 2016 Advanced to your Wishlist.

Add to Wishlist

Excel 2016 Advanced

Take Excel to the next level with advanced formulas, What-If Analysis tools, advanced PivotTables, Macros and much more
4.4 (32 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.
186 students enrolled
Last updated 9/2017
English
Current price: $12 Original price: $30 Discount: 60% off
4 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion

Training 5 or more people?

Get your team access to Udemy's top 2,000 courses anytime, anywhere.

Try Udemy for Business
What Will I Learn?
  • Use Advanced IF Statements
  • Use Advanced Lookup Functions
  • Use Complex Logical and Text Functions
  • Auditing Formulas
  • Working with What-If Analysis Tools
  • Protecting Worksheet and Workbook
  • Use Advanced PivotTables and PowerPivot Tools
  • Automate with Macros
  • Work with Form Controls
  • Ensure Data Integrity
  • Collaborate in Excel
  • Import and Export Data to a Text File
View Curriculum
Requirements
  • Excel Introduction and Intermediate courses or equivalent experience.
Description

This course will teach students advanced concepts and formulas in Microsoft Excel 2016. Students will learn functions such as SUMIF, AVERAGEIF, and COUNTIF, advanced lookup functions such as HLOOKUP and VLOOOKP and MATCH and INDEX, and complex logical and text functions. Additionally, students will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in their worksheets and workbooks. Students will also learn about Excel's many collaboration features, as well as how to import and export data to and from their workbooks.

Who is the target audience?
  • Students who want to expand their Excel knowledge.
Compare to Other Excel Courses
Curriculum For This Course
64 Lectures
02:18:13
+
Introduction
1 Lecture 01:04
+
Using Advanced IF Statements
3 Lectures 08:54
+
Using Advanced Lookup Functions
7 Lectures 19:39
Using VLOOKUP with TRUE
03:40


Using the INDEX Function
03:09

Using the MATCH Function
02:05

Combining INDEX and MATCH
02:51

Comparing Two Lists with VLOOKUP
01:42

Comparing Two Lists with VLOOKUP and ISNA
04:50
+
Using Complex Logical and Text Functions
5 Lectures 10:40
Creating a Nested IF Function
02:53


Using the LEN Function
02:07

Using the TRIM Function
01:03

Using the SUBSTITUTE Function
02:22
+
Formula Auditing
4 Lectures 07:45

Tracing Precedents and Dependents
02:33

Adding a Watch Window
02:16

Error Checking
01:55
+
What-If Analysis Tools
3 Lectures 07:31
Using the Scenario Manager
03:20


Analyzing with Data Tables
02:28
+
Worksheet and Workbook Protection
5 Lectures 10:28
Understanding Protection
01:53

Encrypting Files with Passwords
02:35

Allowing Specific Worksheet Changes
01:27

Adding Protection to Selected Cells
02:48

Additional Protection Features
01:45
+
Advanced Use of PivotTables and PowerPivot
7 Lectures 14:50
Using the PivotTable and PivotChart Wizard
02:02

Adding a Calculated Field
01:33

Adding a Calculated Item
01:43

Applying Conditional Formatting to a PivotTable
02:35

Using Filters in a PivotTable
01:42


Enabling the PowerPivot Add-In
03:59
+
Automating with Macros
8 Lectures 18:50
What are Macros?
02:37

Displaying the Developer Tab
02:41

Creating a Basic Formatting Macro
02:58

Running a Macro
01:32


Creating Complex Macros
02:29

Viewing and Editing the VBA Code
02:37

Adding a Macro to the Quick Access Toolbar
01:49
+
Working with Form Controls
3 Lectures 05:30
What are Form Controls?
01:44

Adding Spin Buttons and Check Boxes
02:04

Adding a Combo Box
01:42
4 More Sections
About the Instructor
Intellezy Trainers
4.4 Average rating
5,158 Reviews
29,151 Students
138 Courses
Computer Training Specialists

At Intellezy, we believe learning should be simple, engaging, and relevant. We make this possible by building innovative, short-segment eLearning videos and easy-to-use quick reference cards designed to educate and empower companies and individuals. In today’s rapidly evolving workplace it is imperative to make sure you have the skills required to succeed. Our library provides dynamic, task-focused videos right at your fingertips, right when you need them. Our goal? To educate the world, one video at a time.