Excel 2019 Intermediate
Excel 2019 Intermediate
PRIVATE
Save nan % - NEW YEAR SALE
OR
Or
Take All courses for £49
1 Year Access 
Intermediate
4 Students -
4 hours, 37 minutes
Get access to 5000+ courses including this for
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
- Instantly accessible CPD-accredited certificate on successful completion of this Excel 2019 Intermediate
- 24/7 access to the course for 12 months
- Study at your own pace
- No hidden fees or exam charges
- Full Tutor support on weekdays (Monday – Friday)
- Efficient assessment and instant results
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
- Instant access to information about scientific investigation techniques
- Full participation in crime detection exercises
- Quick assessment and guidance for all assignments
- CPD accreditation for proof of acquired skills and knowledge
- Freedom to study in any location and at a pace that suits you
- Expert support from dedicated tutors committed to online learning
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
- Students
- Recent graduates
- Job Seekers
- Anyone interested in this topic
- People already working in this field and aspiring to polish their knowledge and skill.
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 | ||
With a team of industry professionals producing and delivering our course content, you can be sure the skills and knowledge you learn are applicable to your career aspirations, whether that’s in management, administration or beyond.
