|
|
|
70 Free Excel Videos |
|
|
|
Online training is excellent these days and with more and more people on broadband it is possible to deliver high quality training directly to your computer right now! No need to
wait for the postman or wait for the college night or training course - you could be learning new stuff in the next 5 minutes.
As the market has grown over the last few years I have seen better
and better offers come to the market. On line training used to be
expensive and only available for a handful of subjects - but now
the market has opened up, the choice is fantastic - and as it's a
very competitive market it means the price is being driven down and
the quality up.
Try before you Buy....
Many sites will allow you to try before you
buy any of their courses and the site below is no different, but
they allow you to try much much more than the majority of other
sites. In fact you will see that you can try 15 on Excel 2003, 25 on Excel 2002 and 35 on excel 2000
without even giving them your name and email address.
I have included links below to the free modules in the VTC training course on Excel. Simply click on each link and the tutorial will start in a new window - no charge, no registration and no fees - I promise.
If you want to complete the course then I am afraid you will need to register with VTC.com as I have not been able to get them to give you the whole course free - Sorry! I am a signed up member of VTC and I cannot live without it - $30 a month for access to over 20,000 videos such as these.
Enjoy the movies and above all - Improve Your Excel
Kind Regards,
Clayton
CLICK HERE
Microsoft Excel 2000
Introduction
Getting Started
The Interface
Menus
Toolbars
Formula Bar
Columns & Rows
Scroll Bars
Sheet Tabs
Status Bar
Interface Review
Workbooks & Worksheets
Open and Close Workbooks
Save Workbooks
Getting Help
The Basics
Select and Navigate Cells
Enter Data
Edit and Delete Data
Cut / Copy and Paste
Undo and Redo
Drag and Drop
Auto Fill
AutoCorrect
Working With Worksheets
Zoom Control
Views
Resize Rows and Columns
Insert Cells
Delete Cells
Insert and Delete Rows and Columns
Rename Worksheets
Insert and Delete Worksheets
Move and Copy Worksheets
Hide and Unhide
Formatting Cells
Text Formats
Align and Text Wrap
Alignment Effects
Format Painter
Borders and Shading
Numbers Formats
Date and Time Formats
Custom Formats
Autoformat
Conditional Formating
Styles
Basic Formulas
Formula Structure
Operators
Creating Formulas
Autofill Formulas
Autosum
Relative Reference
Absolute Reference
Function Wizard
Ready for Printing?
Headers and Footers
Print Preview
Scaling the Print Area
Set Print Area
Margins
Printing
Charts and Maps
Creating a Chart
Chart Wizard
Chart Options
The Legend
The Series
Chart Toolbar
3D Charts
Creating Maps
Customizing Maps
Labeling Maps
Advanced Formulas
If Functions
And / Or
Nested If Functions
Using Excel as a Databse
Create a Database
Sort Data
Filter Data
Advance Filter
Data Forms
Database Functions
Linking and Protecting
Formula Links
Range Names
Paste Special
Protect Cells
Protect Worksheets and Workbooks
Passwords
Analysis
Goal Seek and Solver
Scenarios
Pivot Tables
Validation
Auditing
Outlining
Toolbars and Macros
Customizing Toolbars
Create a Macro
Edit a Macro
Create a Macro Button
Graphics and The Drawing Toolbar
Insert a Picture
Move / Resize and Crop
Creating Shapes and Lines
Arranging and Grouping
Fills and Line Color
Arrows
AutoShapes
Flip and Rotate
Text boxes
WordArt
Shadow and 3D Effects
|
Microsoft Excel 2002
Introduction
About Excel
Open/ Save/Close Workbooks
What’s Inside the Workbook
Menus and Toolbars
What’s on a Worksheet
Getting Assistance from Excel
Getting Started
Select and Navigate Cells
Enter Data
Edit and Delete Data
Undo and Redo
Cut/Copy/Paste
About the Office Clipboard
Drag and Drop
AutoFill
More Ways to Enter Repetitive Data
AutoCorrect
Use a Data Entry Form
Validate Data During Entry
Working With Worksheets
Resize Rows and Columns
Insert and Delete Rows/Columns/Cells
Rename Worksheets
Move and Copy Worksheets
Insert and Delete Worksheets
Freeze and Split a Worksheet
Open Multiple Windows
Simple Calculations
Calculate Without a Formula
Use AutoSum to Write Formulas
Formula Structure
Create Formulas
Edit Formulas
AutoFill Formulas
Relative and Absolute References
Functions
Use the Function Wizard
Name Cells and Ranges
Use Names in Formulas
Using Advanced Functions
AVERAGE/MAX/MIN
SUMIF and COUNTIF
VLOOKUP
PMT
NOW/ TODAY/CONCATENATE
IF and Nested Functions
Organizing Data
Sort Data
Filter Data with AutoFilter
AND and OR Filters
Calculate Filtered Records
PivotTables
Consolidate Data
Subtotal a Worksheet
Formatting Cells
Text Formatting
Align and Wrap Text
Number Formats
Date and Time Formats
Custom Formats
Borders and Shading
Conditional Formatting
Format Painter
Styles
AutoFormat a Table
Transpose Tables and Merge Cells
Format Several Worksheets Identically
Save a File as a Template
Charting Data
About Charts
Create a Chart
Resize and Relocate a Chart
The Chart Toolbar
Chart Options
Legends/Titles/Axes
Series Orientation and Order
Create 3-D Charts
Explode a Pie Chart
Add Data Labels and a Data Table
Trendlines
Secondary Axes
Format Chart Elements
Printing Data and Charts
Create Page Headers and Footers
See a Print Preview
Set the Print Area
Print a Selection
Centering/ Margins/Gridlines
Print on a Specific Number of Pages
Print Multiple Worksheets/Copy/Collate Pages
Print Row and Column Labels on Every Page
Print Charts
Sharing and Protecting Data
Share Data Between Workbooks
Copying/Linking/Embedding Data
Share Data with Other Programs
Share a Workbook with Other Users
Hide Worksheets
Protect Cells
Protect Worksheets and Workbooks
Analyzing Data
Use Goal Seek to Find Answers
Use Scenarios to Compare Alternatives
Locate Worksheet Errors and Invalid Data
Customizing Excel
Customize Your Toolbars
Create a Custom Toolbar
Automate with Macros
Record a Macro
Edit a Macro
Assign a Macro to a Toolbar Button
Create a Hyperlink to Open Another File
Graphics and The Drawing Toolbar
Insert a Picture
Move/Resize/Crop
Draw Shapes and Lines
Draw AutoShapes and Assign Macros
Arrange and Group Drawing Objects
Use Drawn Objects in Charts
Create Text Boxes
Create Worksheet Comments
|
Microsoft Excel 2003
Introduction To Excel 2003
First Glance at Excel 2003
Why Choose Excel 2003?
About Spreadsheets
Touring Excel – Pt.1
Touring Excel – Pt.2
Features New to Excel 2003
Installing Excel 2003
Recommendations Before You Install
Minimum System Requirements
Using Excel Setup
Troubleshooting Excel 2003 Installation
Performance Issues with Excel 2003
Getting Assistance With Excel 2003
Ways to Increase Your Aptitude
Exploring the Assistance Menu
Type a Question for Assistance
Using Microsoft Office Online
Excel 2003 Basic Concepts
Worksheets and Workbooks
Organization
Differences Between Text & Data Values
Labels and Names
More About Labels
More about Cells and Cell Ranges
About Mathematical Operators & Operands
About Formulas & Calculations
The Role of Functions
Types of Charts
Forms/Including Data Forms
The Job of Queries
What are Workbook Audits
Importing and Exporting
Linking and Embedding
Absolute vs Relative Cell References
What About Smart Tags?
What is XML?
Locking/Freezing Cells/Splitting Work Area
About Excel Security
First Hands On In Excel
Launching Excel 2003
Planning Your Worksheet or Workbook
Labeling & Naming Worksheet/Workbook
A Look at Our Example Layout
Naming and Saving Your Workbook
Renaming and Deleting a Workbook
Printing Your Workbook
Double Check Workbook & Exit
Opening an Existing Workbook
Customizing Excel 2003
About Excel Customization
Customizing Excel Menu Bar
Customizing Excel Toolbars
Changing Page Setup
Modifying Default Location of Saved Work
Setting Up Options – Pt.1
Setting Up Options – Pt.2
Entering Your Information
About Entering Your Information
Entering Labels and Values
More About Multiple Entries
Understanding Multiple Selections
Inserting/Deleting Rows & Columns
Copying & Pasting Columns/Rows & Cells
Moving Columns/Rows & Cells
Adding a Smart Tag
Editing Your Work
Formatting Your Work
Introduction to Formatting
Formatting Text & Data Pt.1
Formatting Text & Data Pt.2
Using AutoFormat
Changing AutoFormat Options
Adding Colors and Patterns
Adding Borders
What is Conditional Formatting?
Applying Conditional Formatting
Copying Cell Formatting
About Styles
Creating a Style
Applying and Modifying a Style
Adding Elements To A Workbook
Introduction to Adding Elements
Adding Images to a Workbook
Modifying Images Inserted in Workbook
Adding Clips
Diagramming in Excel
Adding an Organizational Chart
Changing an Organizational Chart
Adding WordArt
Adding a Hyperlink
Inserting Objects Such as AutoShapes
Calculation With Formulas and Functions
About Formulas and Calculation
Creating a Formula – Pt.1
Creating a Formula – Pt.2
Spotting Problems & Editing a Formula
More About Functions
Managing Data With Excel
Use it or Lose it
Using Forms/Particularly Data Forms
Entering Data Using a Data Form
Managing Data from a Data Form
About Using Excel as a Database
What are Lists?
Creating a List
Entering Data into a List
Sorting Data in a List
Using Filters to Sort Lists
Auditing Excel Data
Other Validation and Error Checking
More About Validation for Data Entry
Performing Queries
Exporting Data from Excel
Linking Data Pt.1
Linking Data Pt.2
Working With Charts
About Charts
Creating Your Chart
Modifying & Relocating Your Chart
Other Changes to Your Chart
Sharing & Collaborating With Excel 2003
Sharing Your Worksheet or Workbook
Sending Your Workbook for Review
Using Online Collaboration
Protecting Your Workbook
Change Different Versions of a Workbook
Adding/Editing/Deleting Comments
Creating & Sharing a Workbook Template
Credits
About this Author
|
|
|
|
|
|
|
|
