Advanced Microsoft Excel - Take your skills to a new level!
0.0 (0 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.
11 students enrolled

Advanced Microsoft Excel - Take your skills to a new level!

In this fun and engaging course, you'll learn Excel's most powerful functions, automate work with macros, and more!
0.0 (0 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.
11 students enrolled
Created by Nate @ Wisdify
Last updated 2/2019
English
English [Auto-generated]
Current price: $30.99 Original price: $44.99 Discount: 31% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3.5 hours on-demand video
  • 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
  • Learn Excel in a fun, interactive, and entertaining manner (no sleeping in this course)
  • Master Excel's most powerful formulas like INDEX/MATCH
  • Automate redundant tasks through Macros and VBA
  • Save time by utilizing Named Ranges
  • Take your PivotTable skills to a whole new level by learning advanced features
  • Master keyboard shortcuts and become the Usain Bolt of Excel
Requirements
  • This course was created with Excel 2016 but all features will work in Excel 2010, 2013, 2016 (including Mac). You should know how to do intermediate functions in Excel like VLOOKUP and IF.
Description

Take your Excel skills to a whole new level! Our Advanced Excel course will give you the Excel skills to become an Excel master. You'll learn Excel's most powerful functions including INDEX/MATCH, learn advanced PivotTable tools, automate your work using VBA Macros, and more!


WHAT MAKES OUR EXCEL COURSE UNIQUE?

  • Earn points as you complete the course and unlock your spirit animal

  • Engaging instructor that won't put you to sleep

  • G-rated humor and lighthearted lessons

  • ZERO FLUFF!

  • Real world application that you can start applying today


WHAT YOU'LL BE LEARNING

This course will help you take your Excel skills to an advanced level. This course is beneficial to ANYONE who uses Excel. Here's what you'll master in the next 4 hours:

  • Powerful formulas such as INDEX/MATCH, MIN/MAX, and more

  • Advanced PivotTable functions to better analyze your data

  • Utilize named ranges to efficiently work with advanced formulas

  • Protecting your data using Data Validation and other techniques

  • Enhancing IF statements by incorporating AND/OR formulas

  • Keyboard shortcuts beyond the simple Ctrl+S or Ctrl+C


By the end of this course, you'll be a total boss at Excel! Then you can take those skills to a whole new level by taking our Microsoft Excel VBA (Macros) course which builds off of the Macros portion of this course.

__________

NOTE: If you would like to receive CPE credit for this course, you must complete the final exam on our website. All lectures are compatible with Excel 2010, Excel 2013 or Excel 2016.

Who this course is for:
  • This course is for ANYONE in ANY industry who uses Excel semi-regularly
Course content
Expand all 40 lectures 03:14:46
+ Formatting & Keyboard Shortcuts
9 lectures 38:30
Intro to the workbook
03:19
Other formatting best practices
03:00
Keyboard shortcuts introduction
03:05
Basic keyboard shortcuts
03:17
Basic keyboard shortcuts II
02:48
The almighty ALT key
04:55
Customizing the Quick Access Toolbar
05:25
Quiz: Formatting & Keyboard Shortcuts
5 questions
+ Working with Ranges
4 lectures 18:11
Absolute cell references pt. II
03:08
Naming ranges pt. I
05:21
Naming ranges pt. II
03:50
Quiz: Working with Ranges
4 questions
+ INDEX/MATCH
6 lectures 31:02
Intro to INDEX/MATCH
04:11
The INDEX formula
03:43
The MATCH formula
04:53
Combining INDEX and MATCH
05:06
Examples of INDEX and MATCH
07:35
Case Study #1 - INDEX/MATCH & Locking down cells
05:34
Quiz: INDEX/MATCH
3 questions
+ Other Advanced Formulas
8 lectures 49:54
MIN/MAX pt. I
04:53
MIN/MAX pt. II
04:39
AND/OR pt. I
06:32
AND/OR pt. II
05:04
LEFT/RIGHT + LEN
07:38
Creating a dropdown list
06:10
CHOOSE for scenario analysis
06:44
Case study #2 - Combining MIN + IF + AND
08:14
Quiz: Other Advanced Formulas
5 questions
+ Advanced PivotTables & PivotCharts
4 lectures 24:43
Advanced PivotTables - Calculated fields
07:29
Advanced PivotTables - Running totals
06:59
PivotCharts pt. I
05:14
PivotCharts pt. II
05:01
Quiz: Advanced PivotTables & PivotCharts
3 questions
+ Intro to Macros & Protecting your Data
7 lectures 29:44
Preparing our workbook for macros
04:39
Overview of the Developer Tab
02:34
Recording our first macro
07:22
Running a macro and important macro information
04:48
Protecting an entire sheet
05:01
Protecting only certain cells
02:30
Protecting a workbook
02:50
Quiz: Intro to Macros & Protecting your Data
3 questions