Description

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

 

Radiant Teachlearning offers Introduction to Microsoft Excel 2019 Training Program in Classroom and Virtual instructor Led/Online mode.

 

Duration: 1 day

 

Learning Objectives

After accomplishing this training program, professionals 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.

Pre-requisite

Audience Profile

This training program is intended for professionals who have little or no familiarity with Microsoft Excel 2019 or more experienced Excel users who want to learn the topics covered in this training program in the 2019 interface.

Course Content

Lesson 1: Creating a Microsoft Excel Workbook

This lesson 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: Creating a Microsoft Excel Workbook

After accomplishing this lesson, professionals will be able to:

  • Start Microsoft Excel.
  • Create a Microsoft Excel workbook.
  • Save a Microsoft Excel workbook.
  • Acknowledge the Status Bar.
  • Add and delete Microsoft Excel worksheets.
  • Copy and move worksheets.
  • Split the worksheet window.8. To close a Microsoft Excel workbook.

 

Lesson 2: The Ribbon

This lesson explains how to work with the Ribbon.

Lessons

  • Tabs
  • Groups
  • Commands

Lab: The Ribbon Exercises

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

After accomplishing this lesson, professionals will be able to:

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

 

Lesson 3: The Backstage View (The File Menu)

This lesson 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: Backstage View Exercises

  • Print a Worksheet
  • Open a Workbook

After accomplishing this lesson, professionals 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

 

Lesson 4: The Quick Access Toolbar

This lesson 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: Customize the Quick Access Toolbar

After accomplishing this lesson, professionals 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.

 

Lesson 5: Entering Data in Microsoft Excel Worksheets

This lesson 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: Entering Data Exercises

  • Entering Text and Using AutoComplete
  • Entering Numbers and Dates

After accomplishing this lesson, professionals 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.

 

Lesson 6: Formatting Microsoft Excel Worksheets

This lesson 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: Formatting Worksheets Exercises

  • Customize a Workbook Using Tab Colors and Themes
  • Working with Font Group Commands
  • Working with Alignment Group Commands
  • Working with Nummber Group Commands

After accomplishing this lesson, professionals will be able to:

  • Acknowledge various ways professionals 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.

 

Lesson 7: Using Formulas in Microsoft Excel

This lesson 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: Working with Formulas

After accomplishing this lesson, professionals will be able to:

  • Acknowledge math operators and the order of operations in Excel.
  • Enter basic formulas.
  • Use AutoSum to sum data with one click.
  • Acknowledge absolute, relative, and mixed cell references.
  • Copy formulas and functions.

 

Lesson 8: Working with Rows and Columns

This lesson 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: Working with Rows and Columns

After accomplishing this lesson, professionals 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.

 

Lesson 9: Editing Worksheets

This lesson 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: Editing Worksheets Exercises

  • Using Find and Replace
  • Using the Clipboard
  • Using Format Painter

After accomplishing this lesson, professionals 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

 

Lesson 10: Finalizing Microsoft Excel Worksheets

This lesson 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: Preparing to Print

After accomplishing this lesson, professionals 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.

 

Additional Reading

To help professionals prepare for this class, review the following resources:

  • N/A

FAQs

Q: How many versions of Excel are there?

 

A: There have been 29 different versions of Excel, stretching from 1985 to the present day. These days most users today will have Excel 2016, 2019 or 365. Each version of Excel has been significantly different to the last, and the Mac and Windows versions are still very different today.

 

Q: Why is Microsoft Excel so important?

 

A: Among the computer programs which exist, Microsoft Excel is one of the most important because of the key role it plays in many sectors. Various businesses, personal as well as institutional enterprises have embraced the use of Excel because of its utility and the ability to serve as a visual basic for various different applications.

 

Q: Who uses Microsoft Excel?


A: Microsoft Excel is a spreadsheet program. It generally means that it’s used to make grids of text, numbers and formulas specifying calculations. That’s extremely crucial for multiple businesses, which use it to record expenditures as well as income, plan budgets, chart data and succinctly present fiscal results.

 

Q: How does Microsoft Excel work?

 

A: Microsoft Excel has the fundamental features of all spreadsheets, with the help of a grid of cells which are mainly arranged in numbered rows as well as letter-named columns to organize data manipulations such as arithmetic operations. It has a battery of supplied functions which is used to answer statistical, engineering, and financial needs.

 

Q: How I will be accessing the labs?

 

A: Radiant Techlearning has a data center containing the Virtual Training environment for the purpose of participant’s hand-on-practice. 

Participants can easily access these labs over Cloud with the help of remote desktop connection. 

Radiant virtual labs provides you the flexibility to learn from anywhere in the world and in any time zone. 

Q: What kind of projects are included as a part of training?

 

A: The learners will be enthralled as we engage them the real world and industry Oriented projects during the training program. These projects will improve your skills and knowledge and you will gain better experience. These real time projects, they will help you a lot in your future tasks and assignments.

 

Q: How is the Radiant Techlearning verified certificate awarded?

 

A: Radiant awards course completion certificate to all the participants who have completed the training program which includes various real time projects, assignments, quizzes and some other tasks.  Once the course is done you would be assigned with a project which you would have to submit in 2 weeks’ time. 

Radiant Techlearning experts will be evaluating the project on various parameter. To be eligible for the verified certificate you would have to score more than 60% marks. 

Only after completion of these criteria you would be awarded with Radiant verified certificate and which the participants can use for their future job purpose. 

Participants will be awarded with grades according to the following criteria:

90% – 100% – AAA+

80% – 90% – AA+

70% – 80% – A+

60% – 70% – A

 

Q: Is there any job assistant guarantee?

 

A: No. These training programs are helpful to improve your skills & knowledge on the technology which would help you to land in your dream job by learning them. 

Our training program will maximize your ability and chances of getting a successful job. You have to select job according to your convenience. Your performance in the training program and interview is crucial for getting good job.

 

Unble To Find a Batch..?

Request a Batch