Power of Excel Introductory Bootcamp - Incoming TRSM Students

Learn to handle enterprise, business, and personal information with the industry's most widely used spreadsheet software. This Bootcamp prepares you with the foundational Excel skills that are vital in all areas of business and specifically targeted to your program. You are highly encouraged to attend and repeat these Bootcamps as often as possible to keep your skills up-to-date. Join us to learn the following skills!

Here’s What You’ll Learn

Terms and shortcuts used in an Excel document

Use linear algebra (SUMPRODUCT) to calculate student grades and analyze class performance

Understand how Excel references cells in two ways: static & dynamic

Understand what an array formula is and how to use them

Use conditional formatting to make your data more visually interesting and user-friendly

Understand how Excel handles dates, including how to calculate and format them

Use VLOOKUP, the most popular lookup tool in Excel, to transform one kind of data into another

Use SUMIF to conditionally aggregate data

Add a dropdown list to make your SUMIF interface dynamic

Analyze HR labour cost data to determine cost variance and present it in a dynamic table and dependent chart. This will involve recently added array formulas in Excel: SORT and UNIQUE