Analyzing Data Using Excel

data analysis

Introduction

When you work with large amounts of data, you need tools to manage the sheer volume of information and get the most value from it. In this course, trainer will show a variety of ways to use sorting to order your spreadsheets, insert subtotals into sorted lists, see just data you need with filtering, identify and delete duplicate data, and use the SUMIF and database functions to further analyze your data.

Outline

1. Sorting Data

2. Filtering Data

3. Advanced Filter

4. Creating Automatic Subtotals in Sorted Lists

5. Eliminate Duplicate Data

6. Data Analysis Tools