The material shared here is meant to be used during Excel workshops, but was also designed to be usable for self-teaching.
Easy ExcelUse the main Excel file to learn useful Excel functions about formatting tables, preparing a worksheet for printing, conditional formatting, and filters.
Excel Pivot TablesLearn to visualize data using Excel's pivot charts and pivot tables. Please note that pivot charts are very version-dependant. Slicers and timelines can only be viewed properly and created in the most recent versions of Excel (2013+). Excel pivot charts are not always available for Excel for the Mac.
Fun with Excel FormulasYour pigeons have flown away! Learn about entering formulas in Excel, the difference between indirect and absolute addresses, and see an example of the use of the Indirect formula.
Excel Experts and Excel Macros
Learn to remove duplicates, use the vlookup formula, manipulate text, and create macros in a self-teaching Excel file that includes buttons! Please download the main file to your desktop, and make sure to click twice in the yellow ribbon ("enable content", etc.) if necessary.
Practice useful Excel functions with these exercises where data is retrieved and then formatted in Excel.
Excel and the Census AnalyserTry the first exercise to download data from the Census Analyser, and then follow the instructions and view the Office Mix to nicely format the file in Excel.
Excel and Nova Scotia Open DataFollow the instructions in the Office Mix to format and analyse the CSV files taken from the Nova Scotia Open Data Portal exercise.