- Learn the basics of Microsoft Excel and become an effective user
- Free tutorial
- Rating: 4.5 out of 54.5 (64,453 ratings)
- 641,141 students
- 9hr 38min of on-demand video
- Created by Dinesh Natarajan Mohan
English
What you’ll learn
- 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
Show less
Course content
13 sections • 89 lectures • 9h 38m total lengthCollapse all sections
Introduction1 lecture • 7min
- Introduction to the Course07:11
Basics of Excel3 lectures • 11min
- Basics of Excel03:36
- Workbooks and Worksheets02:46
- Fundamentals05:03
- CHAPTER 2: Basics of Excel5 questions
Entering Data26 lectures • 2hr 45min
- How to Enter data04:17
- Auto Fit07:07
- Keyboard Navigation05:07
- Auto Complete04:49
- Entering Numbers03:32
- Navigating edges09:18
- Navigating – First and last used cells02:27
- Selecting cells – Introduction02:03
- Selecting cells – Shift + Arrow08:38
- Selecting cells – Ctrl + Shift + Arrow08:59
- Selecting cells – Mouse Click and Drag03:45
- Selecting cells – Mouse Click and Shift Click03:21
- Selecting cells – All Cells & Used Cells03:09
- Selecting cells – Rows and Columns03:16
- Selecting cells – Non-contiguous cells04:41
- Selecting cells – Summary10:02
- Number Formatting – Introduction06:23
- Number Formatting – General and Text08:40
- Number Formatting – Number and Fraction15:54
- Number Formatting – Currency05:21
- Number Formatting – Accounting01:50
- Number Formatting – Percentage05:45
- Number Formatting – Date12:05
- Number Formatting – Time10:51
- Number Formatting – Summary02:22
- Inserting and deleting Rows, Columns and Cells11:37
- CHAPTER 3: ENTERING DATA8 questions
Formatting6 lectures • 37min
- Formatting – Introduction05:08
- Formatting – Bold, Italics and Underline05:05
- Formatting – Border08:58
- Formatting – Fill and Font05:27
- Formatting – Alignment09:09
- Formatting – Format Painter and Clear Formats03:17
- CHAPTER 4: FORMATTING2 questions
Editing10 lectures • 1hr 11min
- Editing – Editing Cell Content07:44
- Editing – Multiple Lines of Text03:32
- Editing – Ctrl + Enter02:51
- Editing – Auto Fill05:39
- Editing – Copy and Paste07:13
- Editing – Cut and Paste07:32
- Editing – Auto Fill Series06:59
- Editing – Sort12:18
- Editing – Filter06:14
- Editing – Find and Replace10:45
- CHAPTER 5: EDITING5 questions
Saving1 lecture • 10min
- Saving – Saving Excel documents09:58
- CHAPTER 6: SAVING3 questions
Viewing1 lecture • 7min
- Viewing – Freeze Panes06:47
Calculations17 lectures • 2hr 6min
- Calculations – Introduction to Formula07:42
- Editing Formula02:03
- Introduction to Functions08:23
- Entering Functions08:51
- Types of Functions03:00
- MIN, MAX and AVERAGE Functions05:00
- Copying Formula07:34
- Cell References09:40
- Paste Formula02:27
- Counting Functions08:25
- Lookup Functions13:29
- Date Functions04:53
- Text Functions15:26
- SUMIF Function11:08
- IF Function04:37
- Errors11:33
- Calculations – Summary01:52
- CHAPTER 8: CALCULATIONS10 questions
Visualizing14 lectures • 1hr 21min
- Introduction to Charts02:33
- Creating a Chart08:58
- Chart Components – Labels10:33
- Chart Components – Background01:27
- Chart Components – Axes07:49
- Chart Components – Format and Design02:21
- Chart Types10:47
- Introduction to Conditional Formatting01:51
- Conditional Formatting – Format All Cells08:35
- Conditional Formatting – Format Only Cells05:44
- Conditional Formatting – More Rule Types06:52
- Conditional Formatting – Formula Based05:33
- Conditional Formatting – Summary03:03
- Illustrations04:51
- CHAPTER 9: VISUALIZING4 questions
Analyzing5 lectures • 31min
- Introduction to PivotTables02:07
- Creating PivotTable07:45
- PivotTable Summarization Types05:44
- PivotTable Tools10:44
- PivotCharts04:56
- CHAPTER 10: PIVOTTABLES4 questions
Tables2 lectures • 17min
- Creating a Table06:39
- Tables – Functionality09:51
- CHAPTER 11: TABLES3 questions
Sharing2 lectures • 12min
- Save & Send01:47
- Printing10:37
- CHAPTER 12: SHARING3 questions
Final Thoughts1 lecture • 3min
- Final Thoughts02:35
