Blog

Bonbon's Guide To Data & Tech > Blog

Build Mortgage Home Loan Schedule. Traditional &Dynamic Spilled Array Formulas. 365 MECS Class 21

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/21-M365ExcelClass.xlsx
Pdf notes: https://excelisfun.net/files/21-M365ExcelClass.pdf
Learn how to build Mortgage Loan Schedule to break out interest and principal reduction from a loan payment. Theis same schedule works on Corporate Bonds to help record Interest on Income Statement6 and Principal Reduction on Balance Sheet.

This full free Microsoft 365 Excel & Power BI class is taught by Excel MVP and Highline College Professor and can be found here: https://www.youtube.com/playlist?list=PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW
This video covers.
1. (00:00) Introduction and video topics
2. (00:30) Build Mortgage Loan Schedule to break out interest and principal reduction from a loan payment using Continue reading “Build Mortgage Home Loan Schedule. Traditional &Dynamic Spilled Array Formulas. 365 MECS Class 21” →

Excel For The Infection Preventionist – Preview of APIC Pre-Conference

Posted on by Annie D

The Association for Professionals in Infection Control and Epidemiology is holding their annual conference in Orlando June 26-28, 2023. I will be presenting a half-day pre-conference session on Sunday June 25, 2023 from 8 AM to 1 PM.

My goal in the session is to make you more comfortable with Microsoft Excel. In this preview, I download data from the CDC, do some simple clean-up. I use a few Excel formulas to add some useful metrics. I then display the results on a Map in Microsoft Excel.

Everyone who attends my session receives a copy of my book, MrExcel 2021 – Unmasking Continue reading “Excel For The Infection Preventionist – Preview of APIC Pre-Conference” →

🔴 Microsoft Fabric/Power BI Q&A – LIVE (June 17, 2023) (Member Chat 2nd Half)

Posted on by Annie D

Join us live as we answer your questions about Microsoft Fabric (including Power BI)!

💥 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 to take your Power BI skills to the next level? We have training courses available Continue reading “🔴 Microsoft Fabric/Power BI Q&A – LIVE (June 17, 2023) (Member Chat 2nd Half)” →

What does Microsoft Fabric mean for Power BI?

Posted on by Annie D

You’ve heard the news about Microsoft Fabric but what about Power BI? How does Power BI fit in? Do you need to migrate anything? Can you still do what you were doing? Adam tells you what you need to know!

Direct Lake (PREVIEW)
https://learn.microsoft.com/power-bi/enterprise/directlake-overview

Microsoft Fabric Build 2023 Day 1
https://youtu.be/5jlP0wdEsls

Microsoft Fabric Build 2023 Day 2
https://youtu.be/wdDx0-jvl7w

📢 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!
*******************

— Continue reading “What does Microsoft Fabric mean for Power BI?” →

What Is ChatGPT & How Do You Use It

Posted on by Annie D

Get ready for an in-depth journey into the world of ChatGPT, a revolutionary AI engine changing industries and job roles across the globe.

In this video, Sam explores how ChatGPT, developed by the incredible minds at OpenAI, has attracted millions of users within its first 5 days. Discover how you can leverage ChatGPT’s Natural Language Processing abilities to simplify complex concepts, improve your professional workflows and amplify your learning experience.

Are you curious about how ChatGPT is enhancing programming? We dive into the nitty-gritty of how this amazing AI tool can offer detailed explanations to intricate coding problems, helping programmers Continue reading “What Is ChatGPT & How Do You Use It” →

Excel Formulas Sort By Last Name, Names My Have Middle Name #Short Excel Magic Trick 15

Posted on by Annie D

Learn how to create a formula to sort a column of full names with an Excel Formula. Some names have no middle name others have a middle name.
Download Excel File: https://excelisfun.net/files/SEMT00015.xlsx

#excel #excelisfun #analytics #microsoftexcel #microsoftmvp, #short #shorts #excelmvp #excelformulas #excelfunctions #excelformulaforjobinterview #excelforbegginers #excelshorts #exceltutorial #exceltips #exceltipstricks #freeclass #freecourse #freeclasses #freeexcelcourse #freeexcel #shortsyoutube #shorts #short #Sort #sortby #SortNames

Understanding the TIMELINE in DAX Studio

Posted on by Annie D

