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 for Mac 2011 - Beginning

Course Summary

Learn how to confidently create worksheets, use formatting, calculations, functions, analyze, filter, charts & tables.

  • +

    Course Syllabus

    • Course Introduction
      • Course Certificate
    • Excel Fundamentals
      • Launching Excel for Mac 2011
      • Adding Excel Icon to your Dock
      • Overview of the Excel Program Screen
      • Contextual Tabs
      • Navigating a Worksheet & Keyboard Tips
      • A Bit of Excel Terminology: Workbook vs Worksheet vs Spreadsheet vs File
      • Create, Open & Close a Workbook
    • Getting Started with Worksheets
      • Entering & Editing Labels and Values
      • Entering Data Automatically - Tip
      • Saving Your Workbook, Save vs Save as...
      • Selecting a Cell Range and Entering Data - Tip
      • Entering Data in a Cell Range - Tip 2
      • Entering Data: Labels vs Values (convert a number to text)
      • Entering and Formatting Dates
    • Getting Started with Formulas & Functions
      • Functions & Formulas Introduction. Sum Function.
      • Sum Function. Editing the Formula.
      • Sum Function. Copying the Formula.
      • Math Operators: Additions, Subtraction, Multiplication, Division
      • Formulas: Absolute vs. Relative Reference
      • Formula Ribbon
      • Formulas: Average, Min, Max
    • Editing a Worksheet
      • Moving and Copying Cell Contents
      • Copying Cell Contents to a New Sheet
      • Paste Menu Options
    • Formatting a Worksheet
      • Formatting Options
      • Format and Merge Cells
      • Why Format Options on Ribbon are Different
      • Number Formatting Overview
      • Number Formatting: Currency
      • Clear Formatting vs Clear Contents
      • Adjusting Column Widths
      • Adjusting Row Height
      • Alignment: Top, Bottom, Wrap Text
      • Insert Rows
      • Delete Rows
      • Inserting and Deleting Columns
      • Adding Cell Borders
      • Copy Formatting using Format Painter
      • Print & Print Preview
    • Working with Charts
      • Creating Charts
      • Printing Charts
      • Updating Data in Charts
      • Copying and Moving Charts
      • Copying Charts
      • 37Adding A Chart Series
    • Sorting Data
      • Download PB Travel Sales Report Training.xlsx File
      • Sorting Your Data
      • Sorting a Selected Range vs Automated Sorting
      • Sorting Outside of a Range
      • Sorting a selected Range
      • Sort by Multiple Criteria
    • Filtering Data
      • Filtering Data
      • Filter by Number
    • Introduction to Tables
      • Introduction To Tables (Tables vs Filtering)
      • Table Features
    • Working with Multiple Worksheets
      • Creating, Copying and Naming Worksheets
      • Moving and Navigating between Worksheets
      • Deleting Worksheets and Changing Tab Color
      • Printing Multiple Worksheets
    • Working with Images
      • Inserting and Formatting Images
    • Course Certificate
      • Course Certificate & Feedback

Course Fee:
USD 20

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