Need to learn Excel quickly?
Learn Excel in 5 Days
Try the first class for FREE!

Need to learn Excel quickly? Learn Excel in 5 Days. Try the first class for FREE!

Who is this course for?

NEWBIES

You will learn the skill to enter a high-paying profession and know how to crush Excel job interview questions.

INTERMEDIATE

You'll learn how to do things the right way and put an end to all your #REF, #VALUE, #N/A errors and understand why they happen.

DATA ENTHUSIASTS

Lay the foundation necessary to move into the Power Query, and Power BI world you've heard so much about. Learn additional skills and become more demanded in the labor market.

Live Class Curriculum

  • CONGRATULATIONS! -- WELCOME! - Make sure to download the Excel workbook for this course, You will receive a download link for it in the confirmation email.  
  • Elements of the Excel Screen - Click This Do What? What's a Tab? - Where are the tool Groups? Did you say keep the Marquee in the data? - Here is where you learn the answers to those questions and more...  
  • Is This 2007, 2010, 2013, 2016, 2019, Office 365? What's The Difference? Just Look At The Ribbon! - What version of Excel are you working in? Does it matter? Yes it does!  
  • Saving and Compatibility - How to save and why knowing your Excel version matters.  
  • The QAT - Here is where you will discover many of the "hidden" features of Excel.
  • Begin With The End In Mind - The 7 Steps To Excel Success Explained
  • Step 1 - DESIGN - It's So Easy In The 21st Century - Templates - Learn how to tame the "World's Most Dangerous Program."
  • Step 2 - BUILD - Building Your Worksheet 
  • - Five Things That Can Go Into An Excel Worksheet 
  • - F2 to edit 
  • - Minimize Repetition - The Auto Fill Handle.  
  • - Learn How To Create A Custom Fill Series - No More Typing That List!  
  • - How Many Rows and Columns In Excel? Select All And The Name Box Will Tell You  
  • - Navigation Shortcuts  
  • - Insert Rows and Columns Like A Professional  
  • - Selecting Cells And Ranges Like a Professional  
  • - Universal Shortcuts - You Probably Already Know Them And Did Not Realize It.  
  • - Insert A Worksheet, Name It, Rename It, Move It  
  • - Move Worksheets To Another Workbook 
  • - Make Worksheet Names Standout With Color   
  • Step 3 - FORMULAS - Time To Add Some Calculations
  • - Please Excuse My Dear Aunt Sally! - Time To Remember Some 5th or 6th Grade Math. 
  • - Formulas - The Heartbeat Of Excel - The Cells Remain The Same What Changes Is..?  
  • - You Try - Relative Referencing - Let's Keep It Relative - F4 Is Your Friend  
  • - Example Of The Moment You Realize - It's Time To Start Thinking About Functions  
  • - What Is A Function? Preprogrammed Formulas - Excel Does The Math - Check it out!  
  • - The Most Basic Function - The AutoSum - So Much More Than Just Sum.  
  • - Learn To Delegate To Excel - Just Press Alt+= - The AutoSum Power Move!  
  • - Quick Overview Of The Insert Function Tool - Your Search Engine For Functions  
  • - Quick Tip - Zoom To Selection  
  • - Introduction to 3D Referencing - Enter Data In One Cell, It Appears In Another  
  • - 3D Referencing In Action 
  • - 3D Referencing - Formula Explained - Why Did That Work? It's All In The Set Up!  
  • - Practice More 3D Referencing - Did You Know You Can Link Your Workbooks? 
  • Step 4 - FORMATTING -Make It Pretty For The End User. Make It easy To Understand
  • - Why Format Your Data? Plus A Handy Way To Select Your Data Range - Ctrl+A 
  • - Let's Get Into Some Formatting - Make It Pretty! - Pus Some Formatting Shortcuts 
  • - Formatting Money - Should You Pick The Currency Method Or The Accounting Method? 
  • - Alignment- Customize The Orientation Of Your Values- Use Preset Formats (Styles) 
  • - The Format_Painter 
  • Step 5 - REPORTING - Garbage In...Garbage Out - What About Charts? 
  • - 7 Habits Of Efective Lists -Learn The Right Way To Set Up Your Data Effectivelly 
  • - Organize And Display Data - Sort It Out- But Avoid Merged Cells 
  • - Continue Sorting - Right Click To Sort - A To Z Sorting And Keeping It Together 
  • - Working with Tables - Ctrl+T
  • - Sometimes You Do Not Want To Show All The Data - Hide Rows And Columns With Ease 
  • - The Filter That Lives A Healthy Lifestyle - Auto Filter 
  • - Want To See What Your Numbers Are Saying? How About A Graphical Representation? 
  • - Visualize Your Data With Charts - Insert Charts And See What Your Numbers Say 
  • - Different Charts For Different Reasons - Change Chart Types - Make Them Pretty 
  • - Sparklines - Miniature Charts Inside Of Your Cells - They Make People Say Wow!
  • Step 6 - PRINTING - Learn Where The "Fit-to-One-Page" Button Is Located
  • - Print Correctly - Start With a Print Preview - There Is More Than One Way
  • - Tell Excel What You Want To Print - Set The Print Area  
  • - Now That Excel Knows What To Print Let's Make It All Fit To One Page  
  • - You Can Print Properly - How About Some Headers And Some Footers?
  • Step 7 - MACROS - Delegate to Excel 
  • - What's A Macro?
  • - Recording Your 1st Macro - Yes, It's That Easy  
  • - Run Your Macro  
  • - Wrap Up
  • That's it for the Basics - Next we will go Beyond the Basics! - In the next class you will take the 7 Steps To Excel Success Excel Basics skills to the next level.    Here is a sample of what you will be doing:
  • - Discovering the power of Excel Functions like: VLOOKUP, XLOOKUP, AND/OR, TODAY, and others. 
  • - Logical Functions like IF statements. 
  • - Learn how to write Nested function formulas. 
  • - Conditional Formatting.  
  • - Advanced Reporting. 
  • - PivotTables. 
  • - PowerQuery
  • - Power BI
  • - Macro editing. 
  • - And much more...
  • Stay tuned for Beyond the Basics!

