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
