Learn the basics of Excel in less than a day. Start now!

Master the basics of Excel and get ready for the next Advanced level. Free training files and bonus shortcuts included!
0.0 (0 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.
2 students enrolled
$19
$200
90% off
Take This Course
  • Lectures 95
  • Length 5 hours
  • 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 5/2016 English

Course Description

Learn how to master the basics of Microsoft Excel in a few hours, increase your speed of working by creating button shortcuts in the quick access toolbar and how to save paper by previewing your spreadsheet before you actually print. And many more!

Although this basics course is for Excel 2007, you can still use the skills you learn here for the later versions of Excel, including Excel 2010, 2013 and 2016.

Maybe you have just have the basic skills of using a computer. You know, like how to use a mouse and a keyboard. How to use the windows explorer to move from Excel to PowerPoint to the Internet explorer, for an example. Well, the next logical step is to start today to learn the basics of Excel. And in this course, you will learn exactly that.

Topics in this course include:

  • Tour of the Excel interface.
  • Exploring the ribbon tabs.
  • Working with worksheets.
  • Dealing with data.
  • Basic formulas.

Free Training Files are included which you should use to follow along. You may download the training files for free to your computer.

  • By taking this course, you will learn how to prepare a spreadsheet for printing by doing a print preview first.
  • Learn how to add up numbers quickly by using the AutoSum function, instead of using a calculator and wasting time.
  • Remove duplicate data easily with a few clicks, instead of manually looking for the duplicate data and missing some of it.
  • Do not replace all the text one by one in your long spreadsheet and taking a couple of minutes (or hours): instead, learn how to use the powerful find and replace tool to do the same job in a few seconds. Even for big spreadsheets.
  • Learn how to use the TRIM function to remove extra spaces from the data that you received from another person who didn't bother to clean the data before sending it to you.

BONUS:

  • FREE 7 videos (worth $15) showing the Workbook and Worksheet shortcuts that will help you speed up your work.

Get ready for the next Advanced level of Excel by mastering the basics today!

Take the course now!


What are the requirements?

  • You should have the basic computer skills.
  • Download the course training files to follow along.
  • You need to have the Microsoft Excel 2007 program installed on your computer.

What am I going to get from this course?

  • Create a print preview icon in the Quickaccess toolbar to quickly preview pages before printing them.
  • Use the Office button to change the Excel options such as changing the look and feel of the spreadsheets.
  • Minimize, restore and maximize spreadsheets for a better work environment.
  • Use formulas to add up amounts in a spreadsheet instead of using a calculator.
  • Zoom in and out of a spreadsheet to see the data better which can increase productivity.
  • Use Excel to count rows of data in a matter of seconds.

What is the target audience?

  • People who need to master the basics of Excel.
  • Guys and girls who have not used Excel in a while and need to refresh their knowledge in Excel basics.
  • Users who want to get ready for the next Intermediate and Advance levels of Excel.
  • Not for users who have not used a computer before and just starting out.

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: Introduction
Welcome Excel 2007 basics
Preview
01:56
What you need to know for this course
Preview
01:15
What is excel
Preview
00:48
Training files
Article
Section 2: Tour of the interface
The office button
Preview
02:48
The ribbon
03:46
Excel options
05:02
Exploring the quick access toolbar
04:04
The minimize maximize restore and close buttons
01:45
The zoom area
04:26
The status bar
02:05
Page preview icon area
01:12
The header area
00:58
Section 3: Exploring the ribbon tabs
Home tab clipboard group
04:14
Home tab font group
04:25
Home tab alignment group
03:56
Home tab number group
02:28
Home tab styles group
01:25
Insert tab tables group
02:34
Insert tab illustrations group
05:40
Page layout tab themes group
01:16
Page layout tab page setup group part one
03:14
Page layout tab page setup group part two.mp4
04:40
Page layout tab sheet options group
01:00
Formulas tab function library group
01:49
Formulas tab defined names group
02:14
Data tab sort and filter group part one
05:44
Data tab sort and filter group part two
02:38
Review tab proofing group
Preview
03:09
Review tab comments group
02:59
View tab workbook views group
01:02
View tab show hide group
00:40
View tab zoom group
01:39
View tab window group part one
02:45
View tab window group part two
04:08
Section 4: Working with workbooks
What is a workbook
00:54
Creating a new workbook
03:07
Saving a workbook
05:24
Opening and closing a workbook
02:37
Deleting a workbook
02:21
Renaming a workbook
Preview
01:33
Section 5: Working with worksheets
What is a worksheet
03:05
Creating worksheets
05:34
Opening a worksheet
01:08
Saving a worksheet
01:18
Deleting a worksheet
02:27
Renaming worksheets
01:49
Moving and copying worksheets
05:46
Changing sheet colours
02:38
Exploring the autofills
08:25
Hiding and unhiding sheets
02:48
Selecting several worksheets
02:37
Section 6: Columns rows and cells
What are columns
05:41
What are rows
03:23
What are cells
04:01
Resizing column widths
04:15
Resizing row heights
04:34
Hiding and unhiding columns and rows
05:33
Section 7: Dealing with data
Text to columns
11:15
Removing duplicates
05:45
Finding data
07:16
Replacing data
05:06
Section 8: Printing
Printing basics part 1
05:16
Printing basics part 2
04:49
Working with print preview
04:53
Page setup options part 1
05:53
Page setup options part 2
04:20
Printing your spreadsheet
00:57
Section 9: Formulas
What is a formula
Preview
08:47
The formula bar
03:06
Remember bodmas
03:59
Relative reference
04:02
Absolute reference
06:21
The formula auditing group part 1
05:23
The formula auditing group part 2
04:13
The calculation group
03:41
Section 10: Functions
What is a function
00:53
Types of functions
05:58
The autosum function
04:31
Minimum and maximum functions
04:00
Finding the average of numbers
01:47
The trim function
02:04
The left and right functions
02:09
Lower proper and upper functions
02:34
Merging two cells
02:49
Count function
04:47
Date functions
01:50
Section 11: Bonus: workbook and worksheet shortcuts
Opening and closing workbooks
01:35
Switching between workbooks
01:55

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Hunting Training, Qualified trainers and authors

Walter Mogane - Trainer and author

As an Excel trainer, I love teaching Excel to students, business men and women or just the guys working for an employer. I emphasize how important it is to apply the Excel knowledge you will have gained in your every day job. That way you truly become more productive.

I have been teaching Excel and other Microsoft suite programs for over 15 years and have received diplomas in Basic, Intermediary and Advanced Microsoft courses. I also received an outstanding achievement award for the Advanced Excel course I completed.

I believe that it is vital that you do the quizzes for each lesson as you progress to test your understanding. If you get some questions incorrect in a quiz, don't worry, just try again until you come right.

You can do the sections in any order you like. I don't believe that you have to do the sections in a forced order. This also is very helpful if you just want to dive into a particular section, without having to do the other sections first. Having said that, I do recommend that you do the sections in the order they are available in the course.

In my spare time I enjoy going to the gym, playing tennis, table tennis, swimming, listening to Rap, Soul and R & B music. Sometimes I just generally enjoy coming up with solutions to some of the world problems. I believe that's my entrepreneurial spirit talking. Oh well... there I said it!

I also enjoy spending time with my family watching family movies although my kids and my loved one always sleep halfway through the movies. So, well, I ended up watching the movies alone. Sniff, sniff!

Ready to start learning?
Take This Course