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

Master Excel 2011 for the Mac

Course Summary

Learn the basics of Microsoft Excel 2011 for the Mac in step-by-step videos that build simple spreadsheets!

  • +

    Course Syllabus

    • Basic Spreadsheets and Introduction
      • Introduction
      • Creating an Excel for Mac Spreadsheet
      • Basic Spreadsheet with Chart
    • Charts and Formulas
      • Pie Charts
      • Formulas in Excel for Mac
      • Line Charts and Standard Deviation
      • Built-In Functions
      • More on Formulas
      • Math Formulas
      • Named Formulas
      • The Count Function
    • Tables and Cells
      • Creating Tables
      • Tables Part 2
      • Cell Ranges
      • Cell Locking
      • Cell Locking Part 2
    • Importing Data
      • Importing Text Files
      • Importing Comma Delimited Files
    • Rows, Sorting and Grouping
      • Sorting Horizontally
      • Grouping Data and Subtotals
      • Copying Rows
    • Conditionals
      • IF Statements in Excel
      • Date/Time and Conditional Formatting
    • Pivot Tables and Lookup
      • Pivot Tables
      • VLookup and Popup Lists
      • HLookup

Course Fee:
USD 49

Course Type:


Course Status:



1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Related Posts:

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