EXCEL-lent Analysis 201 Bootcamp
Presenter: Montana Nonprofit Association
Cost: NDANO members $75, nonmembers $150
THE DISCOUNT CODE IS LOCATED IN THE MEMBERS-ONLY PORTAL
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
NDANO offers live in-person and online learning opportunities for nonprofits, often with partners. Members receive discounted rates on all NDANO events. All times are Central unless otherwise indicated.
Do you have a learning opportunity or event for North Dakota nonprofits to add to our calendar? Email NDANO with the details.
