Excel 2007 Training Package

Excel 2007 Training

The Most Comprehensive 12 Hours of Hands On Excel 2007 Training... Guaranteed or Your Money Back!

Learn All of the Simple Tools & Techniques Used By Professionals to Increase Productivity, Enhance Efficiency
and Improve Business Analysis & Reporting!


By Bill Kulterman
CIW, MOS Master Certified


Whether you're tracking expenses, budgeting goals or creating massive keyword lists with one million rows, the new Microsoft Excel 2007 will streamline your workflow like never before.

And thanks to Train Signal's newest Excel 2007 course, you'll master all of those time saving features, and business building tools in no time. No stone is left unturned as we break down common to advanced concepts into easy, hands on lessons!

We are so convinced that this course is the most comprehensive Excel 2007 training on the market, that we guarantee your satisfaction for 90 days! And if certification is your goal, rest assured that this course will help you pass the 77-602 MCAS Exam!

"Can I Take This Microsoft Excel 2007 Course?"

YES! Whether you're a total beginner who has no Excel experience, or even if you have a great deal of experience, you'll benefit from this well rounded course!

Note: You will need a copy of Excel 2007 because the new interface has changed drastically from older versions.

Microsoft Office Excel 2007
Course Outline

Video 1
Introduction

Meet your instructor, Bill Kulterman and become familiar with the features of this course and the scenario that will guide you through your learning experience.

Video 2
Welcome to Excel

A thorough explanation of the new interface of Excel 2007, focusing especially on The Ribbon, and navigation.

* The Ribbon
* Navigation, getting around in Excel

Video 3
Entering and Editing Data

Learn tricks to enter data lists quicker and easier.

* How to enter data
* Working With Ranges of Data
* Auto Fill, or Fill Series

Video 4
Calculations  

Learn about basic arithmetic operations, and the syntax for writing Excel formulas.  Discover many ways to perform the same function and learn about the new file formats of Excel.

* Understanding the Order of Operations
* Using Basic Formulas,
* Understanding Functions
* What is Absolute Reference?
* Save and Save As

Video 5
Multiple Worksheets

Understand the difference between a workbook and a worksheet. Learn to add, move, and copy worksheets in an existing workbook or a new one.  Learn to calculate data from several worksheets.

* What is a Worksheet?
* Add a new Worksheet
* Using 3D Reference to calculate across several worksheets
* Working With Worksheets

Video 6
Basic Formatting

Learn about fonts, text size, color, cell options, fill, merge and center, borders, and alignment.

* Format Numbers
* Working with Text
* Cell options

Video 7
Organize your Excel data

Freeze Panes to make it easier to work with lots of data.  Sort data into groups for better organization.  Learn to filter out unwanted data.

* Freeze Panes
* Sorting your data
* Filtering out unwanted data
* Format Data as a Table

Video 8
Advanced Formatting

Learn about the new Styles options and Smart Art in Excel 2007, as well as mastering the drawing tools to create shapes and text boxes.  All of this is meant to help give a nice finished appearance to your Excel workbooks.

* Using Excel Table Styles
* Adding Shapes to your Excel workbooks
* Graphics in Excel
* Using the new Smart Art tools

Video 9
Advanced Formulas PART 1

Get exposed to some of the most commonly used functions and formulas in Excel. Gain a basic understanding of the types of things you can do with Excel by exposing the user to the different functions available.

* Naming Ranges of data
* Lookup and Reference functions
* Logical Test functions
* Financial functions
* Using Database Functions
* Text functions

Video 10
Auditing features in Excel

Help people find errors in their worksheets, make sure the right type of data is being used, and keep an eye on changes as they happen.

* Identifying Errors
* Using Validation
* Watch Your Data

Video 11
Create Charts and diagrams in Excel

Learn to present data visually in easily understood charts and graphs.

* What Is a Chart?
* Create Charts with Excel
* Format Charts with Excel

Video 12
Working with Multiple Workbooks

Expose people to the concept of linking multiple workbooks together with formulas and summarizing information from a group of workbooks.

* Linking Workbooks
* Consolidation workbook data

Video 13
Use and Create a Template in Excel 2007

Streamline the process of creating the same worksheet repeatedly.

* What is a template?
* Creating our own templates

Video 14
Working with Pivot Tables      

The goal here is to simply learn the best way to analyze large amounts of data in Excel.

* What are Pivot Tables?
* Creating a Pivot Table
* What else can I do with Pivot Tables?
* Formatting a Pivot Table
* Create a Pivot Chart

Video 15
Collaboration in Excel

Learn ways to track several people on the same worksheet and merge them together into a finished document; again, another time saver.

* Protect and share a workbook
* Tracking Changes in Excel
* Merging Documents
* Insert Comments and Hyperlinks in Excel

