Excel 2007 Training Package
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
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!
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!)
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!
Meet Your Certified
Microsoft Excel 2007
Instructor, Bill Kulterman
(CIW, MOS Master Certified)
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
|