Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Microsoft Excel - basics to expert

Name: Microsoft Excel - basics to expert
Rating: 4.6 (79 reviews)

Summer 2023 Revision | FREE PDF Certificate | Accredited 25 CPD Hours | Lifetime Access

Created byVnnergy LLC

Last updated 2/2022

English

What you'll learn

This Excel course is created on latest version Office 365 however it covers all functions of Excel 2013, 2016 and 2019.
Access to a Professional Trainer with 15+ years of Excel Training experience.
Gain a comprehensive understanding of MS Excel best practices.
Apply your knowledge post every module with exercises.
Managing large sets of data
Creating effective spreadsheets
Mastering the use of some of Excel's most popular and highly sought-after functions (SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH and many more...)
Format and make your data more presentable
Audit Excel Worksheet formulas to ensure clean formulas
Use Charts and Tables - make your reports and dashboard visually appealing

Course content

17 sections • 122 lectures • 16h 53m total length

An Introduction to Excel for Beginners4:53
Introduce the fundamentals of Microsoft Excel for beginners, including interface basics, data entry, formatting, formulas and functions, lists and tables, sorting, filtering, and basic charting.

Launching Excel8:59
Starting Up Excel and the Startup Screen
Section Resources0:04
This lecture contains the resources and files which have been used in the lectures in Section 2
Introduction to the Excel Interface12:22
The Different Elements of the Excel Interface
Ribbons and Tabs11:47
Understanding the Ribbon Structure, Contextual Ribbons, Groups and Commands
The Backstage Area8:57
File Menu and Options
The Quick Access Toolbar9:04
Customizing the Quick Access Toolbar
Useful Keyboard Shortcuts9:20
A Summary of Useful Keyboard Shortcuts
Getting Help14:58
The Help Ribbon, Search Box and Contextual Help
Contextual Menus and the Mini Toolbar6:30
Using contextual menus and the mini-toolbar
Status Bar6:16
Customizing the Status Bar
Exercise 013:39

Working with Templates16:11
Exploring the Templates available in Excel
Section 2 Resources0:04
This lecture contains the resources and files which have been used in the lectures in Section 3
Working with Workbooks and Worksheets15:43
Creating New Workbooks and Worksheets
Saving your Excel Spreadsheet13:31
How to Save a Workbook locally and to the cloud
Custom Lists and Series Fill7:46
Viewing, creating and using Custom Lists
Entering and Editing Data11:38
Entering and editing data in a spreadsheet
Basic Number Formatting12:36
Basic Number Formatting
Navigating and Selecting Cells and Ranges10:05
How to navigate around a spreaedsheet
Exercise 036:54
Create an invoice template, build a multi-sheet workbook, enter 2019 sales data with accounting format, and save template to default template folder and workbook to the Excel practice folder.

Introduction to Functions and Formulas15:02
Explanation of the difference between Formulas and Functions.
Section 4 Resources0:04
This lecture contains the resources and files which have been used in the lectures in Section 4
The Order of Calculation9:57
BODMAS Principle
Counting Items in a List8:49
COUNT and COUNTA Functions, Functions Dialog Box
Finding Averages10:52
AVERAGE Function
Finding the Minimum and Maximum Value7:44
MIN and MAX Functions
Using Multiple Functions in a Formula11:27
SUM and AVERAGE, MIN and SUM
Errors in Calculations11:14
Error Resolution, NAME and DIV errors
Relative, Absolute and Mixed Referencing14:40
Understand the different between absolute and relative referencing
Exercise 046:05
AutoSum, Autofill

Creating Named Ranges6:47
Define Name, Create from Selection
Section 5 Resources0:04
This lecture contains the resources and files which have been used in the lectures in Section 5
Managing Named Ranges5:47
Name Manager
Using Named Ranges in Formulas9:02
Named Ranges, F3 key
Named Ranges Tips and Tricks7:04
Apply Names, Zoom Out, List names
Exercise 056:15
Name all ranges on the customer data worksheet, set a tax rate as a named range, and replace formulas with named ranges for totals, min, max, and counts.

Formatting Numbers13:50
Number Formatting
Section 6 Resources0:04
This lecture contains the resources and files which have been used in the lectures in Section 6
Formatting Dates11:12
Date Formatting
Applying Formatting to Cells18:15
Font, Borders, Background Fill
Formatting Columns and Rows15:32
Column/row width/height, formatting
Alignment12:42
Alignment Options
Deleting and Clearing Formatting8:25
Deleting and clearing the contents of cells
Themes and Styles12:21
Applying themes and using styles
Using the Format Painter8:14
Format Painter
Exercise 068:47

How to Structure a List12:16
Headings, Blank Rows
Section 7 Resources0:04
This lecture contains the resources and files which have been used in the lectures in Section 7
Sorting a List (Single-level sort)15:47
Sorting a list using one-column
Sorting a List (Multi-level sort)11:07
Sorting a list using multiple-columns
Sorting using Custom Lists4:49
Custom Lists
Using Auto-Filter to Filter a List13:15
Auto-Filter
Format As a Table14:21
Format as a Table, Filter
Creating Subtotals in a List11:13
Subtotals
Flash Fill8:29
Flash Fill
Exercise 075:41
Format the data as a table named invoices_20-20, then sort by month, invoice total, and status, filter invoices over 3000 with past due, and subtotal monthly totals.

