EXCEL-lent Analysis 201 Bootcamp
Event Details
This series is offered in partnership with Montana Nonprofit Association.
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
For More Information:
Cost + Registration
- MANP members save and discounts whole org participation! Invite your whole team (staff, board, and volunteers) for one flat fee.
- Whole Org: MANP Members $75 / Nonmembers $150
- Simply select the MNA Member rate when registering and be sure to provide your state when asked during registration, to verify. No code needed!
All sessions will be recorded and available for attendees to access, along with all session resources, for six months after the event.
About the Presenter
Adam Jespersen joined MNA in 2019 as its first Director of Innovation, and moved to Executive Director in 2024. As Executive Director, Adam is passionate about helping people, teams, and organizations across Montana find their stride in being more effective and impactful.