4.4 (32 ratings)
186 students enrolled
Wishlisted Wishlist

Take Excel to the next level with advanced formulas, What-If Analysis tools, advanced PivotTables, Macros and much more
4.4 (32 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
• Access on mobile and TV
• Certificate of Completion

### Training 5 or more people?

What Will I Learn?
• 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
Preview 01:04
+
3 Lectures 08:54
Preview 04:27

Preview 02:35

Summarizing Data with COUNTIF
01:52
+
7 Lectures 19:39
Using VLOOKUP with TRUE
03:40

Preview 01:22

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

Preview 02:15

Using the LEN Function
02:07

Using the TRIM Function
01:03

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

Tracing Precedents and Dependents
02:33

02:16

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

Preview 01:43

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

02:35

Allowing Specific Worksheet Changes
01:27

02:48

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

01:33

01:43

Applying Conditional Formatting to a PivotTable
02:35

Using Filters in a PivotTable
01:42

Preview 01:16

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

Preview 02:07

Creating Complex Macros
02:29

Viewing and Editing the VBA Code
02:37

01:49
+
Working with Form Controls
3 Lectures 05:30
What are Form Controls?
01:44

Adding Spin Buttons and Check Boxes
02:04