Useful Excel for Beginners
Learn the basics of Microsoft Excel and become an effective user
4.52 (66272 reviews)
663,564
students
9.5 hours
content
Nov 2020
last update
FREE
regular price
What you will learn
Learn the fundamentals of Excel
Become an effective user
Why take this course?
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.
Content
Introduction
Introduction to the Course
Basics of Excel
Basics of Excel
Workbooks and Worksheets
Fundamentals
CHAPTER 2: Basics of Excel
Entering Data
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
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 - 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 - Saving Excel documents
CHAPTER 6: SAVING
Viewing
Viewing - Freeze Panes
Calculations
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
Visualizing
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
Analyzing
Introduction to PivotTables
Creating PivotTable
PivotTable Summarization Types
PivotTable Tools
PivotCharts
CHAPTER 10: PIVOTTABLES
Tables
Creating a Table
Tables - Functionality
CHAPTER 11: TABLES
Sharing
Save & Send
Printing
CHAPTER 12: SHARING
Final Thoughts
Final Thoughts
Screenshots
Reviews
Jean
November 11, 2023
Yes, it is a good match. The instructor is so fluent, clearly and concisely explains the various Excel functions, making it quite easy to follow along with my own spreadsheet.
Mary
November 10, 2023
I had no knowledge about Excel, so i believe this course will really be of help to me and help me to blend well into the career world
Niby
November 10, 2023
Good & detailed videos. Some explanations were a bit hard to understand but good part is it has covered every minute topics needed... Well done & thanks team :)
Said
November 7, 2023
I am a beginner in learning excel and i was emphasized about stating the course without having knowledge of the importance of it, so i loved that you made me more interested to learn more about the course because you shared the importance of learning excel.
Rojean
November 4, 2023
Yes, It's a good match for me, I realize I have so much more to learn in Excel. I have fun learning this. Thank you
Valentina
November 3, 2023
teacher use a very simple and clear english which allow me to understand very well for me that I am not an english mother tongue.
Abdul-Rasheed
November 1, 2023
This is the best excel course you can get in Udemy. The instructions was clearly stated and easy to understand. Highly recommended
Trương
October 30, 2023
This guy lectures on things that no one really cares about while not teaching about important things about Excel. Waste of times and money
Instead of learning from this guy, you guys can go learn excel on youtube
Susan
October 29, 2023
Yes, a good match. I have experience only in manipulating excel spreadsheets for printing purposes...do not have experience in creating reports via formulas. Really need to practice that application.
Sachin
October 24, 2023
Everything about basic excel is kept , simple and understandable way. Value for time spending on this course. Thank You!
Abhishek
October 24, 2023
Make your basic knowledge of Excel strong in this course. Great Informative that none of the youtubers teach.
Kunal
October 23, 2023
VOICE IS TOO MUCH SLOW AND SOMEWHERE THE VIDEO IS GITTING STUCK IN MIDDLE. IT IS SHOWINNG VIDEO PLAYING ERROR
Kikelomo
October 20, 2023
I leave the rating because of the very simple manner of the course delivery. Anyone can understand the course no matter their level of computer proficiency. The teacher is doing an amazing job with his teaching.
Leliza
October 20, 2023
It really gives me additional knowledge as I am just a newbie in excel. Plus the instructions are very clear. Thanks.
Kumkum
October 18, 2023
Yes, it is a good course. I am a beginner and I am enjoying this course very well. Thanks for this amazing course.
Charts
Price
Rating
Enrollment distribution
Related Topics
53600
udemy ID
5/12/2013
course created date
7/29/2019
course indexed date
Bot
course submited by