Help Menu Commands in Excel 2007
Wednesday, October 22nd, 2008 Posted in Excel | No Comments »In this post we look at the Help menu commands in Excel 2007. This also concludes our menu series. We have barely scratched the surface on commands in Excel 2007. Not convinced. Open up the Excel Options and under Customize ...
Excel Automatic Filling (AutoFill) – Data and Patterns
Monday, October 20th, 2008 Posted in Excel | No Comments »In this post we continue exploring Excel’s autofill feature. Last time we looked at the basics of filling. We saw how to enter data in a few cells and then use the fill handle to extend that data to a ...
Excel Automatic Filling (Autofill) - The Basics
Tuesday, October 14th, 2008 Posted in Excel | 1 Comment »Excel is full of time saving features. One such feature is the ability to automatically fill cells with data. Excel is able to recognize data and patterns and fill cells in an intelligent way. This is a real boon when ...
Sort by Cell Color
Tuesday, October 7th, 2008 Posted in Excel, how-to | No Comments »Most of you probably already know how to sort data by alphabetical or numerical order from highest to lowest or lowest to highest and by several columns if required. In Excel 2007, you can also sort by cell color or ...
Office 2003 SP2 Support Ending in October 2008
Sunday, September 28th, 2008 Posted in Excel | No Comments »Still using Office 2003 SP2? Well, the bad news is that Office 2003 Service Pack 2 support ends on 14 October 2008 as announced by Microsoft. In order to continue support in Office 2003 you will need to upgrade to ...
Excel Tornado Charts
Wednesday, September 17th, 2008 Posted in Charts, Excel | 1 Comment »Tornado charts are bar graphs. Excel is an excellent tool for producing them. Tornado charts can be used, for example, to show the results of sensitivity analysis testing or to highlight differences between two groups. An example of a Tornado chart ...
