Back
About Mr.Excel
Consulting Services
Learn About Excel
Challenge of the Month

Message Board
Online Store
Search
Media
Contact
Home

 

 When Will You Upgrade to Excel 2007?

Excel 2007 will appear on retail shelves on January 30, 2007. This is the best new release of Excel 2007 ever. Among many features, you can look forward to:
  • 1.1 million rows
  • 16K columns
  • 17 BILLION cells, and that is just on Sheet1
  • Great new charting
  • SmartArt Business Diagrams
  • Find duplicates with a single click
  • Intelligent Tables
  • Pivot Table Improvements
  • New menu system (that still supports the old keyboard shortcuts)
  • Conditional Formatting that actually works
  • In-cell data bars, icon sets, heat maps
  • New functions that enable SUMIF and COUNTIF to work with multiple conditions
  • New functions that prevent DIV/0 and other errors
When do you think that you will upgrade to Excel 2007?


When will you upgrade to Excel 2007?
I NEED 1.1 million rows! I will be in line on January 30, 2007.
I'm intrigued by the new features - I will upgrade sometime in the first month or so.
This summer - I have to get through tax season first.
In a year - after the first service release comes out and I feel the product is completely stable.
At my company? Probably 2014. They finally just upgraded us from Excel 95.
I already have Excel 2007 - my company is on a subscription plan.
     Results

I spent a good deal of 2006 writing Special Edition Using Excel 2007 for QUE. It was an honor to take over the current edition of this long-running edition. With a completely new Excel 2007, I rewrote the book from scratch. Some highlights:
  • The first 19 chapters cover all of the new features in Excel 2007 in complete detail
  • The middle part of this book typically contained a function reference which in many cases was a rehash of the help file. I really set out to provide a real-life use for all 356 functions in Excel. If you've never gotten past 5 or 6 favorite functions, the middle section of the book book will be an entertaining read. (Even if you won't be upgrading, only five functions are new, so the reference guide on the other 351 functions is the most thorough that I've seen and worth buying the book).
  • The book finishes with coverage of the important Excel features which may not have changed significantly, but that you may not have discovered before. There is also an introduction to macros and a tour of some cool add-ins for Excel 2007.
Check out the book:
MrExcel.com Consulting can be hired to implement this concept, or many other cool applications, with your data.

MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.

 

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

All contents Copyright 1998-2005 by MrExcel Consulting.