Microsoft Excel Tutorial Video

Self Study, Microsoft Excel Tutorial Video on CD - DVD. The tutor guides you using step-by-step examples. Learn directly from your own desk high quality training videos at an affordable price. Works on both PC and Mac.

These Microsoft Excel tutorials are ideal for the beginner to intermedate user. Expert Lorie Flenner explains how to take advanage of the comprehensive range of tools that Excel offers to build not only simple spreadsheets, but to also add functionallity and life to your data, using step by step training this tutorial highlights in great detail how to create charts and graphs, pivot tables, adding graphics and so much more. If you need to learn Excel and would like the lessons delivered using clear-cut, plain English explanations, then look no further. Related products : Excel 2007 Tutorials .

try for free

Microsoft Excel Tutorial CD / DVD

Creates the perfect self-paced learning environment
on your own desktop.

Professionally created, comprehensive video based training that's easy to follow. At an unbelievable price.

Try for FREE - NOW. To help you evaluate this training CD / DVD the first 3 chapters are available for free, click on any of the links below for a FREE DEMO.

Benefits
  • Professional Tuition by expert
  • Free Certificate with each Tutorial
  • Works on PC or Mac
Topics Covered on this Training Video Include:
Introduction
The Basics
Working With Worksheets
We hope you enjoyed the free videos above. To watch all this course including the chapters below please purchase the CD.
$99.95
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
UK & Europe
Apex Web Media
PO Box 398
Bolton, BL7 9RZ
United Kingdom
T: 01204 592071
USA & Canada
600 17th Street, Suite 2800, Denver CO 80202
Open 8am - 5pm M to F (EST)
Tel - Toll free 1866 402 1903 ( USA )
Tel 434-878-4158
Fax 1 207 433 4356