Search Our Content Library

Learning Path Courses:

• Excel 365-Intermediate

  Excel 365- Intermediate
  (Approximate Duration: 180 minutes)

  Welcome to the Excel 365- Intermediate part of the Microsoft Office Excel 365 Learning Path.

  Course Objectives
  The material presented in this course will help you:
  Learn how to link workbooks and worksheets, work with range names, sort and filter range data, and analyze and organize with tables.
  Learn about conditional formatting, outline with subtotals and groups, display data graphically with charts and SparkLines.
  Understand PivotTables, PivotCharts, and slicers and work with their features.

  Course Prerequisites
  Excel 365- Beginners Course
   
  Tips:
  Turn off your phone, close your email, text and social media apps.
  Plug headphones or ear buds to your computer.
  Go Full Screen when watching videos.

• Excel 365- Beginner

  Excel 365- Beginner
  (Approximate Duration: 220 minutes)

  Welcome to the Excel 365- Beginners course, part of the Microsoft Office Excel 365 Learning Path.

  Course Objectives
  The material presented in this course will help you:
  Learn a solid understanding of how to use Excel.
  Teach the fundamentals of Excel and provide the skills to create and manipulate worksheets.
  Understand how to create, save, enter data, and print spreadsheets.
  Learn how to create formulas, and use functions to calculate in Excel.

  Course Prerequisites
  None
   
  Tips:
  Turn off your phone, close your email, text and social media apps.
  Plug headphones or ear buds to your computer.
  Go Full Screen when watching videos.

• Excel 365- Advanced

  Excel 365- Advanced
  (Approximate Duration: 270 minutes)

  Welcome to the Excel 365- Advanced Course, part of the Microsoft Office Excel 365 Learning Path.

  Course Objectives
  The material presented in this course will help you:
  Learn advanced concepts and formulas in Microsoft Excel 365.
  Learn functions such as SUMF, AVERAGEIF, and COUNTIF, advanced lookup functions, and complex logical and text functions.
  Experiment and understand auditing formulas and error checking using the What-if Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-ins.
  Work with Macros, use form controls, and ensure data integrity in worksheets and workbooks.

  Course Prerequisites
  Excel 365- Beginner
  Excel 365- Intermediate
   
  Tips:
  Turn off your phone, close your email, text and social media apps.
  Plug headphones or ear buds to your computer.
  Go Full Screen when watching videos.