[VIRTUAL] Excel BM Bootcamp: Level 2

Please note this event is open to TRSM/Ryerson students only.

There are a limited quantity of tickets available exclusively to TRSM students, Non-TRSM students, TRSM Alumni and Ryerson/TRSM faculty/staff members. At this time, we do not accept any individuals outside of Ryerson University, however, we are working on this. Please check-in with us in 2020.

If you SIGN UP, the expectation is that you SHOW UP. If you can no longer attend, you MUST log back into Eventbrite and CANCEL your ticket. Instructions on how to cancel your ticket can be found here.

This session will be hosted virtually. All Ryerson attendees will be sent invitation details and instructions to your Ryerson email.

Kindly note that we will be tracking participation in the session by asking that you submit all completed work to a Google Drive folder. You MUST upload completed work into this folder for full consideration of the Power of Excel Badge (File Name: Full Name - Excel BM2).

'Sign-up Show-up' Policy Effective June 1st, 2020.

This policy targets students who are consistently signing up for Bootcamps and not attending them.

All students who sign up for a Bootcamp and do not show up without cancelling their tickets will be placed on a "no-show" list. There is a three-strike system that will be effective immediately. Once you receive your third strike, you will no longer be able to register for future bootcamps and our team will need to cancel your ticket immediately.

If you are unable to attend the Bootcamp you have signed up for, you must cancel your ticket by going back into Eventbrite and doing so at least 24-hours in advance to avoid getting on the no-show list.

We are putting this policy in place given the high demand for Bootcamps and long waiting lists of students who want to attend but are unable to do so due to a consistent number of no-shows.

Power of Excel BM (Level 1-3)

Here’s What You’ll Learn

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!

Level 1: *Recommended experience: no experience required*

• Terms and shortcuts used in an Excel document
• Use formulas to create basic financial sheets
• Use cell referencing to quickly solve problems
• Static vs. dynamic formulas
• Use charts to analyze data
• Detailed cell formatting
• Conditional formatting
• Use tables to organize data
• Math and trig formulas (e.g., rounding, average, median, min, max, sum)
• Text formulas (e.g., upper, lower, proper, left, right)
• Date and time formulas (e.g., year, month, date)
• Lookup and reference formulas (e.g., vlookup, transpose, choose)
• Logic formulas (e.g., if, or, and)

Level 2: *Recommended experience: Level 2 builds on and uses the skills learned in Level 1*

• Terms and shortcuts used in an Excel document
• Using data validation to create dropdown menus
• Lookup and reference formulas (e.g., vlookup, indexmatchmatch)
• Intermediate logic formulas (e.g., combining several logic formulas to create one function)
• Math and trig formulas (e.g., sum, average)
• Statistical formulas (e.g., count, counta, countif)
• Using goal seek to perform a what-if analysis
• Creating a one-variable and two-variable data table to perform a what-if analysis
• Troubleshooting in Excel (e.g., circular references)

Level 3: *Recommended experience: Level 3 builds on and uses the skills learned in Level 2*

• Terms and shortcuts used in an Excel document
• Creating interactive and visually compelling dashboards
• Organizing large amounts of data using PivotTables, PivotCharts, tables, slicers, charts
• Using advanced formatting to analyze data (e.g., sparklines, conditional formatting)
• Introduction to VBA (Visual Basic for Applications), the programming language of Excel
• Introduction to PowerPivot and PowerQuery

FAQs:

How do I receive a badge?

We are currently only issuing badges for Excel, R, Python, Power BI, Tableau and Marketing* Bootcamps. To receive a Badge, students are required to attend each Bootcamp in full, remain engaged throughout the entire session, and provide Luup feedback at the end using their Ryerson emails.

Please note for Virtual Bootcamps, attendees are required to upload completed work assigned for verification of participation.

Can I receive a Badge if I attend different series of a Bootcamp? ( Excel SAF Level 1 and 2 but BTM Level 3)?

No, you must attend all 3 levels of a specific Bootcamp Series in order to qualify for a badge. For example, you must attend SAF Level 1-3 or BTM Level 1-3. Students who attend different levels across multiple series will not qualify. (E.g., Completing SAF Level 1, BM Level 2, BTM Level 3).

How can I cancel my ticket?

Please follow the instructions in the link here to cancel your Eventbrite ticket. Please note, you can only cancel your ticket on a computer. If you run into any challenges while cancelling your ticket, please email trsmbootcamps@ryerson.ca

In the event that a Bootcamp is sold out and you have a legitimate reason to attend, please send a request to trsmbootcamps@ryerson.ca and we will place your name on a waiting list and do our best to accommodate. Please note that placement is not guaranteed.

If you require any special accommodations, please inform trsmbootcamps@ryerson.ca