Microsoft Excel 2007 Training Course

Beginner, intermediate and advanced topics are all covered in this online training course for Microsoft Office Excel 2007. We assume that you haven't used Microsoft Excel before at all, so we start from the very basics, then, we work our way up through the list of more interesting and powerful features that Excel 2007 has to offer. Start learning right now!

Introducing Excel 2007
Welcome to Excel 2007 Free to watch
Starting Excel Free to watch
Understanding the new Excel 2007 screen layout Free to watch
Creating and saving a new workbook
How to open an existing workbook
Excel 2007 Basics
Creating a new workbook from a template
Creating your own custom templates
Opening a workbook using different options
Using SAVE AS to create a new workbook
Saving a workbook in Excel 2003 format
Saving a workbook in OpenDocument Spreadsheet format
Saving a workbook as a PDF file
Saving a workbook in website format
Printing workbooks
Understanding Print Preview
Adding and Editing workbook properties
Working with the Document Inspector
Adding password protection to your workbooks
Marking a workbook as final
Using the Compatibility Checker
Automatically attaching a workbook to an email message
Understanding the Quick Access Toolbar
Minimising the Office Ribbon
Navigating around the menus just using the keyboard
Navigating around the workbook just using the keyboard
Working with Worksheets
The Mini Toolbar
The Formula Bar
Different ways to select cells on a worksheet
Resizing cells and columns
Using the AutoCorrect feature
Using the AutoComplete feature
Using the AutoFill feature
Inserting and deleting rows, columns and cells
Cut, Copy and Paste
Controlling Worksheets and Information
Working with the Office Clipboard
Using the Format Painter
Using the Font Group commands
Using the Alignment Group commands
Using the Number Group commands
Welcome to Conditional Formatting!
Working with tables and table styles
Understanding table formatting options
How to format individual cells
Inserting cells, rows and columns
Deleting cells, rows, columns and sheets
Adjusting row and column sizes
Hiding rows, columns and worksheets
Organising worksheets
Protecting worksheets
Introducing the AutoSum function
Removing data and/or formatting from cells
Sorting and filtering data
How to use the Find and Replace tools
Using the Select Objects tool
Understanding the Selection Pane
Inserting Objects into Worksheets
Inserting and resizing pictures
Picture formatting options
Inserting ClipArt
Inserting and working with Shapes
Introducing SmartArt graphics
Customising SmartArt graphics
Working with charts
Modifying chart data
Modifying the chart design
Changing the chart layout
Chart formatting options
Chart formatting summary
How to change the default chart type
Creating an instant chart using the keyboard
Other ways to select data for charts
Inserting Hyperlinks into worksheets
How to add a Text Box
Formatting a Text Box
Adding Header and Footer information
Inserting WordArt into a worksheet
Using Themes in Excel 2007
Understanding page setup options
Understanding Scale to Fit options
Understanding worksheet options
Working with Excel
Using the spelling checker
Using the other proofing tools in Excel
Working with comments
Protecting and sharing workbooks
Working with different workbook views
Hiding and showing different screen components
Understanding the different zoom commands
Working with multiple windows
Freezing row and column information
Other ways to freeze parts of the screen
Understanding workspaces
Advanced topics - Macros
Recording a basic macro
Saving a macro enabled workbook
Understanding macro security settings
Opening and executing a macro enabled workbook
Absolute versus relative cell referencing in macros
Assigning a macro to a button
Adding a macro to the Quick Access Toolbar
Editing a macro
How to fix macro problems using the debugger
How to enable the Developer Tab
Advanced topics - Pivot Tables
How to use Pivot Tables - Part 1
How to use Pivot Tables - Part 2
Adding data to Pivot Tables
Removing and customising Pivot Table data
Formatting Pivot Table data
Secured By RapidSSL