Free

Power of Excel SAF: Level 2

Event Information

Share this event

Date and Time

Location

Location

Ryerson University - Ted Rogers School of Management

Bootcamp Lab

TRS 3-180

Toronto, ON M5G 2C3

Canada

View Map

Event description
Power of Excel SAF

About this Event

Please note this event is targeting TRSM Ryerson students.

**Please note, you MUST register using your Ryerson Email and bring your OneCard for verification purposes**. There is 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.

**Please note that laptops are issued on a first-come-first serve basis. In the event that attendees exceed available laptops, attendees will be expected to use their own laptops to download the content/software. We always recommend that you bring a laptop with you to any registered Bootcamp.**

If you are interested in attending a specific Bootcamps but do not see an applicable ticket type, please email us at trsmbootcamps@ryerson.ca

New 'Sign-up Show-up' Policy Effective January 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.

Late Policy

The Bootcamp will begin no later than 12:10 PM. Kindly note once the session is in progress, registered attendees may not be admitted after 12:20 PM as the Bootcamp will be in progress. If you are running late, please email trsmbootcamps@ryerson.ca and we will try our best to accommodate you.

Power of Excel SAF (Level 1 - 3)

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 for a day of Excel to learn the following skills!

Here’s What You’ll Learn

Level 1: *Recommended experience: no experience required*

  • Calculating expected portfolio return
  • SUMPRODUCT
  • TRANSPOSE
  • Array functions
  • The significance of CTRL+ SHIFT + ENTER
  • Calculating arithmetic and geometric average stock returns
  • Calculating standard deviation
  • The significance of statistical population (.P) versus statistical sample (.S) functions
  • Calculating the correlation and covariance of a two-stock portfolio
  • Introduction to financial modelling and analysis
  • Working with effective and annual interest rates
  • EFFECT
  • NOMINAL
  • Time value of money (TVM) functions like PMT, FV, and PV
  • Data tables and sensitivity analysis
  • VLOOKUP
  • Tables
  • Drop down lists
  • Conditional formatting
  • COLUMNS
  • Collapsing rows
  • Custom conditional formatting

CASE: Construct an amortization schedule to model the life of a home mortgage

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

  • Construction of a fraud detection engine based on the Benford distribution
  • IF statements
  • COUNTIF
  • LEFT
  • CHISQ.TEST
  • OFFSET
  • LOG
  • Basic charting
  • ISTEXT
  • MATCH
  • Pivot tables

CASE: Use an A/R transaction list to calculate the individual turnover period on transactions, then rollup these calculations into the average A/R turnover period. Also, calculate bad debt expense

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

  • Introduction to more advanced financial modelling
  • Model structuring and formatting
  • Named arrays from selection
  • Circular referencing
  • Circular modelling of income tax and net income
  • Circular modelling of depreciation and accumulated depreciation
  • Circular modelling of Marketable securities and Revolver
  • SLOPE
  • INTERCEPT
  • Charting linear regressions
  • Regression reports using the Data Analysis ToolPak
  • Introduction to multivariate and nonlinear regression modelling
  • Introduction to modelling options portfolios and analyzing their linear characteristics

CASE: Construct a stock portfolio performance dashboard comparing an 8 stock portfolio to the TSX and a comparative savings account. Present the portfolio’s beta, annualized return, and dollar premium return over the market and savings account

FAQs:

How do I receive a badge?

Due to new check-in procedures to validate whether a student attended the sessions from beginning to end, we are are only issuing badges to students who completed Power of Excel, Tableau, Python, or R as of May 2019. 

If you are interested in attaining the badge, please complete the Bootcamps again and use it as an opportunity to test and refresh your memory on the skills. 

How do I receive my Linkedin Endorsement?

Please reach out to your Bootcamp Facilitator for your LinkedIn endorsements and follow the steps below:

1. Add the corresponding Bootcamp skill on LinkedIn

2. Connect with your Bootcamp Facilitator and send them a message once they have connected with you.

Example: Hi. I have attended the Power of Excel Bootcamp and would like my skill to be endorsed. My Ryerson email is ______@ryerson.ca

How can I cancel my ticket?

Please follow the instructions here to cancel your Eventbrite ticket. Please note, you can only cancel your ticket on a computer.

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

Share with friends

Date and Time

Location

Ryerson University - Ted Rogers School of Management

Bootcamp Lab

TRS 3-180

Toronto, ON M5G 2C3

Canada

View Map

Save This Event

Event Saved