BOOT155

Excelling at Excel

Businesses are run and led by people who are good at understanding trends and patterns. In order to make better decisions, most businesses collect a lot of data; however, data without insight does not provide strategic benefits.

Excel allows you to unlock the hidden connections and map out valuable trends that very few would notice in a table of data.

This boot camp will help you learn powerful processes that transform the data you have available into tools that can support and develop business strategy. The instructors will walk you through real-world examples to gain hands-on experience while covering the following topics:

  • Data Import: imports, connections, validation, duplicates
  • Data Manipulation: vlookups, hlookups, arithmetic, functions, etc.
  • Data Hypothesis and Analysis: pivot tables, data enrichment, graphs, etc.
  • Data Extraction: PERL, CSV and PDF conversions (time permitting)

Please bring a laptop loaded with Microsoft Excel in order to complete in-class exercises. Previous experience with Excel is recommended but not required.

Currently not available for registration.

Instructors

Renee Chau

Renee Chau holds a joint major in business and computing science from SFU. As the current IT project manager at TELUS, she manages system-upgrade and server-migration projects, which involves coordinating tasks between multiple technical groups while liaising with business stakeholders to ensure requirements are met. Outside of TELUS, she sits on the access committee for the Burnaby Board of Trade and also coaches case competition teams for SFU's Beedie School of Business.

Daruvin Sood

Daruvin Sood holds a Bachelor of Applied Science in engineering physics from the University of British Columbia and worked in technical roles for multiple large corporations before settling at TELUS. After numerous years of hands-on experience with software projects in Business Transformation, he moved into the role of senior technology specialist, where he provides subject-matter consultation for developers. His active involvement in designing and implementing company-wide initiatives, liaising with vendors and providing training to end users gives him insight into current industry trends and how they can be applied to business settings.