Канал: spreadsheet geek

Investing: Is Warren Buffett Lucky or Skilled?

Investing: Is Warren Buffett Lucky or Skilled?

How To: Compute Compound Annual Growth Rate (CAGR) in Excel

How To: Compute Compound Annual Growth Rate (CAGR) in Excel

Investing: How Likely is a Stock Market Correction?

Investing: How Likely is a Stock Market Correction?

Excel Problem Solver: How To Win Playing Monopoly

Excel Problem Solver: How To Win Playing Monopoly

How To: Compute Internal Rate of Return From Irregular Periods

How To: Compute Internal Rate of Return From Irregular Periods

Investing: How Earnings Can Grow Faster Than Sales

Investing: How Earnings Can Grow Faster Than Sales

Investing: The Benefits of Diversification

Investing: The Benefits of Diversification

Excel Problem Solver: Animate Excel Charts in Power Point

Excel Problem Solver: Animate Excel Charts in Power Point

How To: Understanding Excel's Date & Time Functions

How To: Understanding Excel's Date & Time Functions

How To: Understanding the OFFSET Function

How To: Understanding the OFFSET Function

Excel Problem Solver: Import Real Time Stock Quotes Without Office 365

Excel Problem Solver: Import Real Time Stock Quotes Without Office 365

How To: Use SWITCH or IFS as an Alternative to Nesting IF Statements

How To: Use SWITCH or IFS as an Alternative to Nesting IF Statements

Excel Problem Solver: Pick Randomly From a List and Choose No Duplicates

Excel Problem Solver: Pick Randomly From a List and Choose No Duplicates

Investing: The Shiller PE

Investing: The Shiller PE

Understanding the Statement of Cash Flows

Understanding the Statement of Cash Flows

How To: Excel Functions To Make Text Capitalization Uniform

How To: Excel Functions To Make Text Capitalization Uniform

How To: Calculate Net Present Value of Cash Flows in Irregular Periods

How To: Calculate Net Present Value of Cash Flows in Irregular Periods

Excel Problem Solver: Are Mega Millions Lotto Drawings Biased?

Excel Problem Solver: Are Mega Millions Lotto Drawings Biased?

Excel Problem Solver: Version II - Optimize Manufacturing Costs Using Excel Solver

Excel Problem Solver: Version II - Optimize Manufacturing Costs Using Excel Solver

How To: Internal Rate of Return Explained

How To: Internal Rate of Return Explained

How To: Why INDEX-MATCH Beats VLOOKUP

How To: Why INDEX-MATCH Beats VLOOKUP

Investing: Bond Valuation and Duration

Investing: Bond Valuation and Duration

How To: The Poor Man's Monte Carlo Simulation

How To: The Poor Man's Monte Carlo Simulation

Investing: The Kurtosis of Four Investment Options

Investing: The Kurtosis of Four Investment Options

Investing: Are Berkshire Hathaway's Glory Days Gone Forever?

Investing: Are Berkshire Hathaway's Glory Days Gone Forever?

How To: A Monte Carlo Simulation Demo

How To: A Monte Carlo Simulation Demo

Election Analysis: The Voting Weight of Swing State Cities in U.S. Elections

Election Analysis: The Voting Weight of Swing State Cities in U.S. Elections

Excel Problem Solver: Optimize Manufacturing Costs Using Excel Solver

Excel Problem Solver: Optimize Manufacturing Costs Using Excel Solver

Investing: Calculate Skewness of S&P 500 Returns

Investing: Calculate Skewness of S&P 500 Returns

Investing: Calculate Beta of a Security

Investing: Calculate Beta of a Security

Accounting 101: Understanding Debits & Credits

Accounting 101: Understanding Debits & Credits

Excel Problem Solver: Create a Multi-Layer Excel Power Map

Excel Problem Solver: Create a Multi-Layer Excel Power Map

How To: Get Started Using Excel Power Maps

How To: Get Started Using Excel Power Maps

Excel Problem Solver: Isolate Postal Codes in a Free Text Address String.

Excel Problem Solver: Isolate Postal Codes in a Free Text Address String.

Excel Problem Solver: Detect Fraud Using a Spreadsheet and Benford's Law

Excel Problem Solver: Detect Fraud Using a Spreadsheet and Benford's Law

How To: Use Excel's Scenario Manager

How To: Use Excel's Scenario Manager

How To: Use the Data Table Feature in Excel's What-If Analysis Menu

How To: Use the Data Table Feature in Excel's What-If Analysis Menu

Investing: Back Test a Moving Average Crossover Trading System

Investing: Back Test a Moving Average Crossover Trading System

Accounting Principles - Fixed Asset Depreciation Methods Using Excel

Accounting Principles - Fixed Asset Depreciation Methods Using Excel

How To: Manipulate Text Strings in Excel

How To: Manipulate Text Strings in Excel

How To: Normalize and Standardize Data in Excel

How To: Normalize and Standardize Data in Excel

How To: Use the SUMIF & SUMIFS Functions in Excel

How To: Use the SUMIF & SUMIFS Functions in Excel

Excel Problem Solver: Evaluate Leasing versus Buying

Excel Problem Solver: Evaluate Leasing versus Buying

Top 12 Tips For Excel Users

Top 12 Tips For Excel Users

Excel Problem Solver: Move Header Row Contents Into Columns

Excel Problem Solver: Move Header Row Contents Into Columns

How To: Use the VLOOKUP Function in Excel

How To: Use the VLOOKUP Function in Excel

How to Create & Use Pivot Tables in Excel

How to Create & Use Pivot Tables in Excel

How to Use the Move or Copy Command in Excel

How to Use the Move or Copy Command in Excel

How to Use Relative, Absolute, and Mixed References in Excel

How to Use Relative, Absolute, and Mixed References in Excel