Microsoft Excel Training Course | Learn MS Excel Software Online Course

Learn Excel 2007

Microsoft Excel 2007 training with the best professionals.

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.

For optimal viewing of these high-definition videos, please set your desktop resolution to at least 1024 X 768.

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 Data 4:47 How to Edit Data 4:29 Structuring a Worksheet 4:51 Templates 8:03 Rows and Columns 3:51 More on Worksheets 5:22
Chapter 3
Using Fonts 3:05 Alignment 4:10 Number and Styles 4:09 Cells and AutoSum 4:51 Sorting 5:07 Filtering 4:56
Chapter 4
Symbols and Headers and Footers 3:29 Pictures and Shapes 6:05 Charts 9:25
Chapter 5
Page Setup 4:30 Scale and Sheets 3:33
Chapter 6
Views and Hide and Zoom 4:02 Arrange All 3:31 New Window 4:27 Freeze, Split, and Hide 4:39
Chapter 7
Proofing and Comments 6:08 Protecting and Unprotecting 5:14
Chapter 8
Data from Access 4:24 Data from Web 3:45 Text to Columns 3:28 Remove Duplicates 3:11 Data Validation 5:24
Chapter 9
Formulas and Functions 7:25 Function Library Overview 6:22 Define Name 6:36 Formula Auditing 5:22
Chapter 10
Lists and Tables 5:19 Lists and Tables Continued 5:50
Chapter 11
IF Function 4:30 Nested IF Function 5:46 OR Function 4:09 AND Function 4:15 Text Function 5:27 Text Function Part 2 6:27 Date and Time Function 5:39 Date and Time Function Part 2 5:16 Vlookup Function 4:57 Financial Function 5:04 2D Table 4:57 Conditional Formatting 4:50 Shortcuts 6:04 Shortcuts Part 2 7:12 Conclusion 4:40 Practice File

Microsoft Excel 2010 Online Training Course Overview

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 spreadsheet and worksheets professional by learning proofing and protection techniques.

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

We'll 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!

Any subscription includes access to our entire training library. Watch, rewind and repeat the training as often you like while you subscription is active. Any new course released while your subscription is active can be viewed too..

ANNUAL Membership to SimonSezIT.com ($147 for 365 days. SAVE 51% per month. Includes FREE training DVD!) This is an annual membership to SimonSezIT.com which includes access to all online training courses. You will NOT be charged again when your membership expires. Only $12.25 per month.

MONTHLY Membership to SimonSezIT.com
($25 for the first 30 days. Then $25.00 for each 30 days.) Does not include free training DVD. This is a monthly membership to SimonSezIT.com which includes access to all online training courses. You will be charged each month as long as you are a member. You can cancel at any time.

As you've seen on: