Learning Microsoft Excel 2011 for the Mac - Video Training DVDTraining DVD for Excel 2011In 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 the 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.
Click
Tutorials for Computer Software to go back a level
Learning Microsoft Excel 2011 for the Mac - Video Training DVD
SUMMARY OF CONTENTS
For Full contents list, please click PDF button above.
01. Getting Started
02. Recording And Monitoring Sales Data
03. Using Excel For A Profit And Loss
04. Score Sheets For School Sports Day
05. Expenses Claim Form
06. Sales Contacts Management
07. Stock Sales Summaries
08. Next Steps
Publisher: Infinite Skills
Author: Guy Vaccaro
Media Type: Video DVD ROM
Run Time: 4.5 hours
Language: English
Level: Beginner
System Requirements
Mac: OS X 10.2 or higher
PC: Win 7/Vista/XP/2000
CD/DVD ROM
1024 x 768 Monitor Resolution
Not for use on a set top box - only works on a computer!
Delivery Options selectable at the CheckoutUK- Only 99p Standard UK Delivery (plus vat where applicable)
- Optional services including UK Next Working Day Delivery
For all UK delivery options including UK Next working day, please see our
Delivery Information PageInternationalRoyal Mail Registered Airmail or FedEx Courier options available.
For all International delivery options and price guide, please see our
Delivery Information PageInternational customers may also find our
Ordering for Overseas Customers Information Page helpful.