Канал: All Things Analytic

IRR function and how it is related to NPV

IRR function and how it is related to NPV

NPV function explained---time is money

NPV function explained---time is money

XNPV (interest rate, cash flow, dates) to calculate NPV of cash flows received irregular intervals.

XNPV (interest rate, cash flow, dates) to calculate NPV of cash flows received irregular intervals.

How do I determine the number of workdays between two dates?

How do I determine the number of workdays between two dates?

How do I determine a date that is 50 workdays after another date?what if I want to exclude holidays?

How do I determine a date that is 50 workdays after another date?what if I want to exclude holidays?

can I use a formula to automatically display today's date?

can I use a formula to automatically display today's date?

Use "Flash Fill" to quickly fill out text/information in Excel

Use "Flash Fill" to quickly fill out text/information in Excel

How to quickly extract data from one cell to different columns with Convert Text to Columns wizard.

How to quickly extract data from one cell to different columns with Convert Text to Columns wizard.

Use text functions: Trim, Right, Left, Mid, Len, Value, Concatenate, to extract info from "text".

Use text functions: Trim, Right, Left, Mid, Len, Value, Concatenate, to extract info from "text".

Use “Text" functions to manipulate "Text Strings" in Excel--Part I

Use “Text" functions to manipulate "Text Strings" in Excel--Part I

Match function in Excel--look for the position of a value in a data arrange

Match function in Excel--look for the position of a value in a data arrange

Use Index function in Excel to Look up for information/value in a data sheet.

Use Index function in Excel to Look up for information/value in a data sheet.

use Vlookup function to find information quickly from a data range

use Vlookup function to find information quickly from a data range

use Vlookup function to search and return values in a worksheet

use Vlookup function to search and return values in a worksheet

Name columns to easily remember and calculate data in a worksheet

Name columns to easily remember and calculate data in a worksheet

Create named cells fast using the "Create from Selection" option in EXCEL

Create named cells fast using the "Create from Selection" option in EXCEL

How to Name Data Range and Use it in Excel

How to Name Data Range and Use it in Excel

Spreadsheet example: quickly build a spreadsheet using input information--predicting # of customers

Spreadsheet example: quickly build a spreadsheet using input information--predicting # of customers

Excel One-Way Data Table for "What-If" Analysis

Excel One-Way Data Table for "What-If" Analysis

Excel One-Way Data Table for "What-If" Analysis

Excel One-Way Data Table for "What-If" Analysis

How to calculate across a large area fast in a worksheet and use absolute reference- example 3

How to calculate across a large area fast in a worksheet and use absolute reference- example 3

Calculate across a large area-using absolute reference to lock row/column

Calculate across a large area-using absolute reference to lock row/column

calculate across a large area quickly and Autosum--Basic spreadsheet modeling example 2

calculate across a large area quickly and Autosum--Basic spreadsheet modeling example 2

calculate over a large area fast--using copy and paste, Basic worksheet model 1

calculate over a large area fast--using copy and paste, Basic worksheet model 1

Excel function: sumproduct(array1, array2,...)

Excel function: sumproduct(array1, array2,...)

If(criteria, "Return_if_True", "Return_If_False“) Function in Excel

If(criteria, "Return_if_True", "Return_If_False“) Function in Excel

Easy and Fast Copy & Paste a Cell to a very large range in Excel

Easy and Fast Copy & Paste a Cell to a very large range in Excel

How to Copy, Move, Rename, and delete a worksheet in an Excel Workbook

How to Copy, Move, Rename, and delete a worksheet in an Excel Workbook

How to Count in Excel: function COUNTIF(Data range, "criteria")

How to Count in Excel: function COUNTIF(Data range, "criteria")

Use Rand(), Randbetween, to generate random variables.

Use Rand(), Randbetween, to generate random variables.

How to enter formula fast in an Excel Spreadsheet

How to enter formula fast in an Excel Spreadsheet

Delete mails in bulk---gmail

Delete mails in bulk---gmail

Fast auditing spreadsheet ---show all formulas in an Excel Spreadsheet

Fast auditing spreadsheet ---show all formulas in an Excel Spreadsheet

two-way data table in Excel to answer "what if" questions

two-way data table in Excel to answer "what if" questions

One-Way Data Table to Answer "what if" questions

One-Way Data Table to Answer "what if" questions

How to make section number not showing in LaTex

How to make section number not showing in LaTex

Using Solver in Excel-example 1

Using Solver in Excel-example 1

Formulate and Use Excel Solver to Solve An Assignment Problem

Formulate and Use Excel Solver to Solve An Assignment Problem

Solving a Multiple-Period Production Scheduling Problem with Excel Solver

Solving a Multiple-Period Production Scheduling Problem with Excel Solver