Sign-up to receive a free Intro to Virtualization training course.
Excel 2007 Training
Industry Recognized Training: 2010, 2009 Editor's Best and Community Choice Award from Windows IT Pro

Excel 2007 Training

The Most Comprehensive 12 Hours of Hands On Microsoft 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 and Reporting!

This Course Includes All of the Following:

  • Instant Online Access to Your TrainingInstant Online Access Begin Streaming Your Training Immediately
  • Physical Media Shipped Directly to Your DoorstepPhysical Media Shipped Directly to Your Doorstep For Free, Worldwide

Certified Instruction:

  • Certified Instructor Bill Kulterman Bill KultermanMCT, CIW, Project+, Security+, MOS Master
  • $97
  • Paying with Purchase Order?
  • View Outline
  • TrainSignal Exclusive 90 Day Total Experience Guarantee

    Our Total Experience Guarantee is Very Simple

    If you are not satisfied with our training, our service, or our support FOR ANY REASON, return your course within 90 days for a FULL REFUND (up to $397). You have my word.

    Scott Skinger Founder & President of TrainSignal, Inc.

Overview

  • Train Anywhere You Want Mobile On-Demand Training Train Where You Want, When You Want
  • Additional Training Formats Additional Training Formats High Resolution Video, MP3 Audio and PDF of Instructor Notes
  • Watch a Demo

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!

Professional Training

  • Nearly 12 Hours (11 Hours, 54 Minutes, 3 Seconds) of Excel 2007 Training Videos Jam Packed on 2 DVDs!
  • 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
  • Instant Access Online to the entire training course

Exam Preparation

  • Exam Coverage This course covers exam objectives required for you to pass:
    • 77-602 - MOS: Using Microsoft Office Excel 2007 Exam

Course Outline

Excel 2007 Training - Course Outline

Lesson 1 - Introduction to Excel 2007

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.

Lesson 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
Lesson 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
Lesson 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
Lesson 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
Lesson 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
Lesson 7 - Organization

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
Lesson 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
Lesson 9 - Advanced Formulas

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
Lesson 10 - Auditing

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
Lesson 11 - Charts

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

  • What Is a Chart?
  • Create Charts with Excel
  • Format Charts with Excel
Lesson 12 - 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
Lesson 13 - Templates

Streamline the process of creating the same worksheet repeatedly.

  • What is a template?
  • Creating our own templates
Lesson 14 - PivotTables

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
Lesson 15 - Collaboration

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
Lesson 16 - Macros

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
Lesson 17 - Printing

Control the way your documents print.

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

Certified Instruction

Certified Instructor Bill Kulterman

Bill Kulterman (MCT, CIW, Project+, Security+, MOS Master)

Bill 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.

FAQ

Excel 2007 Training - FAQ

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.

"TrainSignal Courses equals Instant Experience!"

TrainSignal'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 TrainSignal 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. TrainSignal Courses equals Instant Experience!

Christopher Breen Principal Engineer, Network And PC Support
"Any TrainSignal Lab that has Heather Ackmann's name on it, I will make a point of getting..."

I purchased my first TrainSignal Lab over 3 years ago and the Access 2007 Lab is the only one where they have told a fib. The brief says 18 hours 2 minutes and 25 seconds of video tutorials however with the smooth information packed delivery and the easy to listen to style of Heather I believe it seems more like 22 hours of instruction.

Of the 35+ TrainSignal Labs I have, this is undoubtedly the best one to date that I have ever had the pleasure of learning from. Heather presents this Lab in a way that is logically progressive and while this is the same for all the Labs I have, Access 2007 has just that bit more oomph to it. The smooth and easy to listen to delivery is what I believe packs in the seemingly extra 4 hours of tutorial information.

I had never used Access because is just seemed too hard and too complex. Heathers teaching expertise has simplified how to use Access and removed this blinkered view that I should never have had. Any TrainSignal Lab that has Heather Ackmann's name on it (hackmann, what a logon name eh) I will make a point of getting because I know just how good it will be even before reading what the Lab will be about.

I use PowerPoint, but already I am looking forward to the new and unknown features Heather will be teaching me about it.

Christopher Breen Principal Engineer, Network And PC Support
"TrainSignal products not only teach me how to maintain my network, I actually gain understanding that is invaluable for the tests as well..."

I just wanted to send in my thanks. It’s really nice to have a product out there for net admins that really delivers.

Everyone else seems to brag about how you can use their products to pass a test. I've taken and passed several tests, and few contained the content I need on a day-to-day basis.

TrainSignal products not only teach me how to maintain my network, I actually gain understanding that is invaluable for the tests as well. I bought your product at my previous employer and will buy it for my current employer as funds become available.

Though your product is amazing, I would like to make one request that I feel would complete the package. Most admins are clueless when it comes to scripting.

Everyone seems to have tons of advanced scripting, but just like everything else, there are little to no explanations for the beginner. Could you please consider adding something in that area to your training? Keep up the good work.

Thanks

David Morehead www.wcsmiami.org
"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 shall continue to buy your products without a question of a doubt."

I have purchased almost all of your videos so far and I must say that they have been value for money; in as much as that I have gained lots of new skills.

Moreover, I find your service absolutely excellent and I feel totally appreciated as a customer. I shall continue to buy your products without a question of a doubt.

Kind regards,

Keith Greaves Fruitree director
"...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
"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.
"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 Practiceswww.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
"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
"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, TrainSignal.

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.

John Archer

Looking For Volume User Licensing For Excel 2007 Training?

24/7 Instant Access to Individual Courses from TrainSignal

24/7 Access to Training

Online access to all training through My Online Training, with an option for physical media.

Volume Discounts on Individual Courses from TrainSignal

Volume Discounts

Discounts start at quantities as low as 2 licenses per training course.

Scalable Licensing Model from TrainSignal

Scalable Licensing Model

License your team for specific courses that meet their needs to build a custom package of TrainSignal Training.

Call 1.888.229.5055 or Email sales@trainsignal.com

Contact us for a free volume license quote or tell us how many licenses you need and we'll show you the volume license discount immediately in your cart.

Volume Discount Pricing For Excel 2007 Training

# of Users% DiscountCost Per User
10%$97.00
220%$77.60
3-425%$72.75
5-930%$67.90
10-1935%$63.05
20-4940%$58.20
50+Call 1.888.229.5055