55271: Introduction to Microsoft Excel Training

Name: 55271: Introduction to Microsoft Excel Training
Brand: Microtek Learning
Price: $275
Rating: 5 (265 reviews)

Course Description

The students in this Microsoft Excel: Introduction training course will design and edit simple worksheets and workbooks. Students who want to learn how to make, edit, format, and print straightforward Microsoft Excel worksheets should take this course.

Prerequisites for this training

Knowledge of how to use a keyboard, mouse, and personal computer.
Accommodating in a Windows environment.
The capacity to open and shut programs, find information on the computer and organise files and folders.

Who should attend this course?

Students who have little to no experience with Microsoft Excel or more seasoned Excel users who want to learn the course material in the interface should take this course.

Microsoft Certified Partner

Microtek Learning is a Microsoft Certified Partner for Learning Solutions. This class uses official Microsoft courseware and will be delivered by a Microsoft Certified Trainer (MCT).

Schedules

Jun 14, 2023

9:00 am - 5:30 pm EST

Online

ENROLL NOW

What you will learn

Using Microsoft Excel, create simple worksheets.
Calculations should be done in an Excel worksheet.
Make changes to an Excel worksheet.
alter the way that data in a worksheet appears.
controlling Excel workbooks.
Print an Excel worksheet's contents.
Discover how to use practical 2019 additions.

Curriculum

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 Color to Worksheet Tabs

Adding Themes to Workbooks

Customize a Workbook Using Tab Colors 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 Colors 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.

Module 7: Using Formulas in Microsoft Excel

This module explains how to work with formulas in Microsoft Excel.

Lessons

Math Operators and the Order of Operations

Entering Formulas

AutoSum (and Other Common Auto-Formulas)

Copying Formulas and Functions

Relative, Absolute, and Mixed Cell References

Working with Formulas

Lab 1: Working with Formulas

Working with Formulas

After completing this module, students will be able to:

Understand math operators and the order of operations in Excel.

Enter basic formulas.

Use AutoSum to sum data with one click.

Understand absolute, relative, and mixed cell references.

Copy formulas and functions.

Module 8: Working with Rows and Columns

This module explains how to work with rows and columns in Microsoft Excel.

Lessons

Inserting Rows and Columns

Deleting Rows and Columns

Transposing Rows and Columns

Setting Row Height and Column Width

Hiding and Unhiding Rows and Columns

Freezing Panes

Working with Rows and Columns

Lab 1: Working with Rows and Columns

Working with Rows and Columns

After completing this module, students will be able to:

Insert rows and columns in Microsoft Excel worksheets.

Delete rows and columns in Microsoft Excel worksheets.

Transpose rows and columns.

Change row heights.

Change column widths.

Hide and unhide rows and columns.

Freeze panes.

Module 9: Editing Worksheets

This module explains how to edit worksheets in Microsoft Excel.

Lessons

Find

Find and Replace

Using Find and Replace

Using the Clipboard

Using Format Painter

Managing Comments

Lab 1: Editing Worksheets Exercises

Using Find and Replace

Using the Clipboard

Using Format Painter

After completing this module, students will be able to:

Locate information in your worksheet using Find.

Use Find and Replace to quickly replace data with other data.

Use the Cut, Copy, Paste and Format Painter commands to edit worksheets.

Manage comments

Module 10: Finalizing Microsoft Excel Worksheets

This module explains how to finalize Microsoft Excel worksheets.

Lessons

Setting Margins

Setting Page Orientation

Setting the Print Area

Print Scaling (Fit Sheet on One Page)

Printing Headings on Each Page/Repeating Headers and Footers

Headers and Footers

Preparing to Print

Lab 1: Preparing to Print

Preparing to Print

After completing this module, students will be able to:

Set margins in Microsoft Excel worksheets.

Set the page orientation to portrait or landscape.

Set the print area in a worksheet.

Scale a worksheet so that all data prints on one page.

Add headers and footers to a worksheet.

With Microtek Learning, you’ll receive:

Certified Instructor-led training
Industry Best Trainers
Official Training Course Student Handbook
Pre and Post assessments/evaluations
Collaboration with classmates (not available for a self-paced course)
Real-world knowledge activities and scenarios
Exam scheduling support*
Learn and earn program*
Practice Tests
Knowledge acquisition and exam-oriented
Interactive online course.
Support from an approved expert
For Government and Private pricing*

* For more details call: +1-800-961-0337 or Email: info@microteklearning.com

Our Clients

For many years, Microtek Learning has been helping organizations, leaders, and professionals to reach their maximum performance by addressing the challenges they are facing.