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 | Duration | Size | ||||
 |
Welcome to Excel 2007 | Free to watch | 1:48 | 2.05MB | ||
|
Starting Excel | Free to watch | 3:25 | 6.31MB | ||
|
Understanding the new Excel 2007 screen layout | Free to watch | 8:05 | 14.30MB | ||
|
Creating and saving a new workbook | 5:12 | 8.59MB | |||
|
How to open an existing workbook | 2:55 | 5.18MB | |||
| Excel 2007 Basics | ||||||
|
Creating a new workbook from a template | 6:07 | 11.05MB | |||
|
Creating your own custom templates | 4:02 | 7.99MB | |||
|
Opening a workbook using different options | 8:19 | 16.02MB | |||
|
Using SAVE AS to create a new workbook | 2:19 | 4.51MB | |||
|
Saving a workbook in Excel 2003 format | 3:23 | 6.10MB | |||
|
Saving a workbook in OpenDocument Spreadsheet format | 2:00 | 4.07MB | |||
|
Saving a workbook as a PDF file | 4:26 | 8.39MB | |||
|
Saving a workbook in website format | 3:29 | 6.73MB | |||
|
Printing workbooks | 8:44 | 15.51MB | |||
|
Understanding Print Preview | 3:54 | 6.63MB | |||
|
Adding and Editing workbook properties | 3:27 | 6.12MB | |||
|
Working with the Document Inspector | 2:53 | 6.14MB | |||
|
Adding password protection to your workbooks | 3:39 | 8.02MB | |||
|
Marking a workbook as final | 2:25 | 4.88MB | |||
|
Using the Compatibility Checker | 3:09 | 6.87MB | |||
|
Automatically attaching a workbook to an email message | 3:19 | 6.29MB | |||
|
Understanding the Quick Access Toolbar | 7:34 | 14.02MB | |||
|
Minimising the Office Ribbon | 1:59 | 3.72MB | |||
|
Navigating around the menus just using the keyboard | 3:39 | 5.81MB | |||
|
Navigating around the workbook just using the keyboard | 4:44 | 8.09MB | |||
|
Working with Worksheets | 3:49 | 5.53MB | |||
|
The Mini Toolbar | 4:50 | 7.72MB | |||
|
The Formula Bar | 7:20 | 13.46MB | |||
|
Different ways to select cells on a worksheet | 5:06 | 9.02MB | |||
|
Resizing cells and columns | 2:18 | 3.38MB | |||
|
Using the AutoCorrect feature | 3:06 | 5.63MB | |||
|
Using the AutoComplete feature | 2:30 | 4.52MB | |||
|
Using the AutoFill feature | 5:16 | 10.35MB | |||
|
Inserting and deleting rows, columns and cells | 3:17 | 5.30MB | |||
|
Cut, Copy and Paste | 4:53 | 9.01MB | |||
| Controlling Worksheets and Information | ||||||
|
Working with the Office Clipboard | 7:45 | 14.24MB | |||
|
Using the Format Painter | 3:04 | 5.63MB | |||
|
Using the Font Group commands | 8:28 | 16.54MB | |||
|
Using the Alignment Group commands | 5:34 | 10.16MB | |||
|
Using the Number Group commands | 9:12 | 18.41MB | |||
|
Welcome to Conditional Formatting! | 11:35 | 25.24MB | |||
|
Working with tables and table styles | 2:09 | 5.58MB | |||
|
Understanding table formatting options | 5:41 | 12.98MB | |||
|
How to format individual cells | 6:25 | 12.31MB | |||
|
Inserting cells, rows and columns | 3:34 | 7.14MB | |||
|
Deleting cells, rows, columns and sheets | 2:07 | 4.55MB | |||
|
Adjusting row and column sizes | 6:16 | 12.35MB | |||
|
Hiding rows, columns and worksheets | 5:17 | 10.48MB | |||
|
Organising worksheets | 3:49 | 6.92MB | |||
|
Protecting worksheets | 5:20 | 12.33MB | |||
|
Introducing the AutoSum function | 8:11 | 17.57MB | |||
|
Removing data and/or formatting from cells | 2:46 | 4.28MB | |||
|
Sorting and filtering data | 8:57 | 19.07MB | |||
|
How to use the Find and Replace tools | 10:09 | 22.48MB | |||
|
Using the Select Objects tool | 3:56 | 7.34MB | |||
|
Understanding the Selection Pane | 3:35 | 6.40MB | |||
| Inserting Objects into Worksheets | ||||||
|
Inserting and resizing pictures | 5:27 | 11.17MB | |||
|
Picture formatting options | 16:06 | 34.65MB | |||
|
Inserting ClipArt | 5:49 | 12.69MB | |||
|
Inserting and working with Shapes | 12:28 | 27.00MB | |||
|
Introducing SmartArt graphics | 3:54 | 7.88MB | |||
|
Customising SmartArt graphics | 8:25 | 17.76MB | |||
|
Working with charts | 4:27 | 10.06MB | |||
|
Modifying chart data | 2:58 | 6.04MB | |||
|
Modifying the chart design | 8:59 | 19.17MB | |||
|
Changing the chart layout | 19:11 | 42.99MB | |||
|
Chart formatting options | 4:22 | 9.53MB | |||
|
Chart formatting summary | 1:35 | 3.44MB | |||
|
How to change the default chart type | 1:20 | 3.10MB | |||
|
Creating an instant chart using the keyboard | 1:16 | 2.60MB | |||
|
Other ways to select data for charts | 1:26 | 3.12MB | |||
|
Inserting Hyperlinks into worksheets | 6:07 | 12.54MB | |||
|
How to add a Text Box | 3:52 | 7.74MB | |||
|
Formatting a Text Box | 6:07 | 13.53MB | |||
|
Adding Header and Footer information | 7:48 | 16.88MB | |||
|
Inserting WordArt into a worksheet | 2:24 | 4.79MB | |||
|
Using Themes in Excel 2007 | 4:35 | 12.93MB | |||
|
Understanding page setup options | 13:30 | 31.87MB | |||
|
Understanding Scale to Fit options | 2:51 | 6.88MB | |||
|
Understanding worksheet options | 4:26 | 11.29MB | |||
| Working with Excel | ||||||
|
Using the spelling checker | 7:11 | 13.21MB | |||
|
Using the other proofing tools in Excel | 4:04 | 8.61MB | |||
|
Working with comments | 6:08 | 12.53MB | |||
|
Protecting and sharing workbooks | 3:36 | 6.36MB | |||
|
Working with different workbook views | 4:26 | 6.02MB | |||
|
Hiding and showing different screen components | 1:58 | 2.72MB | |||
|
Understanding the different zoom commands | 2:05 | 3.22MB | |||
|
Working with multiple windows | 2:56 | 5.69MB | |||
|
Freezing row and column information | 3:48 | 8.22MB | |||
|
Other ways to freeze parts of the screen | 4:27 | 11.06MB | |||
|
Understanding workspaces | 2:37 | 5.82MB | |||
| Advanced topics - Macros | ||||||
|
Recording a basic macro | 8:12 | 10.95MB | |||
|
Saving a macro enabled workbook | 1:45 | 3.22MB | |||
|
Understanding macro security settings | 3:25 | 4.55MB | |||
|
Opening and executing a macro enabled workbook | 4:56 | 7.96MB | |||
|
Absolute versus relative cell referencing in macros | 3:24 | 4.47MB | |||
|
Assigning a macro to a button | 4:14 | 6.71MB | |||
|
Adding a macro to the Quick Access Toolbar | 2:42 | 4.20MB | |||
|
Editing a macro | 7:16 | 11.60MB | |||
|
How to fix macro problems using the debugger | 6:09 | 10.32MB | |||
|
How to enable the Developer Tab | 3:30 | 6.12MB | |||
| Advanced topics - Pivot Tables | ||||||
|
How to use Pivot Tables - Part 1 | 4:37 | 8.96MB | |||
|
How to use Pivot Tables - Part 2 | 1:44 | 2.59MB | |||
|
Adding data to Pivot Tables | 4:32 | 7.13MB | |||
|
Removing and customising Pivot Table data | 2:17 | 4.11MB | |||
|
Formatting Pivot Table data | 3:46 | 7.28MB | |||
|
Sorting and filtering data | 6:16 | 11.38MB | |||
|
Understanding the Report Filter area | 2:31 | 5.16MB | |||
|
Customising the Pivot Table screen layout | 3:36 | 6.74MB | |||
|
Pivot Table configuration options | 8:51 | 15.33MB | |||
|
Drilling down into Pivot Table data | 1:08 | 2.63MB | |||
|
Understanding Pivot Table calculation options | 2:29 | 4.99MB | |||
|
How to group Pivot Table data | 5:24 | 10.34MB | |||
|
Grouping options relating to date information | 4:40 | 9.56MB | |||
|
Updating and refreshing Pivot Table data | 3:03 | 6.40MB | |||
|
Moving and copying Pivot Tables | 3:25 | 6.65MB | |||
|
Inserting a Pivot Chart into a worksheet | 2:50 | 5.06MB | |||
|
Creating a Calculated Field | 2:45 | 4.96MB | |||
|
Formatting Pivot Tables using the Style Gallery | 1:59 | 4.73MB | |||
|
How to add and customise Pivot Charts | 11:07 | 19.66MB | |||
| Advanced topics - Formulas and Functions | ||||||
|
Introducing Formulas and Functions | 4:31 | 7.22MB | |||
|
Understanding Excel operators | 5:47 | 8.22MB | |||
|
A refresher course in the order or operations - BODMAS | 4:47 | 6.76MB | |||
|
Formula and function basics | 5:21 | 9.06MB | |||
|
How to use the SUM function | 4:59 | 7.89MB | |||
|
Understanding absolute and relative cell referencing | 3:15 | 5.32MB | |||
|
How to use the CONCATENATE function | 2:19 | 4.10MB | |||
|
How to use the SUMIF function | 4:49 | 8.03MB | |||
|
How to use the VLOOKUP function | 4:45 | 8.15MB | |||
|
How to use the TRIM function | 3:47 | 4.37MB | |||
|
How to use the RANDBETWEEN function | 3:03 | 3.80MB | |||
|
How to use the PMT function | 3:06 | 4.56MB | |||
|
How to use the COUNTIF Function | 6:12 | 10.14MB | |||
| More Excel Advanced Topics | ||||||
|
Introducing the Excel Name Manager | 5:45 | 9.21MB | |||
|
Navigating around the Excel Name Manager | 2:52 | 5.20MB | |||
|
Using and managing names cells and ranges | 3:48 | 6.49MB | |||
|
Formula auditing tools | 3:43 | 6.46MB | |||
|
Error checking tools for formulas | 2:00 | 3.60MB | |||
|
Evaluating formulas | 1:16 | 2.25MB | |||
|
Using the Watch Window | 2:06 | 3.69MB | |||
|
Working with Excel calculation options | 2:20 | 4.14MB | |||
|
Importing information from a Microsoft Access database | 2:52 | 4.91MB | |||
|
Importing data from a CSV file | 2:53 | 4.55MB | |||
|
Converting text to columns | 1:31 | 2.64MB | |||
|
Removing duplicated data | 1:35 | 2.57MB | |||
|
Understanding the different types of data validation | 6:44 | 11.01MB | |||
|
Working with the Excel 2007 Consolidation tool | 7:30 | 11.42MB | |||
|
Using the Goal Seek analysis tool | 1:58 | 2.80MB | |||
|
Grouping and Ungrouping data | 3:39 | 6.08MB | |||
|
Automatically generating subtotal information | 3:53 | 6.45MB | |||
| Excel 2007 - Finale | ||||||
|
Finale | 00:43 | 580.56KB | |||
