YoVDO

Excel & Business Math - Important Formulas for Increase Decrease Problems

Offered By: ExcelIsFun via YouTube

Tags

Microsoft Excel Courses Financial Analysis Courses Business Math Courses

Course Description

Overview

Learn essential formulas for solving increase and decrease problems in Excel with this comprehensive video tutorial. Explore various methods including table and diagram approaches, and practice with eight real-world examples covering stock market analysis, farmland valuation, markdown and markup calculations, and company sales figures. Master techniques for calculating percentage changes, interpreting financial data, and creating formulas to analyze diverse scenarios in business and finance.

Syllabus

) Introduction.
) What is an Increase Decrease Problem.
) How to solve an Increase Problem with the Table Method, Diagram Method and an example of every possible formula for an Increase Problem..
) How to solve a Decrease Problem with the Table Method, Diagram Method and an example of every possible formula for an Increase Problem..
) Example 1: Stock Market Drop on Feb 5, 2018 and make formulas.
) Example 2: Using Yahoo Finance to get Stock Data and make formulas.
) Example 3: Farmland Value Example.
) Example 4: Markdown and Markup Examples.
) Example 5: GE Company Sales Example.
) Stock Example with a Portfolio of Different Stocks.
) Summary.


Taught by

ExcelIsFun

Related Courses

Become an Accounts Payable Officer
LinkedIn Learning
Become an Accounts Payable Officer
LinkedIn Learning
Excel & Business Math - Simple Interest Calculations & Short Term Loans
ExcelIsFun via YouTube
Excel & Business Math - Date Math, Invoices, Cash Discounts on Invoices, Nested IF Functions
ExcelIsFun via YouTube
Comprehensive Excel Payroll Example - SUMIFS, MROUND, MOD, VLOOKUP & More
ExcelIsFun via YouTube