MS Excel 2007 Tutorials
Worksheet BasicsLearn what Excel is used for, parts of Excel's window, Ribbon user interface, shortcut menus, dialog boxes and how to navigate Excel worksheets.
Formulas and FunctionsFormulas and worksheet functions are essential to manipulating data and obtaining useful information from the Excel workbooks. This tutorial present a wide variety of formula examples that uses many of Excel's functions.
Charts and GraphicsLearn how to use Excel's graphics capabilities to display your data in a chart and how to use Excel's other drawing tools to enhance a worksheets.
Data SharingLearn how to protect workbooks and worksheets and how to extract data from a database or xml file and analyze it with Excel 2007, and save excel worksheets or workbook for the web so people can browse it.
VBA and MacrosLearn how to: automate routine operations with macros and VBA, use the macro recorder, how macros work, and where Excel stores them. Learn how to use Visual Basic editor, important code techniques, and few useful macros.