Sales Ended

VO Workshop: Excel 201 - Pivot Tables & Charts

Event Information

Share this event

Date and Time

Location

Location

Volunteer Ottawa

363 Coventry Road

Ottawa, ON K1K 2C5

Canada

View Map

Friends Who Are Going
Event description

Description

Everybody needs to use numbers to do analysis. Whether you are tracking volunteer hours, counting donor dollars, or planning spending for the month, you need to keep track of numbers and use them to plan for the future. Excel can be used to conduct planning, manage budgets, create charts, analyze usage data, and keep records.

A lot of us know how to enter data into Excel and use basic functions like =SUM() or =AVERAGE(). That is a good start, but Excel is so much more powerful than that. Come to our workshop to learn how to use this great tool to ask more sophisticated questions of your data, and give your manager, your board or granting organization the information they are asking for.

After completing this workshop, participants will be able to

  • Graph data using multiple types of charts, and know which type of chart is the best for each data inquiry
  • Use cell references to make your tables and charts more easily updatable
  • Use statistical functions
  • Use pivot tables for quick cross-tabulation of large data sets

Bring your laptop for this interactive session. Time-permitting, you can bring up your own Excel conundrum for the group to solve together.

Who should attend

Anyone who needs to write or interpret reports. This may include program managers, finance managers, or Executive Directors

Share with friends

Date and Time

Location

Volunteer Ottawa

363 Coventry Road

Ottawa, ON K1K 2C5

Canada

View Map

Save This Event

Event Saved