Download Excel File: https://excelisfun.net/files/Ch01-ESA.xlsm
Learn the fundamentals of Excel worksheet formulas, functions and how to build worksheet models.
Topics:
(00:00) Introduction
(00:19) Topics in video
(00:45) Worksheet Formula Elements: what can go into a formula
(01:57) Excel Formula Order of Operations
(03:23) Guidelines for Continue reading “Excel Statistical Analysis 03: Comprehensive Worksheet Formula & Model Building Video”
There are a pair of well known Excel tricks with MATCH:
Find the last item in a long list of items that might contain empty cells.
Find the only number in a range of Error or Text values.
Excel tricksters have made use Continue reading “Excel Find Last Item In List Using MATCH But Not XMATCH – 2442”
Download Excel File: https://excelisfun.net/files/Ch01-ESA.xlsm
Topics in video:
(00:00) Introduction
(00:15) Open Excel file using Windows Explorer
(00:46) Navigating through large Workbook File with many Sheet Tabs
(02:27) Structure of an Excel Worksheet and Workbook
(04:21) Conventions for Workbook files in this class
(06:09) Excel Continue reading “Excel Statistical Analysis 02: Structure of Excel files, Navigation, Keyboard and more”
Reid would like to list all 6-number combinations of the numbers 1 to 44. For example, 1-2-3-4-5-6, 1-2-3-4-5-7, and so on up to 39-40-41-42-43-44. The first thing to realize is that all lottery combinations are a lot of numbers. Over Continue reading “Excel List All Lottery Combinations – 2441”
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”
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”
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”
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”
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”
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”
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”
My former co-worker thought it was a good idea to hide all of the whitespace below our Excel data and managed to hide a million rows and 16000 columns. How can I unhide something at the edge of the worksheet?