Home > Browse Events > EXCEL-LENCE Spreadsheet Bootcamp (Partner Series)


EXCEL-LENCE Spreadsheet Bootcamp (Partner Series)

Four 75-minute sessions, Aug. 9-30, 1pm-2:15pm EDT

Description

This online series is offered in partnership through Montana Nonprofit Association (MNA).

Feeling frustrated with technology, particularly with data and spreadsheets? Then you won’t want to miss this four-part 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 over four sessions: 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.

Schedule + Topics

August 9: Excel Beginner
  • What is Microsoft Excel
  • Understanding the structure of Excel workbooks
  • Entering, formatting, and organizing Excel Data
  • Working with Cell References
  • Sorting and Filtering Data
August 16 + 23: Excel Intermediate
  • 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()
August 30: Excel Upper Intermediate
  • Excel Visualizations
  • Creating Charts and Graphs
  • Formatting Charts and Graphs
  • Conditional Formatting
  • Intro to PivotTables
Cost + Registration

For Individuals: 
  • MANP Members Save 50%!
  • $95 MANP members / $190 Nonmembers
  • Register as member to receive discounted rate - no promo code needed!
For Organizations: 
  • MANP Members Save 50%!
  • $150 MANP members / $300 Nonmembers
  • Invite as many people from your team for one flat rate!
  • Register as a member to receive discounted rate - no promo code needed!

Register Here

Event Information
All sessions will be recorded and the recordings will be available to all registered participants. Participants who are unable to attend one or more of the sessions will still have access to all course materials.

Questions?
If you have questions, please contact MNA’s Professional and Organizational Development Director, Shelby Rogala, at srogala@mtnonprofit.org or call (406) 449-3717.


Location + Directions

Location: Your Desk! Webinar Series
Online
Address and Directions
Google Map

Register for this Event or Find Other Trainings

Association Management Software by MemberSuite
   Core Version: 4.72.1.291