Ebook: MrExcel LIVe

Intro; Dedication; About the Author; About the Contributors; Foreword; Introduction; Part 1: The Top 54 Tips; #1 Double-Click the Fill Handle to Copy a Formula; #2 Break Apart Data; #3 Filter by Selection; Bonus Tip: Total the Visible Rows; #4 The Fill Handle Does Know 1, 2, 3a Bonus Tip: Fill Jan, Feb ..., Dec, Total; Bonus Tip: Fill 1 to 100,000 in a Flash; #5 Fast Worksheet Copy; Bonus Tip: Put the Worksheet Name in a Cell; Bonus Tip: Add a Total Row and a Total Column with One AutoSum; Bonus Tip: Power Up the Status Bar Statistics;Provides Excel tips and keyboard shortcuts to maximize efficiency with the spreadsheet software, covering such topics as recovering unsaved workbooks, pasting new data on a chart, and using a pivot table to compare lists.