Course: Mastering the Essentials of Excel

iStock-3-People-on-Computer-870x400MACES’ 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

START DATE October 30, 2015
WEEKDAY Friday
DURATION 4 weeks
TIME 18:00 – 20:30
LOCATION Lab 1285, 688 Sherbrooke St
   

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.

Leave a Reply

Your email address will not be published. Required fields are marked *

Blog authors are solely responsible for the content of the blogs listed in the directory. Neither the content of these blogs, nor the links to other web sites, are screened, approved, reviewed or endorsed by McGill University. The text and other material on these blogs are the opinion of the specific author and are not statements of advice, opinion, or information of McGill.