Category: Business

Solution for Two Fact Tables: Power Query or DAX formulas or Worksheet Formulas? 365 MECS Class 18

Posted on by Annie D

Create Reports & Visuals from Two Fact Tables with Different Grains. 3 Solutions. 365 MECS Class 18
Download Zipped Folder with All Files: https://excelisfun.net/files/18-M365ExcelClassVideoFiles.zip
50 pages of pdf notes: https://excelisfun.net/files/18-M365ExcelClass.pdf
This video shows how to deal with Two Fact Tables with Different Grains. Learn three solutions: 1) Power Query, DAX Formulas or Worksheet Formulas. Learn how to create reports and visuals from Two Fact Tables with Different Grains.

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. Continue reading “Solution for Two Fact Tables: Power Query or DAX formulas or Worksheet Formulas? 365 MECS Class 18” →

Excel Variance Inside The Pivot Table – Episode 2605

Posted on by Annie D

Microsoft Excel Tutorial: Adding a Variance inside of a pivot table.

Keani has a pivot table with current year and last year across the top. She wants a variance. Her current solution is a formula outside of the pivot table which points inside of the pivot table.

This video shows three methods for adding a variance inside the pivot table.
1. Regular pivot table, add Revenue twice. Change calculation to Difference From, Years, and (Previous Item)
2. Regular pivot table. Remove Grand Total. Use 2 Excel Calculated Items to calculate Variance and Total
3. Data Model Pivot Table. Add four DAX Measures to calculate last Continue reading “Excel Variance Inside The Pivot Table – Episode 2605” →

Microsoft’s AI Transformation – A Deep Dive into the Future of Data Tech!

Posted on by Annie D

In this thrilling exploration of Microsoft’s AI advancements, we dissect the democratizing power of AI and how it is revolutionizing every aspect of our digital life, from workflows to product development. We delve into the significance of Microsoft’s partnership with OpenAI, the introduction of AI co-pilots into every sphere of our work, and how AI is becoming an omnipresent force in our digital universe.

Discover the transformative power of data science, data analytics, and application development as we witness the rise of the new Microsoft Data Fabric. Understand the changing landscapes of Power BI, Azure, Synapse, and Data Factory and Continue reading “Microsoft’s AI Transformation – A Deep Dive into the Future of Data Tech!” →

INDEX Function Beats XLOOKUP? #Short Excel Magic Trick 14

Posted on by Annie D

Learn how to use the INDEX function to make an easier lookup formula than using the XLOOKUP function when the lookup values to match are sequential numbers starting at 1.
Download Excel File: https://excelisfun.net/files/SEMT0008-12.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
#xlookup #indexfunction #indexfunction

Learning Together: The Power of Communities for Personal and Professional Growth with Kedeisha Bryan

Posted on by Annie D

Are you struggling to find meaningful learning support in the data analytics field? Tired of the same ineffective advice and lacking the right connections to make a difference? Join us in this episode and learn how to unlock personalized learning support with data communities and AI technology – finally advancing your skills and career in data science.

Kedeisha Bryan is a dedicated data professional who has made a significant impact in the field of data analytics in just two years. With a background in senior data engineering at Booz Allen Hamilton, Kedeisha has a wealth of experience in various aspects of Continue reading “Learning Together: The Power of Communities for Personal and Professional Growth with Kedeisha Bryan” →

Data Immersion Supercharged by AI with Nikola Ilic

Posted on by Annie D

In this episode of The Analytic Mind, host Sam McKay welcomes data expert Nikola Ilic, also known as the Data Mozart, to discuss the latest developments in the data world. Nikola shares his background working with traditional Microsoft business intelligence products and his current focus on Power BI and Azure Synapse Analytics. The conversation then turns to the strength of Microsoft’s data platform and the integration of its various components. Sam and Nikola also explore the potential of AI technology in data analysis and productivity, citing recent advancements in PowerPoint and Power BI.

Nikola Ilic is a renowned data expert Continue reading “Data Immersion Supercharged by AI with Nikola Ilic” →

🔴 Let’s talk Microsoft Fabric – LIVE w/ Matthew Roche (May 27, 2023) (Member Chat 2nd Half)

Posted on by Annie D

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

Connect with Matthew:
Mastodon: https://techhub.social/@SQLAllFather
YouTube: https://www.youtube.com/channel/UCpsilPn-2qFlrYYuvyFkpPQ
Website: https://ssbipolar.com/

