In this project-based Advanced Microsoft Excel 2013 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 Advanced Microsoft Excel 2013 tutorial, online or offline... so you'll know the exact steps for your own projects.
In this advanced training course for Microsoft Excel 2013, expert author Guy Vaccaro takes you beyond the basics of Excel, and teaches you how to use the advanced features and functions in this spreadsheet program from Microsoft.
You will start with basic operations such as SUM, MIN, and MAX, as well as conditional mathematical functions. Guy proceeds to instruct you on using IF statements to control conditions. You will learn how to perform data lookups using VLOOKUP and HLOOKUP, and how to create Sparklines. Other features that are covered in this advanced Excel tutorial are; working with time, outlining, custom views, text manipulation, error checking, pivot tables and pivot charts. Guy also covers some basic Macro operations within Excel for optimizing your workflow.
By the completion of this computer based training video for Microsoft Excel 2013, you will be comfortable with many of the advanced features and functions that this powerful spreadsheet software from Microsoft has to offer. Working files are included, allowing you to follow along with the author throughout the lessons.
Not sure which video training course to purchase? Join our Online Learning Library and have unlimited access to all our content 24/7 for only $25.00 per month.
O'Reilly offer a variety of solutions to provide training across your organisation.
The O'Reilly Multi-User training solutions can accommodate educational and corporate/government organizations of all sizes. It’s built to be a self-contained learning platform, but can also be easily integrated into an existing LCMS if required. Simply put it’s an highly affordable training platform that can be customised to meet your exact requirements no matter how many people you need to provide training to. select your organization type below to find out more.
OVER 18 hours of Microsoft Excel 2013 Training Videos - ONLY $149.95 Purchase the bundle and save. The bundle contains both the Beginners and the Advanced Training videos, the only difference is the price!
An affordable way to train multiple users
This course is also available in multi-user format which is ideal for corporate users, schools and universities. The multi-user training loads directly onto your own server and delivers training to multiple users over your own network. More info...
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