Training Courses

Excel for Beginners: MICROSOFT EXCEL 365: PART 1

$250.00

Excel for Beginners

Excel for Beginners is a 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, providing an extensive set of tools for organizing, analyzing, presenting, and storing 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.

COURSE DETAILS

Excel for Beginners 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.


For more advanced courses:

MICROSOFT EXCEL 365: PART 2
https://itechskills.ca/product/microsoft-excel-365-part-2/

MICROSOFT EXCEL 365: PART 3
https://itechskills.ca/product/microsoft-excel-365-part-3/
Excel for Beginners 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

Excel for Beginners course assumes that the user understands the basics of using a Windows-based computer. Students should be comfortable using the keyboard, mouse, and Start menu. Understanding and experience with printing and using a web browser is an asset, but not required. No previous experience with other versions of Excel is necessary.

Awareness and accomplished attendance
Novice computer Users