Microsoft Excel 2010 Level 1 - DEX10L1

In this course you will create and edit basic Microsoft Office Excel 2010 worksheets and workbooks.

Target Audience:

This course is designed for delegates who desire to gain the necessary skills to create, edit, format, and print basic Microsoft Office Excel 2010 worksheets.

Outline

Lesson 1: Getting Started with Excel

  • Topic 1A: Identify the Elements of the Excel Interface
  • Topic 1B: Navigate and Select Cells in Worksheets
  • Topic 1C: Customize the Excel Interface
  • Topic 1D: Create a Basic Worksheet

Lesson 2: Performing Calculations in an Excel Worksheet

  • Topic 2A: Create Formulas in a Worksheet
  • Topic 2B: Insert Functions in a Worksheet
  • Topic 2C: Reuse Formulas

Lesson 3: Modifying a Worksheet

  • Topic 3A: Edit Worksheet Data
  • Topic 3B: Find and Replace Data
  • Topic 3C: Manipulate Worksheet Elements

Lesson 4: Modifying the Appearance of a Worksheet

  • Topic 4A: Apply Font Properties
  • Topic 4B: Add Borders and Colors to Cells
  • Topic 4C: Align Content in a Cell
  • Topic 4D: Apply Number Formatting
  • Topic 4E: Apply Cell Styles

Lesson 5: Managing an Excel Workbook

  • Topic 5A: Manage Worksheets
  • Topic 5B: View Worksheets and Workbooks

Lesson 6: Printing Excel Workbooks

  • Topic 6A: Define the Page Layout
  • Topic 6B: Print a Workbook
  • £ 310

    Guide Price Per Delegate

  • Dates & Locations Available

  • London
    02/07/2018
    London
    02/07/2018
    Leeds
    12/07/2018
    Leeds
    12/07/2018
    London
    17/07/2018
    London
    17/07/2018
    Birmingham
    01/08/2018
    London
    06/08/2018
    London
    06/08/2018
    London
    22/08/2018
    London
    22/08/2018
    Leeds
    03/09/2018
    Leeds
    03/09/2018
    London
    07/09/2018
    Glasgow
    10/09/2018
    Glasgow
    14/09/2018
    London
    02/10/2018
    Birmingham
    04/10/2018
    Leeds
    05/11/2018
    London
    05/11/2018

Course Information

  • Use a mouse
  • Type and use a keyboard
  • Navigate through Windows files and folders
  • Work with Windows - minimise, maximise, open and close

At the end of this course you will be able to:

  • Create a basic worksheet by using Microsoft Office Excel 2010.
  • Perform calculations in an Excel worksheet.
  • Modify an Excel worksheet.
  • Format a worksheet.
  • Print the content of an Excel workbook.
  • Manage an Excel workbook.

Enquire about this course

Please leave this field blank: