Excel 2011 for Mac Video Tutorial Course

CareerVision Training

£ 46 - (Rs 3,975)
VAT incl.

Important information

  • Training
  • Beginner
  • Distance learning
  • Duration:
  • When:
  • Delivery of study materials


• Format: DVD or Instant Download
• Duration: 4.5 Hours (55 lessons)
• Instructor: Guy Vaccaro
• Platform: Windows PC or Mac


In this computer based training course, expert author Guy Vaccaro teaches you how to get the most out of PowerPoint 2011 for the Mac. Rather than sit through a tour of the interface however, Guy guides you through creating and presenting different PowerPoints presentations, and along the way you will learn to master this powerful program.

Starting with a simple presentation, you learn about planning your presentation to start. You then learn how to add, and customize slides slides with text and images, as well as basic animations. As the video tutorial continues, you will create a sales presentation, adding charts, transitions and slide notes.

Important information

Requirements: This is a DVD Video Tutorial Course which is shipped to you. Work through the video tutorials at your own pace. If you have the software you can practice along with the instructor using the same exercise files as the instructor which are included on the DVD. The narrated training videos demonstrate the key tools and professional techniques helping you to work faster and smarter. All the concepts of each application are explained clearly and precisely. The DVD works on PC and Mac. You can jump to and from lessons and work at your own pace.


Where and when

Starts Location
Distance Learning

What you'll learn on the course

Conditional Formatting
Charts and Graphs

Course programme

01. Microsoft Excel 2011 - Getting Started

0101 How Time Saving Are These Excel Projects?

0102 Making Use Of The Project Working Files

0103 About The Author

0104 An Introduction To Math In Excel

02. Microsoft Excel 2011 - Recording And Monitoring Sales Data

0201 Creating A New Excel File To Record Data

0202 Saving Your Workbook In The Correct Format

0203 Improve Your Worksheet With Some Formatting

0204 Adding Formulas To Total Rows And Columns

0205 Adding Formulas The Quick Way

0206 Working Out Our Average Consumption

0207 Conditional Formatting To Improve Presentation

0208 Renaming Sheets And Printing

03. Microsoft Excel 2011 - Using Excel For A Profit And Loss

0301 Creating The Data Collection Sheet

0302 Setting Up A List Using A Named Range

0303 Adding Formula To Create January Profit And Loss

0304 Changing The Data Entry To A Single Sheet

0305 Creating The Other Eleven Months

0306 Using 3D Referencing To Generate The Whole Years Profit And Loss

0307 Exporting To PDF And Emailing To The Accountant

04. Microsoft Excel 2011 - Score Sheets For School Sports Day

0401 Setting Up The Scoresheet Structure

0402 Looking Up The Competitor Name

0403 A Near Match Lookup For The Event Scores

0404 Using Sheet Replication To Create The Other Event Sheets

0405 Adding Protection To Protect Your Formula

0406 Data Entering The Actual Results

0407 Completing The Competitor Summary

0408 Creating An Error Check For Events Competed

0409 Adding Up The Scores And Ranking For Position

05. Microsoft Excel 2011 - Expenses Claim Form

0501 Expenses Claim Document Setup And Header Page

0502 Adding The First Month

0503 Displaying The Month Name Instead Of The Number

0504 Creating Destination Lookups For January

0505 Protecting January And Setting Print Options

0506 Creating The Other Eleven Months

0507 Adding A Summary Sheet

0508 Using And Submitting Your Expenses Claim

06. Microsoft Excel 2011 - Sales Contacts Management

0601 Setting Up Excel To Store Data And Entering That Data

0602 Creating A Unique ID And Freezing Titles

0603 Calculating New Values Using String Manipulation

0604 Sorting Your Excel Database

0605 Filtering Your Dataset

0606 Removing Duplicate Records From Your Dataset

0607 Mail Merge Using Your Dataset

0608 Form View In Excel

0609 Summarizing The Dataset With Pie Charts

07. Microsoft Excel 2011 - Stock Sales Summaries

0701 Starting The Sales Data Record Sheet

0702 Adding A Sales Chart To The Data

0703 Replicate Sheets To Create Other Sales Regions

0704 Summarizing The Sales Data

0705 Importing CSV Format Sales Data

0706 Adding Some Calculations To The Imported Data

0707 Interrogating The Sales Data With A Pivot Table

0708 Formatting The Pivot Table

0709 Sorting And Filtering The Pivot Table

08. Microsoft Excel 2011 - Next Steps

0801 Reviewing Absolute And Relative Formulas

0802 What Is The SkyDrive?

0803 Saving An Excel File To SkyDrive

0804 Informing Others That The SkyDrive Document Is There

0805 Excel 2011 Summary

0806 What Is Next?