In the increasingly data-driven world, solid Excel knowledge is an essential skill in order to be effective and successful. In this session, we will discuss specific topics that, when mastered, will set you apart as a professional.
Course ID: SOESKC
Stand Out with Your Excel Skills: Key Capabilities to Set You Apart
Learning Objectives
- Create and leverage LOOKUP functions with Exact and Approximate match to effectively supplement and expand a dataset
- Apply pivot tables to analyze data and extract insights
- Understand how macros can be used to automate work using the macro record function in Excel to get started
Major Topics
- LOOKUP functions (VLOOKUP, HLOOKUP)
- Creating analysis with pivot tables
- Workbook automation using basic macros
- Tips to accelerate your productivity with Excel
- An Excel workbook with content examples will be provided to all attendees for use when they return to the office
Who Should Attend
Any business professional responsible for managing and working with data
Fields of Study
Information TechnologyPrerequisites
Comfortable working with and navigating Excel. Skills in topics mentioned are not required.