Course Details:
Microsoft Excel 365: Part 1

<< Back to courses

Course Overview:

This course is intended to help all novice computer users get up to speed with Excel quickly.

Welcome to the first part of our Microsoft 365 Excel courseware. 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.

Most of the features Microsoft incorporated in Office 2019 already exist in Office 365. Office 365 is a great solution for those looking for Office 2019 Training.

 

What You'll Learn

This course is intended to help all novice computer users get up to speed with Excel quickly. The course will cover:

  • Getting started with the app
  • Working with formulas and functions
  • Modifying worksheets
  • Printing workbook contents
  • Managing workbooks
  • Customizing the Excel environment
 

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
Course Title
Microsoft Excel 365: Part 1
Course Number
821472
Duration
1 day
Price
$295.00