- Online Degree Explore Bachelor’s & Master’s degrees
- MasterTrack™ Earn credit towards a Master’s degree
- University Certificates Advance your career with graduate-level learning
- Top Courses
- Join for Free
This course is part of the Data Analysis and Presentation Skills: the PwC Approach Specialization
Problem Solving with Excel
- Thumbs Up 93%
Financial aid available
About this Course
This course explores Excel as a tool for solving business problems. In this course you will learn the basic functions of excel through guided demonstration. Each week you will build on your excel skills and be provided an opportunity to practice what you’ve learned. Finally, you will have a chance to put your knowledge to work in a final project. Please note, the content in this course was developed using a Windows version of Excel 2013.
This course was created by PricewaterhouseCoopers LLP with an address at 300 Madison Avenue, New York, New York, 10017.
Skills you will gain
- Data Analysis
- Microsoft Excel
- Pivot Table
- Data Cleansing
Alex Mannella
With offices in 157 countries and more than 208,000 people, PwC is among the leading professional services networks in the world. Our purpose is to build trust in society and solve important problems. We help organisations and individuals create the value they’re looking for, by delivering quality in assurance, tax and advisory services.
Syllabus - What you will learn from this course
Overview of excel.
In this module, you will learn the basics of Excel navigation and Excel basic functionality. You will learn how to navigate the basic Excel screen including using formulas, subtotals and text formatting. We will provide you an opportunity to perform a problem solving exercise using basic Excel skills. Note: We recommend viewing videos in full-screen mode by clicking the double arrow in the lower right hand corner of your screen.
vLookups and Data Cleansing
In this module you will learn about VLookup, value cleansing and text functions. We will also introduce you to PwC's perspective on the value in cleansing data and using the appropriate functions. Finally, we will provide you an opportunity to perform a problem solving exercise using VLookup, value cleansing and text function. Note: We recommend viewing videos in full-screen mode by clicking the double arrow in the lower right hand corner of your screen.
Logical Functions & Pivot Tables
In this module, you will learn about logical functions and pivot tables. We will show you how to create and use pivot tables to solve business problems. We will give you an opportunity to practice creating and using a pivot table to solve a business problem. Finally, we will share some insight on PwC’s perspectives on the impact of Excel on your career and work. Note: We recommend viewing videos in full-screen mode by clicking the double arrow in the lower right hand corner of your screen.
More Advanced Formulas
In this module you will learn more advanced Excel formulas. We will show you how to create statistical formulas, perform an index match, and lastly, build financial formulas. We will provide you with an opportunity to problem solve using statistical formulas. Finally, we will give you an opportunity to practice what you have learned through a final project. Note: We recommend viewing videos in full-screen mode by clicking the double arrow in the lower right hand corner of your screen.
- 5 stars 77.08%
- 4 stars 18.69%
- 3 stars 3.12%
- 2 stars 0.68%
- 1 star 0.40%
TOP REVIEWS FROM PROBLEM SOLVING WITH EXCEL
Some questions in the cumulative exercise should be phrased in a more "lay man" manner. I don't seem to understand the question(s) at times. Overall still a very good learning journey for me
Really useful training, lot's of meaningful functions (vlookup, index(match) & text functions).
Good to learn formulas in english too and get familiar with them (I was french Excel user).
Great course so far, learned a lot about how to use Excel functions to solve problems. However, the course may need an update on the missing videos and minor calculation errors in the workbooks.
This course was really informative and motivated the learner to practice everything practically. There was some audio problem in some of the lectures though which could be improved.
About the Data Analysis and Presentation Skills: the PwC Approach Specialization
If you are a PwC Employee, gain access to the PwC Specialization and Courses for free using the instructions on Vantage.
This Specialization will help you get practical with data analysis, turning business intelligence into real-world outcomes. We'll explore how a combination of better understanding, filtering, and application of data can help you solve problems faster - leading to smarter and more effective decision-making. You’ll learn how to use Microsoft Excel, PowerPoint, and other common data analysis and communication tools, and perhaps most importantly, we'll help you to present data to others in a way that gets them engaged in your story and motivated to act. Please note: If you'd like to audit the courses in this Specialization, you'll need to enroll in each course separately and then you will see the audit option. This specialization was created by PricewaterhouseCoopers LLP with an address at 300 Madison Avenue, New York, New York, 10017.
Frequently Asked Questions
When will I have access to the lectures and assignments?
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.
The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I subscribe to this Specialization?
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.
Is financial aid available?
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.
More questions? Visit the Learner Help Center .
Coursera Footer
Start or advance your career.
- Google Data Analyst
- Google Digital Marketing & E-commerce Professional Certificate
- Google IT Automation with Python Professional Certificate
- Google IT Support
- Google Project Management
- Google UX Design
- Preparing for Google Cloud Certification: Cloud Architect
- IBM Cybersecurity Analyst
- IBM Data Analyst
- IBM Data Engineering
- IBM Data Science
- IBM Full Stack Cloud Developer
- IBM Machine Learning
- Intuit Bookkeeping
- Meta Front-End Developer
- DeepLearning.AI TensorFlow Developer Professional Certificate
- SAS Programmer Professional Certificate
- Launch your career
- Prepare for a certification
- Advance your career
- How to Identify Python Syntax Errors
- How to Catch Python Exceptions
- See all Programming Tutorials
Popular Courses and Certifications
- Free Courses
- Artificial Intelligence Courses
- Blockchain Courses
- Computer Science Courses
- Cursos Gratis
- Cybersecurity Courses
- Data Analysis Courses
- Data Science Courses
- English Speaking Courses
- Full Stack Web Development Courses
- Google Courses
- Human Resources Courses
- Learning English Courses
- Microsoft Excel Courses
- Product Management Courses
- Project Management Courses
- Python Courses
- SQL Courses
- Agile Certifications
- CAPM Certification
- CompTIA A+ Certification
- Data Analytics Certifications
- Scrum Master Certifications
- See all courses
Popular collections and articles
- Free online courses you can finish in a day
- Popular Free Courses
- Business Jobs
- Cybersecurity Jobs
- Entry-Level IT Jobs
- Data Analyst Interview Questions
- Data Analytics Projects
- How to Become a Data Analyst
- How to Become a Project Manager
- Project Manager Interview Questions
- Python Programming Skills
- Strength and Weakness in Interview
- What Does a Data Analyst Do
- What Does a Software Engineer Do
- What Is a Data Engineer
- What Is a Data Scientist
- What Is a Product Designer
- What Is a Scrum Master
- What Is a UX Researcher
- How to Get a PMP Certification
- PMI Certifications
- Popular Cybersecurity Certifications
- Popular SQL Certifications
- Read all Coursera Articles
Earn a degree or certificate online
- Google Professional Certificates
- Professional Certificates
- See all certificates
- Bachelor's Degrees
- Master's Degrees
- Computer Science Degrees
- Data Science Degrees
- MBA & Business Degrees
- Data Analytics Degrees
- Public Health Degrees
- Social Sciences Degrees
- Management Degrees
- BA vs BS Degree
- What is a Bachelor's Degree?
- 11 Good Study Habits to Develop
- How to Write a Letter of Recommendation
- 10 In-Demand Jobs You Can Get with a Business Degree
- Is a Master's in Computer Science Worth it?
- See all degree programs
- Coursera India
- Coursera UK
- Coursera Mexico
- What We Offer
- Coursera Plus
- MasterTrack® Certificates
- For Enterprise
- For Government
- Become a Partner
- Coronavirus Response
- Beta Testers
- Translators
- Teaching Center
- Accessibility
- Modern Slavery Statement
- Get started with computers
- Learn Microsoft Office
- Apply for a job
- Improve my work skills
- Design nice-looking docs
- Getting Started
- Smartphones & Tablets
- Typing Tutorial
- Online Learning
- Basic Internet Skills
- Online Safety
- Social Media
- Zoom Basics
- Google Docs
- Google Sheets
- Career Planning
- Resume Writing
- Cover Letters
- Job Search and Networking
- Business Communication
- Entrepreneurship 101
- Careers without College
- Job Hunt for Today
- 3D Printing
- Freelancing 101
- Personal Finance
- Sharing Economy
- Decision-Making
- Graphic Design
- Photography
- Image Editing
- Learning WordPress
- Language Learning
- Critical Thinking
- For Educators
- Translations
- Staff Picks
- English expand_more expand_less
Excel Formulas - Functions
Excel formulas -, excel formulas functions.
Excel Formulas: Functions
Lesson 5: functions.
/en/excelformulas/relative-and-absolute-cell-references/content/
Introduction
A function is a predefined formula that performs calculations using specific values in a particular order. All spreadsheet programs include common functions that can be used for quickly finding the sum , average , count , maximum value , and minimum value for a range of cells. In order to use functions correctly, you'll need to understand the different parts of a function and how to create arguments to calculate values and cell references.
Watch the video below to learn more about using functions in Excel.
The parts of a function
In order to work correctly, a function must be written a specific way, which is called the syntax . The basic syntax for a function is an equals sign (=) , the function name (SUM, for example), and one or more arguments . Arguments contain the information you want to calculate. The function in the example below would add the values of the cell range A1:A20.
Working with arguments
Arguments can refer to both individual cells and cell ranges and must be enclosed within parentheses . You can include one argument or multiple arguments, depending on the syntax required for the function.
For example, the function =AVERAGE(B1:B9) would calculate the average of the values in the cell range B1:B9. This function contains only one argument.
Multiple arguments must be separated by a comma . For example, the function =SUM(A1:A3, C1:C2, E2) will add the values of all cells in the three arguments.
Using functions
There are a variety of functions. Here are some of the most common functions you'll use:
- SUM : This function adds all the values of the cells in the argument.
- AVERAGE : This function determines the average of the values included in the argument. It calculates the sum of the cells and then divides that value by the number of cells in the argument.
- COUNT : This function counts the number of cells with numerical data in the argument. This function is useful for quickly counting items in a cell range.
- MAX : This function determines the highest cell value included in the argument.
- MIN : This function determines the lowest cell value included in the argument.
To use a function:
In our example below, we'll use a basic function to calculate the average price per unit for a list of recently ordered items using the AVERAGE function.
Your spreadsheet will not always tell you if your function contains an error, so it's up to you to check all of your functions. To learn how to do this, check out the Double-Check Your Formulas lesson.
Working with unfamiliar functions
If you want to learn how a function works, you can start typing that function in a blank cell to see what it does.
You can then type an open parenthesis to see what kind of arguments it needs.
Understanding nested functions
Whenever a formula contains a function, the function is generally calculated before any other operators, like multiplication and division. That's because the formula treats the entire function as a single value—before it can use that value in the formula, it needs to run the function. For example, in the formula below, the SUM function will be calculated before division:
Let's take a look at a more complicated example that uses multiple functions:
=WORKDAY(TODAY(),3)
Here, we have two different functions working together: the WORKDAY function and the TODAY function. These are known as nested functions , since one function is placed, or nested , within the arguments of another. As a rule, the nested function is always calculated first , just like parentheses are performed first in the order of operations. In this example, the TODAY function will be calculated first, since it's nested within the WORKDAY function.
Other common functions
There are many other functions you can use to quickly calculate different things with your data. Learning how to use other functions will allow you to solve complex problems with your spreadsheets, and we'll be talking more about them throughout this tutorial. You can also check out our articles below to learn about specific functions:
- How to Use Excel's VLOOKUP Function
- How to Count Cells with COUNTA
- Use SUMPRODUCT to Calculate Weighted Averages
- CONCATENATE: Excel's Duct Tape
- Use the PROPER Function to Capitalize Names in Excel
/en/excelformulas/solving-reallife-problems-in-excel/content/
This web page is no longer updated - I am fully retired - Please refrain from sending me requests. Thank you.
Excel spreadsheets.
- 1 Capital Budgeting Analysis (xls) - Basic program for doing capital budgeting analysis with inclusion of opportunity costs, working capital requirements, etc. - Aswath Damodaran
- 2 Rating Calculation (xls) - Estimates a rating and cost of debt based on the coverage of debt by an organization - Aswath Damodaran
- 3 LBO Valuation (xls) - Analyzes the value of equity in a leverage buyout (LBO) - Aswath Damodaran
- 4 Synergy (xls) - Estimates the value of synergy in a merger and acquisition - Aswath Damodaran
- 5 Valuation Models (xls) - Rough calculation for choosing the correct valuation model - Aswath Damodaran
- 6 Risk Premium (xls) - Calculates the implied risk premium in a market. (uses macro's) - Aswath Damodaran
- 7 FCFE Valuation 1 (xls) - Free Cash Flow to Equity (FCFE) Valuation Model for organizations with stable growth rates - Aswath Damodaran
- 8 FCFE Valuation 2 (xls) - Free Cash Flow to Equity (FCFE) Valuation Model for organizations with two periods of growth, high growth initially and then stable growth - Aswath Damodaran
- 9 FCFE Valuation 3 (xls) - Free Cash Flow to Equity (FCFE) Valuation Model for organizations with three stages of growth, high growth initially, decline in growth, and then stable growth - Aswath Damodaran
- 10 FCFF Valuation 1 (xls) - Free Cash Flow to Firm (FCFF) Valuation Model for organizations with stable growth rates - Aswath Damodaran
- 11 FCFF Valuation 2 (xls) - Free Cash Flow to Firm (FCFF) Valuation Model for organizations with two periods of growth, high growth initially and then stable growth - Aswath Damodaran
- 12 Time Value (xls) - Introduction to time value concepts, such as present value, internal rate of return, etc.
- 13 Lease or Buy a Car (xls) - Basic spreadsheet for deciding to buy or lease a car.
- 14 NPV & IRR (xls) - Explains Internal Rate of Return, compares projects, etc.
- 15 Real Rates (xls) - Demonstrates inflation and real rates of return.
- 16 Template (xls) - Template spreadsheet for project evaluation & capital budgeting.
- 17 Free Cash Flow (xls) - Cash flow worksheets - subsidized and unsubsidized.
- 18 Capital Structure (xls) - Spreadsheet for calculating optimal capital structures using different percents of debt.
- 19 WACC (xls) - Calculation of Weighted Average Cost of Capital using beta's for equity.
- 20 Statements (xls) - Generate a set of financial statements using two input sheets - operational data and financial data.
- 21 Bond Valuation (zip) - Calculates the value or price of a 25 year bond with semi-annual interest payments.
- 22 Buyout (zip) - Analyzes the effects of combining two companies.
- 23 Cash Flow Valuation (zip) - Walks through a valuation of cash flows under three models- capital cash flows, equity cash flows, and free cash flows.
- 24 Financial Projections (zip) - Spreadsheet model for generating projected financials along with valuation based on WACC.
- 25 Leverage (zip) - Shows the effects on Net Income from using debt (leverage).
- 26 Ratio Calculator (zip) - Calculates a standard set of ratios based on input of financial data.
- 27 Stock Value (zip) - Calculates expected return on stock and value based on no growth, growth, and variable growth.
- 28 CFROI (xls) - Simplified Cash Flow Return on Investment Model.
- 29 Financial Charting (zip) - Add on tool for Excel 97, consists of 6 files.
- 30 Risk Analysis (exe) - Analysis and simulation add on for excel, self extracting exe file.
- 31 Black Scholes Option Pricing (zip) - Excel add on for the pricing of options.
- 32 Cash Flow Matrix - Basic cash flow model.
- 33 Business Financial Analysis Template for start-up businesses from Small Business Technology Center
- 34 Forex (zip) - Foreign market exchange simulation for Excel
- 35 Hamlin (zip) - Financial function add-on's for Excel
- 36 Tanly (zip) - Suite of technical analysis models for Excel
- 37 Financial History Pivot Table - Microsoft Financials
- 38 Income Statement What If Analysis
- 39 Breakeven Analysis (zip) - Pricing and breakeven analysis for optimal pricing - Biz Pep .
- 40 SLG Ratio Master (exe) - Excel workbook for creating 25 key performance ratios.
- 41 DCF - Menu driven Excel program (must enable macros) for Discounted Cash Flow Analysis from the book Analysis for Financial Management by Robert C. Higgins - Analysis for Financial Management
- 42 History - Menu driven Excel program (must enable macros) for Historical Financial Statements from the book Analysis for Financial Management by Robert C. Higgins - Analysis for Financial Management
- 43 Business Valuation Model (zip) - Set of tabbed worksheets for generating forecast / valuation outputs. Includes instruction sheet. Bizpep
- 44 LBO Model - Excel model for leveraged buy-outs
- 45 Comparable Companies - Excel valuation model comparing companies
- 46 Combination Model - Excel valuation model for combining companies
- 47 Balanced Scorecard - Set of templates for building a balanced scorecard.
- 48 Cash Model - Template for calculating projected financials from CFO Connection
- 49 Ratio Reminder (zip) - Simple worksheet of comparative financials and corresponding ratios
- 50 Risk Analysis IT - Template for assessing risk of Information Technology - Audit Net
- 51 Risk Analysis DW - Template for assessing risk of Data Warehousing - Audit Net
- 52 Excel Workbook 1-2 - Set of worksheets for evaluating financial performance and forecasting - Supplemental Material for Short Course 1 and 2 on this website.
- 53 Rule Maker Essentials - Excel Template for scoring a company by entering financial data - The Motley Fool
- 54 Rule Maker Ranker - Excel Template for scoring a company by entering comparable data - The Motley Fool
- 55 IPO Timeline - Excel program for Initial Public Offerings (must enable macros)
- 56 Assessment Templates - Set of templates for assessing an organization based on the Malcolm Baldrige Quality Model.
- 57 Cash Gap in Days - Spreadsheet for calculating number of days required for short-term financing.
- 58 Cash Flow Template - Simple cash flow model with explanations of each cash flow component - Arkansas Small Business Development Center .
- 59 Six Solver Workbook (zip) - Set of various spreadsheets for solving different business problems (inventory ordering, labor scheduling, working capital, etc.).
- 60 Free Cash Flow Valuation - Basic Spreadsheet Valuation Model
- 61 Finance Examples - Seven examples in Business Finance - Solver
- 62 Capital Budgeting Workbook - Several examples of capital budgeting analysis, including the use of Solver to select optimal projects.
- 63 Present Value Tables (rtf) - Set of present value tables written in rich text format, compatible with most word processors. Includes examples of how to use present value tables.
- 64 Investment Valuation Model (zip) - Valuation model of companies (30 Day Trial Model) from Business Spreadsheets | Additional Trial Models from Business Spreadsheets > Real Option Valuation | Portfolio Optimization | Optimal Hedging Strategy
- 65 Cash Flow Sensitivity (xlt) - Sensitivity analysis spreadsheet - Small Business Store
- 66 What If Analysis - Set of templates for sensitivity analysis using financial inputs.
- 67 Risk Return Optimization - Optimal project selection (must enable macro's) - Metin Kilic
- 68 CI - Basics #1 - Basic spreadsheet illustrating competitive analysis - Business Tools Templates .
- 69 CI - Basics #2 - Basic spreadsheet illustrating competitive analysis - Business Tools Templates .
- 70 External Assessment - Assessment questions for organizational assessment (must enable macros).
- 71 Internal Assessment - Assessment questions for organizational assessment (must enable macros).
- 72 Formal Scorecard - Formal Balanced Scorecard Spreadsheet Model (3.65 MB / must enable macros).
- 73 Project Plan - Project Scheduling Template currently setup for a Balanced Scorecard Project.
- 74 Gantt Chart - Gantt chart for project management with work plan - Jim Chapman's Web Site | Simplified Version - Barnard of Fong's Eng & Manf
- 75 E O Q Model - Simple Inventory Models for calculating Economic Order Quantity.
- 76 Inventory Simulation Control Model - Formal model for simulating inventory shortages, delivery times, costs, backorders, and optimal inventory levels - John McClain
- 77 Financial Projections Model - A comprehensive financial model for forecasting a complete set of financials with breakeven and valuation tabs developed by Frank Moyes and Stephen Lawrence at Leeds School of Business.
- 78 Option Trading Workbook - Educational toolkit for using Excel for Options - Option Trading Tips
- 79 Financial Model - A nice clean financial model driven by different calculators (such as Company, Market, Subscribers, etc.) developed by Bill Snow .
Excel Spreadsheets - continued
- 80 Forecasting Model - Step by step financial model for forecasting financials created by Sam Gui
- 81 Economic Evaluation - Step by step workbook for evaluating the economics of a system investment
- 82 Project Management Templates - A collection of templates (charter, budget, risk register, issues log, etc.) for managing a project - International Association of Project and Program Management
- 83 Project Cost Estimating Workbook - A workbook model for developing a cost estimate on a software development project - ProTrain China
- 84 Risk Assessment Register - A workbook for establishing a risk management register - Emergency Preparedness Capacity Builders
- 85 Simple ABC Model - A simple model that illustrates Activity Based Costing
- 86 Six Sigma Tool Kit - A large collection of templates for doing six sigma tasks
- 87 Project Management Tool Kit - Collection of useful templates for managing projects - Michael D. Taylor
- 88 Intellectual Property Valuation Model - A simple and easy to use model to help assign value to intellectual assets such as patents, copyrights and trademarks
- 89 IT Infrastructure Maturity Assessment - Maturity model for evaluating different segments of IT infrastructure
- 90 EVA Model - Template worksheets for calculating Economic Value Added (EVA) - Zachary Scott
- 91 EVA Tree Mode l - Economic Value Added drill-down model with charts - Manfred Grotheer
- 92 Personal Finance Model - A simple and clean model to track personal wealth - ROI Team
- 93 Financial Startup Model - A six parameter model to help organize financials for startup companies - ROI Team
- 94 Performance Leadership Assessment - Simple and straight-forward tool for assessing leadership across five important categories - People Positive
- 95 Due Diligence Assessment Model - Assessment of new business ventures across ten different dimensions - Affiliate Tips
- 96 Management Diamond Assessment - A useful tool for developing human capital and teams - Geir Fuglaas | Management Diamond Overview | Management Diamond Book
- 97 Performance Solution Tool Kit - Evaluation of performance issues related to knowledge gaps
- 98 Ratio Tree - A simple yet comprehensive tree of ratios for most businesses - Strategy Expert
- 99 Skills & Modeling Guide | Assessment Exercise Workbook - Two very good spreadsheet models to help you develop your spreadsheet modeling skills - Tykoh Training
- 100 Breakeven Forecasting Model - A clean and contemporary spreadsheet tool for easily forecasting breakeven. Includes parameters for seasonality and start-up optimization - Ethos 360
- 101 ROI IT Initiative Tool - A comprehensive business case model for evaluating technology projects - Hall Consulting
- 102 Waterfall Distribution Model - Distribution of proceeds from a business venture using hurdles - Global iConnect
- 103 LBO DCF Model - Leveraged Buyout Model with tabs for financials and analysis - Global iConnect
- 104 Weekly Cash Flow - Rolling cash flow projections of purchases - Portal CFO
- 105 Factoring Cash Flow - Weekly calculation of cash flows with factoring - MP Star Financial Invoice Factoring
- 106 Series of Commission Spreadsheets > Calculator | Template-Fixed | Template-Margin | Template Revenue
- 107 Dashboard Report - Demonstrates countif, vlookup, and arrays - Bob Lopez
- 108 Real Estate Investment Analysis - Workbook example developed by Dr. Greg Smersh
- 109 Rental Property Investment - Workbook for evaluating rental property - Globaliconnect
- 110 Valuation Utility Workbook | User Manual - A nice and simple valuation model with sensitivity charts - Tykoh Training
- 111 Monte Carlo Sales Forecast - Provides an example of Monte Carlo Simulation using a simple sales forecast model - Business Templates
- 112 Depreciation Schedules - Calculates annual depreciation using a variety of methods - Business Templates
- 113 NPV Calculator - Shows examples that use the NPV, IRR, XNPV, and XIRR functions - Business Templates
- 114 Basic Excel Course - Collection of 4 Excel files from the Basic Excel course offered by DeZyre > All 4 Files (zip) | How to Concatenate | How to Use Lookup | How to Filter Data | Excel Module
- 115 Financial Modeling Course - 12 different excel files from the financial modeling course offered by DeZyre > Download All 12 Files (zip) | Advanced Income | Analyzing Dominos-1 | Analyzing Dominos-2 | Balance Sheet Basics | Building Cash Flow Statement | Capex | Double Entry Accounting | Expense Recognition | Revenue-Gross Margin | Revenue Recognition | Tax | Summary |
- 116 BPM Tool Kit - 6 different comprehensive models from Best Practice Modeling > All 6 Files (zip) | Enterprise Valuation Example | Equity Valuation Example | Historical Forecast Model | Whole Business Plan Model | Project Summary | Multi Stack Waterfall Chart
- 117 Box IPO Model - A complete financial model developed by Dheeraj Vaidya - Wall Street Mojo
- 118 Bidder Comparison Matrix - Weighted scoring of bid competition based on proposal criteria - MyPM
- 119 Bid No Bid Worksheet - Captures comparative data on risks, partners, customer and competition - MyPM
- 120 Win Theme Development - Captures data on customer, solutions, proof points and discriminators - MyPM
- 121 Proposal Compliance Matrix - Tracks RFP requirements and corresponding proposal sections - MyPM
General Resources
Business Functions | Business Intelligence | Business Spreadsheets | Convert to Web App | Data Conversion | Excel Applications | Excel Auditor | Excel Business Users | Excel Cheat Sheets | Excel Courses | Excel Development | Excel Web Conv | Excel Exposure | ExcelFix | Excel Formulas | Excel Ideas | Excel Materials | Excel Mixer | Excel Programming Services | Excel Quantitative | Excel Recovery Tool | Excel Solutions | Excel Support | Excel Tutorial | Excel Unusual | Financial Modeling School | Financial Model Training | Financial Model Training-2 | Finance Models | Improve Excel | Invest Excel | Investment Related | Magic Workbooks | Model Answer | Mr Excel | Online Help | Process Simulation | Projected Financials | Quantrix Modeling [ Quantrix Sample Models ] | Real Estate Related | Secure Spreadsheets | Spreadsheet Comparer | Spreadsheet Database | Spreadsheet Guys | Spreadsheet Security | Stock Analyzer | Teach Excel | XL Modeling
Excel Templates
| High Quality Templates | Project Management |
Excel Add On's
Able Bits | Addin Directory | Analyze It | Brush Tools | Business Rules | Custom Add Ins | Database Manager | Dashboards | Decision Analysis | Derivative Analysis | EZ Analyze | EZ Forecaster | FinCad-Derivatives | Free Economic Add On's | Free Navigation Tool Bar | Model Builder | Monte Carlo Simulation | Monte Carlo - Easy | Monte Carlo-Tukhi | NumXL | Portfolio Optimization | Risk Modeling | Sensitivity Toolkit | Simul-Stats | Spreadsheet ML | Statistical Analysis | Recover Corrupted Files | Tree Plan | Utilities | Value at Risk | XL Modeler | XL Sim | XL Stats |
Six Sigma Spreadsheets
ASQ Tools | John Zorich | SPC for Excel | SPC XL | Robert Dallman | Six Sigma Project Files
Financial Modeling
Chandoo | Corality | Modeling Championship | Plum Solutions | Pristine | Strategize Online Lessons in Financial Modeling (includes lesson workbook): Lesson 1 - Cash Flow Modeling Lesson 2 - Financial Model Design Lesson 3 - Excel Financial Functions
Books on Excel
Analyzing Business Data | Balanced Scorecards in Excel | Business Analysis | Data Analysis | Excel Hacks | Financial Analysis | Financial Modeling | Finance with Excel | Managing Money | Spreadsheet Modeling |
IMAGES
VIDEO
COMMENTS
The six steps of problem solving involve problem definition, problem analysis, developing possible solutions, selecting a solution, implementing the solution and evaluating the outcome. Problem solving models are used to address issues that...
When multiplying or dividing different bases with the same exponent, combine the bases, and keep the exponent the same. For example, X raised to the third power times Y raised to the third power becomes the product of X times Y raised to th...
The four steps for solving an equation include the combination of like terms, the isolation of terms containing variables, the isolation of the variable and the substitution of the answer into the original equation to check the answer.
spreadsheets to good use. 3. Provide an example of how businesses might apply a conditional formula to. spreadsheet data.
3. Provide an example of how businesses might apply a conditional formula to spreadsheet data. (2points)○Under the
2Powder Goods3Flour1 bag4 kg4Sugar1 bag45 g5Baking soda1 bag8 oz6Salt3
Question: CB2011 Solving Business Problems with Spreadsheet Modeling Online Assignment 3 (6% weight) Time allowed: 60 minutes (55 minutes + 5 minutes
In this DataHour, Eshan will demonstrate how to perform funnel analysis on excel to identify the product improvement opportunities and
Offered by PwC. This course explores Excel as a tool for solving business problems. In this course you will learn the basic functions of .
For example, the function =SUM(A1:A3, C1:C2, E2) will add the values of all cells in the three arguments. Screenshot of Excel 2013. Let's practice! Question 1
(zip) - Set of various spreadsheets for solving different business problems (inventory ordering
spreadsheets. Tasks. There are 6 tasks to this problem: 1. ... With practice, you.
One company in California 6 gained a huge boost in its.
1. 20.5 x 0.4 = ? 2. 0.55 x 0.5 = ? 3. 2.5 x 2.5 = ? Suggested Practice for SOL 5.5a.