Video 16
Use and create Macros in Excel

Record a series of commands performed frequently to speed up the process, or make it easier for less skilled users to perform complex actions.

* Using Macros
* Creating Macros in Excel 2007
* Create a Macro Button
* Take a look at the Macro Editor, VBA
* Saving a workbook with a Macro

Video 17
Printing your Excel Worksheets 

Control the way your documents print.

* Viewing your documents
* Page layout options
* Insert Headers and footers
* Prepare your document to print

Excel 2007 Training

Microsoft Office Excel 2007 Training

Here's What You Get When You Order Today!

17 Videos (11hrs : 57mins : 51secs) will be provided in High-Quality AVI and WMV format. In other words, you get perfect quality and replication of your instructor's screens. An easy-to-use table of contents allows you to navigate to key areas you wish to focus on.

17 iPod video files to watch Train Signal on the go!
A popular request amongst our students who wish to study while they commute (i.e., train, plane, bus). These 320x240 .m4v files are compressed versions of the original course, and play on any iPod that supports video. Also great for reviewing and refreshing your mind "on the job."

17 MP3 Files to listen to Train Signal on the go. Some of our students have requested this option. People would like to be able to listen in their car or while working out. Can be burnt to a CD or copied to portable device. Great supplemental training to the videos.

Instructor Notes – These PDF documents can be printed out and contain the slides used by the instructor throughout the videos. These allow the user a quick easy reference to notes on the slides and make any additional notes for their own learning process.

A Tremendous Value for Your Modest Investment... Fully Backed by Our 90-Day "Total Experience" Guarantee!

90-Day Guarantee To get this level of training from any other CBT, online class, instructor-led class, workshop, bootcamp, or book, you would pay well over $495.00!

However, you can receive the same high-level professional training via Train Signal for Only $995! Limited-Time Offer Only $97!

PLUS! Because we are so confident in our training and reputation, we guarantee your complete satisfaction for 90 Days! No one else in the industry offers such a powerful guarantee! (If they offer one at all!)

(Risk-Free 90-Day Total Experience ™ Guarantee!)

Order Our Microsoft Excel 2007 Training Course Today, and You'll Receive:

PROFESSIONAL TRAINING

Nearly 12 Hours of Microsoft Office Excel 2007 Training Videos on 2 Jam Packed DVDs!
(Total Running Time: 11hrs : 57mins : 51secs)

Multiple File Formats Make It Convenient for You To Learn Anywhere You Go! iPod Video, Mp3 Audio, .WMV & high quality .AVI video

PDF of Instructor Notes allow you to follow along with the videos and take more organized notes.

77-602 MCAS EXAM PREPARATION

Complete Exam Coverage for "77-602 MCAS" This course covers all of the bases required for you to pass the exam!

Total Package Value $995!
Limited-Time Offer Only $97!

(Risk-Free 90-Day Total Experience ™ Guarantee!)

Meet Your Certified
Microsoft Excel 2007
Instructor, Bill Kulterman
(CIW, MOS Master Certified)

Bill Kullterman Bill Kulterman has worked as a web and graphic designer for over 6 years and has enjoyed teaching the Adobe/Macromedia Creative Suite since 2004.

Although graphics classes are his favorite, he is also an award-winning Microsoft Office Instructor in Chicago. His fun and easy going teaching style is engaging and allows for easy assimilation of new skills.

When not recording the Best Computer Training on the Planet, Bill can be found at the opera or tending to his backyard pond.

What Our Loyal Students
Say About Train Signal's
"Total Experience" Training


"You guys have a unique ability to explain and visually demonstrate these esoteric topics in a way that is easy to understand..."

I just wanted to let you know I have been very impressed with the orders we have placed with you.

Last year we bought the Microsoft Server Complete Library. It is one of the best I have seen.

You guys have a unique ability to explain and visually demonstrate these esoteric topics in a way that is easy to understand.

I have attended many training classes where I was getting good information but because of the way it was taught I had to force myself to pay attention and in some cases just try not to fall asleep.

These videos are just the opposite. If I am not careful I will sit up too late watching them.

Well, we just received our most recent order. This time we decided to order all of your VMWare Videos. If they are as good as your other work then I know I'm going to be happy.

Thanks for the help and keep up the good work.

Del Bullion
VDI Communications, Inc.

"...the best paying job of
my IT career. Your videos
had a big part in that..."

I wanted to let you know I was asked today (3/16/2007) to provide references for a Network Engineer position at a large world-wide law firm. Providing references is typically the last step before an offer. This potentially could be the best paying job of my IT career. Your videos had a big part in that.

I have two and half years experience with Active Directory and Exchange 2003, but your videos showed me just what I needed to pass their skills assessment test. The price was well worth it.

-Bill Boyd

"I ordered this course and within a week I had my exchange server up and going properly."

