Excel Tutorials For Beginners to Experts
4.0 (10 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.
529 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel Tutorials For Beginners to Experts to your Wishlist.

Add to Wishlist

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.
4.0 (10 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.
529 students enrolled
Last updated 8/2016
English
Current price: $10 Original price: $30 Discount: 67% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • 61 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Learn the secrets of Excel and become an Excel Expert.
View Curriculum
Requirements
  • Microsoft Excel 2013 or Microsoft Excel 2016 must be installed before beginning the 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.

Who 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 52 Lectures Collapse All 52 Lectures 02:52:42
+
Chapter 1 - Introduction
6 Lectures 08:19


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
+
Chapter 2 - Data Entry
6 Lectures 13:30

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
+
Chapter 3 - Formulas and Functions
5 Lectures 14:58

3.2 Copy Formulas
01:22

3.3 Hierarchy
01:43

3.4 Absolute References
03:22

3.5 AutoSum
04:15
+
Chapter 4 - Formatting
8 Lectures 40:13

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
+
Chapter 5 - Worksheet Layout
4 Lectures 13:30

5.2 Hide and Unhide
02:18

5.3 Cut Paste Copy Move
03:33

5.4 Find and Replace
04:39
+
Chapter 6 - Print
3 Lectures 22:45
6.1 Page Setup and Scale to Fit
12:00

6.2 PageBreakPreview and PageLayout
05:53

6.3 Print
04:52
+
Chapter 7 - Charts
7 Lectures 19:46

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
+
Chapter 8 - Worksheet Views
2 Lectures 09:20
8.1 Freeze Panes and Split
05:37

8.2 Auto Outline
03:43
+
Chapter 9 - Multiple Worksheets and Workbooks
2 Lectures 05:47
9.1 Linking Data
03:40

9.2 Edit Links
02:07
+
Chapter 10 - IF, VLOOKUP, and Other Functions
3 Lectures 12:12

10.2 VLOOKUP Function
05:33

10.3 COUNTIF Function
02:21
1 More Section
About the Instructor
Yakup Erinç GONCA
4.0 Average rating
10 Reviews
529 Students
1 Course
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.