No products in the basket.
LOGIN

Welcome to

Course Cloud

the best place for online learning!

Keep me logged in

Forgot Password?

Don’t have an account yet? Sign Up

Already have an account? Log In

By signing up, I accept Course Cloud’s Terms & Conditions

Microsoft Excel 2019 Intermediate Diploma

What Will I Learn? Create and use named ranges Sort and filter columns of data Create and modify charts and …

★ ★ ★ ★ ★

4.7(11 reviews)

26 enrolled on this course

What Will I 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, and more!

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 Overview

A survey in the Uk shows that the total number of skills required for a single job has increased by 10% year-over-year since 2017. Furthermore, one in three skills in an average 2017 job posting are already obsolete. Due to ongoing business disruption and rapidly evolving needs, emerging skills gaps have accelerated due to the COVID-19 pandemic.

And to help you bridge that gap, Course Cloud has prepared this comprehensive Microsoft Excel 2019 Intermediate Diploma online course. Microsoft Excel 2019 Intermediate Diploma covers a collection of necessary skills required to help you achieve your goals. In addition, our industry professionals will guide you through the process of establishing a solid foundation in Microsoft Excel 2019 Intermediate Diploma.

The Microsoft Excel 2019 Intermediate Diploma course is broken down into manageable sections, each of which will provide you with a new level of expertise. Our exclusive training in Microsoft Excel 2019 Intermediate Diploma will equip you with the skills required to set yourself up for career success.

The Microsoft Excel 2019 Intermediate Diploma provides internationally accepted certification upon successful completion. This certificate will add value to your resume and let you stand out among your peers. So enrol now and work your way towards becoming a highly sought-after professional at Microsoft Excel 2019 Intermediate Diploma.

Preview

Certification

After successfully completing the course, you will be able to get the UK and internationally accepted certificate to share your achievement with potential employers or include it in your CV. The PDF Certificate + Transcript is available at £6.99 (Special Offer - 50% OFF). In addition, you can get a hard copy of your certificate for £12 (Shipping cost inside the UK is free, and outside the UK is £9.99).

Course Curriculum

Unit 01: Intro to Excel Functions
	Excel Functions Explained	00:03:00
	The SUM() Function	00:08:00
	The MIN() & MAX() Function	00:04:00
	The AVERAGE() Function	00:02:00
	COUNT() Functions	00:05:00
Unit 02: Visually Pleasing Cell Formatting
	Formatting Fonts and Cell Background Color	00:05:00
	Adding Cell Borders	00:05:00
	Formatting Data Appropriately	00:05:00
	The Magic behind Excel’s Format Painter	00:04:00
	Creating Styles for Formatting Efficiency	00:06:00
	Merging Cells for a Cleaner Look	00:03:00
	The Power of Conditional Formatting	00:06:00
Unit 03: How to Insert Images and Shapes!
	Grab User’s Attention using Illustrations	00:09:00
	Customizing Icons	00:05:00
	Create Compelling Graphics with SmartArt	00:06:00
Unit 04: Visualize Data with Charts
	The Commonly Used Column Chart	00:03:00
	Changing the Chart Design	00:02:00
	Formatting Elements of a Chart	00:06:00
	Modifying the Data, Type & Location of a Chart	00:06:00
Unit 05: Working with Excel Datasets
	How to Prepare Data for Analysis	00:04:00
	How to Sort Data in Excel	00:03:00
	Multi-Level Sorting	00:03:00
	Custom Sorting Datasets in Excel	00:02:00
	Applying Filters to Datasets	00:05:00
	Creating Subtotals within a Dataset	00:06:00
	Converting Datasets into Tables	00:06:00
	Finding & Removing Duplicate Values	00:07:00
Unit 06: Excel Database Functions
	The SUMIF() Function	00:09:00
	The DSUM() Function	00:08:00
	The DSUM() Function Cont.	00:07:00
	The SUBTOTAL() Function	00:06:00
Unit 07: Excel PivotTables
	Creating an Excel Pivot Table	00:06:00
	Modifying Excel PivotTables	00:06:00
	Grouping & Filtering PivotTable Data	00:07:00
	Drilling Down into PivotTable Data	00:02:00
	Creating Pivot Charts & Utilizing Slicers	00:08:00
Unit 08: Excel’s PowerPivot Add-In
	What is PowerPivot?	00:04:00
	Activating the Excel PowerPivot Add-In	00:02:00
	Creating Relationships between Data Tables	00:06:00
	Using Data Models to Create PivotTables	00:05:00
	How to Create PowerPivot KPI’s	00:08:00
Unit 09: Excel’s Conditional Functions
	Excel’s IF() Function	00:05:00
	IF() Function with AND() Criteria	00:05:00
	IF() Function with OR() Criteria	00:05:00
	Nesting Multiple IF() Functions	00:07:00
	The COUNTIF() Function	00:04:00
	Key Benefits of Named Ranges	00:04:00
Unit 10: Excel’s Lookup Function
	VLOOKUP() Function	00:09:00
	The Beauty of Excel’s IFERROR() Function	00:04:00
	HLOOKUP() Function	00:06:00
	INDEX() Function	00:05:00
	MATCH() Function	00:05:00
	INDEX() and MATCH() Combined	00:05:00
	Two-Way Lookup with INDEX() and MATCH()	00:04:00
Unit 11: Text Based Functions in Excel
	LEFT(), RIGHT() and MID() Function	00:07:00
	Extracting Specific Text using LEN() & SEARCH()	00:15:00
	Combining Text with CONCATENATE()	00:06:00
	Quick Tips & Other Text Based Functions	00:06:00