Virtual
Lang - Excel 2: Advanced Data Analysis
This is a full day seminar that combines interactive discussions with hands-on Excel computer work.
Date: Saturday, March 4th, 2023
Time: 9:00 am - 5:00 pm
Cost: $13.27 + HST ($15 total)
Location: Zoom Virtual Conference
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
- Experiences 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 [1]! Registration is set to close at 11:59 p.m. on March 1st.
For further information, please contact Nicole Drexler at ndrexler@uoguelph.ca
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.
