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