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


EXCEL-LENCE Spreadsheet Bootcamp (Partner Series)

Three 75-minute sessions, June 23, 30 + July 14, 1:00pm-3:15pm EST

Description

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

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

Schedule + Topics

June 23 - Session #1: Excel 101 (Beginner, entry level)
  • What is Microsoft Excel
  • Understanding the structure of Excel workbooks
  • Entering, formatting, and organizing Excel Data
  • Working with Cell References
  • Sorting and Filtering Data
June 30 - Session #2: Excel 201 (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()
July 14 - Session #3: Excel 202 (Upper Intermediate)
  • Excel Visualizations
  • Creating Charts and Graphs
  • Formatting Charts and Graphs
  • Conditional Formatting
  • Intro to PivotTables
Packages + Cost

Register as an Individual: 
  • MANP Members Save 50%!
  • $95 MANP members / $190 Nonmembers
  • Enter promo code MANP2021 at registration
Register as an Organization: 
  • MANP members save 50%!
  • $125 MANP members / $250 Nonmembers
  • Invite as many people from your team for one flat rate!
  • Enter promo code MANPWHOLEORG2021 at registration
Registration
  • Registration for this series is through Montana Nonprofit Association (MNA)
  • Select Non-Member upon registration and enter promo code to receive discount
  • Register here - don't forget to enter the promo code!
  • 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 about series content or how to register, 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