Learn Advanced Microsoft Excel Skills
Tags: Excel Analytics
"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
* 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:
You won't be bored
You won't get left behind
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
Introduction Preview 01:24
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