MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

Microsoft Excel 2011 for Mac Tutorial - Learn The Easy Way.

Course Summary

Learn Microsoft Excel 2011 for Mac at your own pace. Comes with Certificate of Completion

  • +

    Course Syllabus

    • Getting Started
      • Working Files - Download These First
      • How Time Saving Are These Excel Projects?
      • How to obtain your Certificate of Completion for this Infinite Skills course.
      • Making Use Of The Project Working Files
      • 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 3D 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
      • Excel 2011 Summary
      • What Is Next?

Course Fee:
USD 49

Course Type:


Course Status:



1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top