Course length:  1-day

 

Excel is Microsoft’s powerful and easy-to-use spreadsheet program, which provides you with an extensive set of tools to organize, analyze, present, and store data.

This course is intended to help all novice computer users get up to speed with Excel quickly. We will cover different features including creating a new spreadsheet, working with basic formulas and functions, making a spreadsheet look professional and presentable, and saving and printing a spreadsheet.

Prerequisites

To be successful in this course, you should be familiar with using personal computers and you should be VERY comfortable using and navigating with the mouse and keyboard. You should be experienced in the Windows environment. Specifically, you should be able to launch and close programs; navigate to information stored on the computer; and manage files and folders. Before attending this course, students must have:

  • Basic computer knowledge
  • Windows file management skills
  • Comfort using a mouse and keyboard

Course Outline

Lesson 1: Getting Started

  • Topic A: Getting to Know Excel
  • Topic B: Creating Workbooks
  • Topic C: Getting Help in Excel 365
  • Topic D: Working with Rows and Columns
  • Topic E: Sorting and Filtering Data

Lesson 2: Working with Data

  • Topic A: A Closer Look at Formulas
  • Topic B: Using Formulas and Functions
  • Topic C: Working with Data

Lesson 3: Modifying a Worksheet

  • Topic A: Formatting Text
  • Topic B: Formatting Cells
  • Topic C: Aligning Cell Content
  • Topic D: Search For and Replace Data
  • Topic E: Spell Check a Worksheet

Lesson 4:  Printing Workbook Contents

  • Topic A: Define the Basic Page Layout for a Workbook
  • Topic B: Refine the Page Layout and Apply Print Options

Lesson 5: Managing Large Workbooks

  • Topic A: Format Worksheet Tabs
  • Topic B: Manage Worksheets
  • Topic C: Manage the View of Worksheets and Workbooks

Lesson 6: Customizing the Excel Environment

  • Topic A: Customize General and Language Options
  • Topic B: Customize Formula Options
  • Topic C: Customize Proofing and Save Options
  • Topic D: Customize the Ribbon and Quick Access Toolbar
  • Topic E: Understanding and Enabling Add-Ins
  • Topic F: Customize Advanced and Trust Center Options

You may also be interested in:

Excel Level 2

Excel Level 3 

 

What's next?

View our Excel Flowchart.

Certification

Before testing you will need:

  • Excel Level 1
  • Excel Level 2
  • Excel Level 3

Wondering if you should start with Level 1?

Take our class placement self-assessment to help you decide.