GZ Events Template

Series: EXCEL-lence Spreadsheet Bootcamp

Wednesday, February 7, 2024 (12:00 PM - 1:00 PM) (EST)


4-part series: Wednesdays, February 7-February 28, 12-1pm ET 

Join us for a four week exploration of Microsoft Excel. If you work with any type of data, from grant reporting to program tracking, improving your skills in Excel is one of the easiest ways to level up your efficiency and productivity at work! This fast paced course will start at the very beginning in introducing Excel as an essential tool for any nonprofit professional and will build on that foundation to teach participants how to effectively organize, analyze, and visualize data in ways that make work easier, smarter, more productive, and more efficient.

This course will be broken into three sections: Excel 101 (Beginner), Excel 201 (Intermediate), and Excel 202 (Upper Intermediate). The only prerequisite for this course is that participants are encouraged to have an active subscription for Microsoft Excel.

Course Schedule

Session #1: Excel 101 – Beginner February 7

  • What is Microsoft Excel
  • Understanding the structure of Excel workbooks
  • Entering, formatting, and organizing Excel Data
  • Working with Cell References
  • Sorting and Filtering Data

Sessions #2 & 3: Excel 201 – Intermediate February 14 & February 21

  • Excel Functions
  • The structure of an Excel Function
  • Understanding Order of Operations
  • Numeric Functions: SUM(), COUNT(), MIN(), MAX()
  • Logic Functions: IF(), VLOOKUP(), INDEX(), MATCH()
  • Text Functions: LEFT(), RIGHT(), PROPER(), CONCATENATE()

Session #4: Excel 202 – Upper Intermediate February 28

  • Excel Visualizations
  • Creating Charts and Graphs
  • Formatting Charts and Graphs
  • Conditional Formatting
  • Intro to PivotTables

All sessions will be recorded and available for registered attendees to access, along with all session resources, for six months after the event.

Offered by our partners at Montana Nonprofit Association.

About the Presenter: Adam Jespersen, Associate Director of Montana Nonprofit Association, joined the Montana Nonprofit Association in 2019 as its first Director of Innovation after more than a decade of progressive experience in nonprofit management, leadership, fundraising, and grant writing. Raised in rural Montana, Adam received his bachelor’s degree from Carroll College and his master’s in business administration from the University of Montana. Trained and experienced in Lean management and person-centered design, Adam is passionate about helping people, teams, and organizations across Montana find their stride in being more effective and impactful and has been recognized for his ability to dive headlong into finding solutions and for his cooperative and thoughtful leadership approach. Adam lives in Helena with his wife and two daughters and enjoys hiking, skiing, and all that Montana has to offer.


KNN Members: $95 ($175 whole organization) (Login to the MIC and click on "KNN Member Discount Codes & Benefits" to access registration instructions.) if you have issues registering.

Potential Members: $190 ($350 whole organization)

Not yet a KNN member?  Join now and SAVE!

Wednesday, February 7, 2024 (12:00 PM - 1:00 PM) (EST)
Financial Management
Shared Webinar - National Council of Nonprofits
Powered By GrowthZone