Excel Statistical Analysis 01: Data & Statistics

Download Excel File: https://excelisfun.net/files/Ch01-ESA.xlsm
Topics in video:
(00:00) Introduction
(00:54) Use File Explorer, Show File Extensions, Create Folder for class
(02:59) Use People Web Site to download files for this class
(05:58) How to open Excel files using File Explorer
(04:28) Define Data Continue reading “Excel Statistical Analysis 01: Data & Statistics”

Paste Across Computers But Not Paste All – 2440

The Windows Clipboard (in Windows 10 or Windows 11) can now sync across devices. Copy from one computer and paste to another computer! No more mailing stuff to yourself just to get from this computer to the other. (Here at Continue reading “Paste Across Computers But Not Paste All – 2440”

Excel Formula Master Tricks for Empty Cells, Zeros, Zero Length Text String and ‘Blanks’ EMT 1764

Download Excel File: https://excelisfun.net/files/EMT1764.xlsx
This video exposes the misleading Microsoft terminology for ‘Blanks’. This video examines empty cells, cells with double quotes (zero length text strings) and all the ramifications for Excel worksheet formulas. See the functions: ISTEXT, Continue reading “Excel Formula Master Tricks for Empty Cells, Zeros, Zero Length Text String and ‘Blanks’ EMT 1764”

Single Cell Reporting to Spill MEDIAN and SUM Results using BYROWS & LAMBDA. Excel Magic Trick 1763

Download Excel File: https://excelisfun.net/files/EMT1763.xlsx
Learn how to use the Microsoft 365 BYROWS & LAMBDA functions to spill aggregate results, such as SUM and MEDIAN.
Topics:
(00:00) Introduction
(00:20) Formulas that can spill, including multiplication operation and functions like SUMIFS
(01:10) Aggregate Formulas Continue reading “Single Cell Reporting to Spill MEDIAN and SUM Results using BYROWS & LAMBDA. Excel Magic Trick 1763”

Solving Word Search With Excel (FMWC) – 2439

A challenging puzzle from FMWC – Financial Modeling World Cup. How to solve a Word Maze or a Word Search using Excel. This maze includes 20000 letters! You have 30 minutes to score 1000 points using Excel formulas or Continue reading “Solving Word Search With Excel (FMWC) – 2439”

Challenge How To Arrange A Seating Chart At A Networking Event – 2438

You have 100 people coming to a conference. There are 11 sessions. Tables seat 10 people each. How can you set up a seating chart for the 11 sessions so everyone has a chance to meet everyone else at least Continue reading “Challenge How To Arrange A Seating Chart At A Networking Event – 2438”

Why Excel NPV and XNPV Function Give Different Answers for Cash Flow Analysis. EMT 1762

Download Excel File: https://excelisfun.net/files/EMT1762.xlsx
See the algorithms for the Excel worksheet functions NPV and XNPV and see why XNPV removes more interest in the discounting process than NPV function.
Also, learn many cool worksheet formula tricks to make you Continue reading “Why Excel NPV and XNPV Function Give Different Answers for Cash Flow Analysis. EMT 1762”

How To Delete Blank Rows At Bottom Of Excel – 2436

“My spreadsheet must be haunted” is a great opening line to an Excel question sent in just before Halloween. You have 1510 rows in Excel. You try to Delete Sheet Rows from A1511 to A1048576, but the rows keep coming Continue reading “How To Delete Blank Rows At Bottom Of Excel – 2436”

Arrays As Arguments To Application WorksheetFunction in Excel VBA – 2435

How to use XMATCH with Application . WorksheetFunction in Excel VBA? Today, a question from Hydrogen Peroxide. How can you refer to an array inside of a formula in Excel VBA.
This workbook takes a look at how to simulate Continue reading “Arrays As Arguments To Application WorksheetFunction in Excel VBA – 2435”

Excel XNPV Function: Discounting non-Periodic Cash Flows. Algorithm for How it Works! EMT 1761

Download Excel File: https://excelisfun.net/files/EMT1761.xlsx
Learn how to use the XNPV function to discount non-periodic future cash flows to value investments.
This video answers the question: why does the NPV and XNPV function yield different answers. Look at the algorithm Continue reading “Excel XNPV Function: Discounting non-Periodic Cash Flows. Algorithm for How it Works! EMT 1761”