Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Noble Desktop

Excel Bootcamp

via Noble Desktop

Overview

Become proficient in Microsoft Excel and go from beginner to pro with our hands-on Excel Bootcamp. Learn functions, formulas, Pivot Tables, macros, and time-saving techniques to conquer all the key skills needed to excel in Excel.

Syllabus

  • Excel Level I: Fundamentals
    • Learn how to use functions to speed up your workflow
    • Add formatting and other visual effects
    • Turn data into visual charts, including line, column, and pie charts
    • Learn tips and tricks for easy workbook management
  • Excel Level II: Intermediate
    • Learn to split and join text, add data validation, and named ranges
    • Use database functions and logical statements
    • Create Pivot Tables to quickly summarize large databases
    • Create advanced combo charts from multiple charts
  • Excel Level III: Advanced
    • Cell management including cell locking, auditing, and hot keys
    • Special formatting for calculating dates
    • Use advanced functions and advanced analytical tools 
    • Record macros and relative reference macros for ad hoc reporting

Taught by

Brian McClain, Mourad Kattan, Adebayo Norman, and Garfield Stinvil

Reviews

Start your review of Excel Bootcamp

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.