Skip to main content
Latest information and updates about COVID-19 (coronavirus) from McMaster University

MS Excel: Formatting and an Introduction to Data Analysis

This workshop will look at formatting and analysis techniques in MS Excel. You will require the use of a laptop with the Excel 2013 version to participate in this training (please note: Mac versions may not be fully-featured compared to PCs).

Overview

Andréa Grebenc from CompuStep will provide training on:

Formatting

  • Fonts, Borders and Cell Colour
  • Alignment and Merging Tools
  • Adjusting Numeric Formats
  • Row Column and Sheet Adjustments

Introduction to Advanced Analysis

  • Charting
  • Complex formulas
  • Functions
  • Pivot Tables

Any personal information you provide to McMaster University (“McMaster”) is collected, used, maintained and disclosed in accordance with the University’s Statement on Collection of Personal Information and Protection of Privacy http://www.mcmaster.ca/univsec/fippa/FIPPA_Statement.pdf. Any questions you have about the use of your personal information should be directed to Andrea Colbert-DeGeit at colbert@mcmaster.ca.