Category: Business

Excel’s #1 Most Hidden Trick: Insert Picture In Comment. #Short Excel Magic Trick 04

Posted on by Annie D

Learn how to insert a picture into a Comment/Note. This is Excel most hidden and buried trick because you have to click through nine steps to get to it! But it is worth it!!!
Download Excel File: https://excelisfun.net/files/SEMT0004.xlsx
#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #powerbi #powerquery #powerbidesktop #powerquery #powerquerytutorial #microsoftexcel #microsoftmvp, #short #shorts #shortsyoutube #excelshortcuts #excelshortvideo #insertpicture #comment
#comments

Steps for trick:
1) Select Cell
2) Shift + F2 or Right-click, New Note (Comment in older versions)
3) Click Outside Edge of Note/Comment
4) Ctrl + 1 or Continue reading “Excel’s #1 Most Hidden Trick: Insert Picture In Comment. #Short Excel Magic Trick 04” →

How To Fix SUM Function in Excel – 2578

Posted on by Annie D

How to Fix the SUM function in Excel.
How to tell what is included in the SUM function in Excel.
Edit what is being summed.
Why is there a green triangle on my SUM function in Excel?
Formula Omits Adjacent Cells in Excel.
Update Formula to include cells in Excel.

Today, you have a SUM in Excel which appears to be too small for the numbers you are adding up. Use the F2 key to figure out what numbers are in the sum.

One solution is to drag the range to include many blank cells.
But another solution is to convert the range to a Table so the Continue reading “How To Fix SUM Function in Excel – 2578” →

Excel Sum All VLOOKUP Matching Rows #shorts

Posted on by Annie D

One of the most common questions is how can I do a VLOOKUP in Excel and sum all of the matches? You can’t do it with VLOOKUP because VLOOKUP only finds the first match. It won’t work with XLOOKUP either, because you can only find the last match. Instead, you can use SUMIF or SUMIFS to get the total of all VLOOKUP matches.

This video answers these search terms:
How To Do A VLOOKUP Sum In Excel
How To Lookup And Sum In Excel
How To Sum A Column Using VLOOKUP In Excel
How To Sum A XLOOKUP In Excel
How To Sum In Excel Using Continue reading “Excel Sum All VLOOKUP Matching Rows #shorts” →

How To Detect And Visualize Outliers Using DAX In Power BI [2023 Update]

Posted on by Annie D

Knowing how to detect outliers in datasets and how to visualize them is important for data analysts because it helps them identify potential errors or anomalies in data that can skew statistical analyses and modeling results.

Outliers can also provide valuable insights into unusual or unexpected patterns in the data that may be indicative of underlying trends or issues, facilitating more effective data-driven decision-making. In this video, Sam is going to demonstrate how you can detect and visualize outliers using DAX in Power BI.

*****Video Details*****
00:00 Introduction
01:13 Determining the logic
03:44 Doing logic in a dynamic way
04:00 Criteria for outliers
05:22 Outlier detection logic
08:10 Continue reading “How To Detect And Visualize Outliers Using DAX In Power BI [2023 Update]” →

How to Add Text To A Sum In Excel – 2577

Posted on by Annie D

You have a sum in Excel. You want to add some text to the sum. Maybe something like “Please remit $” before the number. This video shows two methods. The first uses Concatenation. The second uses a custom number format, with different text showing for positive, negative, and zero. Also in this video: using F4 to repeat a command.

Common Search Terms answered by this video:
how to concatenate a number with text in Excel
how to add text to sum in Excel.
how to join text and a number in Excel.

Table of Contents
(0:00) Concatenate text with SUM
(0:26) Custom number format to add text Continue reading “How to Add Text To A Sum In Excel – 2577” →

How To Create Fully Dynamic Image Slicers In Power BI

Posted on by Annie D

Learning how to create dynamic picture slices in Power BI allows you to provide a more interactive and engaging experience for your audience. With dynamic picture slices, users can easily filter data and explore relationships visually, leading to better insights and decision-making. In this tutorial, Brian shows how you can spruce up your standard Power BI slicer into a fully dynamic image slicer.

*****Video Details*****
00:00 Introduction
00:44 Image source
01:52 Standardizing the image background
03:28 Chiclet slicer
05:00 Image hosting
06:40 Linking new table to customers table
09:50 Configuring the buttons
10:23 Formatting the image

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI Continue reading “How To Create Fully Dynamic Image Slicers In Power BI” →

Excel How To Sum But Ignore Errors – 2576

Posted on by Annie D

You have a range of numbers in Excel but there are some error cells. When you try to use AutoSum, it selects the wrong range. When you select the correct range, the Sum is replaced by an error.
This video shows two methods for solving the problem:
With Microsoft 365, add IFERROR inside the SUM.
With older Excel, use the AGGREGATE function to ignore errors.

This video answers these common search terms:
How to get excel to ignore error in sum.
How to ignore errors when summing in Excel.
How to sum columns in Excel with “#value!”.
How to sum columns in Excel with # value.
How to Continue reading “Excel How To Sum But Ignore Errors – 2576” →

Excel Array Formulas in 1 Minute. # Short Excel Magic Trick 04

Posted on by Annie D

Learn Excel Array Formulas so you can have power with Excel Formulas! See 4 examples of array formulas. Define Array Formula.
Download Excel File: https://excelisfun.net/files/SEMT0004.xlsx

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #powerbi #powerquery #powerbidesktop #powerquery #powerquerytutorial #microsoftexcel #microsoftmvp,
#array #arrayformula #excelarrayformulas #dynamicarrays #oneminute

How To Test And Develop Color-blind Friendly Themes For Your Power BI Report

Posted on by Annie D

Using color-blind safe visuals in Power BI is important because around 5-10% of the population has some form of color blindness, which can make it difficult or impossible for them to distinguish certain colors. Failing to use color-blind safe visuals can lead to confusion and misinterpretation of data for people with color blindness, and ultimately lead to poor decision-making.

By using color-blind safe visuals, you can ensure that your data is accessible and understandable to a wider audience, including those with color vision deficiencies. In this tutorial, Brian shares a quick and easy way to check how color-blind friendly is your Continue reading “How To Test And Develop Color-blind Friendly Themes For Your Power BI Report” →

How To Type The Sum Symbol Sigma In Excel – 2575

Posted on by Annie D

Several people asked about typing a Sigma or the Sum Symbol in Excel. There are several different ways to do this, and none are particularly easy to figure out. Perhaps the best way is =UNICHAR(931) followed by F9.

This video answers these search terms:
how to do sigma in excel
how to find sigma in excel
how to find the sum symbol in excel
how to get sum symbol in excel
how to get the sum symbol in excel
how to insert sum symbol in excel
how to type sigma in excel
how to use sigma in excel
what is the sum symbol called in excel

Visually see where you BROKE the fold in Power Query

Posted on by Annie D

Rule #1 – DON’T BREAK THE FOLD! There is an amazing feature that lets you see where this fold was broken, and I’m guessing you didn’t even know it was there! Adam shows you where to go.

Query plan for Power Query (Preview)
https://learn.microsoft.com/power-query/query-plan

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

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

#PowerBI #PowerQuery #GuyInACube