Description

This Microsoft Excel 2019 training program is design for professionals who want to advance their skill set by learning to work with advanced formulas, lists, and illustrations. Professionals will also work with charts and advanced formatting including styles.

 

Radiant Teachlearning offers Intermediate 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:

  • Use formulas and functions.
  • Create and modify charts.
  • Convert, sort, filter, and manage lists.
  • Insert and modify illustrations in a worksheet.
  • Work with tables.
  • Use conditional formatting and styles.

Pre-requisite

Before attending this training program, professionals must have:

  • Fundamental experience with Excel

 

Audience Profile

This training program is intended for professionals who have fundamental skills with Microsoft Excel 2019 who want to learn intermediate-level skills or professionals who want to learn the topics covered in this training program in the 2019 interface.

Course Content

Lesson 1: Advanced Formulas

This lesson explains how to work with advanced formulas in Microsoft Excel.

Lessons

  • Using Named Ranges in Formulas
  • Using Formulas That Span Multiple Worksheets
  • Entering a Formula Using Data in Multiple Worksheets
  • Using the IF Function
  • Using the PMT Function
  • Using the LOOKUP Function
  • Using the VLOOKUP Function
  • Using the HLOOKUP Function
  • Using the CONCAT Function
  • Using the TRANSPOSE Function
  • Using the PROPER, UPPER, and LOWER Functions
  • Using the PROPER Function
  • Using the LEFT, RIGHT, and MID Functions
  • Using the LEFT and RIGHT Functions
  • Using Date Functions
  • Using the YEAR, MONTH, and DAY Functions
  • Creating Scenarios

Lab: Advanced Formulas Exercises

  • Using Named Ranges in Formulas
  • Entering a Formula Using Data in Multiple Worksheets
  • Using the IF Function
  • Using the PMT Function
  • Using the VLOOKUP Function
  • Using the CONCAT Function
  • Using the PROPER Function
  • Using the LEFT and RIGHT Functions
  • Using the YEAR, MONTH, and DAY Functions

After accomplishing this lesson, professionals will be able to:

  • Name and label cells and ranges of cells.
  • Use names and labels in formulas.
  • Create formulas that span multiple worksheets.
  • Use the conditional IF function and its variants in formulas.
  • Use the PMT function to calculate payments for loans.
  • Use the LOOKUP function.
  • Use the VLOOKUP function.
  • Use the HLOOKUP function.
  • Use the CONCAT function to join the contents of numerous cells.
  • Use the TRANSPOSE function.
  • Use the PROPER, UPPER, and LOWER functions to alter the casing of text.
  • Use the LEFT, RIGHT, and MID functions to return characters from the start or end of a string, or a specific number of text characters.
  • Use various date functions.

 

Lesson 2: Working with Lists

This lesson explains how to work with lists.

Lessons

  • Converting a List to a Table
  • Removing Duplicates from a List
  • Sorting Data in a List
  • Filtering Data in a List
  • Adding Subtotals to a List

Lab: Work with Lists Exercises

  • Converting a List to a Table
  • Removing Duplicates from a List
  • Sorting Data in a List
  • Filtering Data in a List
  • Adding Subtotals to a List

After accomplishing this lesson, professionals will be able to:

  • Convert data into tables.
  • Remove duplicates from tables.
  • Sort data in Excel.
  • Filter data in Excel.
  • Use subtotals to automatically total related data.
  • Group and ungroup data.

 

Lesson 3: Working with Illustrations

This lesson explains how to work with Illustrations in Microsoft Excel.

Lessons

  • Working with Clip Art
  • Using Shapes
  • Adding Shapes
  • Working with Icons
  • Working with SmartArt
  • Using Office Ink

Lab: Working with Illustrations Exercises

  • Working with Clip Art
  • Adding Shapes

After accomplishing this lesson, professionals will be able to:

  • Add pictures to your worksheets.
  • Use Clip Art to illustrate your worksheets.
  • Insert shapes into Microsoft Excel worksheets.

Use SmartArt to illustrate your worksheets.

 

Lesson 4: Visualizing Your Data

This lesson explains how to work with various types of charts in Microsoft Excel.

Lessons

  • Inserting Charts
  • Using the Chart Recommendation Feature
  • Editing Charts
  • Using Chart Tools
  • Using the Quick Analysis Tool
  • Add and Format Objects
  • Create a Custom Chart Template

Lab: Visualizing Your Data Exercises

  • Inserting Charts
  • Editing Charts

After accomplishing this lesson, professionals will be able to:

  • Create charts that enable professionals to visualize your data.
  • Choose what data is displayed in your charts.
  • Show and hide data labels.
  • Show and hide the legend.
  • Show and hide the chart title.
  • Add a picture or shape to a chart.
  • Change the way text displays in a chart.
  • Change the fill color of a chart.
  • Add and format objects in a worksheet.
  • Create a custom chart template.

 

Lesson 5: Working with Tables

