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.
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.
Forms created in Excel 2007 and Excel 2010 using ActiveX List Boxes allow you to enter data into Excel quickly, easily and with a minimum of errors. A Command Button is also used to complete the form.
Excel has a pretty cool feature that allows you to insert a background image, that repeats infinitly, throughout the entire worksheet. The nice part is that 100% of the Excel worksheet is still fully functional. You...
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.
Sparklines are a new chart in Excel 2010 and can be simply and quickly placed in just one cell. They can be placed directly next to the data to add context to that data and show trends and variations.
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.
Excel 2007 has lots of built in templates as well as hundreds online. They allow you to save time and effort by saving formatting and data into a template which is then available for new spreadsheets.
Thematic maps show themes or variations across geographical regions. Data is linked to the chart in Excel 2007 or Excel 2010 using Visual Basic code which updates each part of the map automatically.
Visual Basic code allows you to configure a User Interface using a UserForm in Excel 2007 or Excel 2010. Scripts initialise the User Interface, configure the buttons and add data into the worksheet.