Skip to content


Mastering Excel 365 - Advanced (2023)

by Bigger Brains

Course overview

Objectives. You will be able to:

  • Create, save, and use a custom worksheet template
  • Explore dynamic array functions
  • Use the LOOKUP, text, date, and database functions
  • Use advanced filtering and sorting techniques
  • Apply and modify data validation for numbers, text, and date cells
  • Use Subtotal functions and the Subtotals feature
  • Use Data Consolidation to summarize data from multiple ranges
  • Create, modify, and filter a PivotTable
  • Create macros and add form controls
  • Create custom charts and chart templates
  • Insert, format, and modify graphics, screenshots, symbols, and 3D models
  • Run the Accessibility Checker and address needed changes
  • Protect sheets, workbooks, and ranges

Your feedback is important, and helps your course provider to improve. Share your thoughts by leaving a review.

Currently there are no reviews for this course. Be the first to leave a review.

Bigger Brains is known for its high-quality online learning courses in both technology and business skills. Bigger Brains is acknowledged as one of the industry’s best suppliers of online... Read more