Excel 2007 Miracles Made Easy

MrExcel reveals 25 amazing things you can do with Excel

Buy the print version
Buy the E-Book version

"A quick tour of Excel 2007’s New Features" This book is designed to get you up to speed with Excel 2007’s new features. Whether you are thinking about upgrading or recently upgraded, I will take you through the important features in the new Excel. You will start out learning about the new ribbon interface, and move on through all of features designed to make your life easier in Excel. By chapter 25, I will start covering some features that were in the old Excel, but that you might not have ever discovered.

Table of Contents
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 13 - Creating Business Diagrams with SmartArt
Chapter 14 - 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 Transitions
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 - Using Speak Cells
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

Product Details

Paperback: 170 Pages ; Dimensions (in inches): 7 x 9 x 0.75
Publisher: Holy Macro! Books; ISBN 978-1-932802-25-2 (Feb 2007)
Price: $24.95

Buy the print version
Buy the E-Book version

There are over 150,000 pages at MrExcel.com. Use Google to search our site:

MrExcel Consulting can be hired to implement this concept, or many other cool applications, with your data.

Privacy Policy

Excel is a registered trademark of the Microsoft® Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.