Learn Advanced Microsoft Excel Skills

"Do you know any good Excel jokes? I know SUM." Learn advanced Excel w/a touch of humor, from an experienced instructor.

Last updated 2022-01-10 | 4.2

- Learn advanced Charts
- Formulas
- Shortcuts
- Pivot Tables and Visualizations.
- Build on your existing beginner to intermediate Excel skills.
- This course uses fun examples
- humor
- and an experienced instructor to make learning advanced Excel easy and interesting.

What you'll learn

Learn advanced Charts
Formulas
Shortcuts
Pivot Tables and Visualizations.
Build on your existing beginner to intermediate Excel skills.
This course uses fun examples
humor
and an experienced instructor to make learning advanced Excel easy and interesting.
Get ready for that raise
promotion or new job by supercharging your Excel skills.

* Requirements

* You should have a basic understanding of beginning Excel before starting this course.
* A willingness to learn and practice as you go to take your Excel skills to a truly advanced level.

Description

Tired of boring old Excel lessons?

Then you'll love Paul Ray's new style of teaching Excel. In this course, you'll learn advanced Microsoft Excel skills in a fun way using examples from a fictitious toy company. The humor might be cheesy, but make no mistake, the advanced Excel tutorials are extra meaty.

This course was specifically designed for students from Steve McDonald's beginning Excel courses to build on your existing skills. It's also perfect for any Excel user with a basic understanding of Excel who is ready to take their career to the next level. You'll learn awesome advanced functions, shortcuts, and data visualizations.

Here's what you'll learn in this course:

  • Advanced keyboard shortcuts

  • Powerful nested functions

  • Advanced table and cell referencing

  • Bad dad jokes

  • Scroll bars, check boxes and combo boxes

  • Conditional formatting

  • Combo charts

  • Pivot Tables

  • Stunning visuals with charts, pivot charts, slicers, timelines, and more

Here is our commitment to you with this advanced Excel course:

  1. You won't be bored

  2. You won't get left behind

  3. You'll love what you're learning

We guarantee you'll love the course! If, for any reason, you don't, within 30 days of your purchase you can get a complete refund. You can keep the skills that you've learned, along with all of your new dad jokes and you've lost nothing. So, what are you waiting for? Jump in and learn some advanced Excel skills today. 


Who this course is for:

  • Anyone with basic Excel skills and is ready to move on to more advanced skills
  • An employee who needs a raise, promotion or new job that requires advanced Excel skills.

Course content

5 sections • 38 lectures

Keyboard Shortcuts Preview 11:48

Nested Formulas Preview 11:56

Dates Preview 04:30

Quiz 1

Covers material from lectures 1-4

IFERROR, LEN, TRIM Preview 07:22

Advanced Cell Referencing Preview 06:10

Filtering, View Tab, and Trace Precedents Preview 09:01

Quiz 2

Covers material from lectures 5-7

Transpose, Paste Special, HLOOKUP Preview 09:05

Macros Preview 15:31

Text to Columns and Flash Fill Preview 09:10

Data Validation Preview 08:49

Quiz 3

Covers material from lectures 8-11

Sparklines Preview 06:52

Scroll Bars Preview 12:01

Check Boxes Preview 13:11

Combo Boxes Preview 07:12

Quiz 4

Covers material from lectures 12-15

Option Buttons Preview 09:21

Conditional Formatting Preview 10:53

Advanced Chart Features Preview 09:43

Combo Charts Preview 14:24

Quiz 5

Covers material from lectures 16-19

Pivot Table Basics Preview 14:09

Sorting and Filtering Preview 09:49

Pivot Table Visuals Preview 06:26

Quiz 6

Covers material from lectures 20-22

Summarize Values and Advanced Tips Preview 13:47

Show Values As (Part 1) Preview 06:58

Show Values As (Part 2) Preview 08:56

Learn all about Show Values as in this lecture.

Calculated Fields (Part 1) Preview 13:45

Calculated Fields (Part 2) Preview 10:39

Pivot Charts Preview 13:15

Slicers and Timelines Preview 10:44

Quiz 7

Covers material from lectures 23-29

How to Get Your Course Certificate Preview 00:36

Conclusion Preview 06:46