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.
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.
Percentage formulas are used all of the time in Excel. It is important that you know how to write them.
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.
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.
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.
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.
Microsoft Excel can do some amazing things. I like to attempt little projects testing what Excel can do. I was asked the other day to simulate a cup draw using Excel and this is the result. This article will give you access to the completed Excel...
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.