Excel: Intro to Data Analysis

Excel: Intro to Data Analysis

145.00

This intro to Microsoft Excel data analysis course will teach you how to use several tools that allow you to analyze large amounts of data. We'll review pivot tables, charts, SUMIFS, COUNTIFs, and more. Enroll now!

Date:
Delivery Method:
Quantity:
Purchase Now

GSA Checkout → GSA

Course ID: A1200f

Duration: 3 Hours (9:00 am - 12:00 pm PST)

Location: In-Person (San Francisco) or Live Online | Click here to schedule private course.

Overview:

Microsoft Excel includes several tools that allow one to analyze large amounts of data… Master the use of these tools and you change the way you do business. Making sense of your data is essential in making key decisions for your organization. This course will teach you how to use some of the tools built into Excel that enable you to mine the answers hidden in your data records and unlock the analysis power of Excel.

+ Who Should Attend

Data analysts, Excel users who need to analyze, manipulate and visualize data.
Knowledge of Excel Introduction preferred.

+ Course Outline

Module 1 – Analyzing Data in Lists and Tables 

  • What is a well-defined list? 

  • Sorting and filtering records 

  • Format as table 

  • Sorting & filtering 

  • Total rows 

  • Remove duplicates 

  • Applying conditional formatting 

Module 2 - Summary Based IF Functions 

  • IF 

  • SUMIFS 

  • AVERAGEIFS 

  • COUNTIFS 

Module 3 – Chart Tools 

  • Creating charts 

  • Inserting Sparklines 

Module 4 - Building and Working with Pivot Tables 

  • Create a pivot table 

  • Sort & filter 

  • Summarize values by 

  • Number formatting 

  • Slicer 

  • Creating Pivot Charts 

 

+ Prerequisites

There are no prerequisites for this course.

+ Certifications

N/A

+ More Excel Courses