Useful Excel for Beginners
4.5 (2,063 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.
23,189 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Useful Excel for Beginners to your Wishlist.

Add to Wishlist

Useful Excel for Beginners

Learn the basics of Microsoft Excel and become an effective user
4.5 (2,063 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.
23,189 students enrolled
Created by ind zara
Last updated 12/2013
English
Price: Free
Includes:
  • 9.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Learn the fundamentals of Excel
  • Become an effective user
View Curriculum
Requirements
  • Knowledge of operating a personal computer
  • Microsoft Excel for Windows (Preferably 2007 or 2010 or 2013)
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

Who is the target audience?
  • Never used Excel before
  • Beginner level Excel user
Students Who Viewed This Course Also Viewed
Curriculum For This Course
89 Lectures
09:38:16
+
Introduction
1 Lecture 07:11
Introduction to the Course
07:11
+
Basics of Excel
3 Lectures 11:25
Basics of Excel
03:36

Workbooks and Worksheets
02:46

Fundamentals
05:03

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

CHAPTER 2: Basics of Excel
5 questions
+
Entering Data
26 Lectures 02:45:19
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

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

CHAPTER 3: ENTERING DATA
8 questions
+
Formatting
6 Lectures 37:04
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

QUESTIONS RELATED TO MATERIAL COVERED IN CHAPTER 4: FORMATTING

CHAPTER 4: FORMATTING
2 questions
+
Editing
10 Lectures 01:10:47
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

QUESTIONS RELATED TO MATERIAL COVERED IN CHAPTER 5: EDITING

CHAPTER 5: EDITING
5 questions
+
Saving
1 Lecture 09:58
Saving - Saving Excel documents
09:58

QUESTIONS RELATED TO MATERIAL COVERED IN CHAPTER 6: SAVING

CHAPTER 6: SAVING
3 questions
+
Viewing
1 Lecture 06:47
Viewing - Freeze Panes
06:47
+
Calculations
17 Lectures 02:06:03
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

QUESTIONS RELATED TO MATERIAL COVERED IN CHAPTER 8: CALCULATIONS

CHAPTER 8: CALCULATIONS
10 questions
+
Visualizing
14 Lectures 01:20:57
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

QUESTIONS RELATED TO MATERIAL COVERED IN CHAPTER 9: VISUALIZING

CHAPTER 9: VISUALIZING
4 questions
+
Analyzing
5 Lectures 31:16
Introduction to PivotTables
02:07

Creating PivotTable
07:45

PivotTable Summarization Types
05:44

PivotTable Tools
10:44

PivotCharts
04:56

QUESTIONS RELATED TO MATERIAL COVERED IN CHAPTER 10: PIVOTTABLES

CHAPTER 10: PIVOTTABLES
4 questions
3 More Sections
About the Instructor
ind zara
4.5 Average rating
2,061 Reviews
23,189 Students
1 Course
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.