Accredited by the Better Business Bureau. Sign up for our Newsletter and Spcial Sales. Visit us at Facebook Visit us at YouTube Go to your Shopping Cart


image




image

image
Microsoft Excel 2010 & 2007
Training Course

All you need to do is watch and learn. This course starts with the basics and builds your skills to a professional level.

Designed for both beginner and advanced users, it's the only training reference you'll need and it never expires.

127 Lessons
6 Hours (360 Minutes)
653 MB

It's the fastest way to learn everything you need to know!

Try it Free!

Excel Xpress 2010-2007 Lessons
Introduction
Basics
What is a Worksheet
Pointer
Click
Cells Columns and Rows
Highlight
Overview of the Worksheet Screen
The Title Bar
The Quick Access Toolbar
The Ribbon Interface
Intro to Cell Formats
Formatting Text
The Formula Bar
Adjusting Column Width
AutoFit
Screen Tips
Excel Help
The ClipArt Command
What is a Workbook
Getting Started
File Management
Planning Your Worksheet
Moving and Copying Cells
Cut Copy and Paste
The Office Clipboard
The Paste Option Icon
Insert Moved or Copied Cells
AutoFill
Entering Data
Entering Equations
Entering Basic Equations
The Insert Function Tool
The AutoSum Function Tool
Formatting Cells
Formatting Dates Currency and Text
Formatting Cell Borders
Formatting Cell Colors
Putting it All Together
Introduction to Level 2
Logical Functions
If Statement
Nested If Statement
The AND Function
Applying the AND Function
The OR Function
The NOT Function
Comparison Operators
Nested Logical Functions Simplified
Inserting Columns
Inserting Rows
The Insert Options Icon
The Format Painter
View Side by Side
How to Freeze Panes
Hiding and Unhiding Columns and Rows
Protecting Your Worksheet
How to Hide Formulas
Printing
How to Make a Print Sheet
Print Preview
Margins
Page Setup
Adjusting Columns
Setting Up a Print Area
Headers and Footers
Page Break Preview
Additional Equations Techniques
Absolute References
Mixed References
Circular Logic
Exponents and PI
The Power Function
The Square Root Function
Order of Operation
Introduction to Level 3
Introduction to Databases
How to Create a Database
Database Functions
DCOUNT
DCOUNTA
DMAX
DMIN
DGET
DSUM
DPRODUCT
Statistical Database Functions
Sorting Data
Filtering Data
Advanced Filter
Data Entry Form
Editing Data
Adding and Deleting Data
Worksheet Controls and Macros
Combo Box Control
Spinner Control
Option Button Control
Creating Criteria Lists
Using the DGET Function
Using the DCOUNT Function
Error Trapping
Automating Output Part I
Automating Output Part II
How to Create and Run Macros
Deleting and Renaming Macros
Editing Macros
Creating an Update List
Writing an Update Macro
How to Create a Macro Button
Graphs and Charts
Chart Design
Chart Layout
Chart Format
VLOOKUP Function
HLOOKUP Function
INDEX Function
AREAS Function
COLUMNS Function
ROWS Function
LOOKUP Function
MATCH Function
CHOOSE Function
INDIRECT Function
COLUMN Function
ROW Function
ADDRESS Function
HYPERLINK Function
Conclusion

 

Microsoft Excel 2010 & 2007
Excel Xpress
Excel Xpress 2010-2007

image
Master Excel
in the shortest time possible!

Instruction Time: 6 hr
Prerequisites: None

653 MB
ISBN: 1-933030-77-1

Download + DVD: $99.95
Purchase Download + DVD

Download: $89.95
Purchase Download Only

Microsoft Excel 2010-2007 Training Tutorial Catalog

What to Buy -

Buy the Download Only...

  • if you want to start learning now!
  • if you want to bypass shipping costs!

Buy the Download + DVD...

  • if you do not have Internet access.
  • if you want the same benefits of the download but would like a back-up copy of the courses.