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

Description

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. Create Excel Tables for your data and understand why you need to
2. Understand 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. Understand 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.

Provider
Business Learning Institute
Course Level
Basic
Professional Area of Focus
Accounting and Auditing
Business & Industry
Technology
CPE Field of Study
Computer Software & Applications
4
Who Should Attend

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

Instructor(s)
Donald Tomoff
Prerequisites

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

Location
LIVE- ONLINE WEBCAST
Event Information
When
Sep 21, 2022
8:00 am - 11:30 am EDT
Location
LIVE- ONLINE WEBCAST
Total CPE Credits
4
Format
Live Webcast

MEMBER


$ (% off)
$160.00

NON-MEMBER


$ (% off)
$210.00
Become A Member

Register for this Event

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


Loading
Your browser is out-of-date!

Update your browser to view this website correctly.

Update my browser now

×