Welcome to the third part of our Microsoft 365 Excel courseware. Excel is Microsoft’s powerful and easy-to-use spreadsheet program. This new version of Excel incorporates some new features and connectivity to make collaboration and production as easy as possible.
This course is intended to help all users get up to speed quickly on the advanced features of Excel. We will cover:
Using Excel Online
Worksheet Automation
Auditing and Error Checking
Data Analysis and Presentation
Working with Multiple Workbooks
Exporting and Sorting Data
By the end of this course, users should be comfortable in both the online and desktop environments, using automating functions, analyzing and presenting data, auditing and error checking your work, working in multiple workbooks, and accessing and distributing data.
–
Prerequisites
This manual assumes the user has completed, or has an understanding of the materials covered, in the first and second parts of the Microsoft Office Excel 365 courseware, including:
Excel basics
Working with data
Modifying worksheets
Printing workbook contents
Managing large workbooks
Customizing the Excel environment
Creating advanced formulas
Analyzing data with logical and lookup functions
Organizing worksheets data with tables
Visualizing data with charts
Analyzing data with PivotTables, slicers, and PivotCharts
Working with graphical objects
Enhancing workbooks
Topics
Lesson 1: Excel Online
Lesson 2: Worksheet Automation
Lesson 3: Auditing and Error Checking
Lesson 4: Data Analysis and Presentation
Lesson 5: Working with Multiple Workbooks
Lesson 6: Exporting and Sourcing Data
Reviews
There are no reviews yet.