iTunes

Opening the iTunes Store.If iTunes doesn't open, click the iTunes application icon in your Dock or on your Windows desktop.Progress Indicator
Opening the iBooks Store.If iBooks doesn't open, click the iBooks app in your Dock.Progress Indicator
iTunes

iTunes is the world's easiest way to organize and add to your digital media collection.

We are unable to find iTunes on your computer. To download from the iTunes Store, get iTunes now.

Already have iTunes? Click I Have iTunes to open it now.

I Have iTunes Free Download
iTunes for Mac + PC

Sorting Excel Data: The Basics & Beyond

A definitive guide to sorting data managed in Microsoft Excel.

Maria Langer

This book is available for download with iBooks on your Mac or iOS device, and with iTunes on your computer. Books can be read with iBooks on your Mac or iOS device.

Description

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.

Sorting Excel Data: The Basics & Beyond
View In iTunes
  • $3.99
  • Available on iPhone, iPad, iPod touch, and Mac.
  • Category: Computers
  • Published: Jan 15, 2012
  • Publisher: Flying M Productions
  • Seller: Flying M Productions
  • Print Length: 114 Pages
  • Language: English
  • Requirements: To view this book, you must have an iOS device with iBooks 1.3.1 or later and iOS 4.3.3 or later, or a Mac with iBooks 1.0 or later and OS X 10.9 or later.

Customer Ratings

We have not received enough ratings to display an average for this book.