Course ID: BEDIE

Basics of Exploring Data in Excel – Tables, Key Functions, and Pivot Tables

All professionals work with data. Understanding the fundamentals of using Excel to structure data and perform basic analysis is essential to effective performance in your career. Data structure, Excel Tables, Pivot Tables and Pivot Charts are the foundational skills for data analysis in Excel. This course will provide that foundation and prepare you to take on deeper data analysis using Excel and other tools.


Learning Objectives

After completing this course, you will be able to:
1. Distinguish Excel Tables for your data and recall why you need to
2. Identify proper structuring of data for pivot table analysis
3. Recognize how pivot tables and pivot charts can make analysis faster, easier, and more flexible
4. Recall modifying data fields to make analysis simple


Major Topics

We will work through the concepts of proper data structure, key functions, Excel tables and pivot tables. Interactive, hands on analysis will be performed with two typical datasets that accounting professionals frequently encounter. All attendees will receive the workbook datasets to take with them and practice their learnings after the session.


Who Should Attend

Any professional that desires to get better at analyzing data and conducting analysis in Excel.


Fields of Study
Computer Software & Applications

Prerequisites

Solid working knowledge of Excel. Previous experience with the specific topics is not required.


Provider
Business Learning Institute

CPE Credits
4.0

Level
Basic

This course is currently available for registration

Date Host Org CPE Format
06/15/2022 Business Learning Institute 4.0 In-Person --

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

×