Excel 2007 Essential Training

Excel 2007 Essential Training
Like the other applications in Microsoft Office 2007, Excel 2007 boasts upgraded features and a brand-new look. In Excel 2007 Essential Training , instructor Lorna A. Daly introduces the new version in detail. The training begins with the essentials of using the program, including how and why to use a spreadsheet, how to set up and modify worksheets, and how to import and export data. Lorna then moves on to teach more advanced features, such as working with functions and macros. Exercise files accompany the tutorials.

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.0 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.0 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.0 MB
Converting text to columns 4:35 6.9 MB
Data validation 3:41 5.0 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.0 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.0 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.0 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.0 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

Quick links

* Free Video Tutorials
* Frequently Asked Questions
* Sign up for our Newsletter
* System Requirements

Password: TibQA

Code:

http://www.filesonic.com/file/162514871/EXCEL_TRAINING_TibQA.part1.rar
http://www.filesonic.com/file/162515262/EXCEL_TRAINING_TibQA.part2.rar