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

Who Should Attend

Any business professional responsible for managing and working with data


Fields of Study
Information Technology

Prerequisites

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


Provider
Business Learning Institute

CPE Credits
4.0

Level
Intermediate

This course is available for your group as:

 

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: or team@blionline.org
Your browser is out-of-date!

Update your browser to view this website correctly.

Update my browser now

×