MECER ME-EXL19L1 Excel Notebook Laptop Instruction Manual

: June 10, 2024
: MECER

Table of Contents

INTRODUCTION
COURSE CONTENT
ASSOCIATED CERTIFICATIONS & EXAM
Read User Manual Online (PDF format)
Download This Manual (PDF format)

ME-EXL19L1 Excel Notebook Laptop
Instruction Manual

DURATION| LEVEL| TECHNOLOGY| DELIVERY METHOD| TRAINING CREDITS
---|---|---|---|---
1 Day| Introduction| Office 2019| Instructor-led| NA

INTRODUCTION

In this Introduction to Microsoft Excel 2019 training class, students will create and edit basic worksheets and workbooks. This course is designed for students who want to gain the necessary skills to create, edit, format, and print basic Microsoft Excel 2019 worksheets.

AUDIENCE PROFILE
This course is intended for students who have little or no familiarity with Microsoft Excel 2019 or more experienced Excel users who want to learn the topics covered in this course in the 2019 interface.

PREREQUISITES
Before attending this course, delegates must:

Be familiar with using a personal computer, mouse, and keyboard.
Be comfortable in the Windows environment.
Have the ability to launch and close programs; navigate to information stored on the computer; and manage files and

COURSE OBJECTIVES
After completing this course, students will be able to:

Create basic worksheets using Microsoft Excel 2019.
Perform calculations in an Excel worksheet.
Modify an Excel worksheet.
Modify the appearance of data within a worksheet.
Manage Excel workbooks.
Print the content of an Excel worksheet.
Learn how to use handy features new in 2019.

COURSE CONTENT

Module 1: Creating a Microsoft Excel Workbook
This module explains how to create and start working with workbooks and worksheets.
Lessons

Starting Microsoft Excel
Creating a Workbook
Saving a Workbook
The Status Bar
Adding and Deleting Worksheets
Copying and Moving Worksheets
Changing the Order of Worksheets
Splitting the Worksheet Window
Closing a Workbook
Lab 1: Creating a Microsoft Excel Workbook
Creating a Microsoft Excel Workbook
After completing this module, students will be able to:
Start Microsoft Excel.
Create a Microsoft Excel workbook.
Save a Microsoft Excel workbook.
Understand the Status Bar.
Add and delete Microsoft Excel worksheets.
Copy and move worksheets.
Split the worksheet window.8.
To close a Microsoft Excel workbook.

Module 2: The Ribbon
This module explains how to work with the Ribbon.

Lessons

Tabs
Groups
Commands

Lab 1: The Ribbon Exercises

Open a Workbook
Select, Open, and Save a
Template Agenda

After completing this module, students will be able to:

Work with tabs.
Work with groups.
Work with commands.
Know which groups and commands are found on which tabs.

Module 3: The Backstage View (The File Menu)
This module explains how to work with the Backstage View.
Lessons

Introduction to the Backstage View
Opening a Workbook
Open a Workbook
New Workbooks and Excel Templates
Select, Open and Save a Template Agenda
Printing Worksheets
Print a Worksheet
Adding Your Name to Microsoft Excel
Adding a Theme to Microsoft Excel

Lab 1: Backstage View Exercises

Print a Worksheet
Open a Workbook
After completing this module, students will be able to:
Work with the Backstage view.
Open a Microsoft Excel workbook.
Start a new Microsoft Excel workbook.
Use Microsoft Excel templates.
Print a Microsoft Excel workbook.
Personalize your copy of Microsoft Excel

Module 4: The Quick Access Toolbar
This module explains how to work with the Quick Access Toolbar.
Lessons

Adding Common Commands
Adding Additional Commands with the Customize Dialog Box
Adding Ribbon Commands or Groups
Placement
Customize the Quick Access Toolbar

Lab 1: Customize the Quick Access Toolbar

Customize the Quick Access Toolbar
After completing this module, students will be able to:
Add common commands to the Quick Access Toolbar.
Add additional commands to the Quick Access Toolbar.
Move the Quick Access Toolbar.

Module 5: Entering Data in Microsoft Excel Worksheets
This module explains how to enter data in Microsoft Excel worksheets.
Lessons

Entering Text
Adding and Deleting Cells
Adding a Hyperlink
Add WordArt to a Worksheet
Using AutoComplete
Entering Text and Using AutoComplete
Entering Numbers and Dates
Using the Fill Handle
Entering Numbers and Dates

Lab 1: Entering Data Exercises

Entering Text and Using AutoComplete
Entering Numbers and Dates After completing this module, students will be able to:
Enter text in Microsoft Excel worksheets.
Add or delete cells in worksheets.
Add an outline for your data.
Enter a hyperlink in a worksheet.
Use AutoComplete.
Enter numbers and dates in Microsoft Excel worksheets.
Use the Fill Handle to add data to cells.

Module 6: Formatting Microsoft Excel Worksheets
This module explains how to format Microsoft Excel worksheets.
Lessons

Selecting Ranges of Cells
Hiding Worksheets
Adding Colour to Worksheet Tabs
Adding Themes to Workbooks
Customize a Workbook Using Tab Colours and Themes
Adding a Watermark
The Font Group
Working with Font Group Commands
The Alignment Group
Working with Alignment Group Commands
The Number Group
Working with Number Group Commands

Lab 1: Formatting Worksheets Exercises

Customize a Workbook Using Tab Colours and Themes
Working with Font Group Commands
Working with Alignment Group Commands
Working with Number Group Commands
After completing this module, students will be able to:
Understand various ways you can format Microsoft Excel worksheets.
Select a range of cells within a worksheet.
Hide worksheets.
Add color to workbook tabs.
Add themes to worksheets.
Bold, italicize and underline text.
Add borders to cells.
Change text and cell colors.
Change the font and font size.
Align text.
Wrap text.
Indent text.
Merge and center text.
Change number formats.
Change date formats.
Show decimals.