Layout Table~~~~9376~9376~~

Excel 2007 Training Videos~

• 12+ Hours of Instructor Led Video Training covering Microsoft Excel 2007
• Additional Excel 2007 Exercises - Follow Along with Every Step
• 77-602 MCAS: Using Microsoft Office Excel 2007 Certification Exam Coverage
• Proven Training Method Guarantees Results
  
  
• The Most Effective Way to Learn Outlook 2007 . . . See why

~~~9376~9377~~

Excel 2007 Training Demo~~~~9376~9378~~

Layout Table~~~~9376~9379~~

Some of
TrainSignal Users~~~~9376~9380~~

TrainSignal Customers~~~~9376~9381~~

New Display Item~~~~9376~9382~~

New Display Item~~~~9376~9383~~

New Display Item~~~~9376~9384~~

New Display Item~~~~9376~9385~~

Course Outline Table~~~~9376~9386~~

Course Overview~

• Fun, Interactive Scenarios and "Real World" Examples make our Excel 2007 Training easy to retain!
  
• DETAILS, DETAILS, DETAILS...We Teach them to You! We Walk you Through the Details, Step-by-Step.
  
• "Instruction that is as good or better than any class I have attended and is between 1/10 and 1/20 of the price" Testimonial from Jeff Moore (Train Signal customer).
  

Product Review - Trainsignal Video Training Course
JohnKellett.co.uk - Jan 2007

I have taken many courses in my time but never been trained by video before. Over the Christmas period (Happy New Year by the way) that changed as I took the Exchange server 2003 course by Trainsignal. It has to be said that I was most impressed with both the course materials and the instructor.

The CD itself arrived within two days of ordering. There are several hours of Video and I found it refreshing that I could stop and start when I fancied a break, go back to things I needed to hear a few times before it sunk in and know that I can always look at them again should I need to be walked through a specific task in the future. The course includes a fictitious company and scenarios which kept me more interested than listening to someone reel off a load of memorised facts and figures with no explanation. Also included is a PDF “How to” guide. I would definately recommend Trainsignal to both beginners and experienced admins.~~~9376~9387~~

Course Outline~Here are just SOME of the Topics we Cover in the Excel 2007 Training Videos:

• 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
• Calculations
• Order of Operations
• Basic Formulas
• Functions
• Absolute Reference
• Save and Save As
• File Formats
• Multiple Worksheets
• What is a Worksheet?
• Add a new Worksheet
• 3D Reference
• Working With Worksheets
• Renaming
• Move and Copy
• Add Data
• Rearrange
• Basic Formatting in Excel 2007
• Numbers: Currency, Date, Percentage
• Text: Fonts, Wrap Text
• Cells: Merge and Center, Fills, Borders, Alignment
• Organization: Freeze Panes, Sorting, Filtering, Data as Tables
• Advanced Formatting in Excel 2007
• Styles
• Themes
• Shapes: Drawing Tools & Word Art
• Graphics: Pictures, Clip Art, Backgrounds, Smart Art
• Advanced Excel Formulas Part 1
• Naming Ranges
• Lookup and Reference: VLOOKUP, HLOOKUP, Range Lookup
• Logical Test: IF, Nested IF, IF With AND
• Advanced Excel Formulas Part 2
• Financial Tasks: PMT, Goal Seek, Solver
• Using Database Functions: DSUM, DAVERAGE
• Text: Concatenate, Text To Columns
• 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

Further improve email security with Exchange Server 2007 and Outlook 2007 working together.~~~9376~9388~~

Ordering~~~~9376~9389~~