Summarize, Organize and Format Data

Introduction

The Summarize, Organize and Format Data module provides you with the instructions and devices to develop your hands-on skills. This module includes the following exercises:

• Summarize and Organize Data

Lab time: It will take approximately 1 hour to complete this lab.

Exercise 1 - Summarize and Organize Data

In this exercise, you will learn how to work with Sparklines, which is one of the features when working with charts. Sparklines indicate the high and low points in data that is mapped in an Excel chart. A separate lab about working with charts is found in another module. The lab continues with summarizing data using subtotals and concludes with understanding how conditional formatting works."