Month: November 2023

Excel Publish Any Excel Logic As Web App Using Sheetcast While Protecting Your IP – Episode 2635

Posted on by Annie D

Microsoft Excel Tutorial: Embed any Excel Logic in a Web App Using Sheetcast.com.

Try this web app now to search my videos: https://c07.sheetcast.com/view/c79f93d2-0dcf-441f-97ac-b0c100f02a4f/~/d174333f-e3fe-4b14-a13b-ef6e384af5bb?embed=True&expand=true&showTitle=true

Welcome to episode 2635 of the MrExcel podcast! It’s been 25 years since I started sharing my Excel tips and tricks with all of you, and I couldn’t be more grateful for your support. Today, I have something truly amazing to show you – how to publish any Excel logic as a web app using Sheetcast while protecting your intellectual property. Plus, I’ll also be sharing how you can search through 25 years of MrExcel content Continue reading “Excel Publish Any Excel Logic As Web App Using Sheetcast While Protecting Your IP – Episode 2635” →

Excel PIVOTBY Function to Create Completely Dynamic PivotTable Formula Reports! EMT 1845

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1845.xlsx
You will not believe what you see in this video. See the basics of the new PIVOTBY function to make PivotTable Formula Reports, then see how to create monthly sales reports (with a hack), then see a completely dynamic Formula PivotTable Report where you can use cell inputs to change, Row, Column and Filter Conditions, Change the Function for the report and create a dynamic label that describes the report. Simply Amazing!!!
Topics:
1. (00:00) Introduction.
2. (00:22) PIVOTBY function, complete description and examples.
3. (05:50) Monthly Sales Report with PIVOTBY function.
4. (08:11) Fully dynamic PivotTable report with Continue reading “Excel PIVOTBY Function to Create Completely Dynamic PivotTable Formula Reports! EMT 1845” →

ETA-LAMBDAs for BYROW, BYCOL & SCAN to Make Spilling Row Totals & Running Totals Easy. EMT 1846

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1846.xlsx
Learn about how to use ETA-LAMBDAs to replace LAMBDA to make easier formulas to spill row totals, spill column totals, spill running totals and even spilling an average in each row.
Topics:
1. (00:00) Introduction.
2. (00:18) Spill Row Totals with the BYROW function.
3. (00:50) Spill Column Totals with the BYCOL function.
4. (01:06) Spill a Running Total with the SACN function.
5. (01:32) Spill an Average for each row with the BYROW function.
6. (01:53) Summary.
7. (02:12) Closing, Video Links For Full Free LAMBDA Class.

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #lambda Continue reading “ETA-LAMBDAs for BYROW, BYCOL & SCAN to Make Spilling Row Totals & Running Totals Easy. EMT 1846” →

2 Different Functions in GROUPBY & PIVOTBY Functions. Excel Magic Trick 1844 Part 2

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1844-Part02.xlsx
Learn about how to use the GROUPBY and PIVOTBY functions to make single cell formula reports that have 2 functions in a single report.
Topics:
1. (00:00) Introduction to GROUPBY, PIVOTBY and the new Lambda Replacement Functions.
2. (00:15) GROUPBY Function.
3. (01:08) PIVOTBY Function.
4. (01:36) Confusing Labels in Report.
5. (01:49) Two Fields in the Row Area.
6. (02:01) Two Different Functions with Two Fields in Row Area: Labels are correct!
7. (02:32) Summary.
8. (02:55) Closing, Video Links.
#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #groupby #excelformula #excelfunctions #excelfunctions #excelformulasandfunctions #lambda #pivotby