Excel 2007 Miracles Made Easy
July 2008
Unleash powerful new features!
Buy Now »Product Details
- 167 Pages
- Publisher: Holy Macro! Books
- ISBN: 978-1-932802-25-2
In this addendum to Learn Excel from Mr. Excel, the amazing new features offered in Excel 2007 are introduced. Revealing the features that make this new version the best new release of Excel since 1997, this guide provides the necessary information to teach users to quickly unleash the powerful new features in Excel 2007, create incredible-looking charts, customize color themes to match their corporate logo, utilize data-visualization tools, and learn Pivot Table improvements.
- Introduction
- Chapter 1 Introducing the Ribbon
- Chapter 2 Where Can I Find That on the Ribbon?
- Chapter 3 Keyboard Shortcuts
- Chapter 4 Taming the QAT & Finding the Mini Bar
- Chapter 5 Unlocking the Big Grid
- Chapter 6 Page Layout View
- Chapter 7 Tables
- Chapter 8 Data Visualizations
- Chapter 9 Sort by Color
- Chapter 10 Removing Duplicates
- Chapter 11 Seeing Totals in the Status Bar
- Chapter 12 Handling Large Blocks of Text
- Chapter 1 Creating Business Diagrams with SmartArt
- Chapter 1 Charting
- Chapter 15 All Text Can Be WordArt
- Chapter 16 Using Picture Tools
- Chapter 17 Handling Error Formulas Using IfError Function
- Chapter 18 New Conditional Sum Functions
- Chapter 19 Almost New Functions
- Chapter 20 AutoSum Tricks
- Chapter 21 Investigating Formulas
- Chapter 22 Formula Bar Tricks
- Chapter 23 Back into an Answer Using Goal Seek
- Chapter 24 Quick Translations
- Chapter 25 Preventing Distribution of Hidden Information
- Chapter 26 Finding Records with Filter
- Chapter 27 Pivot Tables
- Chapter 28 Fill Handle Tricks
- Chapter 29 Creating and Using Custom Lists
- Chapter 30 Joining Text
- Chapter 31 Splitting Apart Text
- Chapter 32 Adding Subtotals Automatically
- Chapter 33 Adding Subtotals Automatically
- Chapter 34 Recording a Macro
- Chapter 35 Solving Simultaneous Equations
- Chapter 36 Cool Uses for Excel – Solving Sudoku
- Chapter 37 Calculating Texas Hold-Em Probabilities
- Chapter 38 Download Cool Spreadsheets from Office Online
- Chapter 39 Get Excel Answers from the MrExcel.com Board
- Chapter 40 Document Themes & Cell Styles Across Microsoft Office
- Index
