Mastering Excel 2019 – Intermediate

Course Central

Add to wishlist

Duration / Course length: Upto 5 Hours Start now
Accredited by: CPD Group
Certificates:
Sample certificate
Course delivery: This course is delivered in video format

Course details

This Mastering Excel 2019 - Intermediate course is designed for professionals who want to thrive in their profession. The Mastering Excel 2019 - Intermediate course covers all the essential skills and knowledge needed to become specialized in this sector. You will learn real life knowledge and expertise from the industry experts and practitioners from this Mastering Excel 2019 - Intermediate course.

The Mastering Excel 2019 - Intermediate Course starts with the basic knowledge of Mastering Excel 2019 - Intermediate and gradually shares expertise knowledge. In this course you will get a complete idea of Mastering Excel 2019 - Intermediate with key concepts, strategies regarding use of it and in-depth knowledge. The Mastering Excel 2019 - Intermediate course is completely an online course. You can access this course from any part of the world with just a smart device and the internet.

By the end of this course, you will get complete knowledge and marketable skills. The course also comes with an free accredited certificate, which will add extra value to your resume and help you stand out in the job market. In short, Mastering Excel 2019 - Intermediate Course is the perfect course to fast track your career. So what are you waiting for? Enroll today!

What you will learn

Create and use named ranges
Sort and filter columns of data
Create and modify charts and graphics
Create a PivotTable to group and summarize data
Insert functions into spreadsheets including: Date and Time functions, Logical functions, Text functions, Math functions, Database functions, Subtotals, and nested functions
Create and modify Tables, and apply advanced Conditional Formatting
Apply advanced charting tools
Apply advanced PivotTable features, create a PivotChart, and filter data using Slicers and Timelines

Who is this course for?

This course is ideal for those who work in or aspire to work in the following professions:

People who have a working knowledge of Excel 2019 or Excel 365, but want to use more complex functions and features to analyze data

Why Choose Mastering Excel 2019 - Intermediate course?

Accredited by CPD
Conducted by industry experts
Get Instant E-certificate
Fully online, interactive course with Professional voice-over
Developed by qualified professionals
Self-paced learning and laptop, tablet, smartphone friendly
Tutor Support

Certification
By the successful completion of your course, you will get an instant free accredited e-certificate. Our courses are fully accredited with updated industry knowledge and skills that aim at making you an expert in the field. The hard copy of the certificate is also available and can be sent to your address. The delivery charge is applicable with an international shipping cost of £ All the certificates have no expiry dates but to stay updated and valued certificates are recommended to be renewed every year.

Updated on 20 March, 2024

Eligibility / Requirements

No prior experience required to take this course.

Job roles this course is suitable for:

Office Administrator , Excel Specialist , Data Analyst , Account Manager

About Course Central

About us

Course Central is a registered online training institution in the UK. We helped thousands of professionals to grow and achieve career success.
Course Central is equipped with latest audio-visual technology and highly qualified professionals with more than 30 years combined industry experience. Our dedicated course team would ensure you get the best online learning experience from Course Central with high quality courses. Course Central courses are designed to equip you with the required knowledge and skill to excel at your workplace or in your career field.

Our Mission

Course Central aims at helping professionals to grow in their career with highly valuable skills and knowledge. With quality training and valuable certificates, professionals can level up their skills from Course Central and gain professional success.

Comfortable Learning

Facing traffic, then attending classes is always tiresome. With Course Central online education you don’t need to face traffic any more. You can learn from your most cozy bed.