Course Images

Microsoft Excel: from ZERO to ADVANCED Course

Booking options

Free

Enrol Contact Us

Highlights

On-Demand course
2 hours
All levels

Description

[Updated 2022]

Microsoft Excel 2019: from ZERO to ADVANCED

Working knowledge of Excel is vital for most office-based professionals today, and stronger Excel skills can open the door to jobs, promotions, and leadership opportunities.

For example, if basic SUM and AVERAGE functions can help businesses calculate and analyse data better and quicker, think about how much more efficient advanced functions can make you. And to make you efficient and better at work, our Microsoft Excel experts have designed this Microsoft Excel course.

Curriculum

Microsoft Excel 2019 New Features

Getting Started with Microsoft Office Excel

Performing Calculations

Modifying a Worksheet

Formatting a Worksheet

Printing Workbooks

Managing Workbooks

Working with Functions

Working with Lists

Analyzing Data

Visualizing Data with Charts

Using PivotTables and PivotCharts

Working with Multiple Worksheets and Workbooks

Using Lookup Functions and Formula Auditing

Sharing and Protecting Workbooks

Automating Workbook Functionality

Creating Sparklines and Mapping Data

Forecasting Data

Excel Templates

Learning Outcomes

By the end of this course, you'll learn the following skills:

Perform various calculations and get results in seconds rather than doing them manually

Gain the ability to modify and format worksheets and learn to print and manage workbooks

Learn various functions and how to work with lists

Become an expert on data analysis 2019 features

Learn to use visual elements like charts and data visualisation to see and understand trends, outliers, and patterns in data

How to present data using PivotTables and PivotCharts as well as working with multiple worksheets and workbooks

Using lookup functions and formula auditing, sharing and protecting workbooks, automating workbook functionality

How to forecast data, create sparklines and mapping, usage of various Microsoft Excel templates

Key Features of the Microsoft Excel Course :

Accredited by CPD

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

Fully online, interactive course with audio voiceover

Developed by qualified professionals in the field

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

24/7 Learning Assistance

Discounts on bulk purchases

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 the course.

*** Additional Gifts ***

Free Life coaching Course

This Microsoft Excel Skills course is designed for people with a career in Accounting, Finance, Marketing, Sales, Executive, Administration, Business Management, Manager, Human Resources, Customer Service, Assistant, and Reception.

In this course, we will go in-depth into Microsoft Excel applications, which are delivered in a simple way to be understood.

CPD

15 CPD hours / points Accredited by CPD Quality Standards

Career path

No matter where you are or what you do, if you are working with digital data, having Microsoft Excel skills is a must. With skills, you can explore opportunities everywhere, including-