Learn MS Excel and Data Analysis

Master Essential Excel Formulas and Analyze Financials Like a Pro

4.70 (11 reviews)
Udemy
platform
English
language
Microsoft
category
instructor
Learn MS Excel and Data Analysis
1,026
students
3 hours
content
Feb 2022
last update
$19.99
regular price

What you will learn

Use Excel for Personal Finances

Use Excel for Stock Analysis

Calculate and Use Basic Excel Functions

Calculate and Use Advanced Excel Functions

Analyze Data in Excel

Create Pivot Tables

Excel Features

Lifetime Access to Excel Course + Quizzes & Worksheets

Analyze Financial Statements

Perform Business Analysis

Why take this course?

This course is designed with the Excel power user in mind. No prior knowledge of VLOOKUP, IF statements, PivotTables, Sensitivity Analysis, or other such formulas is required -- my goal is to teach you how to solve business problems in Excel.


***Extensive Experience as an eLearning video creator, course creator, for Udemy with over 8000 students.***


By the time you finish this course, you will have a deep understanding of the advanced tools that are built into Excel - and you'll be able to apply your newfound knowledge in your job, schoolwork, or home life.


You will be able to analyze the company's balance sheet and P&L in a short period of time.


Are you interested in using Microsoft Excel to analyze your data, but don’t know where to start? Listen to this course and you’ll learn how to use some of the most powerful functions, like VLOOKUP, INDEX/MATCH, and CHOOSE, as well as some of the lesser-known tricks like combining IF statements with array formulas.


This course is created for one simple purpose:

  • to show people that is possible to master Excel with a few simple techniques.


If you are:

  • a complete newbie when it comes to Excel and business modeling

  • an experienced user who wants to learn more about excel, advanced functions, and how to apply these functions for personal finances. 


I will also show you how to convert Excel from a basic spreadsheet into an analytics tool by explaining some of the most powerful tools that Excel has been hiding from you.


Learn how to calculate your mortgage, solve for unknowns in equations, build a stocks portfolio that grows over time. Gain the excel skills to achieve your financial goals.

Once you understand some of the basics about how Excel functions, you will find it to be a powerful tool for organizing and analyzing data, so you can make informed decisions about everything from your home mortgage payments to your stocks or bond portfolio.


This is the course I wish I had when I just started using Excel in college for building a stocks portfolio. It covers everything from the basics to investment banking formulas and ratios.


If you are ready to master Excel and start crushing your spreadsheets, this is the course for you.


Easy to follow, with practical examples that show exactly how Excel can help you achieve your goals faster.


Start today!

Screenshots

Learn MS Excel and Data Analysis - Screenshot_01Learn MS Excel and Data Analysis - Screenshot_02Learn MS Excel and Data Analysis - Screenshot_03Learn MS Excel and Data Analysis - Screenshot_04

Reviews

Anica
February 25, 2022
The course dives deep into excel functionalities and covers the importance of data analysis and finance.

Charts

Price

Learn MS Excel and Data Analysis - Price chart

Rating

Learn MS Excel and Data Analysis - Ratings chart

Enrollment distribution

Learn MS Excel and Data Analysis - Distribution chart

Related Topics

4411120
udemy ID
11/23/2021
course created date
2/25/2022
course indexed date
Bot
course submited by