Learn the basics of Excel in less than a day. Start now!
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
Wishlisted Wishlist

Please confirm that you want to add Learn the basics of Excel in less than a day. Start now! to your Wishlist.

Add to Wishlist

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
Created by Hunting Training
Last updated 5/2016
English
Current price: $10 Original price: $200 Discount: 95% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 5 hours on-demand video
  • 1 Article
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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.
View Curriculum
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.
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!


Who 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 95 Lectures Collapse All 95 Lectures 05:13:22
+
Tour of the interface
9 Lectures 26:06

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
+
Exploring the ribbon tabs
22 Lectures 01:03:39
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 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
+
Working with workbooks
6 Lectures 15:56
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

+
Working with worksheets
11 Lectures 37:35
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
+
Columns rows and cells
6 Lectures 27:27
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
+
Dealing with data
4 Lectures 29:22
Text to columns
11:15

Removing duplicates
05:45

Finding data
07:16

Replacing data
05:06
+
Printing
6 Lectures 26:08
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
+
Formulas
8 Lectures 39:32

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
+
Functions
11 Lectures 33:22
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
2 More Sections
About the Instructor
Hunting Training
4.3 Average rating
6 Reviews
631 Students
3 Courses
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!