Microsoft Excel Level 1 (Beginner)
Course Objectives

1. Create a basic worksheet by using Microsoft Excel.
2. Perform calculations in an Excel worksheet.
3. Modify an Excel worksheet.
4. Modify the appearance of data within a worksheet.
5. Manage Excel workbooks.
6. Print the content of an Excel worksheet.
Lesson 1

  • Getting Started with Excel
  • Identify the elements of the Excel interface.
  • Navigate and select cells in worksheets.
  • Customize the Excel interface.
  • Create a basic worksheet

Lesson 2

  • Performing Calculations in an Excel Worksheet
  • Create formulas in a worksheet.
  • Insert functions in a worksheet.
  • Reuse formulas.

Lesson 3

  • Modifying a Worksheet
  • Edit worksheet data.
  • Find and replace data.
  • Manipulate worksheet elements.

Lesson 4

  • Modifying the Appearance of a Worksheet
  • Apply font properties.
  • Add borders and colors to cells.
  • Align content in a cell.
  • Apply number formatting.
  • Apply cell styles.

Lesson 5

  • Managing an Excel Workbook
  • Manage worksheets.
  • View worksheets and workbooks.

Lesson 6

  • Printing Excel Workbooks
  • Define the page layout.
  • Print a workbook.