This lesson explains how to work with tables in Microsoft Excel.

Lessons

  • Format Data as a Table
  • Move between Tables and Ranges
  • Modify Tables
  • Define Titles
  • Creating and Modifying a Table in Excel

Lab: Creating and Modifying a Table in Excel

  • Creating and Modifying a Table in Excel

After accomplishing this lesson, professionals will be able to:

  • Format data in Excel as a table.
  • Modify Excel tables

 

Lesson 6: Advanced Formatting

This lesson explains how to work with advanced formatting features in Microsoft Excel.

Lessons

  • Applying Conditional Formatting
  • Using Conditional Formatting
  • Working with Styles
  • Creating and Modifying Templates

Lab: Advanced Formatting Exercises

  • Using Conditional Formatting
  • Working with Styles

After accomplishing this lesson, professionals will be able to:

  • Use conditional formatting to display cells differently based on their values.
  • Quickly format tables using styles.
  • Format cells using styles

Additional Reading

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

N/A

FAQs

Q: Where is options in Excel 2019?

 

A: User can use following steps to see options in Excel 2019:-

  • Open Excel Options from Excel 2010/2013/2016/2019 Ribbon if you do not have Classic Menu for Office
  • Click the File tab jumping into backstage view;
  • Then you will view the Options button at left bar. Click it into Excel Options window.

 

Q: How do I write a formula in Excel?

 

A: To write formula in Excel you can use following steps :-

  • Create a simple formula in Excel
  • On the worksheet, click the cell in which you want to enter the formula.
  • Type the = (equal sign) followed by the constants and operators (up to 8192 characters) that you want to use in the calculation. For our example, type =1+1. Notes.
  • Press Enter (Windows) or Return (Mac).

 

Q: How can I check my Excel version?

 

A: Start by clicking on the File button, on the top left corner of Excel. Click on Account, on the left-hand side of the screen and after that About Excel. The version is visible in the first paragraph of the dialog box that appears.

 

Q: What does {} mean in Excel?

 

A: An {} around the formula indicates that the formula is an ARRAY formula. User generally need to press CTRL-SHIFT-ENTER together for such formulas instead on ENTER only after editing. An array formula is a formula which basically works with an array, or series, of data.

 

Q: How the training will be delivered or conducted?

 

A: Radiant Techlearning offers customized training delivery solutions for individuals, teams and businesses depending upon what they require. Here is how we help each one through our diverse formats.

Dedicated Classroom Training program

Onsite: To meet the needs & expectations of our corporate clients all over the world, our expert will travel all the way to your location to deliver the training program at a premise of your choice & convenience. 

Offsite: Our client and Individual professionals across the world travel all the way to India to attend our classroom training sessions. We assist them in services like accommodation, Airport pick & drop, daily cab & Visa assistance. 

Public Batches: Corporates & Individual professionals across the world can nominate their employees or themselves in our classroom or online public batches. Our public batches would have limited number of participants to ensure individual attention. As the participants are from different background and companies, you learn from everyone’s experience. 

On-the-Job Learning: Our team of consultant would help you to execute end-to-end project and simultaneously learn the technology.  

 

Q: What are the various learning options or training mode available?

 

A: Radiant Techlearning offers customized solutions and training programmes for individuals, teams and businesses depending upon what they require. Here is how we help each one through our diverse formats.

Individuals / One-O-One Training 

  • Focused learning sessions
  • Programs scheduling according to your choice
  • Get personalized attention
  • Choose what technology interests you

 

Teams: Enroll for our Classroom or online Public Batches 

  • Get our specialized updated content for different skill levels
  • Get on-demand learning and solve problems quickly
  • Get help from the ground level through sequential learning

Enterprise:

  • Get customized training programmes and solutions that can be curated especially for your business
  • Meet needs of all learners
  • Let your employees be geared up for all kinds of problem solving
  • Inspire your teams for future
  • Update your employees with latest information stretching from technology, business leadership to marketing

 

Q: Who will be the instructor of training program?

 

A: Radiant Techlearning has large pool of in-house certified trainers & consultants with strong background and working experience on the technology. 

Radiant Techlearning offers more than 800+ courses and for each course Radiant have identified best-in-class instructors. 

Radiant has highly intensive selection criteria for Technology Trainers & Consultants, who deliver you training programs. Our trainers & consultants undergo rigorous technical and behavioral interview and assessment process before they are on boarded in the company. 

Our Technology experts / trainers & consultant carry deep dive knowledge in the technical subject & are certified from the OEM. Our faculty will provide you the knowledge of each course from fundamental level in an easy way and you are free to ask your doubts any time from your respective faculty.

Our trainers have patience and ability to explain difficult concepts in simplistic way with depth and width of knowledge.

 

Q: What is the schedule of the training program?

 

A: Radiant Techlearning offers training program on the weekday, weekend and a combination of weekdays and weekends. You can always choose the schedule that best suits to your need. 

 

Unble To Find a Batch..?

Request a Batch