Description

Microsoft Excel 2019 for Beginner course teaches you everything on the topic thoroughly from scratch so you can claim a certificate of achievement for free to showcase your achievement in professional life. This course is a comprehensive, instructor-guided course, designed to provide a detailed understanding of the nature of the related sector and your key roles within it.

To become successful in your profession, you must have a specific set of skills to succeed in today's competitive world. In this in-depth training course, you will develop the most in-demand skills to kickstart your career, as well as upgrade your existing knowledge & skills.

The training materials of this course are available online for you to learn at your own pace and fast-track your career with ease.

Key Features of the Microsoft Excel 2019 for Beginner Course :

Instant e-certificate and hard copy dispatch by next working day

Fully online, interactive course with audio voiceover

Developed by professionals in the field

Self-paced learning and laptop, tablet, smartphone-friendly

24/7 Learning Assistance

Discounts on bulk purchases

*** Additional Gifts ***

Free Life coaching Course

*** (Offer Ends Soon) ***

Course Curriculum

The detailed curriculum outline of our Microsoft Excel 2019 for Beginner course is as follows:

***Microsoft Excel 2019***

Microsoft Excel 2019 New Features

Introduction to Microsoft Excel 2019 New Features

CONCAT

MAXIFS

MINIFS

SWITCH

TEXTJOIN

Map Chart

Funnel Chart

Better Visuals

Pivot Table Enhancements

Power Pivot Updates

Getting Started with Microsoft Office Excel

Navigate the Excel User Interface

Use Excel Commands

Create and Save a Basic Workbook

Enter Cell Data

Use Excel Help

Performing Calculations

Create Worksheet Formulas

Insert Functions

Reuse Formulas and Functions

Modifying a Worksheet

Insert, Delete, and Adjust Cells, Columns, and Rows

Search for and Replace Data

Use Proofing and Research Tools

Formatting a Worksheet

Apply Text Formats

Apply Number Format

Align Cell Contents

Apply Styles and Themes

Apply Basic Conditional Formatting

Create and Use Templates

Printing Workbooks

Preview and Print a Workbook

Set Up the Page Layout

Configure Headers and Footers

Managing Workbooks

Manage Worksheets

Manage Workbook and Worksheet Views

Manage Workbook Properties

Working with Functions

Work with Ranges

Use Specialized Functions

Work with Logical Functions

Work with Date & Time Functions

Work with Text Functions

Working with Lists

Sort Data

Filter Data

Query Data with Database Functions

Outline and Subtotal Data

Analyzing Data

Apply Intermediate Conditional Formatting

Apply Advanced Conditional Formatting

Visualizing Data with Charts

Create Charts

Modify and Format Charts

Use Advanced Chart Features

Using PivotTables and PivotCharts

Create a PivotTable

Analyze PivotTable Data

Present Data with PivotCharts

Filter Data by Using Timelines and Slicers

Working with Multiple Worksheets and Workbooks

Use Links and External References

Use 3-D References

Consolidate Data

Using Lookup Functions and Formula Auditing

Use Lookup Functions

Trace Cells

Watch and Evaluate Formulas

Sharing and Protecting Workbooks

Collaborate on a Workbook

Protect Worksheets and Workbooks

Automating Workbook Functionality

Apply Data Validation

Search for Invalid Data and Formulas with Errors

Work with Macros

Creating Sparklines and Mapping Data

Create Sparklines

MapData

Forecasting Data

Determine Potential Outcomes Using Data Tables

Determine Potential Outcomes Using Scenarios

Use the Goal Seek Feature

Forecasting Data Trends

Who is this course for?

Anyone with a knack for learning new skills can take this Microsoft Excel 2019 for Beginner course. While this comprehensive training is popular for preparing people for job opportunities in the relevant fields, it also helps to advance your career for promotions.

Accreditation

All of our courses, including this course, are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field.

Certification

Once you've successfully completed your course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

Assessment

At the end of the course, there will be an online assessment, which you will need to pass to complete the course. Answers are marked instantly and automatically, allowing you to know straight away whether you have passed. If you haven't, there's no limit on the number of times you can take the final exam. All this is included in the one-time fee you paid for the course itself.

Requirements

The Microsoft Excel 2019 is open to all students and has no formal entry requirements. To study the Microsoft Excel course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16.

Career path

This course will give you a comprehensive understanding of the Microsoft Excel platform and assist you in pursuing several exciting employment opportunities, such as -

Administrative Assistant

Accountants

Business Analyst

Cost Estimator

Data Entry Specialist

Project Manager

And many more!

These job prospects pay an average of £15k to £55k a year in the UK.

Certificates

Digital certificate

Digital certificate - Included

Hard copy certificate

Hard copy certificate - Included

You will get the hard copy certificates for Free! The delivery charge of the hard copy certificate inside the UK is £3.99 each.

Course Images

Excel : Microsoft Excel 2019 Course

By Training Express

Booking options

Highlights

Description

About The Provider

Tags

Reviews