

Excel Level 3 - Mar 20, Apr 28
Microsoft Excel Level 3 Class
Service Description
Microsoft Excel Level 3 / Advanced (2016, 2019, Office365) Course Overview: In this advanced Excel course, participants will delve into sophisticated functionalities, equipping themselves with upper-level skills to fully harness the capabilities of this potent software. The comprehensive curriculum covers working with Scenarios, utilizing Solver, employing advanced VLOOKUP functions, and mastering the creation and execution of Macros, along with proficient use of What-If analysis tools and data manipulation. Course Details: 1. Working with Scenarios: • Creating, Loading, Merging, and Editing Scenarios • Creating a Scenario Summary Report • Deleting Scenarios 2. Using Goal Seek, Solver, and VLookup: • Setting up the Worksheet • Utilizing Goal Seek • Running Solver • Generating Reports and Scenarios with Solver • Modifying Constraints • Setting Solver Options • Utilizing VLookup 3. Analyzing Data: • Enabling the Analysis ToolPak • Using Data Analysis Tools • Utilizing Data Tables 4. Managing Data: • Consolidating Information • Removing Duplicates • Configuring Data Validation • Transposing Data • Converting Text to Columns 5. Working with Slicers: • Inserting and Utilizing a Slicer • Renaming the Slicer • Changing Slicer Settings • Formatting a Slicer • Clearing the Slicer 6. Using Macros: • Recording a Macro • Writing a Macro using the Visual Basic Editor • Editing a Macro • Running a Macro
Upcoming Sessions
Contact Details
4313388726
BenninkTraining@shaw.ca
Winnipeg, MB, Canada