Excel and Analysis Clinic

 Microsoft Excel and Analysis Clinic 

What: Learn intermediate and advanced concepts in Microsoft Excel to make projects easier, make data more useful, and develop your employable skills.

When: Saturday June 6th, 2015

9:00am – 1:00pm

Where: Windsor Public Library – Central Location (Downtown)

850 Ouellette Ave

Windsor, ON N9A 4M9

What You Will Learn:

How to efficiently organize data

o Format tables

o Sorting

o Filtering

How and when to use advanced functions

o vlookup and hlookup

o Index and Match

o Nested if statements

How to create and use Pivot Tables

o Pivot Tables

o Pivot Charts

o Grouping

o Calculated Fields

How to analyze data and identify trends

o Trends

o Shifts

o Outliers

How to know which graph to choose and how to create it

o Bar Graph vs. Run Chart

o Categorical vs. Continuous

How to make your analysis presentable

o Labelling

o Titles

o Printing

o Create pdf files

Cost: $100 in advance, $125 drop-in

How to Sign Up:

Email: win.excel.experts@gmail.com

Phone: 519-551-7670

  • When: Saturday, June 6, 2015 9:00 am - 1:00 pm

    Venue: Windsor Public Library - downtown

    Where: 850 Ouellette Ave, Windsor

    Cost: Free