Useful Excel for Beginners
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.
Basics of Excel
Entering Data
Formatting
-
6
How to Enter data -
7
Auto Fit
-
8
Keyboard Navigation
-
9
Auto Complete
-
10
Entering Numbers
-
11
Navigating edges
-
12
Navigating - First and last used cells
-
13
Selecting cells - Introduction
-
14
Selecting cells - Shift + Arrow
-
15
Selecting cells - Ctrl + Shift + Arrow
-
16
Selecting cells - Mouse Click and Drag
-
17
Selecting cells - Mouse Click and Shift Click
-
18
Selecting cells - All Cells & Used Cells
-
19
Selecting cells - Rows and Columns
-
20
Selecting cells - Non-contiguous cells
-
21
Selecting cells - Summary
-
22
Number Formatting - Introduction
-
23
Number Formatting - General and Text
-
24
Number Formatting - Number and Fraction
-
25
Number Formatting - Currency
-
26
Number Formatting - Accounting
-
27
Number Formatting - Percentage
-
28
Number Formatting - Date
-
29
Number Formatting - Time
-
30
Number Formatting - Summary
-
31
Inserting and deleting Rows, Columns and Cells
-
32
CHAPTER 3: ENTERING DATAQUESTIONS RELATED TO THE MATERIAL COVERED IN CHAPTER 3: ENTERING DATA
Editing
Saving
-
40
Editing - Editing Cell Content
-
41
Editing - Multiple Lines of Text
-
42
Editing - Ctrl + Enter
-
43
Editing - Auto Fill
-
44
Editing - Copy and Paste
-
45
Editing - Cut and Paste
-
46
Editing - Auto Fill Series
-
47
Editing - Sort
-
48
Editing - Filter
-
49
Editing - Find and Replace
-
50
CHAPTER 5: EDITING
QUESTIONS RELATED TO MATERIAL COVERED IN CHAPTER 5: EDITING
Viewing
Calculations
Visualizing
-
54
Calculations - Introduction to Formula
-
55
Editing Formula
-
56
Introduction to Functions
-
57
Entering Functions
-
58
Types of Functions
-
59
MIN, MAX and AVERAGE Functions
-
60
Copying Formula
-
61
Cell References
-
62
Paste Formula
-
63
Counting Functions
-
64
Lookup Functions
-
65
Date Functions
-
66
Text Functions
-
67
SUMIF Function
-
68
IF Function
-
69
Errors
-
70
Calculations - Summary
-
71
CHAPTER 8: CALCULATIONS
QUESTIONS RELATED TO MATERIAL COVERED IN CHAPTER 8: CALCULATIONS
Analyzing
-
72
Introduction to Charts
-
73
Creating a Chart
-
74
Chart Components - Labels
-
75
Chart Components - Background
-
76
Chart Components - Axes
-
77
Chart Components - Format and Design
-
78
Chart Types
-
79
Introduction to Conditional Formatting
-
80
Conditional Formatting - Format All Cells
-
81
Conditional Formatting - Format Only Cells
-
82
Conditional Formatting - More Rule Types
-
83
Conditional Formatting - Formula Based
-
84
Conditional Formatting - Summary
-
85
Illustrations
-
86
CHAPTER 9: VISUALIZING
QUESTIONS RELATED TO MATERIAL COVERED IN CHAPTER 9: VISUALIZING
Related Courses
