Tutorialspoint

Learn MS Excel, Data Analysis, and Financial Analysis

person icon Tayana Grubisic

Learn MS Excel, Data Analysis, and Financial Analysis

Master Essential Excel Formulas, Analyze Financials, and Pick Stock

updated on icon Updated on Sep, 2023

language icon Language - English

person icon Tayana Grubisic

architecture icon Excel,Financial Analysis,Office Productivity,Microsoft

price-loader

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 19,000+ top Tutorialspoint courses anytime, anywhere.

Course Description

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, and course creator, with over 9000 students, and over 3000 subscribers on YouTube.***

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, and build a stock portfolio that grows over time. Gain the excel skills to achieve your financial goals.

Once you understand some of the basics of 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!

Goals

What will you learn in this course:

  • 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

Prerequisites

What are the prerequisites for this course?

  • No previous Excel knowledge required. You will learn everything from the start

Learn MS Excel, Data Analysis, and Financial Analysis

Curriculum

Check out the detailed breakdown of what’s inside the course

Introduction
4 Lectures
  • play icon Course Overview 01:20 01:20
  • play icon MS Excel Basics 04:00 04:00
  • play icon Basic Excel Formulas 03:31 03:31
  • play icon Intro to Functions 02:07 02:07
MS Excel Basics
16 Lectures
Tutorialspoint
Functions and Formulas
18 Lectures
Tutorialspoint
Finance and Financial Analysis
12 Lectures
Tutorialspoint

Instructor Details

Tayana Grubisic

Tayana Grubisic

Passionate, cross-functional, creative, and results-driven professional with over 4 years of experience in digital marketing and eCommerce. I’m a believer that data should drive decisions, but with fresh creativity to support it. I'll teach you how you can build an online business using the right tools. MSc in Entrepreneurial Leadership with interest in data analytics and finance.

Course Certificate

User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
People having fun around a laptop

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
People having fun around a laptop

Talk to us

1800-202-0515