Excel 2013: Data Tables and Charts in pdf

Lesson Objectives

In this lesson, you will:

• Create and modify tables.
• Sort or filter worksheet and table data.
• Use functions to calculate data.

Lesson Introduction

You've built worksheets and workbooks and used functions and formulas to analyze data. As your worksheets and workbooks grow in size and complexity, you might find it more and more challenging to locate and study the data you need to make business decisions. You want to organize the data in your Microsoft Office Excel 2013 files so that you can find the data you need as efficiently as possible. In this lesson, you will organize worksheet data with tables.