Learn Excel 2007

Title Description

Microsoft Excel 2007 is a major change from the previous version. Learn how to create an array of Excel documents, from simple spreadsheets to vibrant charts and tables. In this course, our instructor guides you through Excel's new interface, new features, and offers plenty of additional tips.

You can try for FREE by clicking on one of the links below.
All titles with an asterisk * are free.

Practice File

Title Excel 2007

Duration 5 hours

Lessons 60

Chapter 1

Introduction*5:00 What Is a Spreadsheet*5:04 Why Use Excel 2007*5:35 New Features in Excel 2007*4:25 Working with Previous Excel Versions*3:57 How to Open Excel 2007*5:59 The Office Button*5:12 The Ribbon*4:22 The Quick Access Toolbar*4:48 Worksheet Tabs*6:01

Chapter 2

Selecting Cells and Data4:47 How to Edit Data4:29 Structuring a Worksheet4:51 Templates8:03 Rows and Columns3:51 More on Worksheets5:22

Chapter 3

Using Fonts3:05 Alignment4:10 Number and Styles4:09 Cells and AutoSum4:51 Sorting5:07 Filtering4:56

Chapter 4

Symbols and Headers and Footers3:29 Pictures and Shapes6:05 Charts9:25

Chapter 5

Page Setup4:30 Scale and Sheets3:33

Chapter 6

Views and Hide and Zoom4:02 Arrange All3:31 New Window4:27 Freeze, Split, and Hide4:39

Chapter 7

Proofing and Comments6:08 Protecting and Unprotecting5:14

Chapter 8

Data from Access4:24 Data from Web3:45 Text to Columns3:28 Remove Duplicates3:11 Data Validation5:24

Chapter 9

Formulas and Functions7:25 Function Library Overview6:22 Define Name6:36 Formula Auditing5:22

Chapter 10

Lists and Tables5:19 Lists and Tables Continued5:50

Chapter 11

IF Function4:30 Nested IF Function5:46 OR Function4:09 AND Function4:15 Text Function5:27 Text Function Part 26:27 Date and Time Function5:39 Date and Time Function Part 25:16 Vlookup Function4:57 Financial Function5:04 2D Table 4:57 Conditional Formatting4:50 Shortcuts6:04 Shortcuts Part 27:12 Conclusion4:40

Our Microsoft Excel 2007 training course can be accessed anytime, anywhere. Why purchase another training DVD or CD with fancy packaging when you can watch our Microsoft Excel training tutorials from any computer.

During this 11 chapter Excel training class, we'll start from the basics including the Office Ribbon and finish off with advanced topics including Excel functions.

Here are some of the topics we’ll cover during the Learn Microsoft Excel 2007 training videos:

Learn how navigate the new Office 2007 interface including the "Ribbon" and Office Button.

Learn great techniques to remove duplicates from Excel, sort and filter your data

Keep your Excel your spreadsheet and worksheets professional by learning proofing and protection techniques.

Are you new to spreadsheets? Learn rows, columns and Excel cell properties.

We'll teach introduce you how to use Excel formulas and functions including the Excel function library.

We'll add some polish to your Excel skills by covering over 10 videos topics on Excel functions including the Vlookup function, IF function, nested IF function, OR function, and Date and Time functions.

Know how to use data validation, data from Access and data from the web.

And much more!