Microsoft Excel for Mac 2011: Applying Basic Data Formatting


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description
Excel 2011 provides a number of tools and features that allow you to visually enhance the appearance of worksheets and workbooks. Data and cells can be manipulated and customized using various alignment and formatting features. This course explores the processing of formatting cells and text, using basic formatting options such as bold and underline, and tools such as the Format Painter. The course also shows you how to align text in a worksheet and how to set certain conditions, that when met, change the appearance of the data – for example you can format data to quickly see the top 10 values in a range. This course also explains the various options for number formatting in Excel for Mac 2011.

Target Audience
Any individuals and business users with basic Mac computer literacy.

Prerequisites
None

Expected Duration (hours)
1.0

Lesson Objectives

Microsoft Excel for Mac 2011: Applying Basic Data Formatting

  • apply basic text formatting
  • apply and copy cell formatting
  • align text within cells
  • apply number formats
  • apply basic conditional formatting
  • format text and cells
  • format cells that meet a specified condition
  • apply number formats to worksheet data
  • Course Number:
    om_bemc_a02_dt_enus

    Expertise Level
    Beginner