Complete Excel Tutorial 2017
4.6 (4 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.
1,434 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Complete Excel Tutorial 2017 to your Wishlist.

Add to Wishlist

Complete Excel Tutorial 2017

Learn to use excel and go from a beginner to pro in no time
New
4.6 (4 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.
1,434 students enrolled
Created by ThinkTank Careers
Last updated 9/2017
English
Current price: $10 Original price: $40 Discount: 75% off
3 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion

Training 5 or more people?

Get your team access to Udemy's top 2,000 courses anytime, anywhere.

Try Udemy for Business
What Will I Learn?
  • Enter numbers and formulas in excel
  • The layout of excel
  • Creating clean spreadsheets
  • Use formulas to automate your work
  • Pivot tables
  • IF functions
  • Vlookup & Hlookup
  • Index & Match
  • Financial charts
  • Graphs
  • Data validation
  • Forecasting
  • Data Sorting and Filtering
  • Absolute References
View Curriculum
Requirements
  • Should be able to use computer at beginner level
  • Should be able to download Microsoft Excel on computer
  • Eagerness to learn
Description

Why this course is for you

You want to increase your Excel skills to become more efficient at work, school, or any personal project. You want to learn powerful Excel functions that will allow you to automate much of your work and make your life easier.  You want to learn how to setup clean spreadsheets and use Excel's functions to work much more efficiently and with less effort.

The functions and formulas you will learn will teach you how to use Excel from beginner to and intermediate level. Along the way I will teach you shortcuts and tips that will impress any employer or teacher.

What you will learn:

  1. The basics of excel: how to input numbers, how to input formulas, and the different functions of Excel
  2. Advance functions to analyze your data 
  3. Setups that will help automate your work
  4. Graphs and charts
  5. Create multiple scenarios
  6. Vlookup, hlookup, index & match functions
  7. How to build dynamic queries
  8. Financial functions
  9. How to create a macro
  10. How to create debt schedules and pp&e schedules
  11. Forecasting
  12. How to create pivot tables

What you will need:

  1. A computer, laptop, or tablet
  2. Microsoft Excel
  3. Hunger to learn 

30-day money back guarantee

In the rare case that you feel the course was not helpful or isn't for you I will refund your money up to 30 days.  You have nothing to lose and everything to gain.

Who is the target audience?
  • Anyone looking to learn Excel for school, work, or personal reasons
  • Anyone who wants to take their Excel skills from beginner to intermediate
Compare to Other Excel Courses
Curriculum For This Course
34 Lectures
02:38:20
+
Getting Started
2 Lectures 10:19
+
Basic Concepts
11 Lectures 51:49
Basic Calculations (Sum, Min, Max, Avg)
07:25

Formatting Styles
04:50

Quick Analysis Tool
03:37

Data Sorting & Filtering
03:55

Freeze Pane
02:04

Absolute References
05:20

Mixed References
05:43

Charts and Graphs
05:17

Flash Fill Data
03:06

Naming Cells & Cross Sheet Reference
04:44

Calculating Percentages
05:48
+
Advance Concepts
11 Lectures 57:41
Financial Functions I
07:55

Finance Functions II
05:58

Dates & Time Periods
05:10

IF Statements
07:22

Vlookup
11:40

Index & Match
04:44

One Click Forecasting
03:32

New Charts & Graphs
02:45

Data Gathering
02:49

Financial Charts
02:55

Data Validation
02:51
+
Pivot Table & Dashboard
3 Lectures 27:59
Pivot Tables I
07:26

Pivot Table II
06:57

Pivot Table III
13:36
+
Processing Tools
3 Lectures 06:00
Set Print Area
01:10

Link Excel to Word
02:51

Save as PDF
01:59
+
Conclusion
1 Lecture 00:42
Conclusion
00:42
About the Instructor
ThinkTank Careers
4.4 Average rating
41 Reviews
5,054 Students
5 Courses
ThinkTank Careers

ThinkTank Careers is a team of professional businessmen and women who have come together to educate individuals in our respective professions.  All of our teachers are college graduates with years of work experience in our fields. Our careers range from finance to management to bloggers. We are diverse group of individuals who hope to educate as many students as possible.