Excel Level 1

Learning Method: Instructor-led Classroom Learning Duration: 1.00 Day


*Click here to view upcoming Excel Level 1 classes


Overview:

In this course, students create and edit basic Microsoft Office Excel worksheets and workbooks.

Who Should Attend:

This course is for people with knowledge of Microsoft  Windows®  who are interested in learning how to create, edit, format and print basic spreadsheets using Excel software.

At Course Completion:

Upon successful completion of this course, students will be able to: Explore the Microsoft Office Excel environment and create a basic worksheet. Perform calculations. Modify a worksheet. Format a worksheet. Print workbook contents. Manage large workbooks.

Course Outline:

Lesson 1: Getting Started with Microsoft Office Excel 2016

  • Navigate the Excel User Interface
  • Use Excel Commands
  • Create and Save Basic Workbook
  • Enter Cell Data
  • Use Excel Help

Lesson 2: Performing Calculations

  • Create Worksheet Formulas
  • Insert Functions
  • Reuse Formulas and Functions

Lesson 3: Modifying a Worksheet

  • Insert, Delete, and Adjust Cells, Columns, and Rows
  • Search for and Replace Data
  • Use Proofing and Research Tools

Lesson 4: Formatting a Worksheet

  • Apply Text Formats
  • Apply Number Formats
  • Align Cell Contents
  • Apply Styles and Themes
  • Apply Basic Conditional Formatting
  • Create and Use Templates

Lesson 5: Printing Workbooks

  • Preview and Print a Workbook
  • Set Up the Page Layout
  • Configure Headers and Footers

Lesson 6: Managing Workbooks

  • Manage Worksheets
  • Manage Workbook and Worksheet Views
  • Manage Workbook Properties
Site Loader