Skip to Main Content

Microsoft Excel and Accessible Excel Documents  (MSXL101)

Time: 9am - 4pm
Duration: 1 day

Compatible with 2007, 2010, 2013

Description:

In this course you will learn how to: Explore the Excel interface; Enter data; Create formulas and functions; Format cells; Adjust worksheet layout and data; Print worksheets; Create charts; Adjust worksheet views; Work with multiple worksheets and workbooks; Add accessibility features and test for accessibility compliance.

Prerequisites:

None

This course is currently available in another city, on demand or for private classes only. Call us at 888.484.2933 to learn more about our flexible scheduling options or complete our Information Request Form and we will contact you to arrange a class date that is suitable to your availability.

Course Outline

  • Explore the Excel interface
    • Use the menu system
    • Use the Quick Access Toolbar
    • Review structure of a worksheet or workbook
    • Use the Formula bar
    • Use the Status bar
    • Create new files
  • Enter data
    • Explore data entry and edit techniques
    • Enter data with AutoFill
    • Work with dates and times
    • Add comments
    • Use Save or Save As
  • Create formulas and functions
    • Create simple formulas
    • Copy a formula for adjacent cells
    • Create a percentage-increase formula
    • Work with relative, absolute, and mixed references
    • Use common functions
  • Format cells
    • Explore font styles and effects
    • Adjust row heights and column widths
    • Work with alignment and Wrap Text
    • Design borders
    • Format numbers and dates
    • Use named styles
  • Apply conditional formatting
    • Adjust Worksheet Layout and Data
    • Insert and delete rows and columns
    • Hide and unhide rows and columns
    • Move, copy, and insert data
    • Find and replace data
    • Use cell addressing
  • Print worksheets
    • Use the Page Layout tab and view
    • Preview page breaks
    • Work with Page Setup and print controls
  • Create charts
    • Explore chart types
    • Format charts with colour, shape and texture fills
    • Work with axes, labels, gridlines, and other chart elements
    • Apply alternative text to a chart
    • Create in-cell charts with sparklines
  • Adjust worksheet views
    • Freeze and unfreeze panes
    • Split screens horizontally and vertically
    • Show necessary information with the Outlining feature
  • Work with multiple worksheets and workbooks
    • Display multiple worksheets and workbooks
    • Rename, insert, and delete sheets
    • Move, copy, and group sheets
    • Use formulas to link worksheets and workbooks
    • Locate and maintain links
  • Add accessibility features
    • Add document title
    • Set the language
    • Provide navigational instructions
    • Use the Accessibility Checker
    • Enable accessibility features for export

Private training is available for this course.

Call us at 1-888-484-2933 to learn more about our flexible scheduling options or complete our Information Request Form.

© 2018 Eliquo, Inc. All rights reserved.

Back to Top