Guide for creating to do lists in Excel 2007 / Excel 2010 using Check boxes and Combo boxes. Use Conditional Formatting using formulas and cell values with icon sets to add visual impact to your list.
MS Excel is one of the most popular data processing tools out there and there is a reason for this – this program can save you so much time once you learn how to use it properly.
A Speedometer, Dial or Gauge chart in your Excel 2007 / 2010 spreadsheet will look impressive, especially in a dashboard. It uses a Doughnut chart and Visual Basic code to create a moving needle.
Guide to Visual Basic or Visual Basic for Applications (VB or VBA) code in Excel 2007 and 2010, learning the basic commands, how to work with errors and how to run the code that you have written.
The SUMIF function in Excel is a great way to quickly summarize data without having to create a pivot table. Follow these simple step-by-step instructions and you will be a pro at it in no time.
Bubble charts created in Excel 2007 or Excel 2010 allow you to show data in three dimensions in a visually stunning chart. This can then be saved as a template to be used to create additional charts.
UserForms in Excel 2007 and Excel 2010 allow you to add fully configurable dialogue boxes or User Interfaces to your spreadsheets. They are easy to use, reduce typing errors, save time and look great.
Using List Boxes in Excel 2007 and Excel 2010 you can create visually appealing and very easy to use boxes containing lists of items from which users can select one or multiple items.
If you are using Microsoft Project to schedule and track your projects, at some point you will probably want to export your project data into Excel. Excel can then be used to analyse and summarise your project data using its wealth of features...
This article describes elements of a PivotTable as well as how to create one. A step by step approach to creating a PivotTable is illustrated that does not require an intermediate understanding of Microsoft Excel. An Excel workbook is made available so the reader can follow along.