Beginning Microsoft Excel 2010

Contents at a glance -- Contents -- About the author -- About the technical reviewer -- Acknowledgments -- Introduction -- Chapter 1: Introduction To Excel -- Making the acquaintance -- Unlocking your inner worksheet -- Pep talk -- Interacting with the interface -- Tab talk -- Something new, something old -- Keeping tabs - on a new one -- Cool QAT -- Understood in context -- Alt-ered consciousness -- Chapter 2: Getting Started And Getting Around The Worksheet -- More addresses than the phone book-cells, and how to get there -- Getting around -- Key points -- Ranges: a select tool -- Data entry: getting started -- Entering text: trespassing allowed -- Numbers are (a little) different -- Relocating the data: copying and moving -- Having your fill -- There'll be some changes made-editing cells -- Chapter 3: From Data Entry To Data Creation: Formula Basics And Beyond -- Cell references explained -- Ordering up your results -- Not just your average function -- Making range values COUNT -- MAX and MIN-recording highs and lows -- Absolute references: absolutely important -- More of the same -- You could look it up -- If: worth knowing-no ifs, ands, or buts -- In conclusion -- Chapter 4: Keeping Up Appearances-Formatting The Worksheet -- You've got designs on your worksheet -- Font button group: a closer look -- Borderline command -- Getting oriented -- Excel has got your number(s) -- Dates-the long and the short of it -- Time is on your side-yes it is -- New kind of copy-and paste -- Style setter -- Formatting-with conditions -- Just a bit more -- P S -- In conclusion -- Chapter 5: Stuff Of Legend-Charting In Excel -- Starting charting -- Making a chart of our own -- Changing the chart-it's your call -- Design tab-a closer look -- Change chart type -- Save as template -- Switch row/column -- Select data -- Chart layouts -- Chart styles -- Move chart -- Changing the chart default-and the 2-second chart -- Layout tab -- Working with chart labels -- Axes to grind -- Format tab-getting your objects in shape -- Sparklines: mini-charts with big impact -- You win some, you lose some -- In conclusion -- Chapter 6: Setting The Table: Database Features Of Excel 2010 -- Sorting-sort of easy -- Using header rows -- Sorting by more than one field -- AutoFilter: picking and choosing your data -- Playing-or plying-the numbers -- Advanced filter-setting your data aside -- Table talk -- Creating a table -- Using table styles -- Adding a total row -- Examining the other table style options -- At the risk of repeating yourself: the remove duplicates option -- Data validation: improving your entree to data entry -- Using data validation -- Adding data entry rules -- Adding an input message -- Using the error alert option -- Adding a validation rule to existing data -- In conclusion -- Chapter 7: Working With Multiple Sheets -- Adding to sheets-inserting rows, columns and cells -- Inserting a column -- Inserting a row -- Deleting rows and columns -- Inserting and deleting cells -- Hiding rows and columns-and getting them back -- Multiple worksheet basics -- Inserting anew worksheet -- Busting a (sheet) move -- Hiding worksheets -- Grouping worksheets -- Far-flung formulas: working with multi-sheet cell references -- Doing a multi-sheet calculation -- Extending your reach: referring to cells in different workbooks -- Watch window-spying on your own data -- Protect your cells from unwanted intruders-even yourself -- Protecting a sheet -- Protecting a whole workbook -- Consolidating your data-getting it all together -- In conclusion -- Chapter 8: PivotTables And Pivot Charts -- Starting out with pivot-tables -- What's in a name? -- Constructing a pivot-table: let's go -- Inserting the table -- Setting up the pivot-table -- Updating the pivot-report -- Filters again-pivot-table style -- Your very own top 10 list -- Report filter-getting on top of the pivot-table -- Slicer-filter deluxe -- Grouping the data -- Formatting the pivot report-values and all -- Pivot charts -- In conclusion -- Chapter 9: Getting It On Paper-Printing In Excel 2010 -- Hard copy? Pretty easy -- Print area option -- Margin-al utility -- Printing as you see fit -- Headers and footers-getting to the bottom (and the top) of your printout -- Title search -- There's more than one way to view a worksheet -- Gimme a (page) break-another view -- Customize your view, too -- In conclusion -- Chapter 10: Taking It To The Cloud: Sharing And Collaborating On The Internet -- Getting there -- Permission granted: sharing your workbooks -- Hey-you! Get onto my cloud! -- In conclusion -- Appendix A: Working with range names -- What's in a name? plenty, if it's a range -- Naming many ranges-at the same time -- Name manager-tracking your ranges -- In conclusion -- Appendix B: Keyboard shortcuts -- Control key combinations -- Other shortcut keys -- Appendix C: Error messages -- Nobody's perfect -- Index.