Microsoft Excel Course for Everyone - Complete Excel Course

For you
For your team

£29 ~~Was £425~~ ex VAT

93% OFF

Offer ends in

Enrol now

14-day money-back Instant access

Or get all courses for £49

£25.00 /Unit Price

£250

Quantity:

Add to Cart

Looking for a more personalised package?

Get access to 5000+ courses including this for only £49. Learn More.

Course Overview

Become a trained professional from the safety and comfort of your own home by taking Microsoft Excel Course for Everyone – Complete Excel Course . Whatever your situation and requirements, One Education can supply you with professional teaching, gained from industry experts, and brought to you for a great price with a limited-time discount.

One Education has been proud to produce an extensive range of best-selling courses, and Microsoft Excel Course for Everyone – Complete Excel Course is one of our best offerings. It is crafted specially to promote easy learning at any location with an online device. Each topic has been separated into digestible portions that can be memorised and understood in the minimum of time.

Teaching and training are more than just a job for the staff at One Education; we take pride in employing those who share our vision for e-learning and its importance in today’s society. To prove this, all learning materials for each course are available for at least one year after the initial purchase.

All of our tutors and IT help desk personnel are available to answer any questions regarding your training or any technical difficulties.

By completing Microsoft Excel Course for Everyone – Complete Excel Course, you will have automatically earnt an e-certificate that is industry-recognised and will be a great addition to your competencies on your CV.

Whatever your reason for studying Microsoft Excel Course for Everyone – Complete Excel Course, make the most of this opportunity from One Education and excel in your chosen field.

Please be aware that there are no hidden fees, no sudden exam charges, and no other kind of unexpected payments. All costs will be made very clear before you even attempt to sign up.

Course design

The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.

You are taught through a combination of

Video lessons
Online study materials

Will I receive a certificate of completion?

Upon successful completion, you will qualify for the UK and internationally-recognised CPD accredited certification. You can choose to make your achievement formal by obtaining your PDF Certificate at the cost of £9 and Hard Copy Certificate for £15.

Why study this course

It doesn’t matter if you are an aspiring professional or absolute beginner; this course will enhance your expertise and boost your CV with critical skills and an accredited certification attesting to your knowledge.

The Microsoft Excel Course for Everyone – Complete Excel Course is fully available to anyone, and no previous qualifications are needed to enrol. All One Education needs to know is that you are eager to learn and are over 16.

Course Curriculum

Section 01: Getting Started
	Introduction	00:03:00
	Course Curriculum	00:04:00
	Getting started on Windows, macOS, Android, and IOS	00:01:00
	How to ask great questions	00:02:00
	FAQ’s	00:01:00
	Starting Excel	00:04:00
Section 02: Excel Basics
	Introduction	00:02:00
	Worksheet basics	00:22:00
	Entering values and formulas	00:12:00
	Data formats	00:10:00
	Data handling basics – cut copy and paste	00:07:00
	Save and print in excel	00:10:00
	Excel Ranges	00:05:00
Section 03: Excel essential functions
	Introduction	00:01:00
	Basic formula operations	00:06:00
	Mathematical functions level 1	00:20:00
	Mathematical functions level 2	00:12:00
	Text functions level 1	00:09:00
	Text functions level 2	00:13:00
	Logical functions	00:11:00
	Date time functions	00:06:00
	V Lookup formula	00:12:00
	HLookup formula	00:04:00
	HLookup + Match formula	00:09:00
	Match + Index formula	00:05:00
Section 04: XLookup only for Excel 2021 and Office 365
	Introduction	00:02:00
	XLookup	00:08:00
	Handling #NA and Approximates match in XLookup	00:11:00
	Wildcard matching in XLookup	00:06:00
Section 05: Get Data and tools
	Introduction	00:02:00
	Split text into columns	00:07:00
	Flash Fill	00:07:00
	Remove Duplicates	00:08:00
	Data Validation	00:07:00
	Get- import Data from Text	00:06:00
	Get – import Data from CSV	00:03:00
Section 06: Formatting data and tables
	Introduction	00:01:00
	Formatting Font	00:04:00
	Formatting Alignment	00:06:00
	Formatting Number	00:05:00
	Formatting Date	00:03:00
	Formatting tables	00:05:00
Section 07: Pivot Tables
	Introduction	00:01:00
	Creating Pivot Table	00:07:00
	Value field settings	00:04:00
	Number format	00:02:00
	Pivot Table Design	00:03:00
	Excel Exercise	00:01:00
	Solution for Excel Exercise	00:02:00
Section 08: Excel Charts
	Introduction	00:01:00
	Excel Charts – Categories	00:03:00
	Elements of a chart	00:04:00
	Easy way to create charts	00:02:00
	Column or Bar charts	00:04:00
	Formatting charts	00:04:00
	Line charts	00:02:00
	Area charts	00:02:00
	Pie and Doughnut charts	00:04:00
	Format AreaPlot or XY chart	00:08:00
	Scatter or bubble charts	00:02:00
Section 09: Advanced Excel charts
	Introduction	00:01:00
	Frequency Distribution and Histograms	00:04:00
	Waterfall charts	00:02:00
	Hierarchy charts: sunburst and tree map	00:03:00
	Combination charts	00:02:00
	Sparklines	00:05:00
Section 10: Pivot Charts
	Pivot charts	00:02:00
Section 11: Maps Chart above 2019
	Maps chart	00:04:00
	3D Maps chart	00:03:00
Section 12: Business-Geo charts
	Introduction	00:01:00
	Stock charts	00:02:00
	Radar charts	00:02:00
	Surface charts	00:02:00
	Heat maps	00:04:00
Section 13: Named Ranges
	Named ranges	00:05:00
	Indirect Name range Function	00:06:00
Section 14: Import Data into Excel
	Import Data table from PDF file – Excel 2021	00:04:00
	Import Data from Website – Excel 2019 above	00:09:00
Section 15: Advanced Excel
	Project: Sales forecast tracker	00:07:00
	Product Sale Tax invoice: Tax Calculations	00:05:00
Resources
	Resources	00:00:00
Order Your Certificate
	Order Your Certificate Now	00:00:00