Advanced Data Analysis (MBA) by Marquee Group
This message does not apply to part-time students.
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.
Comment Policy
We generally welcome discussion on our blog posts. However, we reserve the right to edit or delete comments in certain situations:
This site is moderated by the DeGroote Marketing and Communications team. If you have any questions please email Katie Almas.