Welcome to the second part of our Microsoft 365 Excel courseware. This version of Excel incorporates some new features and connectivity options in efforts to make collaboration and production as easy as possible.
This course is intended to help all users become familiar with the more advanced selection of features of Excel. We will cover how to create and use advanced formulas, analyze data, organize worksheet data with tables, visualize data with charts, work with graphical objects, and enhance workbooks.
By the end of this course users should be comfortable in creating advanced formulas, analyzing data with functions, analyzing data using functions and PivotTables, working with tables, visualizing data with charts, working with graphical objects, and enhancing workbooks.
–
Prerequisites
This manual assumes the user has completed the first part of the Microsoft 365 Excel courseware or has an understanding of the information presented in that course, including:
Getting started with the app
Working with formulas and functions
Modifying worksheets
Printing workbook contents
Managing workbooks
Customizing the Excel environment
Topics
Lesson 1: Creating Advanced Formulas
Lesson 2: Analyzing Data with Logical and Lookup Functions
Lesson 3: Organizing Worksheet Data with Tables
Lesson 4: Visualizing Data with Charts
Lesson 5: Analyzing Data with PivotTables, Slicers, and PivotCharts
Lesson 6: Working with Graphical Objects
Lesson 7: Enhancing Workbooks
Reviews
There are no reviews yet.