Learn Excel - The Excel Tutorial for Beginners
- 8.5 hours on-demand video
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to 4,000+ top Udemy courses anytime, anywhere.Try Udemy for Business
- 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
- All versions of Microsoft Excel work for this course. The instructor will be using Microsoft Excel 2016.
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.
- This course is for beginners
Welcome to Microsoft Excel for Beginners. This welcome video gives a brief overview of the course. My credentials and experience are also presented.
Spreadsheets allow us to work with numbers. Spreadsheets are like customizable calculators. Spreadsheets also allow us to organize and manage data.
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 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:
Time on task
Bill Gates & Warren Buffett
Bill Gates, “Get in front of what’s coming and let it hit you.”
drop by drop, the bucket gets filled
persistently, patiently, you are bound to succeed
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.
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.
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.
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.
Saving a file
Opening a file
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
give you different choices
hit the arrow to go back
you can collapse your ribbon, and pin back in place
Learning tip: jump to hands-on Exercises to reinforce this material
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:
name, color, position
You can name the tabs of these worksheets, change their colors, and change their order. Right-clicking is helpful for this.
You can add new worksheets to your workbook by clicking the plus sign.
Learn how to use relative, absolute, and mixed references when writing formulas in Excel.
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
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.
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.
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).
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
We can copy data from the web and then use “paste special” to determine how that data is pasted into Excel.
Copy data from Yahoo finance, or data from somewhere else online, and paste the data into Excel using paste special.
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:
use Google to find an image that is labeled for reuse
save that image to your computer
insert that image into your spreadsheet
find an image using “online pictures” and insert it into your spreadsheet
insert a star onto your spreadsheet
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
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:
insert a smart art of your choice
if applicable, add 5 options to it
insert this word art: “I’m learning so much about Excel!”
insert the copyright © symbol
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:
create a link to this poem
insert a text box with this phrase
“My Excel skills are going up and up and up!”
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.