Excel 2019 Intermediate

4.8( 9 REVIEWS )

Excel 2019 Intermediate

4.8( 9 REVIEWS )


Excel 2019 Intermediate Take This Course


The Professional Presenter Training provides you with the knowledge and skill building in the planning, preparation and delivery of truly engaging presentations. Exploring all aspects of concept, design and delivery, you will gain a range of tools and techniques to help you plan and deliver engaging and effective presentations to a range of audiences. You’ll learn how to use specific tools and techniques for presentation creation and delivery which will enable you to conduct powerful presentations that engage your audience every time. This course will give you the framework needed to develop and deliver an effective, memorable presentation. You will learn proven tips and examples that will guide you through the presentation process no matter how large the audience.

Who is this course for?

Excel 2019 Intermediate is suitable for anyone who wants to gain extensive knowledge, potential experience and professional skills in the related field. This course is CPD accredited so you don’t have to worry about the quality.


Our Excel 2019 Intermediate is open to all from all academic backgrounds and there are no specific requirements to attend this course. It is compatible and accessible from any device including Windows, Mac, Android, iOS, Tablets etc.

CPD Certificate from Course Gate

At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22.

Career path

This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry.

Course Curriculum

Introduction 00:01:00
Section 01
Linking Worksheets and Workbooks 00:07:00
Linking Worksheets with 3D References 00:05:00
Understanding the Consolidate Feature 00:06:00
Section 02
What are Range Names 00:06:00
Creating Range Names Using the Name Box and Define Name 00:06:00
Creating Range Names Using Create from Selection 00:03:00
Section 03
Understanding the Differences Between Sorting and Filtering 00:03:00
Sorting Lists 00:07:00
Filtering Lists 00:06:00
Creating Subtotals 00:05:00
Section 04
Creating Tables and Understanding the Benefits 00:06:00
Understanding the Elements of a Table 00:05:00
Formatting a Table 00:05:00
Sorting and Filtering Tables 00:04:00
Filtering with Slicers 00:07:00
Calculating with Tables 00:06:00
Removing Erroneous Table Data 00:05:00
Exporting, Refreshing, and Converting Tables 00:05:00
Section 05
What is Conditional Formatting 00:03:00
Conditional Formatting-HIghlight Cells and Top Bottom Rules 00:06:00
Conditional Formatting-Data Bars, Icon Sets, and Color Scales 00:06:00
Using Custom Fonts and Colors 00:03:00
Using Custom Conditional Formatting 00:05:00
Modyfing or Removing Conditional Formatting 00:04:00
Section 06
What are Charts 00:06:00
Forecasting with Trendlines 00:05:00
Creating a Chart Template 00:04:00
Displaying Trends with Sparklines 00:08:00
Creating Charts 00:05:00
Understanding Chart Elements 00:05:00
Modifying Chart Elements 00:05:00
Changing and Moving Charts 00:03:00
Filtering a Chart 00:04:00
Formatting Charts 00:13:00
Adjusting Numbering 00:06:00
Creating Dual Axis Charts 00:05:00
Section 07
What is a PivotTable 00:05:00
Creating a PivotTable 00:07:00
Working with the PivotTable Fields Pane 00:10:00
Basic Data Organization and Analysis with PivotTables 00:08:00
Formatting PivotTables 00:05:00
Creating a PivotChart 00:04:00
Modifying and Formatting a PivotChart 00:04:00
Using Slicers and Timeline Slicers 00:08:00
Section 08
Using the PivotTable and PivotChart Wizard 00:03:00
Adding a Calculated Field 00:04:00
Adding a Calculated Item 00:04:00
Applying Conditional Formatting to a PivotTable 00:06:00
Creating Filter Pages for a PivotTable 00:04:00
Enabling the PowerPivot Add-in 00:11:00
Recap 00:02:00
Certificate and Transcript
Order Your Certificates or Transcripts 00:00:00
Excel 2019 Intermediate

Course Reviews


9 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

Excel 2019 Intermediate Take This Course

Share Link on svg


£11 /Unit Price

Buying more than one of the same courses?

  • 45% discount for orders of 10+ courses
  • 55% discount for orders of 50+ courses
  • 65% discount for orders of 100+ courses

Looking for a more personalised package?

contact us now

© Course Gate Edukite Ltd, Reg no: 11378092

Your Cart

Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £49.00per year


No more than 50 active courses at any one time. Membership renews after 12 months. Cancel anytime from your account. Certain courses are not included. Can't be used in conjunction with any other offer.