| |
|
Quicktime is required for the movies,
click here to download if needed.
|
 |
Please Note: The online FREE lessons have been compressed for faster downloads. Purchased CD ROMs/DVDs load almost instantly and have higher sound and video quality.
Please allow a few seconds for the FREE online tutorials to load. If you have any difficulties downloading these FREE online tutorials. Please do not hesitate to contact us for download help. |
|
- See right for full details on these Microsoft Excel 2011 for Mac Tutorial videos
- See far right to purchase this Microsoft Excel 2011 for Mac Training CD/DVD
- Take your skills and knowledge of this industry standard spreadsheet application to new levels with the help of these practical video training movies |
|
Microsoft Excel 2011 for Mac Tutorial
SPECIAL OFFER: 50% DISCOUNT & FREE SHIPPING!
|
 |
 Professionally created, self-study video training.
About this Tutorialshow detailsLearn the how to use and how to fully utilize the powerful features of this powerful spreadsheet program with the help of these Microsoft Excel 2011 for Mac tutorial videos. Commencing from the basics, expert MS Office tutor Guy Vaccaro uses step-by-step video training movies to help explain and demonstrate the important features and functions of Microsoft Excel 2011 helping you to use this application to a confident and proficient standard.
In over four hours of professionally created tutorials, the video tuition includes a tour of the new interface, creating your spreadsheet, lessons on formulas, profit and loss, how to create charts and tables, formatting text, creating a mail merge in Excel 2011 and so much more. The training is taught using practical project based examples and the work files are also included so you can work on the same material as the trainer. You can start learning right away, click any blue linked lesson below to sample the FREE Excel 2011 video tutorials and discover just how effective this course is!
|
|
| Learn this Software - See below for FREE TUTORIALS |
|
|
FREE Shipping on ALL Orders
|
| |
CD CONTENTS & FREE VIDEO TUTORIALS
Click on any linked lesson below for a
Purchased CD tutorials load almost instantly and have higher sound & video quality. For tutorial support see left
FREE Sample Videos from this Course
 Creating A New Excel File To Record Data
Renaming Sheets And Printing
Creating The Other Eleven Months
Exporting To PDF And Emailing To The Accountant
A Near Match Lookup For The Event Scores
Data Entering The Actual Results
Adding Up The Scores And Ranking For Position
Adding The First Month
Adding A Summary Sheet
We hope you enjoyed the FREE lessons. To view the complete contents, including ALL the lessons below & above, please purchase the course via CD or Download
Getting Started
How Time Saving Are These Excel Projects?
Making Use Of The Project Working Files
About The Excel Tutor
An Introduction To Math In Excel
Recording And Monitoring Sales Data
Creating A New Excel File To Record Data
Saving Your Workbook In The Correct Format
Improve Your Worksheet With Some Formatting
Adding Formulas To Total Rows And Columns
Adding Formulas The Quick Way
Working Out Our Average Consumption
Conditional Formatting To Improve Presentation
Renaming Sheets And Printing
Using Excel For A Profit And Loss
Creating The Data Collection Sheet
Setting Up A List Using A Named Range
Adding Formula To Create January Profit And Loss
Changing The Data Entry To A Single Sheet
Creating The Other Eleven Months
Using D Referencing To Generate The Whole Years Profit And Loss
Exporting To PDF And Emailing To The Accountant
Score Sheets For School Sports Day
Setting Up The Scoresheet Structure
Looking Up The Competitor Name
A Near Match Lookup For The Event Scores
Using Sheet Replication To Create The Other Event Sheets
Adding Protection To Protect Your Formula
Data Entering The Actual Results
Completing The Competitor Summary
Creating An Error Check For Events Competed
Adding Up The Scores And Ranking For Position
Expenses Claim Form
Expenses Claim Document Setup And Header Page
Adding The First Month
Displaying The Month Name Instead Of The Number
Creating Destination Lookups For January
Protecting January And Setting Print Options
Creating The Other Eleven Months
Adding A Summary Sheet
Using And Submitting Your Expenses Claim
Sales Contacts Management
Setting Up Excel To Store Data And Entering That Data
Creating A Unique ID And Freezing Titles
Calculating New Values Using String Manipulation
Sorting Your Excel Database
Filtering Your Dataset
Removing Duplicate Records From Your Dataset
Mail Merge Using Your Dataset
Form View In Excel
Summarizing The Dataset With Pie Charts
Stock Sales Summaries
Starting The Sales Data Record Sheet
Adding A Sales Chart To The Data
Replicate Sheets To Create Other Sales Regions
Summarizing The Sales Data
Importing CSV Format Sales Data
Adding Some Calculations To The Imported Data
Interrogating The Sales Data With A Pivot Table
Formatting The Pivot Table
Sorting And Filtering The Pivot Table
Next Steps
Reviewing Absolute And Relative Formulas
What Is The SkyDrive?
Saving An Excel File To SkyDrive
Informing Others That The SkyDrive Document Is There
MS Excel 2011 Summary
What Is Next? |
  |
|
|
|
 |
|
|
IN STOCK
US & Canada