4.46 out of 5
4.46
27349 reviews on Udemy

Useful Excel for Beginners

Learn the basics of Microsoft Excel and become an effective user
Instructor:
ind zara
264,651 students enrolled
English [Auto-generated]
Learn the fundamentals of Excel
Become an effective user

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.

Since this is a free course, Udemy does not offer certificates anymore.

Introduction

1
Introduction to the Course

Basics of Excel

1
Basics of Excel
2
Workbooks and Worksheets
3
Fundamentals
4
CHAPTER 2: Basics of Excel

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

Entering Data

1
How to Enter data
2
Auto Fit
3
Keyboard Navigation
4
Auto Complete
5
Entering Numbers
6
Navigating edges
7
Navigating - First and last used cells
8
Selecting cells - Introduction
9
Selecting cells - Shift + Arrow
10
Selecting cells - Ctrl + Shift + Arrow
11
Selecting cells - Mouse Click and Drag
12
Selecting cells - Mouse Click and Shift Click
13
Selecting cells - All Cells & Used Cells
14
Selecting cells - Rows and Columns
15
Selecting cells - Non-contiguous cells
16
Selecting cells - Summary
17
Number Formatting - Introduction
18
Number Formatting - General and Text
19
Number Formatting - Number and Fraction
20
Number Formatting - Currency
21
Number Formatting - Accounting
22
Number Formatting - Percentage
23
Number Formatting - Date
24
Number Formatting - Time
25
Number Formatting - Summary
26
Inserting and deleting Rows, Columns and Cells
27
CHAPTER 3: ENTERING DATA

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

Formatting

1
Formatting - Introduction
2
Formatting - Bold, Italics and Underline
3
Formatting - Border
4
Formatting - Fill and Font
5
Formatting - Alignment
6
Formatting - Format Painter and Clear Formats
7
CHAPTER 4: FORMATTING

QUESTIONS RELATED TO MATERIAL COVERED IN CHAPTER 4: FORMATTING

Editing

1
Editing - Editing Cell Content
2
Editing - Multiple Lines of Text
3
Editing - Ctrl + Enter
4
Editing - Auto Fill
5
Editing - Copy and Paste
6
Editing - Cut and Paste
7
Editing - Auto Fill Series
8
Editing - Sort
9
Editing - Filter
10
Editing - Find and Replace
11
CHAPTER 5: EDITING

QUESTIONS RELATED TO MATERIAL COVERED IN CHAPTER 5: EDITING

Saving

1
Saving - Saving Excel documents
2
CHAPTER 6: SAVING

QUESTIONS RELATED TO MATERIAL COVERED IN CHAPTER 6: SAVING

Viewing

1
Viewing - Freeze Panes

Calculations

1
Calculations - Introduction to Formula
2
Editing Formula
3
Introduction to Functions
4
Entering Functions
5
Types of Functions
6
MIN, MAX and AVERAGE Functions
7
Copying Formula
8
Cell References
9
Paste Formula
10
Counting Functions
11
Lookup Functions
12
Date Functions
13
Text Functions
14
SUMIF Function
15
IF Function
16
Errors
17
Calculations - Summary
18
CHAPTER 8: CALCULATIONS

QUESTIONS RELATED TO MATERIAL COVERED IN CHAPTER 8: CALCULATIONS

Visualizing

1
Introduction to Charts
2
Creating a Chart
3
Chart Components - Labels
4
Chart Components - Background
5
Chart Components - Axes
6
Chart Components - Format and Design
7
Chart Types
8
Introduction to Conditional Formatting
9
Conditional Formatting - Format All Cells
10
Conditional Formatting - Format Only Cells
11
Conditional Formatting - More Rule Types
12
Conditional Formatting - Formula Based
13
Conditional Formatting - Summary
14
Illustrations
15
CHAPTER 9: VISUALIZING

QUESTIONS RELATED TO MATERIAL COVERED IN CHAPTER 9: VISUALIZING

Analyzing

1
Introduction to PivotTables
2
Creating PivotTable
3
PivotTable Summarization Types
4
PivotTable Tools
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.5
4.5 out of 5
27349 Ratings

Detailed Rating

Stars 5
14008
Stars 4
9408
Stars 3
3111
Stars 2
495
Stars 1
327
91416fbf1d1bf298c4a7fdad0048e116
30-Day Money-Back Guarantee

Includes

10 hours on-demand video
Full lifetime access
Access on mobile and TV

Working hours

Monday9:30 am - 6.00 pm
Tuesday9:30 am - 6.00 pm
Wednesday9:30 am - 6.00 pm
Thursday9:30 am - 6.00 pm
Friday9:30 am - 5.00 pm
SaturdayClosed
SundayClosed
This website uses cookies and asks your personal data to enhance your browsing experience.