Course ID: SOESKC

Stand Out with Your Excel Skills: Key Capabilities to Set You Apart

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.


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

DESIGNED FOR
Any business professional responsible for managing and working with data

FIELD OF STUDY
Information Technology

PREREQUISITES
Comfortable working with and navigating Excel. Skills in topics mentioned are not required.

COURSE PRODUCER
Business Learning Institute

CPE CREDITS
4.0

LEVEL
Intermediate

This course is available for your group as:

Group Live
 

Let's Roll!

To learn more or customize this course for your group, complete this form and a BLI team member will get back with you shortly.


Or, contact BLI: 888-481-3500 or learn@blionline.org