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
    23/11/2017
    London
    23/11/2017
    Birmingham
    27/11/2017
    London
    28/11/2017
    London
    28/11/2017
    Birmingham
    04/12/2017
    Birmingham
    04/12/2017
    London
    08/12/2017
    London
    08/12/2017
    Glasgow
    13/12/2017
    Glasgow
    13/12/2017
    London
    14/12/2017
    London
    22/12/2017
    London
    05/01/2018
    London
    05/01/2018
    Leeds
    08/01/2018
    London
    15/01/2018
    London
    22/01/2018
    London
    22/01/2018
    London
    24/01/2018
    London
    02/02/2018
    London
    09/02/2018
    London
    09/02/2018
    Birmingham
    12/02/2018
    Birmingham
    12/02/2018
    London
    12/02/2018
    London
    19/02/2018
    London
    19/02/2018
    Glasgow
    05/03/2018
    London
    05/03/2018
    London
    05/03/2018
    Leeds
    08/03/2018
    London
    12/03/2018
    London
    23/03/2018
    London
    23/03/2018
    Leeds
    06/04/2018
    Birmingham
    09/04/2018
    Birmingham
    09/04/2018
    Edinburgh
    09/04/2018
    London
    09/04/2018
    London
    09/04/2018
    London
    16/04/2018
    London
    23/04/2018
    London
    23/04/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: