Learn Excel - The Excel Tutorial for Beginners
4.4 (120 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.
12,717 students enrolled

Learn Excel - The Excel Tutorial for Beginners

Excel training covering Microsoft Excel basics, Excel formulas, Excel functions, formatting, graphics, & layout
4.4 (120 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.
12,717 students enrolled
Created by Todd Enso McLeod
Last updated 11/2017
English
English [Auto]
Current price: $23.99 Original price: $34.99 Discount: 31% off
23 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 8.5 hours on-demand video
  • 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
  • Learn how to navigate around Excel
  • Learn how to enter and edit data in Excel
  • Learn how to adjust the way data and information are displayed in Excel
  • Learn how to write formulas quickly and easily with the point-and-click method
  • Learn how to use relative, absolute, and mixed references in Excel
  • Learn how to create powerful calculations with Excel functions
  • Learn how to format worksheets in Excel for impact and appeal
  • Learn how to "transpose data" - switching the columns and rows in Excel
  • Learn how to use "paste special" to copy data from the web and get it into Excel
  • Learn how to insert pictures, shapes, word art, symbols, hierarchy charts & relationship charts
  • Learn how to include hyperlinks to external resources and call-out text boxes
  • Learn tips and tricks about Excel, as well as Excel shortcuts
  • Learn the fundamentals of using Microsoft Excel
Requirements
  • All versions of Microsoft Excel work for this course. The instructor will be using Microsoft Excel 2016.
Description

You can learn Microsoft Excel easily and quickly if it is taught correctly.

Developed by a Microsoft Certified Master Instructor, this course provides a solid introduction to the fundamental skills necessary to use Microsoft Excel. Taught by a university professor with over twenty years of experience teaching individuals of all ability levels "how to use" Microsoft Excel, Todd McLeod has designed, refined, and perfected this course to make it easy for you to learn Microsoft Excel.

Providing a comprehensive curriculum of 92 video lectures, including 45 hands-on exercises, you will learn all of the following about Microsoft Excel:

  • Learn how to navigate around Excel

  • Learn how to enter and edit data in Excel

  • Learn how to adjust the way data and information are displayed in Excel

  • Learn how to write formulas quickly and easily with the point-and-click method

  • Learn how to use relative, absolute, and mixed references in Excel

  • Learn how to create powerful calculations with Excel functions

  • Learn how to format worksheets in Excel for impact and appeal

  • Learn how to "transpose data" - switching the columns and rows in Excel

  • Learn how to use "paste special" to copy data from the web and get it into Excel

  • Learn how to insert pictures, shapes, word art, symbols, hierarchy charts & relationship charts

  • Learn how to include hyperlinks to external resources and call-out text boxes

  • Learn tips and tricks about Excel, as well as Excel shortcuts

As bonus material, you will also be provided with 

  • a comprehensive set of 45 "hands-on exercises"

  • solutions to all of the "hands-on exercises"

If you need to prove that you have learned the material, or if you are 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 "hands-on exercises."

As an additional bonus, you can download all of the Excel project files that are used in the videos.

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. Described as “fun” and “amazing” and “life changing,” Todd McLeod’s Excel training will forever transform the way you work with numbers. Try this course for yourself and see how quickly and easily you too can learn Microsoft Excel.

Who this course is for:
  • This course is for beginners
Course content
Expand all 93 lectures 08:24:41
+ Introduction
6 lectures 34:04

Welcome to Microsoft Excel for Beginners. This welcome video gives a brief overview of the course. My credentials and experience are also presented.

Preview 04:09

Spreadsheets allow us to work with numbers. Spreadsheets are like customizable calculators. Spreadsheets also allow us to organize and manage data.

Preview 05:47
  • Microsoft Excel comes in many different versions. Every few years, Microsoft releases a new version of Excel. Understanding the different versions available, and which version you are using, is helpful. In this course, we will be using the most current version of Microsoft Excel at the time of the recording: Microsoft Excel 2016.

  • file: Versions of MS Excel

Understanding Versions
07:49

Understanding what has made others successful can help you become successful. These are principles which have helped me become successful. I learned these principles from others and from my own experience. I share these principles to help you succeed in this course and in life:

How To Succeed
09:21

The course outline is part of the course. Please read all of the descriptions of the videos in the course outline. This is part of the learning process. When you read the descriptions:

  • the concepts you are learning will be reinforced

  • you will learn the material more quickly

In addition, I sometimes provide additional information in the course descriptions. Sometimes I record a lecture, then remember that there is a resource or another piece of information which you should know. Some of these resources and extra pieces of information I include are very valuable.

Course Resources
04:38

You can increase the speed of videos when you watch them. Not everyone knows this. This is something you should include in the beginning of all of your courses. Watching videos quickly helps many students. It’s not for everybody, but it works for a lot of people. You need your students to know about this. You can also turn on the “tools / document outline” for our course outline.

Accelerate Learning
02:20
+ Exercises - Ninja Level 1
5 lectures 23:14

Quizzes help you learn the material more quickly. By taking this quiz, you are engaging your mind. By working to recall the material, the material is more deeply integrated. Take this quiz to more quickly learn! Take the quiz now.

Preview 04:27

What version of Microsoft Excel are you using? Is this the most current version?

Hands-on Exercise #1
02:20

Is your computer a 32-bit or 64-bit machine?

Hands-on Exercise #2
04:12

Tell a friend or family member about spreadsheets and Microsoft Excel. Explain to them your understanding of both “spreadsheets” and “Microsoft Excel.”

Hands-on Exercise #3
05:24

Grab a piece of paper and a pen. Write out the principles for student success. Write a commitment to yourself as to how frequently, and how much, you will dedicate yourself to learning Excel. For instance, you might write, “I will study Excel every day for at least 30 minutes until I have finished the course.” Post this paper where you, and everyone else in your household, can see it every day.


Hands-on Exercise #4
06:51
+ Writing Formulas
6 lectures 40:27

A workbook has worksheets. When you open a Microsoft Excel file you are opening a workbook. Inside that workbook you will find worksheets. You can add and delete worksheets as needed.

  • terminology

    • workbook

    • worksheet

  • skills

    • Starting Excel

    • Saving a file

    • Closing Excel

    • Opening a file

Preview 06:16
  • Spreadsheets are made up of columns and rows.

  • The intersection of a column and row is a cell.

    • The active cell has a green or black box around it.

    • Each cell has a cell address: column row, eg, B2.

  • Every Excel file is known as a workbook.

    • Each workbook has worksheets.

  • to enter data into a cell, click on the cell and start typing

    • you can edit data in a cell by

      • double-clicking the cell

      • or up in the formula bar

    • cells overflow if there is no data in the adjacent cell

  • you can make columns wider

  • ribbon menus

    • give you different choices

    • file menu

      • hit the arrow to go back

    • you can collapse your ribbon, and pin back in place

    • view ribbon

      • change view

      • print view

      • gridlines

    • page layout

      • gridlines

      • headings

  • status bar

    • count

    • average

    • sum

  • Learning tip: jump to hands-on Exercises to reinforce this material

Finding Your Way Around Excel
06:37

While using Excel, your mouse pointer will change depending upon the context. Paying attention to the way your mouse pointer looks, and knowing what the different looking mouse pointers mean, will help you use Excel more effectively. Also covered in this video:

  • worksheets

    • name, color, position

      • You can name the tabs of these worksheets, change their colors, and change their order. Right-clicking is helpful for this.

    • add

      • You can add new worksheets to your workbook by clicking the plus sign.

Mouse Pointer Awareness
05:12

Learn the basics of writing formulas in Excel including the point-and-click method for writing formulas.

  • writing formulas

    • =

    • ‘=

  • point-and-click method

  • order of operations

  • relative references

  • formula ribbon

    • show formulas

Writing Formulas
11:23

Learn how to use relative, absolute, and mixed references when writing formulas in Excel.

  • relative

  • ab$olute

  • mixed

Preview 05:39
  • range

    • a selection of 2+ cells

  • colon notation

    • B9:F9

  • names

    • named cells & ranges

Ranges & Names
05:20
+ Exercises - Ninja Level 2
11 lectures 50:41

Quizzes help you learn the material more quickly. By taking this quiz, you are engaging your mind. By working to recall the material, the material is more deeply integrated. Take this quiz to more quickly learn!

Quiz - Getting Started
03:22

Create a new excel spreadsheet. Do the following:

  • create a new worksheet

    • name it “Happy items”

    • give the worksheet tab a color

    • move the worksheet tab to the front of the tabs

  • starting in cell B2

    • list five items that make you happy

      • one item in each cell: B2, B3, B4, B5, B6

  • Delete the other worksheets

    • right-click the worksheets

  • edit the entry in cell B3

    • use the double-click method

  • edit the entry in cell B4

    • use the formula bar

Hands-On Exercise #1
04:01

Create a new workbook. Do the following:

  • make sure you are using normal view

  • remove the gridlines

  • collapse the ribbon menu

pin the ribbon menu back into place

Hands-On Exercise #2
01:27

Open the “020-hands-on-03” workbook. Using the “sales data” worksheet:

  • For items F4:F21, what is the

    • count

    • average

    • sum

Hands-On Exercise #3
02:52

Open the “021-hands-on-04” workbook. Write a formula which adds up B4:B7. Use relative references in your formula. Use the autofill handle to copy that formula across B8:M8

Hands-On Exercise #4
02:03

Open the “021-hands-on-05” workbook. Write a formula which calculates the tax. Use an absolute reference. Use autofill to copy the formula.

Hands-On Exercise #5
03:23
  • Calculate the grade for each student. Assume each graded item carries equal weight. To calculate the grade for each student, just calculate the average score of all scores for that student.

  • Calculate the class average for each graded item.

Preview 05:27
  • Calculate the grade for each student. Each graded item does not carry equal weight. To calculate the grade for each student, you will need to do a weight average calculation.

  • Calculate the class average for each graded item.

Hands-On Exercise #7
05:44
  • Calculate the grade for each student. This gradebook is using the points method. To calculate the grade for each student, just add up a student’s points then divide that by total points possible.

  • Calculate the class average for each graded item.

Hands-On Exercise #8
06:28

Calculate the costs for a trip to Disneyland in Anaheim, California, for yourself and three others. Have your trip last 5 days at the Disneyland & California Adventure parks.

  • ticket price for both Disneyland & Cal Adventure

  • airfare

  • hotel

  • $500 per person for food & incidentals

Hands-On Exercise #9
07:37

Create a spreadsheet that has the recipe for oatmeal peanut butter chocolate chip cookies.

  • include the quantities

include the ability for the quantities to multiply by the number of batches desired.

Hands-On Exercise #10
08:17
+ Formatting
9 lectures 45:41

Formatting your worksheets is important. Join me on a quick tour of some of things we will learn about formatting worksheets.

Overview
03:19

It is not only what you say that matters (the content) but also how you say it (the form). When studied, the greatest impact upon others isn’t the content, but the form. The 7 38 55 study from UCLA says that what impacts people in public speaking is:

  • 7% the content

  • 38% how it’s said

  • 55% body language

This is true in public speaking, this is true in art, this is true in job interviews, and this is true in your Excel spreadsheets. Take your content and give it good form (make it look good).

Preview 04:49

We can format the cells of a worksheet to display different types of data:

  • General

  • Number

  • Currency

  • Accounting

  • Date

  • Time

  • Percentage

  • Fraction

  • Scientific

  • Text

  • Special

  • Custom

Format Cells - Number
07:18

The alignment tab in the format cells dialog box allows you to align your text:

  • horizontal

  • vertical

  • orientation (angle)

  • wrap

  • merge

  • shrink-to-fit

Using the alignment tab, we can quickly achieve some very nice visual looks

Format Cells - Alignment
07:28

In graphic design, font determines feeling. There are two broad categories of fonts: serif and sans-serif. A serif font has feet; a sans-serif font does not. For text on computer screens, sans-serif is the most popular and, perhaps by consensus, best choice. You can find the most popular fonts in the world on Google Fonts.  Once the fonts are installed on your computer, you can use them in your spreadsheets. Take-aways:

  • use a sans-serif font

  • use Google Fonts to get the most popular fonts

Format Cells - Font
06:37

The “format cells” dialog box “border” option allows us to set borders around a cell or range of cells.

Format Cells - Border
02:47

The “format cells” dialog box “fill” option allows us to fill a cell, or range, with a color and pattern.

Format Cells - Fill
04:48

The “clear” option on the “home” ribbon allows you to clear different elements on your spreadsheet:

  • clear all

  • clear formats

  • clear contents

  • clear comments

  • clear hyperlinks

Clear Formats
06:24

You can quickly format tabular data as a table using the “format as table” option on the home ribbon. Two good things to know about:

  • filter checkbox

  • convert to range

Format As Table
02:11
+ Exercises - Ninja Level 3
7 lectures 43:10

Using the format cells dialog box, format various data as different numbers.

Hands-On Exercise #1
05:17

Use the "format cells" dialog box "alignment" tab to align cell contents.

Hands-On Exercise #2
03:40

Using the "format cells" dialog box "font" tab:

  • Use "Roboto regular" from Google Fonts for all text.

  • Also make sure to "superscript" the 42 in cell V27.

Hands-On Exercise #3
04:38

Using the "format cells" dialog box, work with the "fill" & "border" tabs for format your spreadsheet.

Hands-On Exercise #4
08:06

Use the “clear” button on the home ribbon to clear the formatting on a spreadsheet.

Hands-On Exercise #5
02:27

Use the “format as table” button on the home ribbon to format data as a table.

Hands-On Exercise #6
05:54

Format this spreadsheet and make it look pretty.

Hands-On Exercise #7
13:08
+ Home & Insert
10 lectures 50:58

An overview of what we have learned so far, and what we will learn next.

Overview
02:56

In hands-on #7 in Ninja Level 3 you saw me use the “snipping tool” to capture a picture of something in Excel. You can also capture a picture in Excel with “copy as picture.” This workflow, however, is not quite as elegant as using the snipping tool.

Copy As Picture
02:59

Paste has a few options which are useful to know about. These paste options allow us to determine how items we have copied are pasted:

  • paste

  • paste formula

  • paste value

  • paste transpose

Paste
06:40

We can copy data from the web and then use “paste special” to determine how that data is pasted into Excel.

Paste Special
04:07

We can use the “format” option on the home ribbon to format options for column and rows:

  • width

  • height

  • hide & unhide

Format Columns & Rows
04:57
Styles
03:12

Excel makes it easy to insert pictures and shapes (arrows, smiles, stars) into worksheets.

  • pictures

  • online pictures

  • shapes

  • screenshot

Pictures & Shapes
06:20
  • Smart art

    • list

    • process

    • cycle

    • hierarchy

    • relationship

    • matrix

    • pyramid

    • picture

  • word art

  • symbol

Smart Art, Word Art, & Symbol
10:28

You can insert links in your Excel worksheet. You can also insert text boxes.

Link & Text Box
06:31

Increase the functionality of Excel with third-party “add-ins” such as maps.

Add-Ins
02:48
+ Exercises - Ninja Level 4
9 lectures 57:09

Using spreadsheet “054-hands-on-01-disney-trip” use “copy as picture” to copy the table to a picture. Paste that picture back into the spreadsheet.

Hands-On Exercise #1
01:25

Take the data in “055-hands-on-02” and transpose it from a column to a row. Important: only select the data, do not select the entire column. If you select the entire column, you will not be able to paste transpose.

Hands-On Exercise #2
08:42

Copy data from Yahoo finance, or data from somewhere else online, and paste the data into Excel using paste special.

Hands-On Exercise #3
10:17

Using “057-hands-on-04” adjust the row and column height to look good. Hide columns B & C.

Hands-On Exercise #4
08:12

Create a new spreadsheet. Save the spreadsheet as “058-hands-on-05.” Create a tab for each of the following, and then complete the tasks for each tab:

  • pictures

    • use Google to find an image that is labeled for reuse

    • save that image to your computer

    • insert that image into your spreadsheet

  • online pictures

    • find an image using “online pictures” and insert it into your spreadsheet

  • shapes

    • insert a star onto your spreadsheet

  • screenshot

    • open a web page

    • go to excel, then insert a screenshot and choose “screen clipping”

    • the web page should come to the foreground and allow you to select a region of the web page

    • the selection of the web page should appear in excel

Hands-On Exercise #5
07:30

Create a new spreadsheet. Save the spreadsheet as “059-hands-on-06.” Create a tab for each of the following, and then complete the tasks for each tab:

  • smart art

    • insert a smart art of your choice

      • if applicable, add 5 options to it

  • word art

    • insert this word art: “I’m learning so much about Excel!”

  • symbol

    • insert the copyright © symbol

Hands-On Exercise #6
03:00

Create a new spreadsheet. Save the spreadsheet as “060-hands-on-07.” Create a tab for each of the following, and then complete the tasks for each tab:

Hands-On Exercise #7
05:45

Create a new spreadsheet. Save the spreadsheet as “061-hands-on-08.” Use an “add-in” on your spreadsheet.

Hands-On Exercise #8
05:09

Create a new spreadsheet. Save the spreadsheet as “062-hands-on-09.” Copy the Oscar winners from either of these urls …

… then use “paste special” to get it into Excel.

Hands-On Exercise #9
07:09
+ Layout Essentials
6 lectures 41:26

This is an overview of where we’ve been and where we’re going. Looking at what we’ve covered, and what we’re going to cover, helps you learn. This is also referred to as “preview, view, review” and is a well-documented technique to help students learn more effectively.

Overview
10:15

You can add a background image to your spreadsheet. Use the “background” option from the page layout ribbon.

Background
08:56

The stacking order is the order in which overlapping graphics stack. This is also referred to as the vertical stacking order. You can change the vertical stacking order of graphics by using the “bring forward” and “send backward” buttons on the page layout ribbon.

  • forward

  • backward

Stacking Order
03:22

You can use buttons on the page layout ribbon to align, group, and rotate graphics.

Align, Group, Rotate
03:31

Use options on the view ribbon to zoom-in and zoom-out on your spreadsheet.

  • also: formula bar checkbox

Zooming In & Out
02:58

Templates are pre-built worksheets. Excel has a variety of templates which you can search for and use.

Templates
12:24
+ Exercises - Ninja Level 5
5 lectures 10:06

Open the spreadsheet “068-hands-on-01.” Add a Disney related background image to this spreadsheet.

Hands-On Exercise #1
01:29

Open the spreadsheet “069-hands-on-02.” Change the stacking order of the images by putting the image of the beach in the background.

Hands-On Exercise #2
00:58

Open the spreadsheet “070-hands-on-03.” Align the graphics. Evenly distribute the graphics. Group the graphics. Rotate the graphics.

Hands-On Exercise #3
04:20

Find the template “weekly expense report”. Enter the following data:

Save the spreadsheet as “072-hands-on-05”

note: in the video, the file names were incorrectly typed; these are the correct file names:

file: 071-hands-on-04


Hands-On Exercise #4
02:03

Open “072-hands-on-05”, select the table of Disneyland trip data, then zoom in on it. Save the file. Re-open the file. Was the zoom level maintained?

Hands-On Exercise #5
01:16