Excel 2010 Level 1

1 Day Course
Hands On
Code DEX10L1

This course has been retired. Please view currently available User Microsoft Office Training Courses.

Modules

Collapse all

Creating a Basic Excel Worksheet (5 topics)

  • Identify the Elements of the User Interface
  • Customize the Excel Interface
  • Work with Cells
  • Enter Data in an Excel Workbook
  • Obtain Help in Excel

Performing Calculations in an Excel Worksheet (3 topics)

  • Create Basic Formulas
  • Calculate the Cell Values by Using Functions
  • Copy Formulas and Functions

Modifying an Excel Worksheet (4 topics)

  • Manipulate Data
  • Modify the Worksheet Elements
  • Search for Data in a Worksheet
  • Modify Rows and Columns

Formatting an Excel Worksheet (6 topics)

  • Modify Fonts
  • Check a Worksheet for Spelling Errors
  • Apply Number Formatting
  • Add Borders and Colors to Cells
  • Align the Content in a Cell
  • Apply Cell Styles

Printing Excel Workbooks (3 topics)

  • Set the Page Layout Options
  • Set Page Breaks
  • Print a Workbook

Managing an Excel Workbook (3 topics)

  • Format Worksheet Tabs
  • Manage Worksheets
  • View Worksheets and Workbooks

Prerequisites

Delegates should be able to: * Use a mouse * Type and use a keyboard * Navigate through Windows files and folders * Work with Windows – minimise, maximise, open and close

Course PDF

Print

Sections