home
virtual assistant
tutorials
contacts
about
privacy
sitemap
tutorials
shortcut keys
about office
virtual assistant
desktop publishing
word processing
databases
spreadsheets
presentations
web design
blog articles
career links
what is a virtual assistant?
why hire a virtual assistant?
request form
agreement
Excel 2007 - Tutorials
The New Interface
Navigate the New Interface
Explore Interface Tabs
Customise Quick Access Toolbar
Explore the New Office Button
Explore the mini toolbar
Customise Excel
Format Tables
Save worksheet in a different Version
Formatting Tables
Insert, Columns Rows &Tables, Delete, Rename, Add, Worksheets
Adjust size of Columns and Rows
Use Set Formats for Tables
Freezing Rows &Columns
Modifying Rows and Columns
Formatting Fonts
Use Colour
Apply and Remove Filters
Format Cells(set condition of cells)
Formulas
Basic Formulas
Order of Preference
Relative Referencing
Absolute Referencing
Formula Ribbon
Basic Functions
Explore the Function Tools
Use AutoSum Functions - Add & Max
Turn off AutoFormat Settings
Use Text Functions Trim, Left & Upper
Advanced Functions
Concatenate Function
Sum If Function
Vlookup & Hlookup Functions
If Functions
CTRL D to Bookmark
Excel Shortcut Keys
Excel Information
Excel 2000/XP Tutorials
You will need Adobe reader to view the lessons, get the latest one here free for your computer.