From the Grovo Library Learn How To Use Microsoft Office 2011 for Mac

Play

Conquer all of the functionalities of your online office. All of your Microsfot Office 2011 for Mac questions answered, in one-minute videos.

Course details

71 Lessons, 71 Quizzes

Tags: Advanced Organization, Collaborate and Manage Projects, Make and Share Presentations, Work & Productivity

Analyze Data with Pivot Tables in Office for Mac 2011

Properly structure your data, create a pivot table, then use your data as rows, columns, values, and filters.

  • Structure Data for a Pivot Table
  • Create a Pivot Table
  • Rows, Columns, and Values
  • Filter a Pivot Table
  • Choosing Functions
  • Group Items

Calculate Formulas in Excel for Mac 2011

Understand basic formula concepts, then apply commonly used formulas like VLOOKUP, FIND, INDEX, and MATCH.

  • Vlookup
  • Hlookup
  • Using the IF and AND Functions
  • Use the FIND Function
  • Look Up Values Using INDEX and MATCH
  • Combine Values from Multiple Cells
  • Calculate Values Using Basic Arithmetic
  • Perform Logical Tests with AND and OR
  • Use MIN and MAX
  • Use SUM, SUMIF, and SUMIFS
  • Count the Instances of a Value

Present with PowerPoint in Office for Mac 2011

Build custom-themed presentations, animate slides, and present your finished product.

  • Create a Presentation
  • Create Slides
  • Organize Slides
  • Duplicate Slides
  • Add Text Boxes
  • Add Shapes
  • Draw Lines
  • Insert Images
  • Arrange Objects

Manage Excel Spreadsheets in Office for Mac 2011

Format cell text and numerical data, adjust page margins and orientation, and add headers, footers, and page numbers.

  • Move and Edit Cells
  • Merge Cells
  • Format Text Appearance
  • Format Numbers
  • Automatically Format Cells Based on Content
  • Add Borders to Cells
  • Use the Format Paintbrush
  • Resize Columns and Rows
  • Add or Remove Columns and Rows
  • Lock Rows and Columns
  • Create a Chart or Graph
  • Find and Replace Items
  • Add and Manage Additional Sheets
  • Use Auto Fill
  • Adjust Page Margins and Orientation
  • Filter Data
  • Show or Hide Print Titles and Gridlines

What-if Analysis in Excel for Mac 2011

Explore how changes to a formula will affect its outcome, as well as work backwards from a formula’s outcome, and change an aspect to arrive at the correct solution.

  • Create a Data Table with One Variable
  • Create a Data Table with Multiple Variables
  • Find the Value That Completes an Equation
  • Compare Data Scenarios

Create Text Documents in Word for Mac 2011

Create a document and add formatted text, then use advanced tools like a table of contents, headers, and equations.

  • Create A New Document
  • Add Bookmarks
  • Add Headers and Footers
  • Add Page Numbers
  • Add Tables
  • Change a Table's Layout
  • Add a List
  • Change Page Setup
  • Change Line Spacing
  • Change Paragraph Indents
  • Change the Default Styles
  • Format Text
  • Insert Footnotes
  • Insert Images
  • Format Images
  • Crop and Rotate Images
  • Spell Check a Document
  • Turn on Track Changes
  • Review and Accept Changes
  • Copy and Paste from the Scrapbook
  • Find and Replace Text
  • Save Your Document
  • Change Your Document View
  • Paste Special

Learn how to use Microsoft Office 2011 for Mac

Microsoft Office 2011 for Mac is a version of the Microsoft Office productivity suite. The suite includes the most recent version of Microsoft’s instant messaging service, Lync. Learn how to effectively navigate the suite to save hours of productivity.

In these lessons, you’ll learn how to:

  • Create Text Documents in Word for Mac 2011
  • Calculate Formulas in Excel for Mac 2011
  • Manage Excel Spreadsheets in Office for Mac 2011
  • Analyze Data with Pivot Tables in Office for Mac 2011
  • Present with PowerPoint in Office for Mac 2011
  • What-if Analysis in Excel for Mac 2011

Microsoft Office 2011 for Mac Training & Development Courses

Grovo gives you the content, technology, and service you need to get your team up to speed with the necessary skills for Microsoft Office 2011 for Mac. Our learning ecosystem will help your team develop the techniques to advance within your organization as an expert with navigating your online office. Watch, learn, and test your team’s knowledge with Grovo to make the best of Microsoft Office 2011 for Mac.

Advanced Analytics & Reporting
Our integrated reporting system will ensure your team is constantly developing the essential skills necessary to ensure you're collaborting online effectively. Training through quick 1-minute videos ensures individuals on your team are developing the skills they need to fully utilizing Microsoft Office 2011 for Mac. Our reporting system provides:

  • A flexible reporting interface
  • Overview of your team's performance
  • Report cards and detailed spreadsheet reports
  • Customizable email reports

More learning. Less management.

Grovo makes it easy to create, deliver, and measure training learners love.

Learn about the Grovo Platform

Ready to inspire your organization with better learning?

Simply fill out the form and a learning consultant will be in touch right away.