Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel 2007 Training - Beginner to Advanced
Introducing Excel 2007
Welcome to Excel 2007 (1:48)
Starting Excel 2007 (3:25)
Understanding the Excel 2007 screen layout (8:05)
Creating and saving a new workbook (5:12)
How to open an existing workbook (2:55)
Excel 2007 Basics
Creating a new workbook from a template (4:02)
Creating your own custom templates (6:07)
Opening a workbook using different options (8:19)
Using SAVE AS to create a new workbook (2:19)
Saving a workbook in Excel 2003 format (3:23)
Saving a workbook in OpenDocument Spreadsheet format (2:00)
Saving a workbook as a PDF file (4:26)
Saving a workbook in website format (3:29)
Printing workbooks (8:44)
Understanding Print Preview (3:54)
Adding and Editing workbook properties (3:27)
Working with the Document Inspector (2:53)
Adding password protection to your workbooks (3:39)
Marking a workbook as final (2:25)
Using the Compatibility Checker (3:09)
Automatically attaching a workbook to an email message (3:19)
Understanding the Quick Access Toolbar (7:34)
Minimising the Office Ribbon (1:59)
Navigating around the menus just using the keyboard (3:39)
Navigating around the workbook just using the keyboard (4:44)
Working with Worksheets (3:49)
The Mini Toolbar (4:50)
The Formula Bar (7:20)
Different ways to select cells on a worksheet (5:06)
Resizing cells and columns (2:18)
Using the AutoCorrect feature (3:06)
Using the AutoComplete feature (2:30)
Using the AutoFill feature (5:16)
Inserting and deleting rows, columns and cells (3:17)
Cut, Copy and Paste (4:53)
Controlling Information and Worksheets
Working with the Office Clipboard (7:45)
Using the Format Painter (3:04)
Using the Font Group commands (8:28)
Using the Alignment Group commands (5:34)
Using the Number Group commands (9:12)
Welcome to Conditional Formatting! (11:35)
Working with tables and table styles (2:09)
Understanding table formatting options (5:41)
How to format individual cells (6:25)
Inserting cells, rows and columns (3:34)
Deleting cells, rows, columns and sheets (2:07)
Adjusting row and column sizes (6:16)
Hiding rows, columns and worksheets (5:17)
Organising worksheets (3:49)
Protecting worksheets (5:20)
Introducing the AutoSum function (8:11)
Removing data and/or formatting from cells (2:46)
Sorting and filtering data (8:57)
How to use the Find and Replace tools (10:09)
Using the Select Objects tool (3:56)
Understanding the Selection Pane
Inserting Objects into Worksheets
Inserting and resizing pictures (5:27)
Picture formatting options (16:06)
Inserting ClipArt (5:49)
Inserting and working with Shapes (12:28)
Introducing SmartArt graphics (3:54)
Customising SmartArt graphics (8:25)
Working with charts (4:27)
Modifying chart data (2:58)
Modifying the chart design (8:59)
Changing the chart layout (19:11)
Chart formatting options (4:22)
Chart formatting summary (1:35)
How to change the default chart type (1:20)
Creating an instant chart using the keyboard (1:16)
Other ways to select data for charts (1:26)
Inserting Hyperlinks into worksheets (6:07)
How to add a Text Box (3:52)
Formatting a Text Box (6:07)
Adding Header and Footer information (7:48)
Inserting WordArt into a worksheet (2:24)
Using Themes in Excel 2007 (4:35)
Understanding page setup options (13:30)
Understanding Scale to Fit options (2:51)
Understanding worksheet options (4:26)
Working with Excel
Using the spelling checker (7:11)
Using the other proofing tools in Excel (4:04)
Working with comments (6:08)
Protecting and sharing workbooks (3:36)
Working with different workbook views (4:26)
Hiding and showing different screen components (1:58)
Understanding the different zoom commands (2:05)
Working with multiple windows (2:56)
Freezing row and column information (3:48)
Other ways to freeze parts of the screen (4:27)
Understanding workspaces (2:37)
Advanced topics - Macros
Recording a basic macro (8:12)
Saving a macro enabled workbook (1:46)
Understanding macro security settings (3:25)
Opening and executing a macro enabled workbook (4:56)
Absolute versus relative cell referencing in macros (3:24)
Assigning a macro to a button (4:14)
Adding a macro to the Quick Access Toolbar (2:42)
Editing a macro (7:16)
How to fix macro problems using the debugger (6:09)
How to enable the Developer Tab (3:30)
Advanced topics - Pivot Tables
How to use Pivot Tables - Part 1 (4:37)
How to use Pivot Tables - Part 2 (1:44)
Adding data to Pivot Tables (4:32)
Removing and customising Pivot Table data (2:17)
Formatting Pivot Table data (3:46)
Sorting and filtering data (6:16)
Understanding the Report Filter area (2:31)
Customising the Pivot Table screen layout (3:36)
Pivot Table configuration options (8:51)
Drilling down into Pivot Table data (1:08)
Understanding Pivot Table calculation options (2:29)
How to group Pivot Table data (5:24)
Grouping options relating to date information (4:40)
Updating and refreshing Pivot Table data (3:04)
Moving and copying Pivot Tables (3:25)
Inserting a Pivot Chart into a worksheet (2:50)
Creating a Calculated Field (2:45)
Formatting Pivot Tables using the Style Gallery (1:59)
How to add and customise Pivot Charts (11:07)
Advanced topics - Formulas and Functions
Introducing Formulas and Functions (4:31)
Understanding Excel operators (5:47)
A refresher course in the order or operations - BODMAS (4:47)
Formula and function basics (5:22)
How to use the SUM function (4:59)
Understanding absolute and relative cell referencing (3:15)
How to use the CONCATENATE function (2:19)
How to use the SUMIF function (4:49)
How to use the VLOOKUP function (4:45)
How to use the TRIM function (3:47)
How to use the RANDBETWEEN function (3:03)
How to use the PMT function (3:06)
How to use the COUNTIF Function (6:12)
Even More Advanced Topics!
Introducing the Excel Name Manager (5:45)
Navigating around the Excel Name Manager (2:52)
Using and managing names cells and ranges (3:48)
Formula auditing tools (3:43)
Error checking tools for formulas (2:00)
Evaluating formulas (1:16)
Using the Watch Window (2:06)
Working with Excel calculation options (2:20)
Importing information from a Microsoft Access database (2:52)
Importing data from a CSV file (2:53)
Converting text to columns (1:31)
Removing duplicated data (1:35)
Understanding the different types of data validation (6:44)
Working with the Excel 2007 Consolidation tool (7:30)
Using the Goal Seek analysis tool (1:58)
Grouping and Ungrouping data (3:39)
Automatically generating subtotal information (3:53)
Finale
Finale (0:43)
Understanding the Excel 2007 screen layout
Complete and Continue