During this two day, hands-on workshop you will learn:
- Range Names
- Name Error Analysis
- Applying Names in FOrmulas
- Using Named Ranges for Intersections
- Data Visualization
- Advanced Charting Techniques
- Importing Data into Excel
- Creating a popup user form in Excel VBA
- Macro’s in Excel
- Assign a button to a Macro
- Advanced IF statements
- Nested IF statements
- COUNTIF, SUMIF & AVERAGEIF
- Outlining Data in Excel
- Filtering Data using Slicers
- XLOOUP function
- Formatting Custom Numbers
- Using Excel Add-Ins
Who should attend?
This session is geared to First Nation staff who are comfortable with entering data and creating basic formulas in Microsoft Excel but are looking to explore more complex capabilities of the program to make them a more confident and proficient user.
Cost
$1,095.00 per person (includes GST, as well as lunch and refreshments)
Location, date & time
ASI Training Facility: 7th Floor, 294 Portage Ave., Winnipeg, MB
May 21 & 22, 2025
9:00 am to 3:30 pm