Excel Level 3

Service Description

Who Should Attend: This workshop 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 and exporting and sorting data. Unit 1 Excel Online: • Learn about using both Excel Online and the Excel desktop application • Become comfortable managing workbooks in OneDrive • Opening and editing workbooks in both applications • Understand the benefits and obstacles that can be presented by each. Unit 2 Worksheet Automation: • Automate worksheets and their functionality • Manage workbook properties • Record and run basic macros, • Create and use templates • Use data validation criteria. Unit 3 Auditing and Error Checking: • Use formula auditing tools to trace errors and evaluate formulas • Track formulas using the Watch Window and the Camera tool • Arrange and display data using the Group commands. Unit 4 Data Analysis and Presentation: • Using the Quick Analysis Tool • Adding Sparklines • What-If Analysis tools and how to use them to explore different outcomes. Unit 5 Working with Multiple Workbooks: • Arrange, view, and navigate between multiple workbooks • Consolidate data from multiple sources • Create and maintain links between different workbooks • Resolve broken connections. Unit 6 Exporting and Sourcing Data: • Available file formats for exporting data, and how to create them • Understanding different data sources that can be accessed • The process of creating and sharing a Microsoft Form to support data collection Format: · One-day or two half-days, instructor-led online training session(s) Tools Provided: · Comprehensive Learning Guide · Subscription to our monthly LearningLink e-newsletter