Your Career
Training Marketplace

Questions? Call Toll-Free: 1-866-540-9677

Virtual Live Remote Training
Course ID: 252405

e-Learning Bundle

Microsoft Office: Beginning Excel for Mac 2011 Part 2

When you register for training with, you are also supporting local education. Find out how.

  • Instant Access
    From Anywhere
  • Unlimited
  • 6-12 Months
    To Complete


Formulas are the building blocks of data calculation in Excel for Mac 2011. Being able to use formulas to perform everything from easy to complicated calculations not only simplifies your work but also helps to reduce the number of errors that can arise in such complex tasks. This course introduces formulas, demonstrates how to create and edit them, copy and paste them, and how to check for errors that can arise when using formulas in Excel for Mac 2011.
  • identify elements of a formula
  • recognize how Excel calculates precedence in a formula
  • recognize examples of reference types used in Excel formulas
  • create and insert formulas
  • create a name and use in a formula
  • edit formulas
  • correct common error values
  • create a formula
  • correct and edit a formula
  • use a name in a formula
  • copy and paste a formula between cells
One of the great features of Excel for Mac 2011 is its ability to perform a wide variety of functions to make your use of Excel easier. Functions are built-in formulas that save you time by allowing you to choose one that suits your needs rather than creating a complex formula from scratch. This course introduces you to the components of functions, and how and when to use a particular function in the most efficient and practical way.
  • identify Excel's built-in functions
  • enter functions in worksheets
  • use financial functions
  • use date and time functions
  • create logical functions
  • use an AutoSum function to perform a basic calculation
  • use a financial function to calculate the depreciation of asset
  • use a logical function
Charts make data easier to understand by providing a clear diagrammatic representation of your information. By using Excel for Mac 2011's strong charting capabilities, you can create attractive and organized representations of worksheet and workbook data, and you can easily insert and customize charts to suit your needs. This course demonstrates how to effectively insert and edit charts in Excel 2011. It explores the abundance of available chart types such as column, pie, and bar charts, and the best use of each type. The course also shows how to modify the layout and format of charts.
  • recognize when to use different Excel charts
  • show data trends with sparklines
  • insert a chart
  • identify the elements of an Excel chart
  • update an existing Excel chart's style, layout, or location
  • change a chart's source data
  • insert a chart
  • update a chart's type, layout, and style
  • update a chart's source data
Excel for Mac 2011 makes it easy for you to save, print, and share workbooks and worksheets. When you create an Excel workbook, you will most likely want to save it for future use, and in many instances, print it to save a hard copy or share with someone else. This course describes these Excel features and explains how to use them to increase your efficiency and productivity, including sharing your workbooks with colleagues using SkyDrive and SharePoint.
  • save a workbook in a different format
  • change the default save settings
  • share and send a workbook
  • preparing a workbook for printing
  • print a workbook
  • save a workbook
  • share a workbook
  • preview and print a workbook
  • modify default save settings

Join The 50,000+ Companies That Have Purchased Training from

  • 50K+ Companies Trained

    Including 90% Of Fortune 500 Companies Have Purchased Training With

  • 300K+ Courses & Videos

    Live Instructor-Led (Classroom & Virtual), Self-Paced E-learning & Custom OnSite Training Solutions From Leading Training Providers

  • 800+ Expert Instructors

    Industry-Leading Subject Matter Experts (SMEs).Tenured &
    Award-Winning Instructor Network

Get the latest industry news, recommended courses, & promotions from sent straight to your inbox.