Month: March 2023

How To Integrate ChatGPT With Microsoft Outlook Using Power Automate

Posted on by Annie D

In recent months, the popularity of AI tools has risen significantly, and ChatGPT is one of them. These tools offer a range of benefits, including the ability to automate repetitive tasks, analyze data, and provide personalized recommendations. By leveraging the power of AI, organizations can streamline workflows and improve productivity.

Furthermore, AI tools can help identify patterns and insights that would be difficult for humans to detect, leading to more informed decision-making. In this tutorial, Henry is going to demonstrate how you can integrate ChatGPT with Microsoft Outlook using Power Automate.

*****Video Details*****
00:00 Introduction
00:25 Use case
02:57 How the API works
05:53 Power Continue reading “How To Integrate ChatGPT With Microsoft Outlook Using Power Automate” →

Excel Sum With IF Conditions SUMIF SUMIFS 2580

Posted on by Annie D

This video covers six topics about conditional sums in Excel.

Table of Contents
(0:00) Topics in this video
(0:33) Conditional Sum in Excel
(1:17) SUMIFS with multiple criteria
(2:09) SUMIFS with 2 criteria in same column
(5:33) How to Drag SUMIFS formula
(6:27) SUMIFS with Function in Criteria
(7:22) SUMIFS with Range of Dates

This video is designed to answer the popular search terms:
how to add multiple sum ifs in excel
how to sumif by month excel
how to drag sumifs formula in excel
how to use functions as criteria in sumif excel
how to sum if number in excel ignore error
how to use sumif in excel for multiple columns
how to sumifs with Continue reading “Excel Sum With IF Conditions SUMIF SUMIFS 2580” →

Excel Percentage Of Total – 2579

Posted on by Annie D

How to calculate a percentage of total in Excel.

Common search terms answered by this video:
How to add percentages to sum in Excel
how to calculate percentage of a sum in Excel
how to change a percentage on a sum on Excel
how to do a percent sum in Excel
how to do a percentage of a total sum on Excel
how to do a percentage sum in Excel
how to do a percentage sum on Excel
how to do an percentage sum on Excel
how to do percentage sum in Excel
how to find a precentage of sums in Excel

Table of Contents
(0:00) Add a Total in Excel
(0:10) Division formula Continue reading “Excel Percentage Of Total – 2579” →

Switch a Power BI Report’s dataset without needing Premium!

Posted on by Annie D

Want a dev and production environment in Power BI but don’t have Power BI Premium? Patrick shows you a way to switch a report from Dev to Production without Premium or without APIs.

📢 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/
— https://guyinacube.com

***Gear***
🛠 Check out my Tools Continue reading “Switch a Power BI Report’s dataset without needing Premium!” →

Excel Why Is SUM Not Appearing in the Status Bar at Bottom #shorts

Posted on by Annie D

Why is Excel not showing the SUM in the status bar at the bottom of Excel?
There are a few reasons covered in this short video.
1) You only selected a single cell
2) You’ve selected a range of text numbers
3) One or more error cells in the selection
4) Someone turned off the SUM

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” →