Questions? Feedback? powered by Olark live chat software

Excel 2011 (Macintosh) Combo Training Courses

About the Excel 2011 (Macintosh) Combo

Duration: 2 days (16 hours)

Get trained in Microsoft Office Excel 2011 and gain the skills needed to express your ideas, solve problems, and connect with people. This course will go over foundational topics and build upon those to learn more intermediate and advanced skills needed to become a true professional in Excel 2011.

Next Class Dates

Contact us to customize this class with your own dates, times and location. You can also call 1-888-563-8266 or chat live with a Learning Consultant.

Back to Top

This training consists of the following courses:

Excel 2011: Level 1 (Macintosh)   More on this course

1 day | 8 hours

arrow Course Objectives

  • » create a basic worksheet by using Microsoft Excel 2011.
  • » perform calculations in an Excel worksheet.
  • » modify an Excel worksheet.
  • » modify the appearance of data within a worksheet.
  • » manage Excel workbooks.
  • » print the content of an Excel worksheet.

Back to Top

arrow Course Outline

  • Lesson 1: Getting Started with Excel
    1. Topic 1A: Identify the Elements of the Excel Interface
    2. Topic 1B: Navigate and Select Cells in Worksheets
    3. Topic 1C: Customize the Excel Interface
    4. Topic 1D: Create a Basic Worksheet
  • Lesson 2: Performing Calculations in an Excel Worksheet
    1. Topic 2A: Create Formulas in a Worksheet
    2. Topic 2B: Insert Functions in a Worksheet
    3. Topic 2C: Reuse Formulas
  • Lesson 3: Modifying a Worksheet
    1. Topic 3A: Edit Worksheet Data
    2. Topic 3B: Find and Replace Data
    3. Topic 3C: Manipulate Worksheet Elements
  • Lesson 4: Modifying the Appearance of a Worksheet
    1. Topic 4A: Apply Font Properties
    2. Topic 4B: Add Borders and Colors to Cells
    3. Topic 4C: Align Content in a Cell
    4. Topic 4D: Apply Number Formatting
    5. Topic 4E: Apply Cell Styles
  • Lesson 5: Managing an Excel Workbook
    1. Topic 5A: Manage Worksheets
    2. Topic 5B: View Worksheets and Workbooks
  • Lesson 6: Printing Excel Workbooks
    1. Topic 6A: Define the Page Layout
    2. Topic 6B: Print a Workbook

Back to Top

Excel 2011: Level 2 (Macintosh)   More on this course

1 day | 8 hours

arrow Course Objectives

  • » Create advanced formulas.
  • » Analyze data with logical and lookup functions.
  • » Organize worksheet data with tables.
  • » Visualize data by using charts.
  • » Analyzing data with PivotTables, slicers, and PivotCharts.
  • » Insert graphic objects.
  • » Enhance workbooks.

Back to Top

arrow Course Outline

  • Lesson 1: Calculating Data with Advanced Formulas
    1. Topic 1A: Apply Cell and Range Names
    2. Topic 1B: Calculate Data Across Worksheets
    3. Topic 1C: Use Specialized Functions
    4. Topic 1D: Analyze Data with Logical and Lookup Functions
  • Lesson 2: Organizing Worksheet and Table Data
    1. Topic 2A: Create and Modify Tables
    2. Topic 2B: Format Tables
    3. Topic 2C: Sort or Filter Data
    4. Topic 2D: Use Functions to Calculate Data
    5. Topic 2E: Create a PivotTable Report
  • Lesson 3: Presenting Data Using Charts
    1. Topic 3A: Create a Chart
    2. Topic 3B: Modify Charts
    3. Topic 3C: Format Charts
  • Lesson 4: Inserting Graphic Objects
    1. Topic 4A: Insert and Modify Pictures and Clip Art
    2. Topic 4B: Draw and Modify Shapes
    3. Topic 4C: Illustrate Workflow Using SmartArt Graphics
    4. Topic 4D: Layer and Group Graphic Objects
  • Lesson 5: Customizing and Enhancing the Excel Environment
    1. Topic 5A: Customize the Excel Environment
    2. Topic 5B: Customize Workbooks
    3. Topic 5C: Manage Themes
    4. Topic 5D: Create and Use Templates

Back to Top

Recent Client Testimonials & Reviews

The instructor is very knowledgeable on the material. She was very fun and friendly. Kept me engaged.

- Jeanette S.

Course(s) Taken

» Excel 2016 Combo

The instructor was great and very knowledgeable. Great class!

- Amanda D.

Course(s) Taken

» Excel 2016 Combo

I really enjoyed the class. The instructor did a great job.

- Lisa M.

Course(s) Taken

» Excel 2016 Combo

  More testimonials »  

Back to Top