Month: October 2022

How To Add Comments To A Power Automate Desktop Flow

Posted on by Annie D

In today’s tutorial, Jarrett shows how you can add comments to a Power Automate Desktop flow. It might be a simple concept but here is a little bit of a process in order to do this because there’s no feature in how Power Automate is currently setup that enables you to add comments to your flow steps. This technique is going to come in handy when you need to leave an audit trail for a smooth onboarding or transition in case you need to turnover the flow to someone else in your organization.

***** Video Details *****
00:00 Introduction
01:23 Example scenarios
03:30 Flow Continue reading “How To Add Comments To A Power Automate Desktop Flow” →

Two Way Lookup with XLOOKUP & Summary Report with SUMIFS. Excel Magic Trick 1802

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1801-1804.xlsx
Use functions SUMIFS and XLOOKUP to lookup different commission rates for each product by Sales Rep.
Topics:
1. (00:00) Introduction
2. (00:12) XLOOKUP to do a two-way lookup
3. (02:08) SUMIFS to add with one condition
4. (02:43) Summary, Closing, Video Links

FILTER & XLOOKUP to Lookup Different Product Commission Rates for each Sales Rep. EMT 1801
SUMIFS & XLOOKUP to Lookup Different Product Commission Rates for each Sales Rep. EMT 1802
LAMBDA & MAP Functions to Lookup Different Product Commission Rates for each Sales Rep. EMT 1803
XLOOKUP Array Formula to Lookup Different Product Commission Rates for each Sales Rep. EMT Continue reading “Two Way Lookup with XLOOKUP & Summary Report with SUMIFS. Excel Magic Trick 1802” →

Excel Too Many Fields In Pivot Table Field List To Move Around Easily #shorts

Posted on by Annie D

Colleen calls with a question today. She has a pivot table with too many fields in the Values area. She can’t easily resequence them. Is there a way to see more fields in the Pivot Table Fields pane?

Table of Contents
(0:00) Areas Section Only
(0:12) Undock & Resize Field List
(0:22) Drag line between Fields & Areas
(0:29) Re-dock pivot table fields pane
(0:39) Dragging field headings in pivot table
(0:50) Rearrange by typing

Taking On Excel BI’s Alphabets To Columns Power Query Challenge

Posted on by Annie D

In this video, Melissa shares her solution for the Excel BI’s Alphabets to Columns Challenge. The task is to turn the single column table into a table where each letter has its own column, and is repeated as many times as it’s present in the source table as well.

Excel BI Power Query Challenge 3: https://bit.ly/3NeKw8y

***** Video Details *****
00:00 Introduction
01:33 Creating variables
05:15 Bill’s solution

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Continue reading “Taking On Excel BI’s Alphabets To Columns Power Query Challenge” →

🔴 Power BI tips from the Pros – LIVE (Oct 29, 2022) (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 (Oct 29, 2022) (Member Chat 2nd Half)” →

Excel Remove Line At Bottom Of Cell 2527

Posted on by Annie D

K has an line at the bottom of one cell. How can we remove it?
Other questions here:
Why does AutoFit Row Height not work in Excel?
Why can’t I delete this border in Excel?
Deleting drawing objects in Excel?
Borders using Conditional Formatting in Excel?
How to remove page breaks in Excel?
Paste Picture Link in Excel?
Why is there one extra line of whitespace at the bottom of my cell?
How do I manually change row height in Excel?

Thanks to YouTubers: DropMeSort, Finnur Torfi Gunnarsson, Rico S., and Vesa Ruusunen.
Thanks to Debra Dalgleish at Contextures.

Table of Contents
(0:00) Remove the Line at the bottom of a cell
(0:19) Use Continue reading “Excel Remove Line At Bottom Of Cell 2527” →

Does it matter where your Power BI reports are deployed?

Posted on by Annie D

Where to deploy your Power BI Report? My Workspace? Regular Workspace? What about Apps? Adam breaks it down to help you make the right choice and understand why it matters!

📢 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 page – <a Continue reading “Does it matter where your Power BI reports are deployed?” →

FILTER & XLOOKUP to Lookup Different Product Commission Rates for each Sales Rep. EMT 1801

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1801-1804.xlsx
Use Microsoft 365 functions FILTER and XLOOKUP to lookup different commission rates for each product by Sales Rep.
Topics:
1. (00:00) Introduction
2. (00:09) FILTER & XLOOKUP to Lookup Different Product Commission Rates for each Sales Rep
3. (02:54) Summary, Closing, Video Links

FILTER & XLOOKUP to Lookup Different Product Commission Rates for each Sales Rep. EMT 1801
SUMIFS & XLOOKUP to Lookup Different Product Commission Rates for each Sales Rep. EMT 1802
LAMBDA & MAP Functions to Lookup Different Product Commission Rates for each Sales Rep. EMT 1803
XLOOKUP Array Formula to Lookup Different Product Commission Rates for each Sales Continue reading “FILTER & XLOOKUP to Lookup Different Product Commission Rates for each Sales Rep. EMT 1801” →

Create Psychedelic Spreadsheet Art With Night Creator Studio (Number 1)

Posted on by Annie D

These new Artificial Intelligence Art Creators are the buzz lately. You can type a few sentences and it will generate art for you. I am going to see if I can manage to generate an artistic Excel spreadsheet.
How to use Night Creator Studio to generate artwork.
Type a description, a style, and artistic influences.
Choose dimensions, aspect ratio.

Excel Analyzing Year Over Year Changes When Drinking Magic Mind – 2526

Posted on by Annie D

My productivity hack: https://www.magicmind.co/mrexcel Use my
code MREXCEL20 for 20% off #magicmind

Today, we take a look at analyzing YouTube stats year over year. Along the way, you will see:
Unpivoting KPI columns in Excel Power Query
Creating a pivot table in Excel
Using the SEQUENCE function
XLOOKUP in Excel
Charting in Zebra BI for Office

#productivitytips #productivityhacks #productivityatwork
#adhdmanagement #mondaymotivation #lifehack #inspiration #lifetips

Table of Contents
(0:00) Welcome
(0:10) Magic Mind Challenge
(0:35) Szilvia, Rob, and Matcha
(0:51) Magic Mind Ingredients
(1:49) How does it taste
(2:35) Analyze YouTube Stats
(3:10) Power Query
(3:40) Unpivot KPI columns
(4:10) Pivot Table
(4:55) SEQUENCE function
(5:40) XLOOKUP function
(6:22) Adjust formula by dragging
(6:41) Slicer Shape
(7:09) Pivot Table Lock Column Continue reading “Excel Analyzing Year Over Year Changes When Drinking Magic Mind – 2526” →

How To Automatically Save Email Attachments To SharePoint With Power Automate

Posted on by Annie D

In this tutorial, Jarrett is going to demonstrate how to save email attachments directly to Sharepoint with Power Automate online. This trick will help save you the time and brain space from doing menial tasks such as manually downloading files files from numerous emails and uploading on Sharepoint.

***** Video Details *****
00:00 Introduction
03:51 Template
05:12 Overview
07:26 Creating a flow
07:42 When a new email arrives
08:40 Moving attachments
10:47 Deleting email

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power Continue reading “How To Automatically Save Email Attachments To SharePoint With Power Automate” →