Free Microsoft Office Training and Tutorials Blog




    



6 Excel 2007 Tutorials

These are 6 Excel 2007 Tutorials, from brainbell.com, that teach you how to create spreadsheets, use formulas and functions, work with charts and graphs, analyze data, and work with VBA and macros.


Worksheet Basics
Learn 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 Functions
Formulas 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 Graphics
Learn 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 Sharing
Learn 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.

Analyze Data
Learn how to obtain and analyze data with powerful and easy to use Excel capabilities.

VBA and Macros
Learn 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.

Comments



 
Name

Email

URL


Remember me?

Comments


Verification code
Verification code