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:
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.
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.
Broad, deep, and trustworthy information—everything from the Learning Library plus much more. 40,000 books, videos, and tutorials from 200+ pro publishers.
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