[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-
* Administrative Assistant
* Accountants
* Retail Manager
* Cost Estimator
* Financial Analyst
* Project Manager
* Business Analyst
* Data Journalist
And much more!
CERTIFICATES
CERTIFICATE OF COMPLETION
Digital certificate - Included
CERTIFICATE OF COMPLETION
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.