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.
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.
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.
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.
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.
Format menu of Excel 2003 helps us to format the cells and the entire worksheet. It is through this menu that you can be able to change things like font, font colour, and font size of Excel document.
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.
Visual Basic loops can use IF, ELSE and ELSEIF or FOR NEXT statements to allow you to perform the same task on a large number of cells easily and quickly. You can easily group cells using cell ranges
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.
Excel will help you perform various calculations, produce graphs and analyze your data with ease. This free tutorial introduces you to the Excel basics. It is a comprehensive and easy to use tutorial.