Excel for Complete Beginners - Fun Easy Lessons

A guide to Excel for total beginners, showing you how to create and format basic spreadsheets.
4.7 (6 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
708 students enrolled
$50
Take This Course
  • Lectures 21
  • Contents Video: 1 hour
    Other: 3 mins
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 4/2015 English

Course Description

GET THIS COURSE NOW WHILE IT IS CHEAP - PRICE WILL GO UP VERY SOON

One of my first students, Rick, messaged me to say "I thought it was outstanding! It was extremely easy to follow and hit on some critical key points for a beginner."

You should join this active course - I am extremely responsive inside the course answering questions from students and helping them learn Excel. I look forward to working with you, as well.

The course will gently lead a total beginner through all the steps to create and format a basic spreadsheet.

It will demystify a lot of jargon, and also provide some killer tips that will save a lot of time, and wow your boss.

The course assumes no prior knowledge. Each lesson builds on the previous one. So it is designed for you to start at the beginnning and work your way through. However if you prefer, you can jump around and just do the lessons you want.

In the later lessons I have provided before and after spreadsheets. You do not need to download these, but they are available for your use if you want to.

I have also given a quiz at the end of each section so that you can test if you have absorbed all the lessons properly.

Happy Excelling!!!

Keith

What are the requirements?

  • You must have a working version of Excel. I will be using Excel 2013 running on a PC, but if you have a different version it will probably mostly be very similar.
  • You will need to know how to load Excel on your device

What am I going to get from this course?

  • Create basic Excel spreadsheets
  • Understand basic Excel jargon
  • Navigate quickly with mouse and keyboard
  • Open and save files in different locations and formats
  • Understand what the ribbon and quick access toolbar are
  • How to enter data and add totals
  • How to format a table beautifully and easily
  • How to take full control over formatting
  • How to copy and different ways to paste

What is the target audience?

  • It is meant for complete beginners with no Excel knowledge
  • It is NOT for people who already know how to create basic Excel spreadsheets

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Start Here - introduction and the basics
1 page

This course is designed to be watched in HD.

The default Udemy settings are in SD - standard definition, and the videos will appear blurry.

To get them clear you need to click on the "HD" letters at the bottom of the video between the time counter and speaker icon. See the pdf below for screenshots of this.

Fortunately you usually only have to do this once, and then Udemy will remember your preference.

04:21

Welcome to the course!

This course is for total beginners to Excel. Do not get it if you already know how to use Excel or you will be bored.

I am using Excel 2013 for Windows. But if you have another version, it should be very similar.

A bit about me. I qualified as a chartered accountant (UK version of CPA), and worked as one for many years.

In 1989 I first started using Excel and soon fell in love with it. Since then, most days I have used it for several hours a day.

I am a power user, used to creating massive spreadsheets with complex formulae, but I also have a lot of simple spreadsheets.

The course is designed so each lesson builds on the previous one, and you can work your way through sequentially. Or if you prefer, you can just look at the sections that you want to.

The lessons in the second half of the course have downloadable before and after spreadsheets. You do not need to download these. But if you want to work along with me, or are feeling a bit confused, then they might be of use to you.

Usually the "before" spreadsheet is the same as the "after" spreadsheet of the previous course. I have just renamed it for clarity.

That is all for now.

I wish you the best of luck with your course.

04:11

You will learn how to create a new blank spreadsheet. You will also get to understand some commonly used jargon, and what goes on in the different parts of the screen.

03:18

You will learn the difference between a workbook and worksheets, and how to create multiple worksheets, change the tab color, and also hide and display them.

04:59

You will learn how to quickly move around the spreadsheet using both the mouse and also keyboard short cuts. In addition you will learn about how to navigate using the "end", "home" and "control" keys along with the arrow keys.

05:17

You will learn how to open and save a file. You will learn how to do this from and to a specific folder or drive. You will also know a bit about the different formats you can open and also save to including "xls" the old pre 2003 Excel file format, and "csv" (comma separated values) which is used for importing and exporting data from other software (including banking software).

Article

To prove you have gone through and absorbed section 1 please go through perform these steps.

I am not providing answers to the test, but if you have problems, you should be easily able to review the lessons and find out what to do.

Section 2: Menu, the ribbon and quick access toolbar
04:50

The ribbon contains numerous icons and has massive functionality. This is a quick overview to show you around it.

03:38

Many people do not know about the quick access toolbar, but it will save you a lot of time. You will learn how to save the functions you use most often here, so that they are just one click away.

Article

To prove you have gone through and absorbed this section please go through perform this step.

I am not providing answers to the test, but if you have problems, you should be easily able to review the lessons and find out what to do.

Section 3: Creating a table of data
02:46

I show you how to enter a simple block of data, and also explain the difference between labels and values.

03:54

You will learn how to quickly add totals to sum numbers in rows and also columns. The way we do this is to use the autosum function. You will also learn how to change the items being summed, and how to copy the autosum along to different columns.

04:38

Learn how to delete rows, and prepare a table for one click formatting.

Learn how to format a table with one click, and choose between many preset styles for this, or create your own.

Learn how to filter a table to only show certain rows.

Article

To prove you have gone through and absorbed this section please go through perform these steps.

I am providing a sample answer to the test. Yours will have different data, and probably be formatted differently. That is OK.

If you have problems, you should be easily able to review the lessons and find out what to do.

Section 4: Formatting
05:47

You will learn two methods how to manually change column widths and row heights, as well as a very quick way to autofit to the optimal size several columns or rows in one fell swoop.

06:48

You will learn different ways of formatting numbers.

You will learn how to:

add commas to separate thousands, millions etc.

specify how many decimal places to show

how to add a currency symbol

how to show negatives in red

how to format as a percentage

and more

04:34

You will learn how to
clear formatting of a selection
remove the filters of a table
make cells bold
change the background color of a cell
my system for letting the user of a spreadsheet know which cells they can add data to
how to align the contents of a cell horizontally and/or vertically

Article

To prove you have gone through and absorbed this section please download the unformatted spreadsheet and perform these steps in the text file.

I am providing a sample answer to the test, but if you have problems, you should be easily able to review the lessons and find out what to do.

Section 5: copying and pasting
07:08

You will learn 2 ways to move data - dragging, or cutting and pasting

You will also learn many ways of pasting including whether you want to keep the formatting and column widths, and also whether you want to keep the formulas, or have them hard coded as values.

You will also learn how to transpose your columns and rows very easily.

I did not mention the other ways you can copy and paste.
These are by using the Windows shortcuts "control C" and "control V".
You can also select the area and right click. You will see an option to copy or paste, there.

Article

To prove you have gone through and absorbed this section please go through perform these steps.


I am providing answers to the test, and in the "section 5 quiz answer - pasted after table" spreadsheet, I have also included screenshots to help you see which paste icon I used.

If you have problems, you should be easily able to review the lessons and find out what to do.

Section 6: Conclusion
00:52

This is the end of the course.

Thank you so much for taking the time to look at it, and I really hope that you learned from it.

I will be doing many more more excel courses that follow on from this one, so I really hope you check them out too.

Happy Excelling :-)

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Keith Griggs, Excel Fanatic

I was a chartered accountant (UK equivalent of CPA) in London for many years. I trained at a partnership that merged into Deloittes.

In 1989 I started using Excel and fell in love with it very quickly. I am a power user and can create massive spreadsheets with complex formulae, although I am also happy making small simple ones.

I am really excited about sharing my knowledge and enthusiasm for Excel with others.

In 2001 I started my first internet business, and have become expert in SEO, internet marketing and online reputation management.

Ready to start learning?
Take This Course