Excel for Complete Beginners - Learn From Examples

Focused View

Jeremy Schilling

35:34

8 View

1. Complete Beginner Course - Zero to Hero in Excel

1. Introduction.mp4

00:17

2. Opening An Excel File.mp4

00:32

3. What are Columns, Rows, and Cells.mp4

01:48

4. Home Tab.mp4

01:06

5. Insert Tab.mp4

00:16

6. Page Layout Tab.mp4

00:31

7. Data Tab - Filters.mp4

02:00

8. Data Tab - Data Tools.mp4

00:52

9. Review Tab.mp4

00:37

10. View Tab.mp4

00:17

11. Formula Introduction.mp4

00:29

12. Xlookup Formula.mp4

04:18

13. IF Statement Formula.mp4

00:55

14. Subtotal Formula.mp4

01:24

15. Course Wrap Up.mp4

00:17

2. Live Examples

1. Introduction.mp4

00:30

2. Filters.mp4

02:56

3. Data Tools.mp4

03:48

4. Freeze Panes.mp4

01:59

5. Xlookup.mp4

04:17

6. IF Statement.mp4

05:32

7. Subtotal.mp4

00:53

Description

Learn Microsoft Excel Fast and Easily through Examples

What You'll Learn?

Understand the complete basics of Microsoft Excel
Learn what the different tabs do in Microsoft Excel
Learn what cells, rows, and columns are in Microsoft Excel
Learn the most commonly used formulas in Microsoft Excel

Who is this for?

Complete Beginner Excel Users

What You Need to Know?

No Excel experience needed. You will learn everything you need to know in the course.

More details

Description
Summary of Course
This course walks the complete beginner through Microsoft Excel from the very beginning. The course begins with opening an excel file and progresses to understanding the anatomy of a spreadsheet (columns, rows, and cells), understanding the different tabs, and finally diving into the most common used formulas. Along the way, the student is given examples of how each function or formula works. At the end of the course, there is an entire section dedicated to more examples - this is the real power of the course. Learning by example is the best way to learn and this course embodies that concept. The live examples section is set at a pace where the student can follow along in Excel and work through everything alongside me. This will bring someone from zero knowledge in Excel to an Intermediate level analyst that could ace the initial job recruiter Excel tests.

Course Content
Opening an Excel File
Columns, Rows, and Cells
Home Tab
Font
Alignment
Insert Tab
Page Layout Tab
Data Tab
Filters
Text to Columns
Remove Duplicates
Review Tab
View Tab
Freeze Panes
Introduction to Formulas
The Xlookup
The IFÂ Statement
The Subtotal Formula
Don't be afraid of excel - this course will teach you everything you need to know and more. You will become your company's subject matter expert in Excel!
Who this course is for:
Complete Beginner Excel Users

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Jeremy Schilling

Instructor's Courses

Hi, I'm Jeremy. I have been in the working world for almost 7 years and all of that time has been spent in excel. From my time in college, to my current role today, excel has been a part of my daily toolkit. I’ve developed a passion for analytics, an interest in figuring out the most efficient solutions, and a love for automation.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.