fbpx

Excel Level 1 – Fundamentals

Learning Method: Take Excel Level 1 Online or In-Person. Duration: 1.00 Day


*Click here to view upcoming Excel 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

  •  Topic A: Navigate the Excel User Interface
  •  Topic B: Use Excel Commands
  •  Topic C: Create and Save a Basic Workbook
  •  Topic D: Enter Cell Data
  •  Topic E: Use Excel Help

Lesson 2: Performing Calculations

  •  Topic A: Create Worksheet Formulas
  •  Topic B: Insert Functions
  •  Topic C: Reuse Formulas and Functions

Lesson 3: Modifying a Worksheet

  •  Topic A: Insert, Delete, and Adjust Cells, Columns, and Rows
  •  Topic B: Search for and Replace Data

Lesson 4: Formatting a Worksheet

  •  Topic A: Apply Text Formats
  •  Topic B: Apply Number Formats
  •  Topic C: Align Cell Contents

Lesson 5: Printing Workbooks

  •  Topic A: Preview and Print a Workbook
  •  Topic B: Set Up the Page Layout
  •  Topic C: Configure Headers and Footers
  •  Topic D: Print Selection
  •  Topic E: Print Titles

Lesson 6: Managing Workbooks

  •  Topic A: Manage Worksheets
  •  Topic B: Manage Workbook and Worksheet Views

Lesson 7: Working with Lists

  •  Topic A: Sort Data
  •  Topic B: Filter Data
Site Loader
Facebook
YouTube
LinkedIn