Home  >  Microsoft Office Training  >  Microsoft Office 2007 Training  > Excel 2007 Training

Excel 2007 Training
Excel 2007 Training Package

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

Start Learning Right Now with Instant Access to your Excel 2007 Training Course (via Train Signal’s My Online Training)

This great feature allows you to get access to the training just seconds after you’ve purchased it! Plus, you’ll still receive the DVDs in the mail!

My Online Training - Instant Access

You have access to all the Excel 2007 Training you’ve purchased in one simple location. There is no need to bring your DVDs from home to work or school anymore. Just login to Trainsignal.com and in your account you’ll see a section containing your courses in My Online Training

Instant Access via My Online Training is the perfect addition to Train Signal’s industry leading Excel 2007 Training course! Best of All, it’s completely FREE!

  • No more waiting for the mail to get started with learning. Get access to your training instantly!
  • Receive both the physical DVDs and online access!
  • Full quality playback compatible with Windows, Mac, and Linux!
  • All your training is just a click away!

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

A Word from 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.

Excel 2007 Training 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

Here's What You Get When You Order Our
Excel 2007 Training Today!

  • 17 Videos (11hrs : 54mins : 03secs) will be provided in high-quality AVI and WMV format. In other words, you get perfect quality and replication of your instructors' screens. An easy-to-use table of contents allows you to navigate to key areas you wish to focus on.
  • Instant Access to all 17 Videos in Train Signal’s My Online Training section. These high resolution videos allow you to access any and all of this award winning training in just moments. No need to wait for the DVDs to arrive to get started learning. You can be watching video in just moments and it’s all included for free.
  • 17 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 audio files to listen to Train Signal anytime, anywhere. Some of our students have requested this option. Now, you can listen in the car or while working out. Our MP3 files can be burnt to a CD or copied to a portable device.
  • Instructor Notes - These PDF documents, which can be printed out, contain the slides used by the instructors throughout the videos. These documents allow the user a quick easy reference to the instructors' notes on the slides, and provides a place to make additional notes.

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

90-Day Total Experience 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!

You can receive the same high-level professional training via Train Signal for Only $199!
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 Excel 2007 Training Today, and Receive:

PROFESSIONAL TRAINING

  • Nearly 12 Hours of Microsoft Office Excel 2007 Training Videos on 2 Jam Packed DVDs!
  • Instant Access Online to the entire training course
  • 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 $199!

Limited-Time Offer Only $97

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

watch demo
Microsoft Excel 2007
Training Demo

Meet Your Certified Instructor, Bill Kulterman

(Project+, Security+, CIW, MOS Master Certified)

Bill Kulterman 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 and Project+ certified Project Manager. 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.

Similar Products

"Train Signal Courses equals Instant Experience!"
Train Signal's Excel 2007 Lab is the Rolls Royce of training at Ford prices. This Lab has been created for the novice who has no idea what a spreadsheet is, to the Advanced User who wants to quickly know about the new features in Excel 2007.

Bill took me through Excel 2007, explained all the basics and later showed me where to find all these new features and how to apply them. If you are an Excel Power User or a regular user like me, then you too shall find this Train Signal Lab the cheapest and easiest way to become an expert in a single weekend.

Now that I have finished the Excel Lab, my High School daughter has stolen the disc from me so she too can learn about Excel 2007 the easiest way possible. Train Signal Courses equals Instant Experience!

Christopher Breen
Principal Engineer
Network And PC Support
"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 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
"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 it 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
"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
Connect with Us

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