june, 2021

This is a repeating event

23jun11:00 am12:15 pmFeaturedEXCEL-LENCE: Spreadsheet Bootcamp

more

Event Details

Join MNA for a 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 anactive subscription for Microsoft Excel.

Session #1: Excel 101 — Beginner (June 23)

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

Session #2: Excel 201 – Intermediate (June 30)

  • 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 #3: Excel 202 – Upper Intermediate (July 14)

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

Fees:

  • $125 MNA Member Whole Org
  • $250 Non-Member Whole Org
  • $95 MNA Member Individual
  • $190 Non MNA Member Individual

Time

(Wednesday) 11:00 am - 12:15 pm

Future Event Times in this Repeating Event Series

june 30, 2021 11:00 amjuly 7, 2021 11:00 amjuly 14, 2021 11:00 am

Leave a Reply

X
X