5 Excel 2007 Tutorials

Here are 5 Excel 2007 Tutorials that demonstrate how to use the following features using Excel 2007: Excel's new interface, format tables, create and use formulas, autosum function, autoformat function, concatenate function, Sum If function, and the Vlookup and Hlookup functions. These Excel tutorials are in pdf format.


The New Interface in Excel 2007

• 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

• 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)

• Basic Formulas
• Order of Preference
• Relative Referencing
• Absolute Referencing
• Formula Ribbon

• Explore the Function Tools
• Use AutoSum Functions - Add & Max
• Turn off AutoFormat Settings
• Use Text Functions Trim, Left & Upper

• Concatenate Function
• Sum If Function
• Vlookup & Hlookup Functions
• If Functions