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.
How to create and use Sparklines in Excel 2010 to summarise and add context to your data and to also show trends
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.
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.
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.
Microsoft's Excel has many terms and terminologies; some which are intuitive, some which are not. Here are 10 of the basic ones with full explanations.
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.
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.
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.
How to write Visual Basic code to configure a User Interface created using a UserForm in Excel 2007 and Excel 2010
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.
Step by step guide to password protecting and encrypting spreadsheets, worksheets and cell ranges as well as preventing the deletion, moving and copying of worksheets in Excel 2007 and Excel 2010.
Not finding what you're looking for? Browse other articles about Microsoft Office.