RESOURCE DOWNLOAD – https://portal.enterprisedna.co/p/webinar-series-resources-free/
When is it?
October 28th, Thursday, 6pm New York (EST), 3pm Los Angeles (PST), 11pm London (BST)
October 29th, Friday, 9am Sydney (AEDT), 11am Auckland (NZDT)
How long is it?
Session will run for approximately 1 hour
Where is Continue reading “Power BI Freestyle Session w/ Sam McKay”
For this video, I’d like to do a walkthrough on a solution I developed for a recent entry in the Enterprise DNA forum asking how to compare data by billable days instead of calendar days. This is quite an interesting Continue reading “How To Dynamically Compare First N Business Days In Power BI”
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”
For this tutorial, we will look at how we can customize bar charts using native visuals, custom visuals that are readily available on the marketplace, and with the Charticulator. There are many limitations when trying to place bar charts in Continue reading “588 Different Bar Charts That You Can Use To Elevate Your Power BI Report”
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”
EVENT DETAILS – https://enterprisedna.co/business-analytics-week-october-2021-registration/
RESOURCE DOWNLOAD – https://portal.enterprisedna.co/p/learning-summit-series-free/
Session 2 – Business Insights Deep Dive
When is it?
October 21st, 4pm New York (EDT), 1pm Los Angeles (PDT), 9pm London (BST)
October 22nd, 7am Sydney (AEDT), 9am Auckland (NZDT)
Where Continue reading “Business Analytics Week – Session 2: Business Insights Deep Dive”
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?
EVENT DETAILS – https://enterprisedna.co/business-analytics-week-october-2021-registration/
RESOURCE DOWNLOAD – https://portal.enterprisedna.co/p/learning-summit-series-free/
Session 1: Business Analytics w/Power BI
When is it?
October 20th, 4pm New York (EDT), 1pm Los Angeles (PDT), 9pm London (BST)
October 21st, 7am Sydney (AEDT), 9am Auckland (NZDT)
Where is Continue reading “Business Analytics Week – Session 1: Business Analytics w/Power BI”
“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”
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”