| training courses |
Excel Training Course & Excel Tutorials Online
Free sample lesson: Creating Excel Formulas
This training course contains a series of video based tutorials which are designed to teach users the essential spreadsheet skills. It begins with the basics of the Microsoft Excel spreadsheet and quickly advances to cover the more advanced features, including functions, formulas, charts, importing and exporting data, Excel help and tips, and much more. You learn how to use Microsoft Excel in hours, not days.
Excercise files can be downloaded by subscribed members so you can follow along each tutorials and learn at your own pace.
Note: Monitor resolution needs to be set to at least 1024 X 768 to view the video tutorials.
Register and Start Learning Today
MS Excel 2003 Training Course Online
Click the links below to see the video tutorials
Chapter 1 - Getting Started
The interface
The menus
Customizing toolbars I
Customizing toolbars II
Navigating techniques
Getting help & assistance
Chapter 2 - Creating/Working with Excel Workbook
Creating a new workbook
Entering & editing data
Commenting
Chapter 3 - Managing Excel Workbooks
Saving & converting file to a web page
Opening a workbook
Securing an file
Adding and deleting worksheets
Adding rows & columns
Sharing files
Chapter 4 - Managing Excel Data
Working with data
Find & replace data
Naming cells & cell ranges
Creating lists
AutoFilter
Using data form
Data validation
Chapter 5 - Formatting Excel Worksheets
Formatting cells I
Formatting cells II
Adjusting width & height
Copying cell formatting
Using AutoFormat
Freeze/unfreeze rows & columns
Chapter 6 - Advanced Excel Worksheet Formatting
Using styles
Conditional formatting
Protecting cells
Inserting graphics
Chapter 7 - Working with Excel formulas
Operators
Creating formulas
Relative & absolute references
External references
Creating named constants
Concatenation
Chapter 8 - Working with Excel Functions
Functions & the function wizard
Common functions
Text functions
Date & time functions
Lookup functions
Chapter 9 - Working with charts
Creating charts
Editing charts
Formatting charts
Adding graphics to charts
Chapter 10 - Importing & Exporting Data
Importing data
Querying external database I
Querying external database II
Exporting data
Chapter 11 - Printing Excel Worksheets
Setting up
Headers & footers
Print what you want
Chapter 12 - Other Handy Excel Tips
Compare workbooks
Handy tricks
Useful shortcuts
{/author}