I would like to take this time and tell you how helpful found these videos. I have gone through books, online sessions, forums and I never really understood exchange in and out.

I ordered this course and within a week I had my exchange server up and going properly. I couldn't have asked for a better product and sometimes its nice to hear that instead of the bad stuff. Thank you.

James Latham, Jr.
Network administrator
Laro Maintenance Corp.

"I will recommend TrainSignal to all of my tech buddies..."

I wanted to write and express my great satisfaction with the Exchange Server 2003 for SophiesToyBox.com. I am very impressed with the course. I felt as though I was actually performing the tasks during the course.

Scott was great at explaining things and even going through the quirks that would surely happen during an install. I am very pleased with the material and plan to be back to purchase more. Great job. I will recommend TrainSignal to all of my tech buddies.

William R. Cunningham (Reggie)
Systems Administrator
Institute for Safe Medication Practices www.ismp.org

"I am on my way to becoming an MCSE and have found your videos very informative. However, your service deserves even more praise."

I inadvertently ordered two of the same course on Routing and Remote Access and when I discovered my mistake, I was very upset.

Internet based companies are often hard to deal with. If you try to return something, they put you off -sometimes indefinitely. I was almost sure that I would encounter problems when I attempted to exchange the video.

I called Ashley on the phone and informed her of my intent to exchange the duplicate video for another. She told me that she would send the other video when I returned mine.

I sent the video back by UPS and within a few days I received a package with the new Active Directory tutorial movie. I was so impressed that your company did not try to hold the movie hostage or to delay sending it. Even though I am an avid supporter of technology, I have to agree with those who say that the age of impersonal commerce has opened doorways to poor service.

I hope your company is successful and that others realize the benefit of doing business with someone they can trust!

Sincerely,

Nancy Ashley Ware

"I will be happy to recommend your products to anyone I know..."

Just to let you guys know I received my order this morning. Extremely happy with the fast delivery service, since I ordered the product on Tuesday afternoon and I received them Thursday morning (48hrs delivery from the US to the UK, that puts to shame some mail order companies in the UK) I will be happy to recommend your products to anyone I know.

Daniel Jenkins
Surrey, Great Britain

"Train Signal Rocks!"

Keep kicking butt! I have purchased CBT nuggets before. They are good on theory and very little application. Yours is both. Please keep up the great work Scott. You are very gifted.

What I love about your stuff is you have the theory and then you apply and then you test it! You go full circle. CBT nuggets leaves too many things open ended. People don’t realize from the home CBT user. You need to go full circle theory, application how to use it, and then prove it. Mistakes and proving things help us see why? And help us handle the unexpected better. I also am a teacher at my work, and this is what I do with effectiveness.

I also bought all of your courses all 21... I am studying for MCSE 2003 and your course rocks better than classroom. Way better.

Keep up the great work. Train Signal rocks!

Robert W. Van Dyke
IS Assistant
Bulls Eye Credit Union

"I’m sure I will be buying a lot more videos from you. :)"

I bought the entire Windows training package and I am probably about half way through it. I am definitely happy with the product. So far I’ve watched videos from both Scott Skinger and Obaid Chhatriwala…both do a very good job.

Again, I am really happy with the product and I think the instruction quality of both Scott and Obaid is great! I’m only commenting on this because I’m sure I will be buying a lot more videos from you. :)

David Copenhaver
IT Manager / Network Administrator
HESSTECH, LLC

"Your way of running business is a rare example..."

There truly is power in a good name and a way of running business. Good impressions and positive experiences with a company definitely affect how people think when they think of your name - in this case, Train Signal.

All that is to say thank you and that I will truly enjoy the material. I have studied all the other many hours diligently and will continue on my certification path. You guys are doing it right; it's great to take part in your program and business.

Sincerely,

John Archer

"Its like having a Veteran walk you through training camp, building your confidence so you know what it takes to get it done."

Just want to say great job by you and the team on the training videos. The videos and the lab books trail each other so you align the image of it being done with the instructional reading. Its like having a Veteran walk you through training camp building your confidence so you know what it takes to get it done.

If your goal is certification then partner the video with test questions and you will solidify the knowledge from the video in your mind for the test and while really getting to know your craft!

- Andrew (MCSE, A+, N+)

"I highly recommend your products and I buy every new release that comes out."

I would like to say that I have had many “live” classes in everything from MCSE to CCNA and your classes are as good or better. You can play the CDs over and over or go back and review something that you did not really understand the first time.

I highly recommend your products and I buy every new release that comes out. Please keep up the great work!

Thanks,

Joseph McElveen
Insync Network Systems
Savannah, Georgia

Copyright © 2002-2008 Train Signal, Inc. All Rights Reserved.
All logos and trademarks are property of their respective owners.