Month: April 2023

SUMIF Function Trick: Single Cell Dynamic Range! #Short Excel Magic Trick 12

Posted on by Annie D

Learn how to use a single cell in the Sum Range argument of the SUMIF function rather than an entire column.
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

#sumif #sumifs #sumifactsshorts #sumifacts #dynamicarrays #dynamicrange

🔴 Power BI tips from the Pros – LIVE (April 15, 2023) (Member Chat 2nd Half)

Posted on by Annie D

Join us live as we answer your questions about 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 to help you Continue reading “🔴 Power BI tips from the Pros – LIVE (April 15, 2023) (Member Chat 2nd Half)” →

How To Quickly Changing Multiple Measures At Once In Power BI

Posted on by Annie D

Measures are an essential part of creating meaningful data visualizations in Power BI, as they allow analysts to define calculations and metrics based on their data. However, making changes to measures can be a tedious process, especially if the data model is complex or the calculations involve multiple steps.

When changing the formula for a measure, you may need to modify multiple components of the data model and visualization to ensure the changes are reflected accurately. This can involve navigating through multiple menus and interfaces in Power BI, which can be time-consuming and error-prone. In this video, Brian will show how Continue reading “How To Quickly Changing Multiple Measures At Once In Power BI” →

Minimize diagnostics steps by just using the VPAX file!

Posted on by Annie D

Getting a VPAX and BIM or PBIT file is key to helping optimize your Power BI dataset. We look at them all the time. Patrick shows how you can simplify this by just using the VPAX file!

DAX Studio:
https://daxstudio.org

Tabular Editor:
https://tabulareditor.com/

📢 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
— Continue reading “Minimize diagnostics steps by just using the VPAX file!” →

Excel Random Sample From a List – #shorts

Posted on by Annie D

Microsoft Excel Tutorial
Excel random sample?
Excel random sample without replacement?
Excel how to random sample?
Excel random selection from list?
Excel random selection from list no duplicates?
Excel random row selection?
Excel random cell selection?
Excel random list selection?
Is there a random selection function in excel?
Can Excel randomly select from a list?
Can Excel randomly select rows?
Using Excel random selection?
Can Excel make random selections?

Table of Contents
(0:00) Random sample from Excel list?
(0:03) Analysis ToolPak
(0:07) Easier – Select 28 Rows
(0:21) SORTBY RANDARRAY
(0:44) No RANDARRAY? Use RAND

Excel Enter Random Numbers That Will Not Change Again – #shorts

Posted on by Annie D

In Excel… How does one create a character+number THAT ONLY UPDATES WHEN ENTERED and DOES NOT change with F9 or reloading the spreadsheet?
I want to create sort of an inventory number that I can put on my 3D printer filament boxes to identify them quickly.
But I don’t want the inventory number to ever change after the first creation of the numbers/characters.

This video answers these questions:
Excel random not change?
Excel random keeps changing?
why does random number change in Excel?
Excel random number without changing?
how to stop Excel random number changing?
can i generate random numbers in Excel?
Excel and random number generator?
Excel rand Continue reading “Excel Enter Random Numbers That Will Not Change Again – #shorts” →

Is Excel DATEDIF Gone from Excel? Quick How-To!

Posted on by Annie D

C. R. asks: Is DATEDIF gone from Excel? It is missing from the latest beta builds. Luckily, it is still there, but you have to know the arguments because Excel won’t provide any guidance.

Let’s see how DATEDIF works, even if the function doesn’t appear to be working in your version of Excel.  DATEDIF is useful for calculating the difference between two dates and can return the measure of time you specify (years, months, days, etc.).

Watch the short video below to see the steps!

This video answers all of these questions related to dated if:
is datedif still in excel
is datedif in excel 2016
why does datedif not work in excel
does datedif still work
can’t find datedif in excel
does datedif still work
datedif how to use
how excel datedif works
how to add datedif function in excel
how to get datedif in excel
how to enable datedif function in excel
what replaced datedif in excel
how to use datedif

For even more info: 

https://support.microsoft.com/en-us/office/datedif-function-25dba1a4-2812-480b-84dd-8b32a451b35c

Excel Cost Column Is In Cents! Divide All By 100 – #shorts

Posted on by Annie D

Microsoft Excel Tutorial
Can someone please help me???

I have an Excel file that has the cost column in cents so if something is 1.25 it is showing as 125 .

When I change it to currency the numbers change to 125.00….

Anyone knows how to fix the issue faster than one by one. I have over 5,000 items to go through!

In this short video, learn how to multiply an entire column by 0.01 to quickly convert 125 cents to 1 dollar and twenty five cents.

How To Manage Supply Chain Data With Power BI [2023 Update]

Posted on by Annie D

Power BI can be extremely useful in managing supply chain data by providing powerful visualization and analytics capabilities that enable users to gain insights into their supply chain processes. Users can use Power BI to monitor and analyze inventory levels, track supplier performance, and identify supply chain bottlenecks. Additionally, users can leverage machine learning algorithms to forecast demand, optimize inventory levels, and reduce lead times.

By using Power BI, supply chain managers can make informed decisions that improve supply chain efficiency, reduce costs, and increase customer satisfaction. In this video, Sam will demonstrate how you can effectively manage supply chain Continue reading “How To Manage Supply Chain Data With Power BI [2023 Update]” →

SUMIF Trick that Beats SUMIFS. #Short Excel Magic Trick 11

Posted on by Annie D

Learn how to use the SUMIF function to add numbers greater than a hurdle is a better way than if you use the SUMIFS function.
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

#sumifs #sumif #sumifactsshorts #sumifacts #excelanalytics #excelstatistics

Excel Randomly Sort a List – #shorts

Posted on by Annie D

Microsoft Excel tutorial on randomly sorting a list.

Sort a list into random sequence.
Can Excel Randomly Sort Data?
Excel Create Random Order?
Excel Random Sort?
Can Excel Randomly Sort Data?
Excel How To Random Sort?
Excel Random Order?
Excel Random Order List?
Excel Random Row Order?
Excel Create Random Order?