The Complete Microsoft Excel Course for 2023

Name: The Complete Microsoft Excel Course for 2023
Rating: 4.0 (5 reviews)

Excel with this A-Z Microsoft Excel Course. Microsoft Excel 2010, 2013, 2016, Excel 2019 and Microsoft/Office 365

Created byKevin Cullen

Last updated 3/2023

English

What you'll learn

Microsoft Excel Basics and User Interface
How to perform basic and complex calculations in Excel
How to plot graphs and charts in Excel
How to create Microsoft Excel Spreadsheets
How to create and manipulate Pivot Tables

Course content

1 section • 7 lectures • 1h 9m total length

Introduction16:49
This lesson provide a basic introduction to Microsoft Excel.
In this lesson you will learn:
How to navigate through Microsoft Excel
How to enter and format data
How to perform basic calculations
Excel Introduction - Graphs and Charts14:58
This lesson provide an introduction to plotting graphs and charts in Microsoft Excel
In this lesson you will learn:
How to plot various types of graphs
How to plot pie charts
How to format graphs and charts
Excel Introduction - Conditional Formatting7:15
This lesson provide an overview of conditional formatting in Microsoft Excel.
In this lesson you will learn:
How to assign conditional formatting to a data set
How to modify and update conditional formatting
Excel Introduction - VLookups3:48
This lesson provides an overview of the VLookup function in Microsoft Excel.
In this lesson you will learn:
How to perform the Vlookup function in Microsoft Excel
Why the Vlookup function in an incredibly powerful tool in Microsoft Excel
Excel Introduction - Tips, Tricks and Shortcuts3:56
This lesson provide an overview of some tips, tricks and shortcuts for Microsoft Excel.
In this lesson you will learn:
Keyboard shortcuts for various Microsoft Excel functions
Tips and tricks for Microsoft Excel
Excel Introduction - Pivot Tables12:22
This lesson provide an overview of the Pivot Table function for Microsoft Excel.
In this lesson you will learn:
How to create Pivot Tables in an Excel worksheet
Why Pivot Tables are an extremely powerful tool in Microsoft Excel
How to manipulate Pivot Tables to quickly display valuable information
How to create graphs from Pivot Tables
Excel Introduction - Mood Tracker Example10:38
This lesson provides a useful example that highlights many of the features we have learned throughout this Microsoft Excel course.
In this lesson you will learn:
How to create a Daily/Monthly Mood Tracker chart
How to put a lot of the features we have learned into a working model
Excel Progress Quiz

Requirements

Basic computer skills required in order to open Microsoft Excel application
A learning mindset is benificial
No other material is required

Description

Over 750 million people have Excel on their computers, but most don't know how to use it!

This might be because Excel can come across as being a little awkward with first-time users.

This Microsoft Excel course is aimed at Beginner to intermediate Microsoft Excel users. It will allow students to become familiar with this program. No previous Microsoft Excel experience is required in order to attend this course. It will start at a very basic level and allow students to learn Microsoft Excel at their own pace. Then, we'll start diving into other areas of Excel to really start sharpening the skills you would have already learned, along with learning some new things as well.

In this course you will learn:

How to become familiar with and navigate through Microsoft Excel
How to create spreadsheets that can be easily modified
How to enter and format data into Microsoft Excel
How to create various graphs and charts from data
How to perform basic and complex calculations
How to create complex pivot tables in order to analyse data

What do you get when you enroll:

- A 30-day money-back guarantee, so you can enroll risk-free.

- A lifetime access guarantee so you can re-visit the course whenever you want.

- A certificate of completion to add to your resume/CV.

I have been learning and using Microsoft Excel for over 20 years and I hope to using this experience to help student become more familiar with this amazing program.

Please feel free to reach out if you have any questions or comments about this course. Feedback is always welcome as I hope to ensure that this course meets the highest standards.

Who this course is for:

Beginner Microsoft Excel Users