Microsoft Excel Course for Everyone - Complete Excel Course

Description

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!

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.

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.

After completing this course, it will increase the value of your CV and open you up to multiple sectors, such as :

These salary ranges can vary based on factors such as experience, location, and the specific industry of the business.

15 sections • 80 lectures • 06:51:00 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