Font size:

Description:

This is a bundled training package. It contains training for each of the bundled items below:

Course Price
Microsoft Excel for Mac 2011: Using Basic Formulas $74.95
Microsoft Excel for Mac 2011: Using Basic Functions $74.95
Microsoft Excel for Mac 2011: Inserting Basic Charts $74.95
Microsoft Excel for Mac 2011: Saving, Sending, and Printing Workbooks $74.95

Bundle Price: $169.00
Total Savings: $130.80


Microsoft Excel for Mac 2011: Using Basic Formulas

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

Microsoft Excel for Mac 2011: Using Basic Functions

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

Microsoft Excel for Mac 2011: Inserting Basic Charts

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

Microsoft Excel for Mac 2011: Saving, Sending, and Printing Workbooks

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
Register Now
Microsoft Office: Beginning Excel for Mac 2011 Part 2 e-learning bundle
  • Course ID:
    252405
  • Duration:
    4 hours
  • Price:
    $169