Skip to content
CBT Nuggets

Microsoft Excel (Office 365 & 2021)

This intermediate Microsoft Excel (Office 365 & 2021) training teaches professionals how to create effective spreadsheets for storing, manipulating, and displaying data. Master formulas, charts, and graphs to improve productivity and storytelling. Whether you’re managing projects, tracking expenses, or analyzing data, this Microsoft Excel course will make you the Excel expert on your team.

Updated August 2022

16Skills
107Videos
15hTotal
107 videos15h

Who This Course Is For

This Microsoft Excel (Office 365 & 2021) training is considered foundational-level Excel training, which means it was designed for technical and non-technical professionals. This Excel skills course is designed for technical and non-technical professionals with three to five years of experience with Microsoft.

Skills Your Team Will Gain

  • Opening, navigating, and using spreadsheets
  • Formatting cells to hold different types of information
  • Writing formulas that process your data for you
  • Using multiple sheets within the same spreadsheet
  • Graphing and visualizing your data

Course Curriculum

  • Premium skill.Get Started with Microsoft Excel52m
  • Premium skill.Format and Structure Spreadsheets57m
  • Premium skill.Get Started with Formulas and Functions57m
  • Premium skill.Work with Charts1h 6m
  • Premium skill.Use Excel to Manage Lists55m
  • Premium skill.Analyse Excel Data with PivotTables50m
  • Premium skill.Visualise Data57m
  • Premium skill.Share and Collaborate in Excel55m
  • Premium skill.Learn More Excel Functions1h 4m
  • Premium skill.Perform a Forecast or What-If Analysis56m
  • Premium skill.Enhance Spreadsheets with Graphics, Themes, and Ink52m
  • Premium skill.Understand Excel Templates, Defaults, and Customisation56m
  • Premium skill.Link, Import, Export, and Manage Large Datasets58m
  • Premium skill.Get Started with Worksheet Forms and Macros53m
  • Premium skill.Excel Tips and Tricks51m
  • Premium skill.Excel for the Web60m

Readiness check

Confirm prerequisite knowledge before training begins

A short placement assessment on the CBT Nuggets assessments platform measures whether a learner already has the foundation this course assumes. IT Directors use it to put the right people in the right training — and any learner can take it right now to make sure they'll get full value from day one.

  • Questions generated from this course's own lesson transcripts — what gets measured is exactly what gets taught
  • Instant, per-learner results that show whether the prerequisite foundation is in place
  • Results roll up into team readiness reporting, so training hours go where they change outcomes

Runs on assessments.cbtnuggets.com — sign in with an Adept account so results roll up into team readiness reporting. Need one? Create an Adept account.

This course is included with every subscription

Get your team access to all 559 courses, virtual labs, and practice exams.

Most Popular

Team

$749per seat / year

5+ learner seats

Get Started

Enterprise

Customannual contracts

Any size

Contact Enterprise Sales

Just need this course?

Single-course enrollment — $29 for 1 year of access to Microsoft Excel 2021.

Enroll in This Course
Calculate the ROI of training your team

Trusted by 23,000+ organizations

Frequently Asked Questions

Ready to upskill your team?

Talk to our sales team to find the right plan for your organization.