Mise à jour COVID-19

BO est en train de recruter et de déployer des bénévoles pour répondre aux besoins en matière de bénévolat liés spécifiquement à la COVID-19 à Ottawa, à Prescott-Russell, dans le comté de Lanark et dans le comté de Renfrew tout en assurant des protocoles de dépistage et de formation appropriés pour protéger la santé des bénévoles et de ceux qu'ils aident. Veuillez trouver les portails d'accueil des bénévoles, des membres et des autres organisations sur notre page d'accueil. Le programme de déploiement de volontaires COVID 19 de BO est soutenu par le Fonds de soutien communautaire d'urgence du gouvernement du Canada et la Fondation communautaire d'Ottawa.

Espace Membres Événements English | Français Panier
Skip to main content
Inside Banner
  • VO Événement/Atelier
  • Evénements publiés par les membres

VO Workshop: Excel 202 - Dive into Data with Pivot Tables and Data Substitution

mai 28, 2020, 9:00 AM - 12:00 PM

Workshop_Images/Excel_202.jpgEverybody 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.

Learning Objectives

After completing this workshop, participants will be able to

  • Organize spreadsheet data in such a way as to facilitate maximum opportunity for data analysis
  • Create and interpret pivot tables to
    • Summarize data
    • Identify trends
    • Create dashboards and reports

What to bring

Bring your laptop for this interactive session. You may also wish to bring your own data to work with, if you can do so without compromising confidentiality policies.

Who should attend

Anyone who needs to write or interpret reports and who has a solid basic grasp of Excel, including cell references, basic functions, and basic charts. This may include program managers, finance managers, or Executive Directors

Instructor

Maria Lahiffe, VO’s Education Officer, has a rich background in data analysis and education. She started her career as an Environmental Engineer, where she managed wilderness monitoring projects which collected data remotely every 15 minutes for 7 months per year. She analyzed all that data each winter and turned it into slick reports. After that, she spent 13 years in K-12 education, where she honed her skills in simplifying difficult topics. Maria is a confirmed data nerd who loves helping others learn how much valuable information can be extracted from data.


Info:

Please contact Maria Lahiffe, Education Officer, at 613-736-5266 ext 114 or 


Cancellation policy: 

An email confirming this registration will be sent to the primary email address for your member account, or the email address on this form if you are a non-member. Your registration is transferrable to anyone else within your organization. The following workshop registrations are non-refundable: (a) purchased at a discounted rate, (b) purchased using a voucher, or (c) cancellation received less than five (5) business days prior to the event. Any other cancellation is refundable, subject to a $10.00 administration fee

Rideau Community Hub (Former Rideau High School)

Carte

Coordonnées

815 St Laurent Blvd
Ottawa, ON
Canada K1K 3A7

Téléphone: 613-736-5270

Courriel: info@volunteerottawa.ca
web: www.volunteerottawa.ca

Inscription

Il reste 11 place(s)