2103 – Microsoft Excel 2016 Advanced EssentialsDownload Course Outline
Title: Microsoft Excel 2016 Advanced Essentials 2103; 1 Day, Instructor-led
This course is intended to help all users get up to speed on the different features of Excel and to become familiar with its more advanced selection of features. We will cover how to create and use advanced formulas, analyze data, organize worksheet data with tables, visualize data with charts, insert graphics, and enhance workbooks.
At Course Completion:
Audience & Prerequisites:
Course Outline Details: Working with Multiple Workbooks Working with multiple workbooks How to: consolidate data How to link cells in different workbooks How to merge workbooks Creating Advanced Formulas How to use range names in formulas and functions How to use specialized functions Visualizing Data with Charts How to create charts How to modify and format existing charts How to create a trendline How to create advanced charts Organizing and Analyzing Datasets and Tables How to create and modify tables How to sort and filter data How to use subtotal features Database functions Analyzing Data with PivotTables, Slicers, and PivotCharts Creating PivotTables Filter data using slicers Analyzing data using PivotCharts Enhancing Workbooks How to customize workbooks Manage themes Use templates Protecting files Preparing a workbook for multiple audiences Customizing the Excel Environment How to customize general, language, formula, proofing, and saving options How to use Excel’s version control features How to customize the ribbon and the Quick Access toolbar Enable add-ins Customize advanced and Trust Center options
Start Date: 10/27/2020
End Date: 10/27/2020