Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Udemy

Beginner to Pro - Excel Tutorial

via Udemy

Overview

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

What you'll 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

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 integratedfinancial 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.


Taught by

ThinkTank Careers

Reviews

4.1 rating at Udemy based on 551 ratings

Start your review of Beginner to Pro - Excel Tutorial

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.