💥 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 Continue reading “🔴 Let’s talk Microsoft Fabric – LIVE w/ Matthew Roche (May 27, 2023) (Member Chat 2nd Half)” →

Excel All Combinations One To Six in Four Columns – Episode 2604

Posted on by Annie D

Microsoft Excel Tutorial: Generating all combinations of N outcomes for K games.

In episode 2602, I had to generate all possible combinations of 4 games with 6 possible outcomes in each game. I used my very convoluted “binary count up, but not binary because it is base 6, but not base 6 because I need the digits 1 to 6 instead of 0 to 5” method. This involves a lot of typing and two different formulas.

Today, a much easier way from Kyle Freistedt. Kyle DOES use Base 6. He does use a SEQUENCE function but starts at 0 instead of Continue reading “Excel All Combinations One To Six in Four Columns – Episode 2604” →

Excel – Circle Invalid Data – #shorts

Posted on by Annie D

Microsoft Excel Tutorial – Circle invalid data in Excel

This video shows a cool use for Data Validation: Circling Invalid Data.

Also: manually circling a cell in Excel using the drawing tools. This method creates a filled circle. This video shows you how to remove the fill so you have a circle that does not cover the data.

To download this workbook: https://www.mrexcel.com/youtube/OpVReJuDvWs/

Table of Contents
(0:00) Circle invalid data in Excel
(0:08) Define valid data in Data Validation first
(0:28) Manually drawing circles
(0:38) Making filled circle an outline
(0:46) Ctrl+Drag to copy circles in Excel
(0:52) Wrap-up

This video answers these search terms:
how do you circle Continue reading “Excel – Circle Invalid Data – #shorts” →

Excel VBA Window is All Grey Or Panes Will Not Redock Correctly – Episode 2603

Posted on by Annie D

Microsoft Excel Tutorial: The VBA Editor Panes are missing or not docked correctly.

Chris writes in. His VBA Editor is completely grey. How does he get back to the classic view with the Project Explorer in the Top Left, the Properties window in the bottom left and the Code on the right?

To download this workbook: https://www.mrexcel.com/youtube/C4T9CDfVA5g/

Table of Contents
(0:00) Program Note
(0:11) Excel VBA Editor is all Grey
(0:50) VBA Panes not docking correctly
(0:55) Undocking VBA Pane
(1:08) Look for “Ghost” panel to redock
(1:28) Excel VBA Pane redocks full width
(1:46) VBA Editor no room for code pane
(1:56) Undock the Project Explorer
(2:08) Continue reading “Excel VBA Window is All Grey Or Panes Will Not Redock Correctly – Episode 2603” →

What does Microsoft Fabric mean for Guy in a Cube?

Posted on by Annie D

Very excited that Microsoft Fabic has hit Public preview! But what does that mean for Guy in a Cube? Is Guy in a Cube going to cover Microsoft Fabric?

Blog: https://azure.microsoft.com/blog/introducing-microsoft-fabric-data-analytics-for-the-era-of-ai/

Blog: https://powerbi.microsoft.com/blog/introducing-microsoft-fabric-and-copilot-in-microsoft-power-bi/

Docs: https://learn.microsoft.com/fabric/get-started/microsoft-fabric-overview

Tutorials: https://learn.microsoft.com/fabric/get-started/end-to-end-tutorials

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Microsoft Fabric & 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
— Continue reading “What does Microsoft Fabric mean for Guy in a Cube?” →

Excel – How to Draw a Circle in Excel #shorts

Posted on by Annie D

Microsoft Excel Tutorial – Draw a Circle in Excel

The drawing tools in Microsoft Excel offer an oval. There is a secret trick to making the oval into a perfect circle: Hold down the Shift key while drawing.

To download this workbook: https://www.mrexcel.com/youtube/vUtrQeqxqRA/

Table of Contents
(0:00) Draw a Circle in Excel using Shift Key
(0:22) Draw Many Circles in Excel
(0:33) Circle something on a chart in Excel
(0:44) Remove Fill in Excel circle

This video answers these common search terms:
how do you draw in a circle in excel
how to draw a circle in excel
how to draw circle in excel
how to draw circles in Continue reading “Excel – How to Draw a Circle in Excel #shorts” →