Excel Intro to Data Analysis- Standard

$ 140.00

Class Duration: 3 Hours

Class Agenda

Training Session 3 Hours
Breaks Prescribed by Instructor

Beyond simple averages and totals, Microsoft Excel offers many features to help you draw insights from your data. Sometimes those observations come from a particular formatting or visualization of the data; other times a specific summary function will generate a surprisingly significant result.

  • Be able to clean up data into well-defined lists and convert them to tables
  • Use Excel’s aggregate functions to conditionally apply summary calculations to the data
  • Display data in summarized formats using pivot tables and with visuals using pivot charts
  • Cleaning data into a well-defined list 
  • Sorting and filtering records 
  • Formatting as a table 
  • Totaling rows 
  • Removing duplicates 
  • Applying conditional formatting 
  • IF 
  • SUMIF
  • AVERAGEIF
  • COUNTIF
  • Creating charts 
  • Inserting sparklines 
  • Creating a pivot table 
  • Sorting and filtering 
  • Summarizing values by fields
  • Formatting numeric data
  • Adding slicers
  • Creating pivot charts 
“Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.”

The ability to work with and analyze data is critical to the success of your organization. For decades, Microsoft Excel has been the go-to application for doing so. Begin adding it to your professional skill set with our foundational Excel course. You will learn to navigate the application confidently while creating and developing worksheets and workbooks that employ the most popular features Excel has to offer.

DETAILED COURSE OUTLINE

Getting Started with Access

Working with Table Data

Querying a Database

Using Forms

Generating Reports

“Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.”

Event Details

Phone: (602)252-3955

Email: registration@trainingtoyou.com

Scroll to Top