Excel XP Pro Video Training Tutorials-2 x Video CD Set

 Excel XP Video Tutorial

Compatible with Vista
This CD Set is compatible with Windows 95 upto and including Vista

Excel, the electronic spreadsheet is one of the
most complicated and difficult to navigate
programs without a guide. Enter this tutorial
to the rescue. Let's say you want to set up a
spreadsheet to manage your business or home
finances. You diligently enter each category
of numbers and you can program the column to
give you a total at the bottom all without a calculator.
There are other formulas available to multiply and
other complicated math equations at the touch of a
button. This is a very flexible program with the
ability to move or shift columns and rows to make
custom spreadsheets and invoices for business.
After watching these amazing CDs you will also know
how to add 3D Effects and Charts to make
any financial presentation very compelling.

This is a 4 hours course
This CD Set is compatible with Windows 95 upto and including Vista
You will learn virtually everything you need to know about Excel XP.

Lessons:

Introduction
Getting Started
Windows
Menus
Toolbars
Formula Bar
Scroll Bars
Worksheet Tabs
Status Bar
Task Panes
Interface Review
Workbooks and Worksheets
Managing Workbooks
Getting Help
File Recovery

The Basics
Selecting/Navigating Cells
Entering Data
Edit Data
Cut, Copy & Paste
Undo & Redo
Drag & Drop
Autofill
Auto Correct

Working In Datasheet View
Zoom Control
Views
Resize Rows and Columns
Insert Cells
Delete Cells
Insert/ Delete Rows
Rename Worksheets
Insert and Delete Worksheets
Move and Copy Worksheets
Hide and Unhide

Formatting Cells
Text Formats
Align and Text Wrap
Alignment Effects
Borders and Shading
Number Formats
Date and Time Formats
Custom Formats
Format Painter
Auto Format
Conditional Formatting
Styles

Basic Formulas
Formula Structure
Operators
Creating Formulas
Autofill Formulas
Autosum
Relative and Absolute referencing
Function Wizard

Other CD Sets in this Series

Printing
Headers & Footers
Print Preview
Scaling the Print Area
Set Print Area
Margins
Printing

Charts
Creating Charts
Chart Wizard
Chart Options
The Series
Chart Toolbar
3D Charts

Advanced Formulas
IF Functions
And & Or Functions
Nested IF Functions

Using Excel as a Database
Create Data Base
Sort Data
Filter Data
Advanced Filter
Data Forms
Database Functions

Linking and Protecting
Formula Links
Range Names
Paste Special
Protect Cells
Protect Worksheets Workbooks
Passwords

Analysis
Goal Seek and Solver
Scenarios
Pivot Tables
Validations
Auditing
Outlining

Toolbars and Macros
Customizing Toolbars
Create a Macro
Edit a Macro
Create a Macro Button

Graphics & the Drawing Toolbar
Insert a Picture
Move, Resize and Crop
Creating Shapes and Lines
Arranging and Grouping
Fills and Line Colors
Arrows
AutoShapes
Flip and Rotate
Tex Boxes
Word Art
Shadows and 3d Effects

Thanks for looking, why not pick up some great FREE software<Here>

Check Out My other Great Items <Here>
Free P&P for orders of 3 or more items