 Excel
2007 Training Course
"Hands On" Training for IT Users
Excel 2007 Training Demo
With Microsoft Office's Newest release, Excel 2007
is better than ever. Every business out there has an application of Excel 2007
that will benefit them with increased productivity and better analysis. Whether
it is just tracking expenses, budget goals or creating massive keyword lists for
Google with 1,000,000 rows Microsoft Excel 2007 has a way to make you work
better and quicker. In the sample training video Bill will teach you about
creating table styles in Microsoft Office Excel 2007.
Topics you will Master in
Microsoft Excel 2007 Training Video Course:
Introduction to Microsoft Excel 2007
- About your Excel 2007 training instructor: Bill Kulterman
- Who is Microsoft Excel 2007 training for?
- About this course
- Learning Made Fun Scenario
- Excel Keyboard shortcuts
- What we learned
Welcome to Microsoft Excel 2007
- The Ribbon
- The Quick Button
- The Quick Access Toolbar
- Contextual Tabs
- Navigation
- Scroll Bars
- Excel 2007 Keyboard Commands
- Go To
Entering and Editing Excel Data Part 1
- Entering Data In Excel 2007
- Editing Your Data
- Cut, Copy, Paste, Undo, Redo
- Inserting Rows and Columns into your Excel Workbook
- Edit Column Width and Row Height
Entering and Editing Excel Data Part 2
- Find And Replace Data
- Working With Ranges
- Auto Fill: Text, Numbers, Custom Lists
Auditing Your Excel Files
- Errors: Trace Precedents, Trace Dependants, Trace Errors, Evaluate
Formulas, Error Checking, ISERROR
- Validation: Data Validation, Invalid Data
- Watch Your Data: Watch Window, Conditional Formatting
Charts in Excel 2007
- What Is a Chart?
- Chart Types
- Create Charts: Column, Pie, Combination Chart, Bar, Modify
- Format Charts: Design, Layout, Format
Multiple Workbooks
- Linking Workbooks: Workspaces, External Reference
- Consolidation: by Position, by Category
Templates For Excel 2007
- What is a Template?
- Using Templates
- Downloading and Installing Excel Templates
- Creating Your Own Template
- Protecting Your Worksheet
- Save As Template
Pivot Tables in Excel 2007
- What Are Pivot Tables?
- Creating Pivot Tables in Excel 2007
- What Else Can I Do With Pivot Tables?
- Formatting Pivot Tables
- Pivot Charts
Collaboration with Microsoft Excel 2007
- Protect and Share a Workbook
- Tracking Changes in Excel Files
- Merging Excel Documents
- Comments and Hyperlinks
Macros
- Using Macros
- Creating Macros
- Creating Buttons in Excel
- Macro Editor
- Saving Excel Macros
Printing Your Excel files
- Viewing your Excel Documents
- Page Layout
- Headers and Footers
- Ready to Print
The Complete Train Signal FastTrack Video
CBT Training Library
Buy "Excel 2007" as Part of our
Complete FastTrack Video CBT Training Library...
Every Course we Have on a USB Hard Drive
Check it Out Now!
Excel 2007
Only £60 (ex vat &
del)
Multi user pricing available - call sales now
Official Purchase orders accepted from
Government, Education, Health & Charity, Times 1000 plc's, Professional
Partnerships and other pre-approved accounts. Want to order more than one course
? Contact sales for a custom quote.
| 