Actions and Detail Panel
VO Workshop: Excel 101
Wed, 1 February 2017, 9:00 AM – 12:00 PM EST
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.
Take this workshop if you have never used Excel before, or if your use of it is basically as a big table. You will learn ways to store and manipulate data, to help you make decisions and report to your manager or your board.
Afterward, you will likely find that your newfound skills allow you to save hours every week that you used to spend scratching your head over a calculator, freeing you up to do what you really love.
Create a new workbook and new worksheets in your workbook
Understand and use some of the different cell formats, like text, currency, percentage, date, and time
Use cell references to do calculations
Use basic functions, like SUM() and AVERAGE()
Convert a data table into a chart
What to bring:
Bring your laptop to this interactive session.
Who should attend
People who are beginners with Excel.
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.
For the direct link to the Volunteer Ottawa event page visit: http://www.volunteerottawa.ca/cgi/page.cgi/_evtcal.html?evt=82