Skip to content
UdemyExcelPaid courseAll LevelsCertificate

Beginner to Pro - Excel Tutorial (Udemy.com)

Become an Excel power user by learning all the functions, formulas, and formatting you will need to for finance

Created by: ThinkTank Careers

Last updated August 2020

icon
What you will learn

  • How to build a professional financial analysis setup
  • How to use powerful Excel functions and formulas
  • How to build pivot tables
  • Financial modeling
  • Recording Macros
  • Build dynamic queries
  • Build drop down lists
  • Clean formatting
  • Forecasting
  • Build dashboards
  • Integrated financial statements
  • Entering numbers in excel
  • Basic application and how to use Excel

How it compares

Against the other 355 rated Udemy courses in Excel on CourseDuck:

  • Rating4.2 out of 5higher than 8% of them
  • Reviews552#217 of 356 by number of reviews
  • Length8.4 hourslonger than 63% of them
  • Last updatedAugust 2020earlier than 73% of them

icon
Course 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 and format different financial setups and use advance functions to deeper analyze your data.

The functions and formulas you will learn will not only teach you how to use Excel for finance, but it will teach you tools to become an Excel power user in other areas. I will teach you shortcuts and tips that will impress anyone employer.

At the end of each section I have also created quizzes for you to make sure you are understanding the concepts and remember them for life!

What you will learn:

  1. The basics of excel: how to input numbers, how to input formulas, and the different functions of Excel
  2. How to create a professional financial analysis setup
  3. Build a common size income statement
  4. Functions that will help you analyze your data at a deeper
  5. Create multiple scenarios
  6. Vlookup, hlookup, index & match functions
  7. How to build dynamic queries
  8. Finance functions (NPV, IRR, Payback Period)
  9. How to create a macro
  10. How to create integrated financial statements (Balance Sheet, Income Statement, Statement of Cash Flows)
  11. How to create debt schedules and pp&e schedules
  12. Forecasting revenues
  13. Running a statistical regression
  14. How to create pivot tables and dashboards

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.


icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

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.  

icon
More Excel courses

$39.99

Free

$99.99

Free

$15.99

$119.99

icon
Reviews

4.2

552 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

By Lanre Awoeyo on 8/29/2023

Thanks to the Trainer. The course has achieved its goal of Excel pro. I really need to know detail about Macro and VBA, please can you guide and help me on how I can know it? My contact: Lanre.S.Awoeyo@gmail.com and +2348037640409 (WhatsApp) Thanks to Udemy for providing this great learning platform.

By Aditya Agarwal on 5/29/2021

Had the best experience in learning excel from learning such a good mentor. Enjoyed all the videos. It was fun attending the classes.

By Areeba Nasir on 8/27/2020

bro you tell a lot of stories in the course the course is about excel so just keep it short and to the point instead of beating around the bush .... other than this huge disatisfation the information in the course was good

By Ed John on 6/23/2020

I felt as though I was looking over the shoulder of someone who knows Excel well, but does not do a very good job of explaining it to others. Too much "then you do this, then this, then this ..." using keyboard shortcuts, with little explanation of why.

By Lorna Reed on 4/15/2020

I thought I had quite a good basic knowledge of Excel but even from Video one am learning so much. The shortcuts are so handy! His voice could be a little bit more animated. I do like the interactive quizzes throughout the course think there could be more of these to test the knowledge we have learnt. Also surely he could have re recorded if a mistake was made or to find the way to align charts without having to do it manually?

By Lenny McKnight on 4/13/2020

I've learn some new tricks here, like shift+right to move to next cell, then control+r to repeat, excellent. I do have one issue the instructor at times went too fast, hence made it impossible to follow, slow down as some of us are trying to do the course with you.

By Siddhant Ratna on 4/1/2020

Great Experience. Very informative in the very short video. Best for the student or working professional who is in the accounts field. Thanks a lot

By Tiger Williams on 3/23/2020

I thought it was well done. Easy to follow along. I would recommend this for beginners. Some thoughts... Replicating cell formats is MUCH easier using the format painter - good to show the short cut method for a few times. After a few times it is not needed to watch how to format/add each group - too repetitive. Showing a currency format with only 1 decimal seems odd - should be none or 2. On the pivot tables simplicity is key - showing 2 decimals just 'muddies the water'. - showing pennies on values in the thousands of dollars is not needed for decision makers. - grand total maybe, since that is a value that may need to be reported on.

By Ryen Haney on 3/24/2018

This course was very useful for me as I am taking an Internship that requires excel skills and this has given me a solid base to perform well and do good work at this job

By Said Hmaidan on 6/27/2017

Important information, especially the shortcuts, but he goes too fast. The course has wealth of information and the instructor is very knowledgeable about the content and the technical. So I suggest the instructor to adjust his speed accordingly and pronounce terms and names slowly and clearly.

Showing all 10 reviews on CourseDuck

Read all 552 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 84 / 100