Cut Copy and Paste Basics7:39
The different ways to Cut and Copy
Section 8 Resources0:04
This lecture contains the resources and files which have been used in the lectures in Section 8
Paste Options10:43
Paste Options; Values Only, Transpose, Formatting etc
Using the Clipboard7:56
Copying and Pasting Items from the Clipboard
Linking to cells in other Worksheets9:38
Linking to Cells
3D Referencing9:17
Linking across numerous worksheets
Inserting Hyperlinks to Worksheets11:18
Inserting links to other worksheets and workbooks
Exercise 086:28
Practice linking data in Excel with paste options, preserve column widths, paste values, and transpose; create subtitles, link totals, add a hyperlink to summary, and apply 3D referencing across worksheets.

The VLOOKUP Function (Exact Match)10:08
Looking up information with VLOOKUP Exact Match
Section 9 Resources0:04
This lecture contains the resources and files which have been used in the lectures in Section 9
The VLOOKUP Function (Approx Match)7:08
Looking up information with VLOOKUP Approx Match
The HLOOKUP Function7:42
Lookup up information with HLOOKUP
Error Handling in Formulas12:30
IFERROR, IFNA
Logical Functions - Part 18:27
Understanding Logical Functions. AND, OR, TRUE, FALSE
Logical Functions - Part 212:21
IF Command
COUNTIF and SUMIF7:10
COUNTIF, SUMIF
Text Functions14:19
PROPER, UPPER, LOWER, MID, TRIM, LEFT, RIGHT, FIND
Date and Time Functions11:55
DATE, DAY, MONTH, HOUR, WORKDAY, TODAY, NOW, NETWORKDAYS
Exercise 0913:05
Practice applying vlookup, countif, logical and text functions in Excel by creating tables and named ranges, using data validation, and analyzing student scores, retakes, and venue options.

Creating Charts to Present Data9:36
Creating a Chart from a Dataset
Section 10 Resources0:04
This lecture contains the resources and files which have been used in the lectures in Section 10
Formatting a Chart11:21
Format a Chart, Add Chart Elements, Modidy the Design
Other Useful Charts14:01
Map Charts, Trendlines, 3D Charts, Donut Charts
Updating Charts4:26
Formatting as table
Exercise 105:20
Format data as a table top five physics, filter to top five students, and create a 2D clustered column chart with a chart title and axis labels.

Requirements

Internet connection.

Description

Excel is the most in commonly used and in-demand tool for making sense of data. When you can harness that power, you will be a sought after employee and YOU CAN EARN MORE MONEY!.

If you run a business, being proficient in Excel can help you see your business in a completely different light.

Congratulations!

If you are reading this, you have already taken your first important step. You want to learn Excel from the ground up, and go from a complete beginner, to a super user, to being part of the few Excel Elite, and being able to program your very own full blown applications.

This complete course contains all the lectures, quizzes, projects, and downloadable resources. In fact, everything you will need to go from novice to coder! There's no need to buy one course after another to become an Excel master...it's all here!

Enroll now to go through a deep dive of the most popular spreadsheet tool on the market, Microsoft Excel. As your instructor, I will use my 15+ years of Excel training to guide you step by step through the beginner to advanced level and beyond.

As you participate in the course you will master Excel tools that will clear away the pain of stumbling through your daily tasks. You will start with the basics, building a solid foundation that will give you further knowledge as you progress into intermediate and advanced level topics.

At completion of this course you will have mastered the most popular Excel tools and come out with confidence to complete any Excel tasks with efficiency and grace. Below are just a few of the topics that you will master:

Creating effective spreadsheets
Managing large sets of data
Mastering the use of some of Excel's most popular and highly sought after functions (SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH and many more...)
Create dynamic report with Excel PivotTables
Unlock the power and versatility of Microsoft Excel's Add-In, PowerPivot
Audit Excel Worksheet formulas to ensure clean formulas
Automate your day to day Excel tasks by mastering the power of Macros and VBA

So, what are you waiting for, enroll now and take the next step in mastering Excel and go from Excel Newbie to Excel Guru!

Who this course is for:

This course is intended for anyone who seeks to develop one of the most critical and fundamental digital skills today.
Master Excel skills which you require in your day to day activity in office.

Microsoft Excel - basics to expert

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 5min

Excel Basic Skills11 lectures • 1hr 32min

Creating Your First Excel Spreadsheet9 lectures • 1hr 34min

Introduction to Excel Formulas and Functions10 lectures • 1hr 36min

Named Ranges6 lectures • 35min

Formatting Numbers, Cells and Worksheets10 lectures • 1hr 49min

Working with Excel Lists10 lectures • 1hr 37min

Moving and Linking to Data8 lectures • 1hr 3min

Useful Functions11 lectures • 1hr 45min

Analyzing Data with Charts6 lectures • 45min

Requirements

Description

Who this course is for: