Overview
This Microsoft Excel Course for Everyone – Complete Excel Course is your passport to spreadsheet mastery.
Explore Excel in detail and improve your abilities with practical activities that go beyond boring lectures. Take on spreadsheets like an expert, from data entry to difficult formulas and eye-catching graphics.
But the magic doesn’t end there! After finishing successfully, you’ll not only impress with your proficiency with Excel, but you’ll also obtain a respected CPD certification to enhance your CV and make a statement in the job market. Consider it your golden ticket to go up in your job!
Enrol right away to see how your confidence and chances rise! Don’t wait!
How will I get my certificate?
You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate.
Who is This course for?
There is no experience or previous qualifications required for enrolment on this Microsoft Excel Course for Everyone – Complete Excel Course. It is available to all students, of all academic backgrounds.
Requirements
- Compatible with a wide range of gadgets, including smartphones, tablets, laptops, Macs, and PCs.
- Particularly designed to be easily accessed with an internet connection on tablets and smartphones.
- No strict deadlines; learn whenever it’s convenient for you.
- Individuals with basic English proficiency.
Career Path
After completing this course, it will increase the value of your CV and open you up to multiple sectors, such as :
- Data Analyst: £25,000 – £50,000 per year
- Financial Analyst: £30,000 – £60,000 per year
- Operations Manager: £35,000 – £70,000 per year
- Accountant: £25,000 – £50,000 per year
- Business Intelligence Analyst: £35,000 – £65,000 per year
These salary ranges can vary based on factors such as experience, location, and the specific industry of the business.
Course Curriculum
- 15 sections
- 80 lectures
- 6 hours, 51 minutes total length
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
Pivot charts 00:02:00
-
Maps chart 00:04:00
-
3D Maps chart 00:03:00
-
Introduction 00:01:00
-
Stock charts 00:02:00
-
Radar charts 00:02:00
-
Surface charts 00:02:00
-
Heat maps 00:04:00
-
Named ranges 00:05:00
-
Indirect Name range Function 00:06:00
-
Import Data table from PDF file – Excel 2021 00:04:00
-
Import Data from Website – Excel 2019 above 00:09:00
-
Project: Sales forecast tracker 00:07:00
-
Product Sale Tax invoice: Tax Calculations 00:05:00
Frequently Bought Together
5 course rating - 1 review
£12.99
£419
This course includes:
-
Duration:6 hours, 51 minutes
-
Access:1 year access
-
Units:80
-
Level:Advanced
-
CPD Points:10
-
Certificate:Yes
