Public Relations Programs

MACES’ objective with the MS Suite workshop is to equip students with the necessary knowledge to maximise their use of the fundamental features of Excel, Word, PowerPoint, and Outlook, something that we hope will be of great benefit to students.

The Excel Course – Mastering the Essentials of Excel – will launch this semester in preparation for a full launch in the winter 2016 semester. Course details are as follows:

Mastering the Essentials of Excel
COURSE DATES

COURSE FEE
$120

OUTLINE
¨      Indispensable keyboard shortcuts
¨      Organizing data in order to work efficiently in Excel
¨      Page set-up: using the fill handle, special cut and paste techniques
¨      Various addressing modes
¨      Financial functions (FV, PMT, IMPT, PPMT)
¨      Statistical Functions (AVG, COUNT, MIN, MAX, SUM)
¨      Median and logical functions (IF, COUNTIF, SUMIF, AND, NOT, OR)
¨      Date and time (NOW, TODAY)
¨      Text functions (TRIM, UPPER, LOWER, VLOOKUP, etc…)
¨      Automating layout custom formats and conditional formatting
¨      Creating graphics
¨      Updating multiple tabs
¨      Analysis tools: pivot tables, filters, and subtotals
¨      Using Scenarios
¨       Input control: protection and validation information

REGISTRATION
Students who wish take the course can register by emailing their name and student number to maces@mail.mcgill.ca. The deadline to sign up for the course is Wednesday, October 28, 2015, 17:00 p.m.