The Best Way To Learn Is With Others. You will feel Excel-lent after 
each class!

5 - Live Excel Classes - Try The First Class For Free!

$147

  • Microsoft Certified Trainer (Valued $165/hour)
  • Comfortable class size
  • Custom Excel Workbook (Valued at $125)
  • Unlimited access to class recording
  • 5 - 1.5 hour sessions
  • Quizzes To Confirm Your Excel Skills
  • Simple assignments to reinforce your learning
  • Access to your MCT, MOS Excel Expert Instructor (Valued at $165/hour)
  • Fill in the blank PDF
  • E-book with 338 Excel Keyboard Shortcuts (Valued at $27)
  • E-book with 227 MAC OS Excel Keyboard Shortcuts (Valued at $27)
  • Completion Certificate With MCID (Valued at $265)
  • Access to a private community

You will learn everything you need to know to get going with Excel! These are all Instructor-led Live online classes. Each training is open to only 30 registered users. Hurry up and Book your Spot! Try the first class for FREE!

Class Schedule

choose your Live Class

October 10th - 14th, 2022

Class Times:
9:00am - 10:30am PST
11:00am - 12:30pm CST
12:00pm - 1:30pm EST
Class Days: M-F
Class Type: Online with Live Microsoft Certified Trainer
Last Day To Register: Wednesday, October 12th, 2022 @ 9:15am PST.

Special Fall Offer

$97


Regular price $147

October 24th - 28th, 2022

Class Times:
9:00am - 10:30am PST
11:00am - 12:30pm CST
12:00pm - 1:30pm EST
Class Days: M-F
Class Type: Online with Live Microsoft Certified Trainer
Last Day To Register: Wednesday, October 26th, 2022 @ 9:15am PST.

Special Fall Offer

$97


Regular price $147

November 7th - 11th, 2022

Class Times:
9:00am - 10:30am PST
11:00am - 12:30pm CST
12:00pm - 1:30pm EST
Class Days: M-F
Class Type: Online with Live Microsoft Certified Trainer
Last Day To Register: Wednesday, November 9th, 2022 @ 9:15am PST.

Special Fall Offer

$97


Regular price $147

November 21st - 25th, 2022

Class Times:
9:00am - 10:30am PST
11:00am - 12:30pm CST
12:00pm - 1:30pm EST
Class Days: M-F
Class Type: Online with Live Microsoft Certified Trainer
Last Day To Register: Wednesday, November 23rd, 2022 @ 9:15am PST.

Special Fall Offer

$97


Regular price $147

December 5th - 9th, 2022

Class Times:
9:00am - 10:30am PST
11:00am - 12:30pm CST
12:00pm - 1:30pm EST
Class Days: M-F
Class Type: Online with Live Microsoft Certified Trainer
Last Day To Register: Wednesday, December 7th, 2022 @ 9:15am PST.

Special Winter Offer

$97


Regular price $147

Billy "Mr. Aloha" Wigley

Your Premium Instructor is a Microsoft Certified Trainer with over 40,816 students enrolled in his courses on Udemy and more than 12,770 positive reviews. He always says: "Don't Get Mad...Get Skills!"

Microsoft Certified Trainer

Microsoft Certified Trainers (MCTs) are the premier technical and instructional experts in Microsoft technologies.