Useful Excel for Beginners

Learn the basics of Microsoft Excel and become an effective user
Rating: 4.5 out of 5 (29,460 ratings)
284,463 students
Useful Excel for Beginners
Rating: 4.5 out of 5 (29,460 ratings)
284,463 students
Learn the fundamentals of Excel
Become an effective user

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. 

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

Who this course is for:
  • Never used Excel before
  • Beginner level Excel user
Course content
13 sections • 89 lectures • 9h 38m total length
  • Introduction to the Course
    07:11
  • Basics of Excel
    03:36
  • Workbooks and Worksheets
    02:46
  • Fundamentals
    05:03
  • CHAPTER 2: Basics of Excel
    5 questions
  • 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
  • CHAPTER 3: ENTERING DATA
    8 questions
  • 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
  • CHAPTER 4: FORMATTING
    2 questions
  • 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
  • CHAPTER 5: EDITING
    5 questions
  • Saving - Saving Excel documents
    09:58
  • CHAPTER 6: SAVING
    3 questions
  • Viewing - Freeze Panes
    06:47
  • 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
  • CHAPTER 8: CALCULATIONS
    10 questions
  • 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
  • CHAPTER 9: VISUALIZING
    4 questions
  • Introduction to PivotTables
    02:07
  • Creating PivotTable
    07:45
  • PivotTable Summarization Types
    05:44
  • PivotTable Tools
    10:44
  • PivotCharts
    04:56
  • CHAPTER 10: PIVOTTABLES
    4 questions

Instructor
Sharing simple but effective solutions
ind zara
  • 4.5 Instructor Rating
  • 29,462 Reviews
  • 284,502 Students
  • 2 Courses

I, Dinesh Natarajan Mohan, have been working with Microsoft Excel since 2001. My specialty is in the field of Reporting and Analytics. I have experience leading Reporting and Analytics teams in different domains such as Finance, Marketing and Operations in the U.S. 

From 2013, I have been publishing Excel templates on my website indzara. As of writing this, I have published more than 50 Excel templates, both free and premium. The templates have been downloaded and appreciated by users from more than 100+ countries. So far, there have been more than 7000 premium customers and more than 500,000 downloads of the free templates.

I also publish video demos of all my Excel templates in my YouTube Channel which has more than 10,000 subscribers and been viewed more than 2 Million times. I have published more than 235 free videos.