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.
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.
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.
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.
Percentage formulas are used all of the time in Excel. It is important that you know how to write them.
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 the Left and Right functions in Excel will make you much more efficient. They are a great way to extract data from inside a cell.
The Insert Tab of Microsoft Excel 2007 is important as it helps you to insert objects like tables, pictures, charts, hyperlinks, symbols among others. It has been discussed thoroughly here.
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.
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.