Category: Business

Excel Place Local Pictures In Cell Using Formula and a VBA Hack – Episode 2607a

Posted on by Annie D

Microsoft Excel Tutorial: Use Excel VBA to replicate the IMAGE function for images stored locally.

In episode 2606, I showed the new Insert Pictures in Cells and lamented that they did not change the IMAGE function to allow images stored on the local hard drive. Using the VBA Macro in this workbook, you can do it. The VBA is actually better because it remembers the image path and displays it in the formula bar.

To download the workbook or copy the VBA: https://www.mrexcel.com/youtube/0NArag0pV7I/

Table of Contents
(0:00) Enhancing Picture In Cells to use a formula
(0:30) Behind Scenes of 2606
(1:00) Sort Order Continue reading “Excel Place Local Pictures In Cell Using Formula and a VBA Hack – Episode 2607a” →

Use your browser to edit your Power BI dataset within Microsoft Fabric

Posted on by Annie D

More Power BI Desktop capabilities are heading to the service. Modeling in the web is the latest addition. Now Mac users can enjoy editing capabilities! Emily joins us to tell us more!

Edit your data model in the Power BI Service (Preview)
https://powerbi.microsoft.com/blog/edit-your-data-model-in-the-power-bi-service-public-preview-opt-in/

Edit data models in the Power BI service (preview)
https://learn.microsoft.com/power-bi/transform-model/service-edit-data-models

Emily Lisa
https://twitter.com/emilyklisa
https://www.linkedin.com/in/emilyklisa/

📢 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 Continue reading “Use your browser to edit your Power BI dataset within Microsoft Fabric” →

Understanding OneLake within Microsoft Fabric

Posted on by Annie D

The key to Microsoft Fabric is definitely OneLake! OneLake enables the reuse of data within Fabric to help drive all of the engines. One copy of the data! Josh Caplan joins us to help get an understanding of the power of OneLake.

OneLake, the OneDrive for data
https://learn.microsoft.com/fabric/onelake/onelake-overview

OneLake shortcuts
https://learn.microsoft.com/fabric/onelake/onelake-shortcuts

OneLake File Explorer
https://learn.microsoft.com/fabric/onelake/onelake-file-explorer

Josh Caplan:
https://twitter.com/JoshCaplan1984
https://www.linkedin.com/in/josh-caplan-2139a3a6/

📢 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: <a Continue reading “Understanding OneLake within Microsoft Fabric” →

Excel – Picture Place In Cell – Episode 2606

Posted on by Annie D

Microsoft Excel Tutorial – new feature to place a picture in a cell in Excel.
Can the Excel IMAGE function use a local hard drive? Not yet.
New Excel VBA method: InsertPictureInCell
Insert Many Pictures in Excel in one command.
Feature Requests:
Expose a VBA property to show original source of the image
Allow IMAGE function to point to local hard drive.
Allow Power Query to load in-cell images.

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

Table of Contents
(0:00) New Picture In Cell feature
(0:33) Pictures on drawing layer
(0:47) Inserting image in cell in Excel
(1:05) Fitting in Cell
(1:20) Alignment
(1:35) No apparent way to rotate image
(2:02) Use Case from Jerry
(3:48) Continue reading “Excel – Picture Place In Cell – Episode 2606” →

Understanding Microsoft Fabric — 11 Crucial Things You Need to Know

Posted on by Annie D

Welcome to our guide on Microsoft Fabric, Microsoft’s newly introduced data platform.

In this video, we’re presenting 11 key aspects you need to understand about this powerful tool. We’ll explore its primary functions, integral features, and how it interfaces with other Microsoft products such as OneLake Data Hub, Data Factory, Synapse Data Engineering, Synapse Data Science, Power BI, as well as its AI and Co-pilot integrations.

This guide is suitable for business owners, data scientists, and anyone interested in the latest advancements in data platforms. It’s important to note that as a new platform, Microsoft Fabric is in continuous development and Continue reading “Understanding Microsoft Fabric — 11 Crucial Things You Need to Know” →

