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
• 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
• 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
• Alignment: Top, Bottom, Wrap Text
• Insert Rows
• Delete Rows
• Inserting and Deleting Columns
• 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
• Sorting 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

Self-Study

### Course Status:

Active

1 - 4 hours / week

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

Related Posts: