Useful Excel for Beginners

Learn the basics of Microsoft Excel and become an effective user
4.5 (845 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.
15,130 students enrolled
Free
Start Learning Now
  • Lectures 89
  • Length 9.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 11/2013 English

Course Description

Welcome to the Useful Excel for Beginners course.

In this course, you will learn the fundamentals of Excel and become an effective user. The target audience for the course are those who have never used Excel before and those who are beginner level users. You would need a copy of Microsoft Excel for Windows since you will be practicing along with the course. I use Excel 2010 for Windows in the videos but any version with Excel 2007 for Windows or later would work. Excel Versions prior to 2007 have a different user interface but concepts will apply.

As the course is targeting beginners, it has been developed to be very easy to follow. We will be working with data related to a book store in the exercises. The files are available for download and you can follow along the videos while practicing.

The course covers the topics that you would need to know, to become a functional user. You can download the Table of Contents document from Chapter 1, to see all the topics the course will address. The course has 89 videos and runs for 9.5 hours.

If there are any questions about the course, please e-mail at indzara at gmail.com

What are the requirements?

  • Knowledge of operating a personal computer
  • Microsoft Excel for Windows (Preferably 2007 or 2010 or 2013)

What am I going to get from this course?

  • Learn the fundamentals of Excel
  • Become an effective user

What is the target audience?

  • Never used Excel before
  • Beginner level Excel user

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
Introduction to the Course
07:11
Section 2: Basics of Excel
Basics of Excel
03:36
Workbooks and Worksheets
02:46
Fundamentals
05:03
5 questions

Questions on the material covered in Chapter 2: Basics of Excel.

Section 3: Entering Data
How to Enter data
04:17
Auto Fit
07:07
Keyboard Navigation
05:07
Auto Complete
04:49
Entering Numbers
03:32
Navigating edges
09:18
Navigating - First and last used cells
02:27
Selecting cells - Introduction
02:03
Selecting cells - Shift + Arrow
08:38
Selecting cells - Ctrl + Shift + Arrow
08:59
Selecting cells - Mouse Click and Drag
03:45
Selecting cells - Mouse Click and Shift Click
03:21
Selecting cells - All Cells & Used Cells
03:09
Selecting cells - Rows and Columns
03:16
Selecting cells - Non-contiguous cells
04:41
Selecting cells - Summary
10:02
Number Formatting - Introduction
06:23
Number Formatting - General and Text
08:40
Number Formatting - Number and Fraction
15:54
Number Formatting - Currency
05:21
Number Formatting - Accounting
01:50
Number Formatting - Percentage
05:45
Number Formatting - Date
12:05
Number Formatting - Time
10:51
Number Formatting - Summary
02:22
Inserting and deleting Rows, Columns and Cells
11:37
8 questions

QUESTIONS RELATED TO THE MATERIAL COVERED IN CHAPTER 3: ENTERING DATA

Section 4: Formatting
Formatting - Introduction
05:08
Formatting - Bold, Italics and Underline
05:05
Formatting - Border
08:58
Formatting - Fill and Font
05:27
Formatting - Alignment
09:09
Formatting - Format Painter and Clear Formats
03:17
2 questions

QUESTIONS RELATED TO MATERIAL COVERED IN CHAPTER 4: FORMATTING

Section 5: Editing
Editing - Editing Cell Content
07:44
Editing - Multiple Lines of Text
03:32
Editing - Ctrl + Enter
02:51
Editing - Auto Fill
05:39
Editing - Copy and Paste
07:13
Editing - Cut and Paste
07:32
Editing - Auto Fill Series
06:59
Editing - Sort
12:18
Editing - Filter
06:14
Editing - Find and Replace
10:45
5 questions

QUESTIONS RELATED TO MATERIAL COVERED IN CHAPTER 5: EDITING

Section 6: Saving
Saving - Saving Excel documents
09:58
3 questions

QUESTIONS RELATED TO MATERIAL COVERED IN CHAPTER 6: SAVING

Section 7: Viewing
Viewing - Freeze Panes
06:47
Section 8: Calculations
Calculations - Introduction to Formula
07:42
Editing Formula
02:03
Introduction to Functions
08:23
Entering Functions
08:51
Types of Functions
03:00
MIN, MAX and AVERAGE Functions
05:00
Copying Formula
07:34
Cell References
09:40
Paste Formula
02:27
Counting Functions
08:25
Lookup Functions
13:29
Date Functions
04:53
Text Functions
15:26
SUMIF Function
11:08
IF Function
04:37
Errors
11:33
Calculations - Summary
01:52
10 questions

QUESTIONS RELATED TO MATERIAL COVERED IN CHAPTER 8: CALCULATIONS

Section 9: Visualizing
Introduction to Charts
02:33
Creating a Chart
08:58
Chart Components - Labels
10:33
Chart Components - Background
01:27
Chart Components - Axes
07:49
Chart Components - Format and Design
02:21
Chart Types
10:47
Introduction to Conditional Formatting
01:51
Conditional Formatting - Format All Cells
08:35
Conditional Formatting - Format Only Cells
05:44
Conditional Formatting - More Rule Types
06:52
Conditional Formatting - Formula Based
05:33
Conditional Formatting - Summary
03:03
Illustrations
04:51
4 questions

QUESTIONS RELATED TO MATERIAL COVERED IN CHAPTER 9: VISUALIZING

Section 10: Analyzing
Introduction to PivotTables
02:07
Creating PivotTable
07:45
PivotTable Summarization Types
05:44
PivotTable Tools
10:44

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

ind zara, Sharing simple but effective solutions

My background is in data mining and business analysis. I have worked in large corporations for more than 10 years. I have also led teams of data analysts and managers in large corporations, working on data analysis and reporting. I have more than 12 years of experience working with Microsoft Excel.

I like to share what I know about Excel and data mining. I strongly believe that Excel can be leveraged better at home and at work, to make smarter decisions. I hope this course can help those who are new to Excel, learn the basics and become effective users.

I am also building and sharing Excel templates that can help people do day to day tasks more efficiently. Please find them online on my site. There are also simple video tutorials on my YouTube channel.

Ready to start learning?
Start Learning Now