We brought Marco in to help explain the TIMELINE update within DAX Studio. This can help you understand performance a bit deeper when optimizing your DAX and models. This is one to watch!

DAX Studio
https://daxstudio.org

Marco Russo
https://twitter.com/marcorus
https://www.linkedin.com/in/sqlbi/
https://sqlbi.com

Optimizing DAX Video Course
https://www.sqlbi.com/p/optimizing-dax-video-course/

📢 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
— Continue reading “Understanding the TIMELINE in DAX Studio” →

Conditional Format Row When Employee Is Listed More Than 1 Time For Date. Excel Magic Trick 1821.

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1821.xlsx
Learn how to conditionally format a row in a table when the employee is listed more than one time for a specified Date. Learn how to create Logical Formula to apply Formatting. See COUNTIFS function.
Topics:
1. (00:00) Introduction
2. (00:26) Learn how to conditionally format a row in a table when the employee is listed more than one time for a specified Date. Learn how to create Logical Formula to apply Formatting. See COUNTIFS function.
3. (02:47) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #microsoftexcel #microsoftmvp #conditionalformating #conditionalformatting #conditionalformattinginexcel

Create your FIRST Lakehouse in Microsoft Fabric

Posted on by Annie D

You started your journey into Microsoft Fabric. Ted wants to help you understand how to create your first Lakehouse and start getting data into OneLake!

What is a lakehouse in Microsoft Fabric?
https://learn.microsoft.com/fabric/data-engineering/lakehouse-overview

Create a lakehouse in Microsoft Fabric
https://learn.microsoft.com/fabric/data-engineering/create-lakehouse

Ted Vilutis
https://www.linkedin.com/in/tedvilutis/
https://twitter.com/tvilutis

📢 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
— rel=”nofollow”>http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com

***Gear***
🛠 Check out my Tools page – https://guyinacube.com/tools/

#MicrosoftFabric #Lakehouse #GuyInACube

What Is My CD Worth? A Lesson in Finance & Worksheet Model Building. 365 MECS Class 20

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/20-M365ExcelClass.xlsx
Pdf notes: https://excelisfun.net/files/20-M365ExcelClass.pdf
Learn how to build a Bank CD worksheet schedule to show monthly interest and final CD Value. Learn about the financial concepts behind CD value, and the more general investment future value. Learn about the math that makes compound interest so powerful. See two solutions: worksheet formula model and dynamic spilled array formula model.

This full free Microsoft 365 Excel & Power BI class is taught by Excel MVP and Highline College Professor and can be found here: https://www.youtube.com/playlist?list=PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW
This video covers.
1. (00:00) Introduction and video topics
2. (00:31) Continue reading “What Is My CD Worth? A Lesson in Finance & Worksheet Model Building. 365 MECS Class 20” →

🔴 Let’s talk Microsoft Fabric – LIVE w/ Amir Netz (June 10, 2023)

Posted on by Annie D

Join us live as we answer your questions about Microsoft Fabric including Power BI with out guest Amir Netz who is a Microsoft Technical Fellow and CTO/Visionary of Microsoft Fabric. You don’t want to miss this one!

Connect with Amir:
LinkedIn: https://www.linkedin.com/in/amirnetz/
Twitter: https://twitter.com/amirnetz

📢 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 Continue reading “🔴 Let’s talk Microsoft Fabric – LIVE w/ Amir Netz (June 10, 2023)” →

Excel Formula to Sort By Last Name: Four Awesome Examples! Excel Magic Trick 1821

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1821.xlsx
Learn about how to sort a column of full names (including middle names) by last name using an Excel Formula. See 4 different methods, including Microsoft 365 Excel methods and methods that will work in older versions of Excel.
Topics:
1. (00:00) Introduction
2. (00:21)
3. (00:37) Microsoft 365 Excel Formula (Easy One), SORTBY, TEXTAFTER, LEN and SUBSTITUTE functions.
4. (01:57) Crazy M 365 Excel Formula #1. LOOKUP, BYROWS, LAMBDA, TEXTSPLIT, SORTBY functions with BIG Text Lookup Value “zzzzzz”.
5. (03:57) Crazy M 365 Excel Formula #2. Same as #2, but using BIG Text Lookup Value “Ω”.
6. (04:31) Old School Continue reading “Excel Formula to Sort By Last Name: Four Awesome Examples! Excel Magic Trick 1821” →