Skip to Main Content
Microsoft Office Inside Out: 2013 Edition
book

Microsoft Office Inside Out: 2013 Edition

by Ed Bott and Carl Siechert
June 2013
Intermediate to advanced content levelIntermediate to advanced
912 pages
27h 36m
English
Microsoft Press
Content preview from Microsoft Office Inside Out: 2013 Edition

Chapter 13. Analyzing Data with Tables and Charts

Sorting out your data analysis options

Using tables to organize and analyze data

Sorting and filtering data

Using conditional formatting to highlight cells based on their content

Using sparklines to visualize trends within a range

Turning data into charts

EXCEL is no one-trick pony. Yes, the program works wonders with number-crunching tasks, but its rows and columns are also tailor-made for managing data that goes beyond basic bean counting. With minimal effort, you can keep address lists and membership rosters, track temperatures and rainfall, monitor stock prices, and record your performance in whatever sport or hobby you happen to fancy.

In this chapter, we look at the many options you have for entering, ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft Outlook 2013 Inside Out

Microsoft Outlook 2013 Inside Out

Jim Boyce
Office 2013 Bible: The Comprehensive Tutorial Resource

Office 2013 Bible: The Comprehensive Tutorial Resource

Lisa A. Bucki, John Walkenbach, Michael Alexander, Dick Kusleika, Faithe Wempen

Publisher Resources

ISBN: 9780735677517Purchase book