Advanced Data Analysis (MBA) by Marquee Group

| January 9, 2023
Submitted by Alex Cotoc for DeGroote School of Business
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.

 

Tags:
be curious | explore new possibilities | mba | think big
Categories:
ALL MBA | Bulletin Posts

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Comment Policy

We generally welcome discussion on our blog posts. However, we reserve the right to edit or delete comments in certain situations:

  • Comments which include unrelated or suspicious links or messages (spam).
  • Comments which are off topic.
  • Comments which attack or threaten individuals or a group of people.
  • Comments which include profanity or messages that would generally be considered offensive or inappropriate by the McMaster community.

This site is moderated by the DeGroote Marketing and Communications team. If you have any questions please email Katie Almas.