Advanced Data Analysis (MBA) by Marquee Group

Sign up for Marquee’s interactive MBA Career Workshop to learn Advanced Data Analysis at the RJC! This is a full-day workshop combining interactive discussions with hands-on Excel computer work.

• Use Excel’s Database functions so that Excel can be used instead of Microsoft Access
• Learn common uses for the Database functions, some of the most underutilized tools in Excel
• Discuss the rationale for using Static Names when building formulas
• Learn to create Dynamic Named Ranges, one of the most powerful concepts in Excel which allows users to automatically update graphs, Lookup functions and Pivot Tables
• Learn to create a Table (previously known as a List) to manage and analyze data
• Use Structured Reference functions to perform powerful calculations on a dataset
• Use some of Excel’s more advanced Lookup functions, including the Index function, and learn helpful applications for their use
• Use advanced conditional formatting tools to enhance the caliber of analytical output
• Review Excel’s security features, including some lesser known techniques to protect a spreadsheet
• Use Excel’s Data Validation tool to restrict a cell’s contents

Workshop details:

Wednesday, January 18

• Time: 9 am – 5 pm
• Location: RJC 214
• Cost: $66.37
• Registration: Please register both on OSCARplus and the Marquee website
  • Registration deadline: Sunday, January 15 at 11:59 pm (ET)

For more information, please email Disha Patel at pated148@mcmaster.ca.