Excel Intro to Data Analysis

What We'll Explore:

1. Be able to clean up data into well-defined lists and convert them to tables

2. Use Excel’s aggregate functions to conditionally apply summary calculations to the data

3. Display data in summarized formats using pivot tables and with visuals using pivot charts

Topics:

Analyzing Data in Lists and Tables

• Cleaning data into a well-defined list 
• Sorting and filtering records 
• Formatting as a table 
• Totaling rows 
• Removing duplicates 
• Applying conditional formatting 

Summary Based IF Functions 

• IF 
• SUMIF
• AVERAGEIF
• COUNTIF

Chart Features

• Creating charts 
• Inserting sparklines 

Working with Pivot Tables and Pivot Charts

• Creating a pivot table 
• Sorting and filtering 
• Summarizing values by fields
• Formatting numeric data
• Adding slicers
• Creating pivot charts 

• Be able to edit a spreadsheet by adding columns and rows
• Creating reusable fonts, and formats in workbooks by saving them as templates
• Adjust settings for workbook so its suitable for printing? using print options in Excel