2105 – Microsoft Excel 2016 ExpertDownload Course Outline
Title: Microsoft Excel 2016 Expert 2105; 1 Day, Instructor-led
Microsoft Office Excel 2016 is the newest version of Microsoft's popular spreadsheet program. This, the third level of Velsoft’s training program, explores the advanced features in in Excel 2016. Students will cover how to automate worksheet functionality, audit worksheets, analyze data, work with multiple workbooks, export Excel data and import/export XML data.
At Course Completion:
Audience & Prerequisites:
Course Outline Details: Analyzing Data with Logical and Lookup Functions How to analyze data by using text Logical functions Lookup functions Date and financial functions Auditing Worksheets How to: trace cells How to troubleshoot invalid data and formula errors Watch and evaluate formulas Create a data list online Automating Worksheet Functionality Automating worksheet functionality How to update worksheet properties How to create and edit a macro How to apply conditional formatting Add data validation criteria to a workbook Exporting Excel Data How to export data Import a delimited text file Integrate Excel data with the web Create a web query Importing and Exporting XML Data How to import and export XML data Analyzing and Presenting Data How to: create Sparklines How to create scenarios Perform a what-if analysis Perform statistical analysis with the Analysis ToolPak How to create interactive data with Power View
Start Date: 08/05/2020
End Date: 08/05/2020