Learning Microsoft Excel 2011 (Mac) Training Video

Course

Online

£ 98.92 + VAT

*Indicative price

Original amount in AUD:

$ 189

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

Learning Microsoft Excel 2011 (Mac) Training Video A Practical Excel Training Course That Teaches Real World Skills 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 Learning Microsoft Excel 2011 (Mac) Training Video course to get: Concise, informative and broadcast-quality Microsoft Excel 2011 (Mac)  training videos delivered to your desktop The ability to learn at your own pace with our intuitive, easy-to-use interface A quick grasp of even the most complex Microsoft Excel 2011 (Mac)  subjects because they're broken into simple, easy to follow tutorial videos 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. Course Fast Facts: Only 4.5 hours to complete this course 59 tutorial videos Expert instructors lead each course Download to any Windows PC or Mac and save for viewing off line Course is accessible 24/7 from any computer once downloaded You can study from home or at work at your own pace in your own time Course Description In this Learning Microsoft Excel 2011 (Mac) Training Video, 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...

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

System Requirements - Digital Download Digital Download: Microsoft Windows XP or higher, Mac OS X 10.4 or higher. Minimum screen resolution of 1024x768 Digital Download specific requirements: Between 1GB and 6GB of available hard drive space (depending on the training course) An Internet connection with sufficient bandwidth. You must have at least a 56K modem connection (Broadband recommended). Most modern ADSL and Cable internet solutions will be sufficient. Do I need...

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Excel
  • Microsoft Excel
  • Spreadsheet
  • Sales
  • Project
  • Microsoft excel training
  • MS Excel
  • Mac
  • Skills and Training
  • Sales Training

Course programme

01. 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. 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. 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. 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. 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. 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. 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. 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?

Additional information

Digital Download FAQs

Q: What is a digital download?

A digital download is training that you download from the internet using your web browser instead of us shipping you a physical CD.

Q: How instant is the "Instant Purchase"?

If you complete your purchase, you are emailed your access key within minutes of the transaction completing.

Q: How do I access my digital download purchase?

Once you complete your purchase, you will receive an email with an Access Key, and instructions on how to download your purchase. You will enter that Access Key...

Learning Microsoft Excel 2011 (Mac) Training Video

£ 98.92 + VAT

*Indicative price

Original amount in AUD:

$ 189