Excel Tutorials For Beginners to Experts

Learn the secrets of Excel and become an Excel Expert. This course can be used with Excel 2013 and Excel 2016.
3.9 (9 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
525 students enrolled
$19
$25
24% off
Take This Course
  • Lectures 52
  • Length 3 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 3/2016 English

Course Description

This course is created for Excel beginners and has been designed for computer users who are willing to learn Microsoft Excel in simple steps. At the end of this course you will become an Excel Expert for sure. Also, even Excel Experts can improve their Excel Skills by the help of this course.

Tutorials are with English subtitles. Exercise files are included for each lecture. Shorcut Keys indicated for each lecture if available.

You will begin at beginner level and reach to intermediate level. You will use Excel effectively in your daily life, such as job, personal data usage etc.

Course consists of 11 Chapters. New Chapters will be added. 

Take this course to make your life easy and organized with Excel.

What are the requirements?

  • Microsoft Excel 2013 or Microsoft Excel 2016 must be installed before beginning the course

What am I going to get from this course?

  • Learn the secrets of Excel and become an Excel Expert.

What is the target audience?

  • Excel beginner users must take the course, Excel already users can develop their skills with the new features of Excel 2013 and Excel 2016

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Chapter 1 - Introduction
Introduction
Preview
00:47
1.1 Menu
Preview
01:04
1.2 Workbook
01:02
1.3 Worksheet
02:18
1.4 Quick Access Toolbar
01:30
1.5 Column Row Cell Status
01:38
Chapter 1 - Introduction Quiz
6 questions
Section 2: Chapter 2 - Data Entry
2.1 Entering Data
Preview
01:48
2.2 Auto Fill and Flash Fill
01:33
2.3 Dates and Times
01:21
2.4 Undo & Redo
01:33
2.5 Comments
02:35
2.6 New Open Save and Save As
04:40
Section 3: Chapter 3 - Formulas and Functions
3.1 Basic Formulas
Preview
04:16
3.2 Copy Formulas
01:22
3.3 Hierarchy
01:43
3.4 Absolute References
03:22
3.5 AutoSum
04:15
Section 4: Chapter 4 - Formatting
4.1 Font and Borders
Preview
04:43
4.2 Column Width and Row Height
03:56
4.3 Alignment
04:07
4.4 Number
03:04
4.5 Date and Time Format
02:02
4.6 Conditional Formatting
06:05
4.7 Tables
09:52
4.8 Illustrations
06:24
Section 5: Chapter 5 - Worksheet Layout
5.1 Insert and Delete Cells
Preview
03:00
5.2 Hide and Unhide
02:18
5.3 Cut Paste Copy Move
03:33
5.4 Find and Replace
04:39
Section 6: Chapter 6 - Print
6.1 Page Setup and Scale to Fit
12:00
6.2 PageBreakPreview and PageLayout
05:53
6.3 Print
04:52
Section 7: Chapter 7 - Charts
7.1 Recommended Charts
Preview
02:29
7.2 Creating Charts
04:03
7.3 Chart Formatting Shortcuts
03:05
7.4 Change Chart Type
01:55
7.5 Formatting Chart Elements
03:12
7.6 Trendline
02:02
7.7 Sparklines
03:00
Section 8: Chapter 8 - Worksheet Views
8.1 Freeze Panes and Split
05:37
8.2 Auto Outline
03:43
Section 9: Chapter 9 - Multiple Worksheets and Workbooks
9.1 Linking Data
03:40
9.2 Edit Links
02:07
Section 10: Chapter 10 - IF, VLOOKUP, and Other Functions
10.1 IF Function
Preview
04:18
10.2 VLOOKUP Function
05:33
10.3 COUNTIF Function
02:21
Section 11: Chapter 11 - Security and Sharing
11.1 Protect Sheet
Preview
01:33
11.2 Lock Cells
02:30
11.3 Protect Workbook
01:25
11.4 Workbook Password
03:09
11.5 Share Workbook
01:35
11.6 Track Changes
02:10

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Yakup Erinç GONCA, Jacobo Tutorials Founder, Atlas Sale Founder

I am Jacobo Tutorials (jacobotutorials.com) and Atlas Sale (atlassale.com) Founder. I have 10 years of experience with MS Office Programs and SAP. I am also an Android Developer. I improved myself through especially with tutorials, reading books and searching Google. If you want to learn something, watching tutorials is the best solution.

While watching tutorials I discovered that I can be a good instructor and dediced to make tutorials. I always begin with basics and slowly I reached the advanced levels. So in my courses I will begin with the basics and get you to Advanced Levels.




Ready to start learning?
Take This Course