Excel: Intro to Data Analysis

Who should attend

This live online Excel: Intro to Data Analysis course is for data analysts and all Excel users who need to analyze, manipulate and visualize data. Knowledge of Excel Introduction preferred.

Team Pass by Learnit

Excel: Intro to Data Analysis

From $0
Two, 2-hour Modules (9am - 11:30am PT)

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.

Course ID
L0027
Available times
June 17 & June 18, 2021
9:00am-11:30am
June 17 & June 18, 2021
9:00am-11:30am
June 17 & June 18, 2021
9:00am-11:30am
June 17 & June 18, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am

Course Outline

Learning Outcomes

1. Be able to identify a well-defined list and convert to Tables for advanced analysis techniques

2. Use excel’s summary functions to find high level values within data (total Sales, Total cost, etc)

3. Display Data in summarized formats with visuals using pivot Tables and Pivot Charts

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 

Summary Based IF Functions 

  • IF 
  • SUMIFS 
  • AVERAGEIFS 
  • COUNTIFS 

Chart Tools 

  • Creating charts 
  • Inserting Sparklines 

Building and Working with Pivot Tables 

  • Create a pivot table 
  • Sort & filter 
  • Summarize values by 
  • Number formatting 
  • Slicer 
  • Creating Pivot Charts 

Skills covered

No items found.