Excel 2019 Intermediate

Excel 2019 Intermediate

get Access To All 3500+ One Education Courses For Just £49/Year!
Claim Offer

Overview

Take steps to become fully proficient in Excel, with the Excel 2019 Intermediate course.

This instructor-led video course will take you through the basic functions, features and tools of the 2019 version of Excel. Through step-by-step guidance, you will learn how to perform a range of procedures that will set you up to become an expert in Excel in no time. From creating your first workbook and entering data, to familiarising with the Quick Access toolbar, this course provides straightforward instructions for complete beginners.

This course is an internationally-recognised qualification, and is ideal for those who have little to no working knowledge of Excel, who want to learn how to perform basic tasks and familiarise with the Excel interface. 

Why People Love and Enrol in The Excel 2019 Intermediate from One Education

Description

Here at One Education, we put our heart and soul into every single course we design. We make sure that all our courses are designed and developed by industry experts. Our aim is to always provide value to our learners with quality courses.

Our learners are our top priority, and you as a learner will gain tremendous knowledge and skill on this topic from this Excel 2019 Intermediate.

The certification that you will receive upon completing this Excel 2019 Intermediate will help to boost your resume and will help you stand out among your peers in the competitive job market.

Our course will help you get employed in the relevant field and advance your career. Enjoy this expertly made course from One Education. Enrol now!

Course Benefits

Method of Assessment

To assess your learning, you have to participate in an automated multiple-choice question exam. You have to score at least 60% to pass the exam and to qualify for CPD accredited certificates. After passing the exam, you will be able to apply for a certificate.

Certification

After completing the MCQ assessment, you will qualify for the CPD Certificate from One Education, as proof of your continued professional development. Certification is available in PDF format, for £9, or a hard copy can be sent to you via post, for just £15.

Who is this course for?

This Excel 2019 Intermediate is ideal for

Requirements

There are no specific prerequisites to enrol in this Excel 2019 Intermediate. Anyone and everyone can take this course.

The Excel 2019 Intermediate is fully accessible from any internet-enabled smart device. So, you can study from the comfort of your home!

All you need is a passion for learning, literacy, and to be over the age of 16.

Career path

This Excel 2019 Intermediate will help you procure a job in the relevant field and will allow you to advance your career. Many job roles will be available for you to explore after completing this course. This Excel 2019 Intermediate also increases your competency to be eligible for promotions at work.

Enrol now to this comprehensive course from One Education and take your career to the next step.

Course Curriculum

Intro
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:04:00
Creating Filter Pages for a PivotTable 00:04:00
Enabling the PowerPivot Add-in 00:11:00
Recap
Recap 00:02:00
sidemoneyBack

COPYRIGHT © 2022 One Education

Home Search Cart
2
  • Item added to cart
  • Item added to cart
2
Your Cart
Objectives and Key Results (OKR)

Objectives and Key Results (OKR)
- +
£29
Get A PDF Certificate & Transcript After You Complete Your Course

Scholarship: Score 80% or more in your final exam to get this Fee refunded.

New Certificate On A Table
- +
£9.99

Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £49/year

Claim Offer & Upgrade

Membership renews after 12 months. You can cancel anytime from your account.

Other Students Also Buy
    Apply Coupon