Budget Vs. Actual Variance Analysis: Data Modeling, DAX, or Worksheet Formulas? 365 MECS Class 19

Posted on by Annie D

Download Zipped Folder with All Files: https://excelisfun.net/files/19-M365ExcelClassVideoFiles.zip
50 pages of pdf notes: https://excelisfun.net/files/19-M365ExcelClass.pdf
This video shows how to create an actual vs. budget variance report in three ways: 1) Relationships and DAX Formulas, TREATAS Dax Function and Worksheet Formulas.

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:32) Budget Vs Actual Grain Problem
3. (01:13) Two Fact Tables
4. (02:20) Create Budget Vs Actual Variance Report with three methods
5. (02:20) Worksheet Formulas Continue reading “Budget Vs. Actual Variance Analysis: Data Modeling, DAX, or Worksheet Formulas? 365 MECS Class 19” →

Leverage the Microsoft Fabric Trial

Posted on by Annie D

Did you know that Microsoft Fabric comes with a 60-day free Fabric Capacity trial? Adam shows you how to get it and the reason why you may not be able to use it.

Microsoft Fabric (Preview) trial
https://learn.microsoft.com/fabric/get-started/fabric-trial

📢 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
— https://www.instagram.com/guyinacube/
— <a href="https://guyinacube.com" Continue reading “Leverage the Microsoft Fabric Trial” →

Why can’t I use Microsoft Fabric?

Posted on by Annie D

You’ve heard about all the great things with Microsoft Fabric, but you don’t see it in the portal. You only see the Power BI items and no persona switcher. What’s going on? Adam shows you to enable Fabric for your tenant.

Enable Microsoft Fabric for your organization
https://learn.microsoft.com/fabric/admin/fabric-switch

📢 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
— Continue reading “Why can’t I use Microsoft Fabric?” →

Excel – Draw a Line through Text (Strikethrough) #shorts

Posted on by Annie D

Microsoft Excel Tutorial – How to draw a line through text.
Some people call it Strikethrough. Others call it crossing out text.
How can you do it in Microsoft Excel.

This short video starts with a memory aid about taking inventory with a mechanical pencil and making hashmarks. You might start with |||| to mean 4. After the 4th vertical hashmark, you cross out the lines to indicate 5. It is the 5th line that crosses the others out. This is how I remember that Ctrl+5 is Strikethrough!

Download the workbook from https://www.mrexcel.com/youtube/PmQpp46p3ls/

Table of Contents
(0:00) Counting with Hashmarks
(0:12) Cross out Continue reading “Excel – Draw a Line through Text (Strikethrough) #shorts” →

What is Microsoft Fabric (Public Preview)?

Posted on by Annie D

Maybe you’ve heard the announcement of Microsoft Fabric. Maybe you are coming from Power BI and curious how Microsoft Fabric relates. Adam gets you up to speed!

Microsft Learn: Get Started with Microsoft Fabric
https://learn.microsoft.com/training/paths/get-started-fabric/

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

📢 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 Continue reading “What is Microsoft Fabric (Public Preview)?” →

Excel – Draw Arrows or Dotted Line in Excel – #shorts

Posted on by Annie D

Microsoft Excel Tutorial – How to Draw Arrows or Line in Excel.
How to draw an arrow in Excel?

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

Table of Contents
(0:00) Draw arrow in Excel
(0:08) Change Arrow Color, Weight, Arrow Heads
(0:21) Make line dotted in Excel
(0:24) Curve arrow around an obstacle in Excel
(0:51) Wrap up

Common Search Terms:
how do i draw arrows in excel
how do you draw arrows in excel
how to draw a arrow in excel
how to draw an arrow in excel
how to draw an arrow in excel 2010
how to draw an arrow line in excel
how to draw arrow in excel
how to draw arrow in Continue reading “Excel – Draw Arrows or Dotted Line in Excel – #shorts” →