Top Excel Techniques for Data Manipulation and Pivot Table Primer

Track: Data Analytics Symposium

Session Number: 1144
Date: Wed, Aug 8th, 2018
Time: 2:00 PM - 3:00 PM
Room: Room 317-318

Description:

Ideal for those who seeking to gain confidence working with data in Excel, Brian will present the top formulas and techniques in his toolbox for prepping data for analysis using Excel. We will cover merging data from multiple datasets, checking for duplicates, IF/ELSE statements, date-based arithmetic and handling N/A values. Pivot Tables will be introduced as a fast, easy way to aggregate your data.
Sub-Categorization: Start-Up Track
Session Type: Breakout Session

Primary Competency: DA:Competency 3: Data Manipulation Skills
Secondary Competency: DA:Competency 4: Statistical Techniques and Competencies
Tertiary Competency: DA:Competency 5: Visualization/Reporting Techniques and Competencies
Intended Audience Level: Level I
Recommended Prerequisites: Attendees should be familiar with looking and navigating data in Excel. This in not Excel 101, rather, this is a set of tools to make attendees more proficient and efficient with Excel.
Learning Objective #1: Attendees will be introduced for formulas and techniques they can use in Excel.
Learning Objective #2: Attendees will learn how to create and use Excel Pivot Tables.
Shop Size: All Shop Sizes
Sub-Categorization: Start-Up Track
Session Type: Breakout Session

Primary Competency: DA:Competency 3: Data Manipulation Skills
Secondary Competency: DA:Competency 4: Statistical Techniques and Competencies
Tertiary Competency: DA:Competency 5: Visualization/Reporting Techniques and Competencies
Intended Audience Level: Level I
Recommended Prerequisites: Attendees should be familiar with looking and navigating data in Excel. This in not Excel 101, rather, this is a set of tools to make attendees more proficient and efficient with Excel.
Learning Objective #1: Attendees will be introduced for formulas and techniques they can use in Excel.
Learning Objective #2: Attendees will learn how to create and use Excel Pivot Tables.
Shop Size: All Shop Sizes