Table of contents

Introduction

Welcome

0:36

0.7 MB

1. Getting Started

Why use a spreadsheet?	1:44	2.9 MB
What's changed in Excel 2007?	5:37	11.2 MB
The Ribbon	2:09	3.5 MB
The Microsoft Office Button	1:27	2.7 MB

2. Setting Up Excel 2007

What's on the Ribbon?	1:56	2.4 MB
Making your way around the Ribbon	2:12	3 MB
Customizing the Ribbon	3:08	4.6 MB
Customizing the Microsoft Office Button	4:54	7.9 MB

3. Modifying Worksheets

Opening old worksheets	2:24	3.8 MB
Adding and deleting worksheets	3:18	4.2 MB
Inserting and deleting cells	6:53	12.6 MB
Freezing areas of a worksheet	3:40	6.9 MB

4. Basic Formatting

Width and height	7:25	11.5 MB
Numeric formats	2:21	3.9 MB
Alignment of data	3:19	5 MB
Playing with fonts	2:58	4.5 MB
AutoFilter	2:21	3.9 MB
Formatting as a table	2:27	4.8 MB

5. Advanced Formatting

Removing duplicates	6:01	9.4 MB
What is Conditional Formatting?	2:21	3.7 MB
Working with Conditional Formatting	2:14	4.3 MB
Managing Conditional Formatting rule preferences	2:39	4 MB
Converting text to columns	4:35	6.9 MB
Data validation	3:41	5 MB

6. Using Templates, Styles, and AutoFormat

Templates	3:45	6.1 MB
Styles	3:35	6.4 MB
AutoFormat	3:36	4.8 MB

7. Managing Lists in Excel

Excel lists have now become tables	2:34	4.7 MB
Converting text to columns	3:11	5.1 MB
Sorting and Grouping	5:09	9 MB
Creating a summary report	1:22	2.5 MB

8. Reviewing Worksheets

Proofing your work	3:31	5.6 MB
Providing comments on worksheets	3:13	5.3 MB

9. Sharing Worksheets

Protecting and sharing a worksheet	3:57	6.5 MB
Allowing others to edit ranges	4:03	6.1 MB
Track Changes	3:43	6.4 MB

10. Printing Workbooks

Preparing to print	2:31	4.5 MB
Print Preview	3:33	5.1 MB
The Page Layout Tab	3:56	6.8 MB
Page Breaks	4:36	7.6 MB
The Page Layout View	3:54	5.1 MB
Headers and Footers	4:13	4.8 MB

11. Enhancing Worksheets

Adding themes to your worksheet	2:53	5.7 MB
Page setup options	8:00	14.6 MB
Scale to Fit	2:26	4.4 MB
Worksheet options	5:29	10 MB
Inserting images	3:46	6.5 MB

12. Using Templates

Using templates

3:50

6.1 MB

13. Manipulating the Screen Display

Workbook Views	2:53	4.5 MB
Hiding and Zooming	3:44	7.4 MB
Window Panes	5:31	10.1 MB
More screen options	5:40	9.7 MB

14. Importing Data

Importing from Access	2:24	3.4 MB
Using the Import Wizard for text files	5:52	7.6 MB

15. Finding and Replacing Data

The Find and Select button	4:34	7.7 MB
Find and Replace	2:48	4.3 MB
Removing duplicates	4:01	6.9 MB

16. Working with Formulas

What are formulas?	3:20	3.6 MB
Order of Operations	2:50	3 MB
Relative and absolute referencing	4:54	7.5 MB
The new Formula Tab	5:59	9.4 MB

17. Working with Basic Functions

What are Functions?	2:57	4.3 MB
AutoSum	2:47	4.9 MB
Minimum	3:55	7.3 MB
Trim	5:02	9.2 MB
Left	2:48	5.1 MB

18. Working with Advanced Functions

Concatenation	4:10	7.5 MB
SumIf	5:18	8.2 MB
Lookup	7:25	10.8 MB
What-If Analysis	3:53	4.8 MB

19. Charts

Why create a chart?	2:12	3.3 MB
Creating your chart	3:37	5.5 MB
Modifying your chart	6:46	10 MB
Laying out your chart	4:09	5.4 MB

20. Pivot Tables

What are PivotTable reports and PivotChart reports?	2:32	3.9 MB
Creating a PivotTable	4:47	7.5 MB
Laying out your PivotTable	2:30	3.8 MB
Designing your PivotTable	4:09	6.3 MB
Creating a PivotChart	3:25	6.1 MB

21. Working with Macros

Why use macros?	2:14	4.4 MB
Creating a macro	4:31	7.2 MB
Macro security	2:12	2.5 MB

22. Workflow in Excel 2007

Reviewing a workflow in Excel

5:36

10.1 MB

Conclusion

Conclusion

0:22

0.5 MB