Leaderboard Ad728 × 90AdSense placeholder — will activate after approval

Search: "power-automate"

71 prompts matching "power-automate"

"power-automate" ✕ Clear all ✕
excel Intermediate

Excel: Clean a Messy Address Column Without Losing Edge Cases

I have a column of free-text addresses scraped from a form: [PASTE 20 SAMPLES]. ...

#excel #power-query #data-cleanup
👁 5 views
excel Intermediate

Turn a wide budget sheet into a flexible pivot-ready long format

I have a budget spreadsheet in wide format: one row per account, then 12 columns...

#excel #power-query #unpivot
👁 5 views
excel Intermediate

Convert a Messy Survey Export Into Clean Long-Format Data

I exported a survey to Excel. Each respondent is one row, each question is its o...

#excel #power query #survey
👁 4 views
business Intermediate

Stakeholder Map for a Cross-Functional Project

Build a stakeholder map for the following cross-functional project. Categorize e...

#business #stakeholder-management #project-management
👁 4 views
excel Intermediate

Excel: Detect Duplicate Rows Across Multiple Key Columns

I have an Excel sheet where 'duplicates' aren't exact matches — they share a cus...

#duplicates #dedupe #power-query
👁 4 views
excel Intermediate

Excel: Untangle a Column Where Multiple Fields Got Stuffed Into One

I have one column containing several fields concatenated together (name, email, ...

#excel #data-cleaning #power-query
👁 4 views
excel Advanced

Excel: Replace a Fragile VLOOKUP Chain With Power Query

I have a workbook stitched together by [N] VLOOKUPs across [M] sheets, and it br...

#excel #power-query #vlookup
👁 4 views
excel Intermediate

Reconcile two lists that should match but somehow never do

You are an Excel power user. I have two lists in Excel that are *supposed* to be...

#excel #vlookup #reconciliation
👁 4 views
excel Advanced

Excel Power Query Recipe to Clean and Unify Multi-Sheet Sales Data

You are an Excel Power Query expert. I have a workbook with 12 monthly sales she...

#power-query #m-language #etl
👁 4 views
In-feed Ad336 × 280AdSense placeholder — will activate after approval
excel Intermediate

Excel: Convert a Messy Paste-from-PDF Table Into a Clean Dataset

I pasted a table from a PDF and Excel split it badly — values are stuck together...

#excel #power-query #data-cleaning
👁 3 views
excel Intermediate

Decide when to use Power Query vs formulas vs a real database

I keep solving the same data problem three different ways across my team's sprea...

#excel #power query #decision
👁 3 views
data Intermediate

Translate a Business Question into a Defensible SQL Query

You are an analytics engineer. I will paste a fuzzy business question (e.g., 'ho...

#sql #analytics #business-questions
👁 3 views
excel Advanced

Reconcile two messy spreadsheets when the join keys don't match

I have two Excel files I need to reconcile, but the join columns aren't clean ma...

#excel #power-query #reconciliation
👁 3 views
excel intermediate

Trace a broken cell reference across a workbook before fixing it blindly

Act as an Excel auditor. A formula on the summary tab is returning #REF! after a...

#excel #auditing #debugging
👁 3 views
excel Intermediate

Turn a messy date column into clean, consistent dates in Excel

I have an Excel column of dates entered in mixed formats (some text, some real d...

#excel #dates #data cleaning
👁 3 views
excel Intermediate

Convert a Messy CSV Export Into a Clean Excel Table

Help me clean a messy CSV export from [SYSTEM NAME] and turn it into an Excel Ta...

#power-query #csv #data-cleaning
👁 2 views
data Advanced

Choose between A/B test variants when results are statistically tied

My A/B test ran for 3 weeks. Variant B is +0.4% on the primary metric, not stati...

#data #ab-testing #experimentation
👁 2 views
excel Intermediate

Turn a messy exported report into a clean pivot-ready table

You're an Excel power user. I pasted in an export from another system and it's a...

#power-query #data-cleaning #pivot
👁 2 views
data Advanced

A/B Test Sample Size and Duration Calculator

Calculate the required sample size and test duration for an A/B test given: base...

#data #ab-testing #experimentation
👁 1 views
creative Intermediate

Invent one cultural detail that makes a fictional society feel lived-in

I am building a fictional society — give me one mundane cultural detail (a greet...

#worldbuilding #cultural detail #fiction
👁 1 views
creative Intermediate

Cut a dialogue scene by 30% without losing what the characters are doing to each other

Cut the dialogue scene below by ~30%. Preserve: the underlying power move (who i...

#dialogue #cutting #fiction
👁 1 views
excel Intermediate

Reconcile two versions of a budget when the row labels don't match

You are an Excel modeler. I'll paste two budget extracts from different teams. T...

#reconciliation #budget #fuzzy-match
👁 1 views
excel intermediate

Clean Messy Excel Data Step by Step

Act as a data cleaning specialist. My Excel sheet has these issues: [list proble...

#excel #data cleaning #power query
👁 1 views
End-of-content Ad728 × 90AdSense placeholder — will activate after approval