Training Home | Business Applications | Microsoft Excel 2007: Beginners

Microsoft Excel 2007: Essentials Tutorial Video

Learn how to take your skills to the next level. This Microsoft Excel 2007: Essentials training DVD is the ultimate in comprehensive learning for the discerning professional.

The training uses broadcast quality audio and video to deliver concise and informative training right to your desktop. The Tutorial comes complete with practical working files and presented via an intuitive, easy-to-use interface, This Microsoft Excel 2007: Essentials tutorial video makes learning simple, quick and enjoyable. All training courses are authored by professional instructors who have a passion for teaching.

Self Paced, Affordable Training Videos - Tutorials Taught by Professionals

Reduce learning time by 80%. Learn from a professional trainer from your own desk.
Suitable for beginners to advanced users. ideal for users who learn faster when shown.
Visual training method, offering users increased retention and accelerated learning.
Breaks even the most complex applications down into simplistic steps.

For evaluation purposes the links below offer an insight into the quality of these Microsoft Excel 2007: Essentials tutorials. In order for the free demo videos to play QuickTime needs to be installed.

Free Demo Tutorial 1
Quicktime »
Windows Media Player »

Free Demo Tutorial 2
Quicktime »
Windows Media Player »

This Weeks Limited Offer

25% off AutoCAD 2010 Videos

OVER 9 hours of Video Training - ONLY $74.95

We are pleased to announce that we have just released our Amazing AutoCAD training videos. This highly intuitive and engaging training course is only $74.95, which is amazing value. To try a free demo just follow the link below. To try for FREE Click Here »

Customer Testimonials

I have been a Flash designer for many years, but only dabbled in ActionScript. I understood advanced techniques only with a holistic understanding, but having viewed much of Joey's training I understand so much more. His presentation is perfect to work along with and his examples cover projects that you could actually use and adapt in the real world. I can't praise it enough!
richard b.

WORKING WITH THE USER INTERFACE

Introducing the Ribbon User Interface
Introducing Workbooks & Worksheets
Introducing the Formula Bar
Saving with Different File Extensions
Customizing the User Interface

ENTERING & MANAGING DATA

Getting Data into Excel
Importing Text Files
Using the Freeze Panes Functionality
Using the Zoom Functionality
Using Hot Keys
Managing Rows & Columns
Finding Data
Matching Case & Entire Cell Contents
Replacing Data
Finding & Replacing Empty Values
Sorting Data
Sorting Multiple Columns
Filtering Data

USING FORMATTING TECHNIQUES

Formatting Numbers & Dates
Formatting Cells
Setting the Font Type, Color & Size
Using Borders & Cell Styles
Adding Shapes & Pictures
Creating WordArt

FORMULA BASICS

Constants, Formulas & Cell References
Understanding the Order of Operations
Using Formulas with Dates & Text
Linking Cells & Using Comparison Operators
Creating an Absolute Reference
Defining Named Ranges
Exploring the Function Library
Using the AutoSum Function

USEFUL FUNCTIONS

Using the INT Function
Using the Rounding Function
Using the ABS Function
Using the SUBTotal Function
Using Logical Functions
Using the AND & the OR Function
Using LEFT, RIGHT & MID Functions
Using the UPPER, LOWER, PROPER & TRIM Functions
Using COUNT Functions
Using the VLOOKUP Function

CREATING REPORTS

Creating a Subtotal Report
Using Conditional Formatting
Creating & Managing Conditions
Creating a Chart
Refining Charts
Using Basic Chart Types

SHARING & DISTRIBUTING YOUR WORK

Inserting Headers & Footers
Adding Comments
Adjusting Page Layout
Distributing Your Worksheets
Protecting Your Worksheets
Understanding Compatibility

TIPS & TRICKS

Using the Fill Handle
Filling in a Series of Numbers
Typing in Multiple Cells at Once
Leveraging a Custom List & Transposing a Range
Deleting & Inserting Blank Cells
Filling Holes in Your Data
Getting a List of Unique Records & Parsing Text
Rearranging Columns & Linking to Multiple Cells
Using Right Mouse Button Drag Options
Make Format Painter Persist & Paste Special Formats
Formatting Portions of Text & Multiple Sheets
Creating Cell Border Effects & Sorting on Color
Turning Formulas into Hard Data
Copy Formula References & Highlight Formulas
Creating Dynamic Charts & Combination Charts
Add a Secondary Axis, Average Line & Smooth Line
Comparing Data Dynamically with Charts
Final Comments & Credits

Microsoft Excel 2007 Tutorial Info

Title Information.

Learning to use Microsoft Excel has never been this simple. Our video tutorials quickly and thoroughly walk you step-by-step through all aspects Excel offers. This video training series begins with the simplest tasks and progresses to more difficult projects. Along the way, you will pick up tips and tricks of savvy Excel users. If you have ever wanted to learn how to use Excel to create better spreadsheets and improve spreadsheet analysis, now is the time!. Close »

Instructor : Michael Alexander

All Training Courses by this author

Publisher:

Total Training

Duration:

5 hours - 72 lessons

Platform:

PC or Mac

Fomat :

DVD Video

Price:

$99.99
Sale Price: $69.99

£48.43

€56.62

Select your delivery option

ONLY 1 LEFT!

Microsoft Excel 2007: Essentials Related Training Videos :

Join our Newsletter and Save

By joining our newsletter you will be notified of special offers and limited promotions. We don't sell, rent or otherwise disclose your details to any 3rd party. Sign up today and take advantage.

Just Released Training Titles

Adobe Photoshop CS5 Training
Microsoft Office 2010
Learning Microsoft Project 2010
Learning Microsoft Excel 2010
Carrara 8 Training

Learn Online - Instant Access - Low Price

Giving you amazing freedom to learn at your own pace these online training videos combine high quality professionally created content, broadcast standard high definition video and crystal clear audio, at an extremely cost effective price. The tutorials are presented via an easy to use interface.

You can now access an entire library of professionally created tutorials in High Definition video for the same price as our competitors charge from one DVD.

Users are bound by no constants on the amount of titles that can be viewed, access can be from any location and where available, working files are included at no extra charge.

Customer Comments

I don't know who is receiving this email but I must compliment Mr. Garrick Chow on his presentation style and content. I was in a terrible fix, i.e., I had no one to do my website. I was going to have to do it myself. So flying by the seat of my proverbial pants, I learned how to create something that was in my brain to html. If I can do it AND be pleased, then that is remarkable. Mr. Chow's knowledge is evident and he is a natural born teacher. I also took Mr. Chow's GarageBand and Podcasting. I now have three podcasts under my belt and will attempt to do a videocast in the future. Again...thanks to the brilliant instruction of Mr. Chow. Thank you again for this instructional model. Your company resonates with quality.
catherine r.