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.

Tired of turning raw video footage into ho-hum productions that make people yawn? Or, worse yet, just putting raw video out there and hoping for the best? If so, this guide is for you. It clearly explains how to research, plan, shoot, assemble, edit, and fine-tune video productions for just about any purpose. Richly illustrated with stills from an example movie, it'll get you on the right track to making movies that'll inform, entertain, and impress your audience.

Apple is leading the pack again-this time with a new ebook creation application that pushes the limits of ebook publishing. iBooks Author makes it easy for Mac users to create "multi-touch" ebooks that combine text, images, video, and interactive elements with finely tuned page layouts. "iBooks Author: Publishing Your First Ebook" helps you learn how to take advantage of iBooks Author's amazing feature set to create your own ebooks without a lot of trial and error experimentation. Using an illustrated, step-by-step approach, it guides you through the creation of a sample ebook with features you're sure to want in your own ebook publications.