Microsoft Excel Advanced - Formulas, Functions, Macros & VBA
4.0 (72 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
357 students enrolled

Microsoft Excel Advanced - Formulas, Functions, Macros & VBA

Become an Excel Expert in this Advanced Excel Course (Microsoft Excel 2010, Excel 2013, Excel 2016, and Excel 2019)
4.0 (72 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
357 students enrolled
Created by Brian Wells
Last updated 3/2019
English
English, French, 3 more
  • Indonesian
  • Portuguese
  • Spanish
Current price: $100.99 Original price: $154.99 Discount: 35% off
17 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 6 hours on-demand video
  • 51 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Master the Most Complex Concepts of Microsoft Excel.
  • Advanced Excel Functions & Formulas, Pivot Tables, Macros, VBA & More!
  • Create dynamic reports by mastering one of the most popular tools, Pivot Tables.
  • Harness the full power of Microsoft Excel by automating your day to day tasks through Macros and VBA.
  • Wow your boss by unlocking dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more.
  • Access to a Professional Trainer with 12+ years of Excel Training.
  • Maintain large sets of Excel data in a list or table.
  • My personal Excel keyboard shortcuts CHEATSHEET!
Requirements
  • Have an understanding of how Microsoft Excel works and the main concepts such as, beginner formulas & functions.
  • This course was created with Excel 2016. But all features will work in Excel 2010, 2013, 2016, and most will work in 2019.
Description

Welcome to Your Microsoft Excel 2016 Advanced Course.

⇉ Watch the promo video to see How Quickly You Can Begin to Master Microsoft Excel!

⇉ This Course is MASSIVE! You receive over 6+ hours of video content & 90 lectures!

Just Click the "Take This Course Now" For Instant Life-Time Access To All Levels Of Excel Below!

  1. Intermediate

  2. Advanced

  3. and Excel Macros/VBA.

This Microsoft Excel course concentrates on the most advanced features, after taking this online class you will be able to use Microsoft Excel at an expert level. You can learn Microsoft Excel easily and quickly if it is taught correctly. Developed by a Microsoft Certified Master Instructor, this course provides comprehensive coverage on Microsoft Excel.

As an additional bonus, you can download all of the Excel project files that are used in the videos so that you can get a “hands-on” approach to learning the material. You will also be shown how to find and download free "Excel templates" which are spreadsheet templates that you can use like "budget templates" or a "calendar template" or a "schedule template."

PLUS included in this course is 84 Excel Shortcuts that will increase your everyday speed using Microsoft Excel.

Another great aspect of this course is that, at the end of this Excel class, you will be given a CERTIFICATE OF COMPLETION. This course has a quiz after every section so if you need to prove that you have learned the material, or if you’re an employer or supervisor that needs to ensure that someone has actually done the work, this is easily done by looking at the results of these quizzes.

This class is guaranteed to teach you Microsoft Excel. Once enrolled, you will have access to this Excel course for the rest of your life. You will always be able to come back to this Excel class to review material or to learn new material about how to use Excel. 

Enroll now and transform your abiliy to use Microsoft Excel.

Who this course is for:
  • Beginner Microsoft Excel Students looking to learn Advanced Excel concepts & uses.
Course content
Expand all 84 lectures 06:05:47
+ Advanced Formula Knowledge - Importing Data, VLOOKUP & More!
6 lectures 32:48
Advanced Formula Knowledge: Introduction
01:22

Learn to work with formula auditing tools including tracing precedent and dependent cells and formula evaluation.

Preview 08:33

Learn to use SUMIF, COUNTIF and SUMPRODUCT to add cells only when certain conditions are met.

Preview 07:59

Learn about creating and updating external links, and about the potential dangers of external links in Excel.

How to Import Data in Excel
06:25

Learn to use VLOOKUP to find an approximate match and return it or the corresponding value from another column.

Preview 04:24

Learn to use VLOOKUP to find an exact match and return it or the corresponding value from another column.

VLOOKUP With Exact Match
04:05
Advanced Formula Knowledge: Quiz
5 questions
+ CONCAT & CONCATENATE Functions
3 lectures 09:51

Learn the basics of CONCAT & CONCATENATE functions.

Preview 01:41

Learn how to use and build your CONCAT & CONCATENATE functions.

Using The CONCATENATE Function
03:28

Learn how to build logic into your CONCAT & CONCATENATE functions using IF, ISNUMBER, & FIND statements.

Using Logic in your CONCATENATE Functions
04:42
+ ADDRESS & INDIRECT Functions
4 lectures 16:11

Learn the arguments of the Address function.

ADDRESS Function
03:48

Learn how to string data with the ADDRESS function.

Using the ADDRESS Function to String Data
04:24

Learn how to build a formula that uses both the ADDRESS & INDIRECT functions to extract data.

Using the ADDRESS Function in a INDIRECT Function
03:29

Learn how to use the INDIRECT function in formulas.

INDIRECT Function
04:30
+ INDEX & MATCH Functions
6 lectures 25:44
INDEX Function Rules
02:48
Using Array in the INDEX Function
03:06
Using the Reference Form & Sum Function in a INDEX Function
07:04
Introduction to MATCH Function
03:50
Match Function
04:37
+ Sorting, Filtering, Tables, Ranges & More!
5 lectures 21:01
Enhancing Data: Introduction
00:40

Learn to sort data in Excel by a single column or by multiple columns.

Sorting
05:55

Learn to filter Excel data for specific words, dates, and apply multiple filters to a single data table.

Filtering
04:43

Learn about creating named ranges, and the benefits of doing so.

Excel Ranges
04:53

Learn about creating Excel tables, and their advantages.

Excel Tables
04:50
Enhancing Data: Quiz
4 questions
+ Mastering Excel's Advanced Filtering Tool
7 lectures 20:45
Introduction
00:59

Introduction in the Advanced Filter tool in Microsoft Excel.

Introduction to the Advanced Filter
01:31

Learn the steps in setting up the Advanced Filter tool process in Microsoft Excel.

Setting Up The Advanced Filter
04:40

Learn how to run the Advanced Filter.

Running the Advanced Filter
04:58

Continue your learning about using Advanced Filters on large data sets.

Modifying the Advanced Filter
03:36

Use a powerful Advanced Excel Filtering tool.

Using the 'Filter in Spot' Advanced Filter Setting
02:21

Learn how to avoid a headache when using Excel's Advanced Filter by avoiding these simple mistakes!

Common Excel Advanced Filter Mistakes
02:40
Advanced Filter: Quiz
3 questions
+ Pivot Tables - Beginner to Intermediate
5 lectures 26:45
Pivot Tables Beginner Introduction
01:21

Learn to create and modify basic PivotTables (for quickly summarizing and highlighting data).

Creating a Pivot Table
06:09

Learn to control formatting and other options in PivotTables.

Formatting a Pivot Table
06:22

Learn to create and modify basic calculated fields for PivotTables.

Calculated Fields In Pivot Tables
04:44

Learn multiple ways to filter data in Excel.

Filtering Pivot Table Data
08:09
+ Pivot Tables - Advanced Level
6 lectures 23:05
Pivot Tables Advanced: Introduction
00:56

Learn advanced formatting inside Excel Pivot Tables.

Formatting a Pivot Table Advanced
05:10

Learn how to group within Pivot Tables.

Grouping in Pivot Tables
06:20

Learn how to use the drill down function in Excel Pivot Tables.

Drilling Down into Pivot Tables
02:40

Learn how to make stunning dynamic charts from Pivot Tables.

Pivot Table Charts
04:11

Learn one of the best tools associated with Pivot Tables.

Creating a Slicer in Pivot Tables
03:48
Pivot Tables: Quiz
3 questions