Presenter
- This event has passed.
Date & Time: March 17 at 11:00 am - 12:30 pm MDT
Location: Online
Member - Whole Org: $75 (for MNA members and members of partner state associations)
Non Member - Whole Org: $150
Free to All Access Pass holders.
Course Description:
Get ready to save yourself some staff time with the skills you learn in this course’s sessions! This course is for those with a basic comfort level in Excel who ready to learn how to dig into deeper data analysis through a comprehensive understanding of functions. This course’s two sessions, over two weeks, will cover a variety of formulas applied to different scenarios, and give you time to adapt, practice, and build your own for easy analysis.
By the end of the series, you will feel confident building complex formulas, manipulating data for specific uses, and analyzing complicated data questions. This might mean calculating revenue amounts by source, analyzing budget impacts of programs, or sorting contact information into more easily segmented lists.
Topics Covered:
- Numeric Functions: SUM(), COUNT(), MIN(), MAX()
- Logic Functions: IF(), VLOOKUP(), INDEX(), MATCH()
-
Text Functions: LEFT(), RIGHT(), PROPER(), CONCATENATE()
-
Newer functions in M365: XLOOKUP(), TEXTSPLIT(), FILTER(), SORT()
-
Conditional Formatting
All session recordings and resources will be available to registrants for 6 months following the conclusion of the course.
Not the right fit? This course is part of a full month of Excel-lence Bootcamp!
Spreadsheet 101 Bootcamp | March 3rd & 5th
Analysis 201 Bootcamp | March 10th & 17th
Visualization 301 Bootcamp | March 24th & 26th
Search by tag:
