Excel 2010 Made Simple

ISBN-13: 9781430235453 / Angielski / Miękka / 2011 / 372 str.

Abbott Katz; Msl Made Simple Learning

Opis

Get the most out of Excel 2010 with Excel 2010 Made Simple--learn the key features, understand what's new, and utilize dozens of time-saving tips and tricks to get your job done. Over 500 screen visuals and clear-cut instructions guide you through the features of Excel 2010, from formulas and charts to navigating around a worksheet and understanding Visual Basic for Applications (VBA) and macros. Excel 2010 Made Simple takes a practical and highly effective approach to using Excel 2010, showing you the best way to complete your most common spreadsheet tasks. You'll learn how to input, format, sort, and filter your data to find out what you want to know. You'll see how to place your data in tables and named ranges for easy access, all of which will get you working efficiently and productively. Excel 2010 Made Simple also covers the new features introduced in Excel 2010. For instance, it shows you how to use Sparklines for data comparison and the Backstage view for printing and sharing your spreadsheets, so you can carry out your tasks with minimum fuss. The hands-on focus on tasks means you'll see how to actually use Excel 2010 to suit your needs.

Spis treści

1. Introducing Excel 2010
2. Getting Around the Worksheet and Data Entry 
3. Editing Data
4. Number Crunching 101: Functions, Formulas, and Ranges
5. For Appearance's Sake: Formatting Your Data
6. Charting Your Data 
7. Sorting and Filtering Your Data: Excel's Database Features
8. PivotTables: Data Aggregation Without the Aggravation 
9. Managing Your Workbook
10. Printing Your Worksheets: Hard Copies Made Easy
11. Automating Your Work with Macros

O autorze

Abbott Katz, author of Beginning Microsoft Excel 2010, brings extensive Microsoft Office instructional experience to the task, having trained users of the suite s components in varied academic and corporate settings. He has a doctorate in sociology and wide-ranging writing experience as well. Abbott has composed, and continue to compose, numerous complex spreadsheets, twinning technical fluency with the imagination to realize Excel s potential in a diverse array of settings.