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 share documents & use track changes to highlight changes in a document. Use Document Inspector to find hidden & personal data, Compatibility checker shows issues older Excel versions may have.
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.
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.
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.
Microsoft Excel is a very powerful tool that allows you to produce professional line graphs very quickly and easily. With intuitive functionality it's possible to create professional and relevant graphs with the click...
Using PMT, PPMT, IPMT, IF and IFERROR functions in Excel, we create an amortization schedule to calculate repayments / over payments as well as the amount of interest and principal paid on a mortgage.
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.