LinkedIn Google + Facebook YouTube Twitter
Build infinite skills
with project-based training videos
Master Microsoft Excel - Advanced Tools And Techniques Training Video

Master Microsoft Excel - Advanced Tools And Techniques Training Video

A Practical Excel Training Course That Teaches Real World Skills

In this project-based Master Microsoft Excel - Advanced Tools And Techniques video tutorial series, you'll quickly have relevant skills for real-world applications.

Follow along with our expert instructor in this training course to get:

  • Concise, informative and broadcast-quality Master Microsoft Excel - Advanced Tools And Techniques training videos delivered to your desktop
  • The ability to learn at your own pace with our intuitive, easy-to-use interface
  • A quick grasp of even the most complex Master Microsoft Excel - Advanced Tools And Techniques subjects because they're broken into simple, easy to follow tutorial videos

Practical working files further enhance the learning process and provide a degree of retention that is unmatched by any other form of Master Microsoft Excel - Advanced Tools And Techniques tutorial, online or offline... so you'll know the exact steps for your own projects.

Share |
SKU: 01923 | Duration: 23.25 hours - 227 tutorial videos | Date Released: 2014-05-02
Works on: Windows PC or Mac | Format: DVD and Download | Instructor: Guy Vaccaro

Table of Contents

expand all / collapse all

Course Description

In this Mastering Microsoft Excel training video, expert authors Guy Vaccaro and Erin Olsen take you beyond the basics of Excel and teach you power user tools and techniques to help you get the most out of this popular spreadsheet program. This tutorial is designed for users that already have a basic working knowledge of Microsoft Excel.

This video based training course starts with a close look at how to increase your productivity using shortcuts. Using keyboard commands, the ribbon and simply organizing your data you can work faster and better in Excel. Erin takes over to teach you about managing your worksheets, and importing data from external sources. Next, you tackle advanced formulas and functions such as Mround, Ceiling, extracting data with Left, Right and Mid, and advanced conditional statements. This video tutorial continues with an in-depth look at tables, creating, formatting, and even performing table calculations. Pivot tables is the next major topic, and Erin dives deep into how to create, summarize and manage large amounts of data with Pivot Tables. Finally, Guy will show you how to summarize and present your data using different kinds of charts and advanced chart formatting techniques.

Once you have completed this computer based training course on advanced Microsoft Excel techniques, you will have a deep understanding of how you can manage, manipulate and present your data using this powerful spreadsheet software from Microsoft. Working files are included, allowing you to follow along with the author throughout the lessons.

Unlimited Online Access

The O’Reilly Learning Library is now part of Safari

Broad, deep, and trustworthy information—everything from the Learning Library plus much more. 40,000 books, videos, and tutorials from 200+ pro publishers.

Try it Free
  • Learn the way you like to—video, audio, books, tutorials, lessons
  • Available anytime, anywhere—mobile, desktop, even offline
  • Find the exact information you need to solve a problem on the fly, or learn something new from the ground up.

100% Money Back Guarantee

Complete Customer Satisfaction is our goal. All O'Reilly Training DVDs come with a 100% money back guarantee. If you are not happy with your Training DVD just contact our sales department within 30 days of purchase for a refund. View our full terms and conditions