Excel 2: Advanced Data Analysis Seminar | Gordon S. Lang School of Business and Economics

Excel 2: Advanced Data Analysis Seminar

Date and Time

Location

Online - Zoom Virtual Conference

Laptop open with eyeglasses on top with The Marquee Group logo

Details

Lang - Excel 2: Advanced Data Analysis - For B.Comm Students ONLY

This is a full day seminar that combines interactive discussions with hands-on Excel computer work. 

New Date: Thursday, April 25, 2024 (rescheduled from May 9, 2024)
Time: 9:00 a.m. - 5:00 p.m.
Location: Zoom Virtual Conference
Cost: $44.25 + HST ($50 total)

Overview:

This session covers advanced level Excel topics that are required to manage and analyze data. This hands-on course is intended for anyone who uses Excel extensively and who is already comfortable with the skills that were taught in "Excel 1: Core Data Analysis" (Students should have a taken Excel 1 prior to taking this course)

Course Benefits:

  • Transforms participants into Excel "Power Users"
  • Bridges the gap between academic course work and real-world application
  • Prepares students for employment in the business world
  • Covers topics included in the training provided by major banks and corporations
  • Individualized attention from instructors
  • Experienced instructors are seasoned financial professionals

Learning Topics:

  • 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

Register for the course here! Registration is set to close at 11:59 p.m. on April 23rd. 

For further information, or if you need to cancel your registration, please contact Nicole Drexler at ndrexler@uoguelph.ca. **If 48 hours' notice is not given, registrants will forfeit the entire fee.

About the Business Career Development Centre

The Business Career Development Centre (BCDC) offers tailored career support to business students at the University of Guelph. The BCDC provides access to workshops, events and services including mentoring and networking opportunities, one-on-one career coaching, and assistance building your professional online presence. The BCDC strives to ensure the legitimacy of external events and workshops posted we promote to students. As a participant in any event or workshop, we encourage you to exercise due diligence, and research the integrity of the organization(s) prior to attending. If you have any questions or concerns, please contact our office.

Find related events by keyword

Events Archive