Excel 2007 Essential Training
0. Introduction 36s
Welcome 36s
1. Getting Started 10m 57s
Why use a spreadsheet? 1m 44s
What's changed in Excel 2007? 5m 37s
The Ribbon 2m 9s
The Microsoft Office Button 1m 27s
2. Setting Up Excel 2007 12m 10s
What's on the Ribbon? 1m 56s
Making your way around the Ribbon 2m 12s
Customizing the Ribbon 3m 8s
Customizing the Microsoft Office Button 4m 54s
3. Modifying Worksheets 16m 15s
Opening old worksheets 2m 24s
Adding and deleting worksheets 3m 18s
Inserting and deleting cells 6m 53s
Freezing areas of a worksheet 3m 40s
4. Basic Formatting 20m 51s
Width and height 7m 25s
Numeric formats 2m 21s
Alignment of data 3m 19s
Playing with fonts 2m 58s
AutoFilter 2m 21s
Formatting as a table 2m 27s
5. Advanced Formatting 21m 31s
Removing duplicates 6m 1s
What is Conditional Formatting? 2m 21s
Working with Conditional Formatting 2m 14s
Managing Conditional Formatting rule preferences 2m 39s
Converting text to columns 4m 35s
Data validation 3m 41s
6. Using Templates, Styles, and AutoFormat 10m 56s
Templates 3m 45s
Styles 3m 35s
AutoFormat 3m 36s
7. Managing Lists in Excel 12m 16s
Excel lists have now become tables 2m 34s
Converting text to columns 3m 11s
Sorting and Grouping 5m 9s
Creating a summary report 1m 22s
8. Reviewing Worksheets 6m 44s
Proofing your work 3m 31s
Providing comments on worksheets 3m 13s
9. Sharing Worksheets 11m 43s
Protecting and sharing a worksheet 3m 57s
Allowing others to edit ranges 4m 3s
Track Changes 3m 43s
10. Printing Workbooks 22m 43s
Preparing to print 2m 31s
Print Preview 3m 33s
The Page Layout Tab 3m 56s
Page Breaks 4m 36s
The Page Layout View 3m 54s
Headers and Footers 4m 13s
11. Enhancing Worksheets 22m 34s
Adding themes to your worksheet 2m 53s
Page setup options 8m 0s
Scale to Fit 2m 26s
Worksheet options 5m 29s
Inserting images 3m 46s
12. Using Templates 3m 50s
Using templates 3m 50s
13. Manipulating the Screen Display 17m 48s
Workbook Views 2m 53s
Hiding and Zooming 3m 44s
Window Panes 5m 31s
More screen options 5m 40s
14. Importing Data 8m 16s
Importing from Access 2m 24s
Using the Import Wizard for text files 5m 52s
15. Finding and Replacing Data 11m 23s
The Find and Select button 4m 34s
Find and Replace 2m 48s
Removing duplicates 4m 1s
16. Working with Formulas 17m 3s
What are formulas? 3m 20s
Order of Operations 2m 50s
Relative and absolute referencing 4m 54s
The new Formula Tab 5m 59s
17. Working with Basic Functions 17m 29s
What are Functions? 2m 57s
AutoSum 2m 47s
Minimum 3m 55s
Trim 5m 2s
Left 2m 48s
18. Working with Advanced Functions 19m 51s
Concatenation 4m 10s
SumIf 4m 23s
Lookup 7m 25s
What-If Analysis 3m 53s
19. Charts 16m 44s
Why create a chart? 2m 12s
Creating your chart 3m 37s
Modifying your chart 6m 46s
Laying out your chart 4m 9s
20. Pivot Tables 17m 23s
What are PivotTable reports and PivotChart reports? 2m 32s
Creating a PivotTable 4m 47s
Laying out your PivotTable 2m 30s
Designing your PivotTable 4m 9s
Creating a PivotChart 3m 25s
21. Working with Macros 8m 57s
Why use macros? 2m 14s
Creating a macro 4m 31s
Macro security 2m 12s
22. Workflow in Excel 2007 5m 36s
Reviewing a workflow in Excel 5m 36s
Conclusion 22s
Conclusion 22s
Welcome 36s
1. Getting Started 10m 57s
Why use a spreadsheet? 1m 44s
What's changed in Excel 2007? 5m 37s
The Ribbon 2m 9s
The Microsoft Office Button 1m 27s
2. Setting Up Excel 2007 12m 10s
What's on the Ribbon? 1m 56s
Making your way around the Ribbon 2m 12s
Customizing the Ribbon 3m 8s
Customizing the Microsoft Office Button 4m 54s
3. Modifying Worksheets 16m 15s
Opening old worksheets 2m 24s
Adding and deleting worksheets 3m 18s
Inserting and deleting cells 6m 53s
Freezing areas of a worksheet 3m 40s
4. Basic Formatting 20m 51s
Width and height 7m 25s
Numeric formats 2m 21s
Alignment of data 3m 19s
Playing with fonts 2m 58s
AutoFilter 2m 21s
Formatting as a table 2m 27s
5. Advanced Formatting 21m 31s
Removing duplicates 6m 1s
What is Conditional Formatting? 2m 21s
Working with Conditional Formatting 2m 14s
Managing Conditional Formatting rule preferences 2m 39s
Converting text to columns 4m 35s
Data validation 3m 41s
6. Using Templates, Styles, and AutoFormat 10m 56s
Templates 3m 45s
Styles 3m 35s
AutoFormat 3m 36s
7. Managing Lists in Excel 12m 16s
Excel lists have now become tables 2m 34s
Converting text to columns 3m 11s
Sorting and Grouping 5m 9s
Creating a summary report 1m 22s
8. Reviewing Worksheets 6m 44s
Proofing your work 3m 31s
Providing comments on worksheets 3m 13s
9. Sharing Worksheets 11m 43s
Protecting and sharing a worksheet 3m 57s
Allowing others to edit ranges 4m 3s
Track Changes 3m 43s
10. Printing Workbooks 22m 43s
Preparing to print 2m 31s
Print Preview 3m 33s
The Page Layout Tab 3m 56s
Page Breaks 4m 36s
The Page Layout View 3m 54s
Headers and Footers 4m 13s
11. Enhancing Worksheets 22m 34s
Adding themes to your worksheet 2m 53s
Page setup options 8m 0s
Scale to Fit 2m 26s
Worksheet options 5m 29s
Inserting images 3m 46s
12. Using Templates 3m 50s
Using templates 3m 50s
13. Manipulating the Screen Display 17m 48s
Workbook Views 2m 53s
Hiding and Zooming 3m 44s
Window Panes 5m 31s
More screen options 5m 40s
14. Importing Data 8m 16s
Importing from Access 2m 24s
Using the Import Wizard for text files 5m 52s
15. Finding and Replacing Data 11m 23s
The Find and Select button 4m 34s
Find and Replace 2m 48s
Removing duplicates 4m 1s
16. Working with Formulas 17m 3s
What are formulas? 3m 20s
Order of Operations 2m 50s
Relative and absolute referencing 4m 54s
The new Formula Tab 5m 59s
17. Working with Basic Functions 17m 29s
What are Functions? 2m 57s
AutoSum 2m 47s
Minimum 3m 55s
Trim 5m 2s
Left 2m 48s
18. Working with Advanced Functions 19m 51s
Concatenation 4m 10s
SumIf 4m 23s
Lookup 7m 25s
What-If Analysis 3m 53s
19. Charts 16m 44s
Why create a chart? 2m 12s
Creating your chart 3m 37s
Modifying your chart 6m 46s
Laying out your chart 4m 9s
20. Pivot Tables 17m 23s
What are PivotTable reports and PivotChart reports? 2m 32s
Creating a PivotTable 4m 47s
Laying out your PivotTable 2m 30s
Designing your PivotTable 4m 9s
Creating a PivotChart 3m 25s
21. Working with Macros 8m 57s
Why use macros? 2m 14s
Creating a macro 4m 31s
Macro security 2m 12s
22. Workflow in Excel 2007 5m 36s
Reviewing a workflow in Excel 5m 36s
Conclusion 22s
Conclusion 22s
Comments
Post a Comment