Excel 2007 / 2010 - What's New?
Auto filters
The improvement done to Excel 2007 and Excel 2010 is the ability to group the dates in
the dropdown list into years and months. That means you don't have to create new columns
to identify the years and months of each row using Excel formulas. In addition, you can now
select multiple values in the dropdown list for filtering. Instead of scanning through
row and rows of records to identify those that are coloured with a certain color, you
can filter the records by colour and have auto filter present you with all the
selected coloured records.
Customised Ribbons / Menu for Excel 2010 only
In Excel 2010, you can customize your own Ribbon (i.e. Tab) and put your frequently use commands in one place.
In this way you do not have to click from one Tab to another to find your commonly used command. In my Excel 2010, I have
a Tab called Jason that stores all the commands I use frequently. See picture below:
To find out how to set it up, click on this Ribbon and Quick Access Toolbar link.
Sorting
In the earlier vesion of Excel (2003 and below), sorting can only be done based on the values
or text in the cells. The improved version allows you to sort the records based on the colour
coding in the cell. Not only that, you can also sort the records by the font colour. That's
new in Excel 2007 and 2010.
Multiple Conditional Count
Multiple conditional count is now made easy with Excel 2007 and 2010. In the older Excel
verions 2003 and below, we are able to count based on one single condition. To work on
mor than one condition, we would have to form another column and combine all the conditions
together. Now, all we need is to mark out all the conditions within the formula and boola!
the count is computed for us.
Multiple Conditional Sum
When I was using Excel 2003, multiple conditional sum has to be done using the formula
SUMPRODUCT or by combining all the conditions into one before applying the formula SUMIF
to the data. With the new Excel 2007, you can now easily sum up the values based on
more than one condition by using the SUMIFs formula.
Click here to see the difference between excel formulas and functions
•
|
New! Comments
Have your say about what you just read! Leave me a comment in the box below.