top of page

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


Get In Touch

Bennink Training

Winnipeg, Manitoba
Phone: (431) 338-8726

Email: BenninkTraining@shaw.ca

  • Facebook
  • Twitter
  • Instagram
  • YouTube

© 2024 Bennink Training. All Rights Reserved.

We've Received Your Message!

bottom of page