5

1

ratings 

Mastering Excel 2019 - Intermediate course is the perfect course for the professionals. Learn key concepts, strategies of Mastering Excel 2019 - Intermediate and boost your career with a marketable skill. Learn from the experts and become an expert. 

£100.00
Course Access

Unlimited Duration

Last Updated

September 6, 2021

Students Enrolled

371

Course Duration

5 hours, 7 minutes

Course Instructor
Certification
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 specialised 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 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? Enrol 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
 

Course Media

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 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 a shipping cost of £4.99. All the certificates have no expiry dates but to stay updated and valued certificates are recommended to be renewed every year.

Instructor

Profile Photo
5 5
7441

Students

Accredited by

Course Curriculum

    • Introduction 00:02:00
    • Using Named Ranges, Part 1 00:05:00
    • Using Named Ranges, Part 2 00:06:00
    • Using Named Ranges, Part 3 00:05:00
    • Working with Date Functions, Part 1 00:09:00
    • Working with Date Functions, Part 2 00:05:00
    • Working with Date Functions, Part 3 00:04:00
    • Working with Time Functions 00:06:00
    • Working with Logical Functions 00:09:00
    • Working with Conditional Functions 00:08:00
    • Multiple Criteria Functions 00:05:00
    • Using Nested Functions 00:05:00
    • Using IFS and SWITCH Functions 00:06:00
    • Working with Text Functions, Part 1 00:05:00
    • Working with Text Functions, Part 2 00:05:00
    • Working with Text Functions, Part 3 00:04:00
    • Working with Text Functions, Part 4 00:09:00
    • Working with Math Functions 00:07:00
    • Sorting Data, Part 1 00:06:00
    • Sorting Data, Part 2 00:06:00
    • Filtering Data, Part 1 00:06:00
    • Filtering Data, Part 2 00:08:00
    • Filtering Data, Part 3 00:08:00
    • Querying with Database Functions 00:07:00
    • Using the Subtotal Function 00:05:00
    • Using the Subtotal Feature 00:07:00
    • Creating Tables 00:07:00
    • Modifying Table Styles 00:07:00
    • Summarizing Data in Tables 00:05:00
    • Using the Quick Analysis Shortcut 00:02:00
    • Customizing Conditional Formatting 00:06:00
    • Using Formulas with Conditional Formatting 00:06:00
    • Creating Charts 00:06:00
    • Using Chart Types 00:02:00
    • Changing Chart Data Source 00:07:00
    • Adding Chart Elements 00:10:00
    • Formatting a Chart 00:05:00
    • Using Advanced Chart Features 00:04:00
    • Applying Trendlines 00:05:00
    • Creating a Chart Template 00:03:00
    • Inserting Graphics 00:09:00
    • Modifying Graphics, Part 1 00:06:00
    • Modifying Graphics, Part 2 00:07:00
    • Creating a PivotTable 00:12:00
    • Summarizing Data in a PivotTable 00:08:00
    • Grouping Data in a PivotTable 00:06:00
    • Formatting a PivotTable 00:07:00
    • Selecting and Moving PivotTables 00:03:00
    • Changing PivotTable Options 00:08:00
    • Adding Calculated Fields 00:02:00
    • Presenting Data with PivotCharts 00:04:00
    • Using Timeline Slicers 00:02:00
    • Get Your Certificate & Transcript 00:00:00

Course Reviews

© Course Central 2021. Course Central is a trading style of Idea Republic Ltd. Company registered in England and Wales. Registration no: 08664232 | Registered Address: 1 Flag Business Exchange, Vicarage Farm Road, Peterborough, PE1 5TX | VAT no: 196 1993 55

X