Sorting Excel Data - the Basics and Beyond: A definitive guide to sorting data managed in Microsoft Excel

Sorting Excel Data - the Basics and Beyond: A definitive guide to sorting data managed in Microsoft Excel

by Maria Langer
     
 

Wildly popular as a spreadsheet application, Microsoft Excel includes a robust collection of data management features, making it an excellent tool for working with lists of data. The ability to sort this data remains one of Excel's strongest and most-used features.

But exactly how do you use Excel's sorting features to organize data the way you need to? Ribbon and

See more details below

Overview

Wildly popular as a spreadsheet application, Microsoft Excel includes a robust collection of data management features, making it an excellent tool for working with lists of data. The ability to sort this data remains one of Excel's strongest and most-used features.

But exactly how do you use Excel's sorting features to organize data the way you need to? Ribbon and toolbar buttons, menu commands, dialog boxes, and hidden options-in Excel, sorting can be simple and complicated at the same time, often yielding surprising, undesired results.

This guide takes the mystery and confusion out of Excel's sorting features. It starts by covering the basics of simple, one-column sorts. It then builds on that information to explain multi-column sorting, setting up and using custom sort orders, sorting based on cell colors or icons, performing case-sensitive sorts, and sorting by rows instead of columns. Step-by-step, fully illustrated instructions make it clear what you need to do. Sample files available on the Maria's Guides website make it easy to repeat exercises so you can see the same results.

Although this book concentrates on Microsoft Excel 2010 for Windows and Microsoft Excel 2011 for Mac OS, it also provides useful tips and instructions for previous versions of Excel.

Don't waste time trying to decipher cryptic instructions in Excel's onscreen help. Get the information you need, written in a way you can understand by an experienced author who has been using, teaching, and writing about Excel for more than 20 years.

Read More

Product Details

ISBN-13:
9781886637054
Publisher:
Flying M Productions
Publication date:
01/15/2012
Pages:
116
Product dimensions:
6.00(w) x 9.00(h) x 0.24(d)

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >