Learn Excel 2007 through our free training videos


Home Excel 2003 Macros Excel 2007 Macros Excel 2003 Excel 2010


BASICS
Introduction
Basic Calculations
Microsoft Office Button
Using worksheets effectively
Formatting text and numbers
Saving Excel 2007 files
Saving an Excel file as a PDF file
Inbuilt Functions
Sort Function
More on sort data
Formatting data as tables
Absolute and relative cell reference
Page layout and print preview
Printing: display gridlines
How to rotate Excel worksheet data
Condtional Formatting
Charts
Text to columns
Autofilter
INTERMEDIATE
Library functions use
Circular Reference
Turn on/off Autocomplete
How to avoid auto hyperlinks
Fill data across worksheets
How to use comments
How to remove duplicates
Template based workbook
Themes and smartart diagrams
'IF' function
Countif
Nested functions
Advanced filter
Named ranges
Subtotals
In-Cell Graphs
Formatting in-cell graphs
Data validation
Custom Data Validation
ADVANCED
Gantt Charts
Pivot Tables
Vlookup and Hlookup
Goal Seek
Solver
Get external data - text files
Import data from access databases
Import data from an Excel file
Array Formulas
Calculations in Word
Data tables and sensitivity analysis
Printing: Repeat specific rows
Excel Help - Vlookup
Excel Booksms excel 2007 books
Step by step Excel macros...

MISCELLANEOUS
How to use comments
Convert function
Factorials
Using 3-D references
Consolidate data
SUMIFS
RANK function
Named ranges use
Advanced filter - unique records
Highlighting duplicates
Database functions
DSUM
DAVERAGE
Vlookup and calculations
Data Analysis and Vlookup
Vlookup using lists
Data Analysis and Hlookup
Lookup function 
Left Lookups: Overcome limitations of Vlookup
How to use the 'power to' feature
Convert numerical text data into numbers
Work with Excel data containing blank rows
Lookup functions - nested functions
Highlight blank cells
Compound interest calculations using user form
How to copy a Word table into Excel
Insert a watermark
How to draw in Excel
CHOOSE function
SUBSTITUTE function
MISCELLANEOUS
Data Analysis and MATCH function
Max, Match, Vlookup and LARGE functions
Breakeven analysis using Goalseek
Staff scheduling with Solver
Solver to minimize delivery costs
How to avoid duplicate entries
Data validation, Named Ranges, Indirect Function
Trim function
Text functions
Link an Excel worksheet to Word
Keyboard shortcuts
Keyboard & MS-Office Ribbon
Quiz
Teaching kids
Manage Inventory
Accessing data from another workbook
Send Excel document in an e-mail
Sensitivity Analysis with data tables
Sumif - multiple criteria
Data entry only into specific cells
Ensure all data entries
MS-Access Table using MS-Excel data
Delete empty rows
Quiz using the comments and conditional formatting
Open a user form using a command button
Depreciation Schedule
Depreciation using the straight line method
Consolidate data from Excel worksheets
Share files using Microsoft's Skydrive
MISCELLANEOUS
Checkbox form control
Dynamic ranges
Find latest sales data
Datedif Function
Sensitivity analysis for startups
Sensitivity analysis with Scenarion Manager
How to Generate Random  Numbers
Excel and mail merge in MS-Word
Export data from Outlook to Excel
Calendar
Budget
Track changes
Descriptive Statistics
Interesting use of date function
Enter only dates of weekdays
Interest calculations
Extracting numbers from alphanumeric text
Recover excel graph data from powerpoint slide
What happened to the data form in Excel 2007?
Financial statements
Cost to company
Future value - FV
Data tables and sensitivity analysis
countif - multiple criteria
How to improve readabilty of your Excel data
Net Present Value (NPV)
NPV Correction
How to enter fractions
Excel tips for beginners and advanced users
Home Excel 2003 Macros Excel 2007 Macros Excel 2003 Excel 2010