Microsoft Excel - Excel from Beginner to Advanced & VBA
4.3 (352 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3,269 students enrolled

Microsoft Excel - Excel from Beginner to Advanced & VBA

Master Excel with this A-Z Microsoft Excel Course (Microsoft Excel 2013, Excel 2016, and Excel 2019)
4.3 (352 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3,269 students enrolled
Created by Brian Wells
Last updated 9/2019
English
English, French, 3 more
  • Indonesian
  • Portuguese
  • Spanish
Current price: $126.99 Original price: $194.99 Discount: 35% off
15 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 9.5 hours on-demand video
  • 93 downloadable resources
  • 2 Practice Tests
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Master Excel from Beginner to Advanced + Macros & VBA!
  • Learn Excel Formulas & Functions and perform complex Calculations
  • Create dynamic reports by mastering one of the most popular tools, Pivot Tables
  • Build a solid understanding on the Basics of Microsoft Excel
  • Wow your boss by unlocking dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more
  • Build a solid understanding of Microsoft Excel and develop detailed knowledge in complicated real world Excel scenarios
  • Harness the full power of Microsoft Excel by automating your day to day tasks through Macros and VBA
  • Maintain large sets of Excel data in a list or table
  • My personal Excel keyboard shortcuts CHEATSHEET!
  • Access to a professional trainer with 12+ years of Excel training
Requirements
  • No prior knowledge of Microsoft Excel is needed! This course is designed to teach you every aspect that you need to graduate from a beginner to advanced user of Excel.
Description

★★★★★ Course access includes the exact files I use to download and follow along, 1 on 1 Instructor support, lifetime access and a 30 day money back guarantee ★★★★★

Welcome to our course on Microsoft Excel from Beginner to Advanced.

⇉ This course is MASSIVE! You receive 9.5 hours of video content & 138 lectures!

By Enrolling in this course you get instant life-time access to all four levels of Microsoft Excel!

  1. Beginner

  2. Intermediate

  3. Advanced

  4. Excel Macros & VBA.

This Microsoft Excel course combines the basic fundamentals to the most advanced features, after taking this online class you will be able to use Microsoft Excel at an expert level. You can learn Microsoft Excel easily and quickly if it is taught correctly. Developed by a Microsoft Certified Master Instructor, this course provides comprehensive coverage on Microsoft Excel.

As an additional bonus, you can download all of the Excel project files that are used in the videos so that you can get a “hands-on” approach to learning the material. You will also be shown how to find and download free "Excel templates" which are spreadsheet templates that you can use like "budget templates" or a "calendar template" or a "schedule template."

PLUS included in this course is 84 Excel Shortcuts that will increase your everyday speed using Microsoft Excel.

Another great aspect of this course is that, at the end of this Excel class, you will be given a CERTIFICATE OF COMPLETION. This course has a quiz after every video so if you need to prove that you have learned the material, or if you’re an employer or supervisor that needs to ensure that someone has actually done the work, this is easily done by looking at the results of these quizzes.

This class is guaranteed to teach you Microsoft Excel. Once enrolled, you will have access to this Excel course for the rest of your life. You will always be able to come back to this Excel class to review material or to learn new material about how to use Excel. 

⇉ Watch the promo video to see How Quickly You Can Begin to Master Microsoft Excel!

Enrol now and transform your abiliy to use Microsoft Excel.

Who this course is for:
  • This Microsoft Excel course will take you through 4 levels of Microsoft Excel topics (Beginner, Intermediate, Advanced and Macros/VBA).
  • If you want to learn Microsoft Excel at a beginner, intermediate, and pro level then this course was made just for you.
Course content
Expand all 138 lectures 09:36:20
+ Welcome To Your Excel Course!
1 lecture 01:11

Welcome to your new Microsoft Excel course! We are looking forward to getting started and if you ever have any questions please feel free to reach out! P.S You can control the speed of all video lectures directly on the video player on the bottom if you feel that the speed is too fast at times. All the best!

Preview 01:11
+ Introduction: Microsoft Excel for Beginners
9 lectures 42:16
Getting To Know Excel: Introduction
01:13

Identify the terminology and elements of the Ribbon.

Preview 06:06

Learn how to customize the quick access toolbar.

Preview 04:00

Navigate Excel quickly with Tab & Enter.

Using Tab & Enter to Navigate the Spreadsheet
02:03

Learn the most efficient way to save an Excel document.

Saving An Excel Document
02:04

Recognize the main terms used to describe Excel’s work canvas.

The Worksheet
05:45

Utilize the keyboard or mouse to select cells and ranges in a spreadsheet.

Navigation
07:28

Format cells by selecting fonts and color fills to make information more attractive.

Formatting Excel
08:01

Utilize basic mathematics including multiplication and division in Excel.

Basic Math
05:36
Getting To Know Excel: Quiz
10 questions
+ Modifying an Excel Worksheet
6 lectures 18:30
Modifying an Excel Worksheet: Introduction
00:36

Learn how to insert and delete rows and columns with Excel shortcuts.

Inserting and Deleting Rows and Columns
03:31

Learn how to change the width and height of cells in Microsoft Excel.

Changing the Width and Height of Cells
03:07

Learn how to effectively hide and unhide rows and columns in Excel.

Hiding and Unhiding Excel Rows and Columns
04:08

Learn how to quickly rename an Excel worksheet.

Renaming an Excel Worksheet
04:51

Learn how to delete a worksheet.

Deleting an Excel Worksheet
02:17
Modifying an Excel Worksheet: Quiz
4 questions
+ Practice Test 1: Microsoft Excel Beginner Level
0 lectures 00:00

Welcome to the first practice test in your Microsoft Excel course. In this test you will be required to use the previous skills you have learned up until this point to solve or think through different scenarios in Microsoft Excel.

I encourage you to try and answer these questions without referring back to the lesson on your first try.

Goodluck.

Microsoft Excel Beginner Level Test
6 questions
+ Formatting Data in an Excel Worksheet
8 lectures 23:23
Formatting Data in an Excel Worksheet: Introduction
00:46

Learn about different font commands.

Working With the Font Commands
02:57

Learn how to add dynamic and beautiful borders to your cells, columns, and rows.

Adding Borders to Cells
05:22

Learn how to change the background colour of your cells.

Changing the Background Colour of a Cell
05:22

Learn how to properly format your cells in the currency format.

Formatting Data in Currency
03:26

Learn how to format your data in the percentage format.

Formatting Data in Percentages
01:54

Learn how to use the Excel Format Painter.

Using Excel Format Painter
01:25

Learn how and when to merge and centre your cells.

Merge & Centre Cells
02:11
Formatting Data in a Excel Worksheet: Quiz
2 questions
+ Excel Templates
3 lectures 10:49

Discover Microsoft Excel templates.

Intro to Excel Templates
01:21

Learn how to use an existing Excel template.

Using an Existing Excel Template
05:40

Learn how to create and save your own custom template for future use.

Preview 03:48
Excel Templates
2 questions
+ Printing an Excel Worksheet
6 lectures 20:43
Printing an Excel Worksheet: Introduction
01:45

Learn how to change the margins, scaling, and orientation of your spreadsheets before your print them.

Change the Margins, Scaling, and Orientation
06:06

Learn how to locate the print preview section, and make necessary edits.

Viewing your Document in Print Preview
04:08

Learn all the aspects of laying out your page before printing!

Page Layout View
03:35

Add a customer header and footer to your Excel spreadsheets!

Adding a Header and Footer Content
02:00

Print a specific range of cells from an Excel spreadsheet.

Printing a Specific Range of Cells
03:09
Printing an Excel Worksheet
2 questions
+ Microsoft Excel Charts
5 lectures 24:42
Microsoft Excel Chart: Introduction
00:35

Learn how to create an effective column chart by reducing ink and 'noise' that distract from the main messages.

Building A Column Chart
05:33

How to create an effective bar chart by reducing ink and noise that distract from the story.

Building A Bar Chart
03:51

Learn how to build an effective pie chart, and when you should and shouldn’t use them.

Building A Pie Chart
09:25

How to create an effective line chart through careful manipulation of chart elements to enhance its story telling ability.

Building A Line Chart
05:18
Excel Charts: Quiz
4 questions