In this project-based Learning Microsoft Excel 2011 (Mac) 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 Microsoft Excel 2011 (Mac) tutorial, online or offline... so you'll know the exact steps for your own projects.
In this video tutorial for Microsoft Excel 2011 For Mac, expert author Guy Vaccaro teaches you to effectively utilize the features and functions of Excel through project based learning. You will complete various projects, and along they way learn to leverage the power of the most important features Excel 2011 has to offer the Mac user.
Starting your training course with the creation of a spreadsheet to record and monitor sales data, you will learn the basics of what you can do with a spreadsheet. You will then move on to creating a Profit and Loss report, learning formulas along the way. Moving to score sheets for a sports day, you will discover conditional based formatting, lookups, and more. You then create a functional expense claim form, advancing your Excel expertise. Moving on to a sales contact management sheet, you will discover how you can manipulate text, and even create mail merges from Excel. Finally, you will utilize all your knowledge thus far to create a sales report, including charts, pivot tables, and importing data.
By the conclusion of this Excel 2011 For Mac video training course, you will fully understand the capabilities of this powerful program. Not only will you understand the concepts, but how to properly apply them for your own spreadsheet needs. This training tutorial comes complete with working files, so you can use the exact same files that the author does as he proceeds through the course.
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