Useful Excel for Beginners

Learn the basics of Microsoft Excel and become an effective user
Rating: 4.5 out of 5 (27,059 ratings)
261,525 students
Useful Excel for Beginners
Rating: 4.5 out of 5 (27,059 ratings)
261,525 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
Curriculum
13 sections • 89 lectures • 9h 38m total length
  • Introduction to the Course
  • Basics of Excel
  • Workbooks and Worksheets
  • Fundamentals
  • CHAPTER 2: Basics of Excel
  • How to Enter data
  • Auto Fit
  • Keyboard Navigation
  • Auto Complete
  • Entering Numbers
  • Navigating edges
  • Navigating - First and last used cells
  • Selecting cells - Introduction
  • Selecting cells - Shift + Arrow
  • Selecting cells - Ctrl + Shift + Arrow
  • Selecting cells - Mouse Click and Drag
  • Selecting cells - Mouse Click and Shift Click
  • Selecting cells - All Cells & Used Cells
  • Selecting cells - Rows and Columns
  • Selecting cells - Non-contiguous cells
  • Selecting cells - Summary
  • Number Formatting - Introduction
  • Number Formatting - General and Text
  • Number Formatting - Number and Fraction
  • Number Formatting - Currency
  • Number Formatting - Accounting
  • Number Formatting - Percentage
  • Number Formatting - Date
  • Number Formatting - Time
  • Number Formatting - Summary
  • Inserting and deleting Rows, Columns and Cells
  • CHAPTER 3: ENTERING DATA
  • Formatting - Introduction
  • Formatting - Bold, Italics and Underline
  • Formatting - Border
  • Formatting - Fill and Font
  • Formatting - Alignment
  • Formatting - Format Painter and Clear Formats
  • CHAPTER 4: FORMATTING
  • Editing - Editing Cell Content
  • Editing - Multiple Lines of Text
  • Editing - Ctrl + Enter
  • Editing - Auto Fill
  • Editing - Copy and Paste
  • Editing - Cut and Paste
  • Editing - Auto Fill Series
  • Editing - Sort
  • Editing - Filter
  • Editing - Find and Replace
  • CHAPTER 5: EDITING
  • Saving - Saving Excel documents
  • CHAPTER 6: SAVING
  • Viewing - Freeze Panes
  • Calculations - Introduction to Formula
  • Editing Formula
  • Introduction to Functions
  • Entering Functions
  • Types of Functions
  • MIN, MAX and AVERAGE Functions
  • Copying Formula
  • Cell References
  • Paste Formula
  • Counting Functions
  • Lookup Functions
  • Date Functions
  • Text Functions
  • SUMIF Function
  • IF Function
  • Errors
  • Calculations - Summary
  • CHAPTER 8: CALCULATIONS
  • Introduction to Charts
  • Creating a Chart
  • Chart Components - Labels
  • Chart Components - Background
  • Chart Components - Axes
  • Chart Components - Format and Design
  • Chart Types
  • Introduction to Conditional Formatting
  • Conditional Formatting - Format All Cells
  • Conditional Formatting - Format Only Cells
  • Conditional Formatting - More Rule Types
  • Conditional Formatting - Formula Based
  • Conditional Formatting - Summary
  • Illustrations
  • CHAPTER 9: VISUALIZING
  • Introduction to PivotTables
  • Creating PivotTable
  • PivotTable Summarization Types
  • PivotTable Tools
  • PivotCharts
  • CHAPTER 10: PIVOTTABLES

Instructor
Sharing simple but effective solutions
ind zara
  • 4.5 Instructor Rating
  • 27,061 Reviews
  • 262,552 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.