Learn about the brand new Microsoft 365 Excel BYROW and BYCOL functions to spill any aggregate function down the rows o down the columns.
Category: Business

25 Formulas with a Single Keyboard Shortcut: Believe it!
Learn how to highlight a rectangular range of numbers with one extra column to the left and one row below and add 25 Columns and Row SUM Function totals with the single keyboard shortcut: Alt + =

Excel Dynamic Range with TRIMRANGE Function
Excel TRIMRANGE Function to Remove Empty Cells from a Rectangular Range in Any Direction!

What is an Unmanaged Tenant in Entra ID with Microsoft Fabric / Power BI
What happens when you sign up for Microsoft Fabric and you are the first for your organization? Adam dives into an unmanaged Entra ID tenant / directory so you can understand!
What is Microsoft Entra ID?
https://learn.microsoft.com/entra/fundamentals/whatis
Quickstart: Create a new tenant in Microsoft Entra ID
https://learn.microsoft.com/entra/fundamentals/create-new-tenant
What is self-service sign-up for Microsoft Entra ID?
https://learn.microsoft.com/entra/identity/users/directory-self-service-signup
📢 Become a member: https://guyinacu.be/membership
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: https://guyinacu.be/courses
*******************
LET’S CONNECT!
*******************
— <a href="http://twitter.com/guyinacube" Continue reading “What is an Unmanaged Tenant in Entra ID with Microsoft Fabric / Power BI”

Excel Dynamic Range Reference Operator .:. Remove Empty Cells in Range: Trim Range Reference
See how to remove empty cell s below and above a range reference with Excel Dynamic Range Reference Operator .:.

Keep your secrets SAFE in Microsoft Fabric and Azure Key Vault
You don’t want to store your secrets in plain text! Patrick walks you through how you can store your secrets in Azure Key Vault and then leverage them within a Microsoft Fabric Notebook.
NotebookUtils (former MSSparkUtils) for Fabric – Credentials utilities
https://learn.microsoft.com/fabric/data-engineering/notebook-utilities#credentials-utilities
📢 Become a member: https://guyinacu.be/membership
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: https://guyinacu.be/courses
*******************
LET’S CONNECT!
*******************
— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— <a href="https://www.instagram.com/guyinacube/" Continue reading “Keep your secrets SAFE in Microsoft Fabric and Azure Key Vault”

Remove All Workbook References From Formulas Quickly with Excel Replace Feature
Remove All Workbook References From Formulas Quickly with Excel Replace Feature
#excel #excel365 #excelformula #excelreplace #excelisfun

🔴 Microsoft Power BI / Fabric Q&A – LIVE (Jan 11, 2025) (Member Chat 2nd Half)
Join us live as we answer your questions about Power BI & Microsoft Fabric! Get your questions in the chat early as we don’t get to all of them.
💥 30 minutes: Open Q&A (Public)
💥 Then… Members Only Chat (Public can watch & Super Chat for Questions)
📢 RULES FOR Q&A: 📢
👉 Put a “Q:” in front of your comment to help us identify questions!
👉 Super chats take priority
👉 Do NOT re-post your questions! We’ll get to as many questions as we can.
👉 If you SPAM your question, you will be put in timeout
📢 Become a member: https://guyinacu.be/membership
*******************
Want Continue reading “🔴 Microsoft Power BI / Fabric Q&A – LIVE (Jan 11, 2025) (Member Chat 2nd Half)”

Rad Is Rad: BMX or Skateboards or Excel: Old or Young: Having Fun Is It!!!
Monday, January 6, 2025, Nick Roth (70 years old) , Mike excelisfun Girvin (62 years old) and Isaac Girvin (18 years old) get rad on skateboards and BMX bikes at Jefferson Skatepark in Seattle, WA.

How to understand large code bases for applications quickly
***** Video Details *****
Explore how an AI-first development workflow can transform the way you build, understand, and manage complex applications. In this video, you’ll see a live demonstration of using cutting-edge tools like WindSurf and ChatGPT to quickly get to grips with extensive codebases—even if you haven’t written a single line of code yourself.
Follow along as we: • Introduce Prompt Central, an AI-driven application in active development • Show how to pull entire repositories into a single PDF for easy reference • Demonstrate how to upload that PDF to ChatGPT and receive a comprehensive overview of the code’s architecture and Continue reading “How to understand large code bases for applications quickly”

MS 365 Excel Basics 07: Comprehensive Excel Formula Lesson To Become The Go-To Excel Guru!
Download Excel File: https://people.highline.edu/mgirvin/AllClasses/218M365/Content/ExcelBasics07.xlsx
Read (download right-click): pdf notes: https://people.highline.edu/mgirvin/AllClasses/218M365/Content/ExcelBasics07.pdf
In this video learn about.
Topics:
1. (00:00) Introduction
2. (00:39) Topics
3. (02:05) Starting a worksheet formula
4. (02:17) What formula do
5. (02:37) Keyboard shortcuts are fast
6. (03:21) How default alignment helps
7. (05:12) Number Formatting
8. (05:28) Formulas & Number Formatting
9. (07:11) Excel’s Golden Rule
10. (12:09) Formula elements
11. (12:37) Cell References
12. (12:52) Formula to “List products that each employee sold last week” (Relative and Absolute Cell References)
13. (15:15) TEXTJOIN function
14. (16:09) Conditionally format a row with a logical formula with Mixed Cell References
15. (16:48) What is a Mixed Cell Reference?
16. (23:00) Continue reading “MS 365 Excel Basics 07: Comprehensive Excel Formula Lesson To Become The Go-To Excel Guru!”

Highline College Excel Corporate Finance ACCTG 455 Class 2025 Winter by Mike “excelisfun” Girvin
This class is for matriculating students at Highline College, but videos and files are free at YouTube in this playlist: https://www.youtube.com/watch?v=cSs9jYudZBQ&list=PLrRPvpgDmw0ly_v86mHHjoE1SwVs0vRV4
Videos (both old from 2010 and new ones for MS 365 Excel) to be posted over next three months.
Topics:
Chapter 1: Introduction
Chapter 2: Financial Statements
Chapter 3: Working with Financial Statements
Chapter 4: Time Value of Money and Valuation
Chapter 5: Discounted Cash Flow Valuation
Chapter 6: Interest Rates & Bond Valuation
Chapter 7: Equity Markets & Stock Valuation
Chapter 8: NPV & Other Investment Criteria
Chapter 9: Capital Investment
Chapter 10: Some Lessons from Capital Market History
Chapter 11: Risk & Return