Learn about Microsoft Excel 2007
Learn more about the new features of Microsoft Excel 2007 and what are the things to look
out for in Excel 2007.
Read Excel 2007 files (.xlsx) in previous version of Excel
What happens if you are using 2003 and somebody send you a file that was created
in 2007? Other than asking them to save the file in a lower version or spend money
to upgrade to the new version, there is another option which will cost you nothing.
Download this
office converter from Microsoft Website
Creating pdf files using Excel 2007
To create a pdf file in previous version of Excel, we need to make use of the acrobat
writer which will set you back by a few hundreds dollars. Now, with Office 2007, you don't
even need to pay a single
cent to create a pdf document. All you have to do is download and install
this add-in from
Microsoft®'s website
and you are on your way to create a pdf file,
simply by saving your excel file in pdf format.
Beware of Conditional Formatting in Excel 2007
Conditional formatting in 2007 is filled with bugs. I found 2 so far and have another one from one of
my visitors. You can read more about it in my conditional formatting page.
You can also share with us your discovery though our Ask Us Page.
New Averageif Formula in Excel 2007
In the older versions of Excel, we have to calculate the average of a range of
numbers based on condition using a combination of sumif divided by countif. In
Excel 2007, you can calculate the average with a new single averageif formula.
The inputs is the same as that for sumif "=AVERAGEIF( Range, Criteria, Average
Range)". In fact, you could calculate average based on more than one condition
with the new averageifs formula.
The Averageifs is entered differently from the averageif formula. It
starts with the range of value to calculate the average, following by the
range for the 1st criteria, the criteria, criteria2_range, criteria2…..) i.e.
=Averageifs(Average_Range, Criteria1_range, Criteria1, Criteria2_range, Criteria2...)
Colours in Excel 2007
Excel 2007 has 16 millions colours, much more than the 56 colors in Excel 2003 and
below. There is no
excuse not to be draw professional and better looking charts with Excel 2007.
You can also share with us your discovery though our Ask Us Page.
|
