Search: "refresh"

#pivot tables #excel #data analysis

ChatGPT Prompt: Excel Pivot Table with Calculated Fields and Slicers Setup

Help me build a comprehensive pivot table report for [DATA TYPE]. Data context:...

#excel #power query #m code

Power Query M Code Generator for Repeatable Data Transformation

Act as a Power Query (M language) developer. I will describe a messy raw export ...

Excel Power Query to Consolidate Monthly Sales Files in a Folder

Generate Power Query M code that consolidates all .xlsx files in a folder into a...

#excel #power-query #etl

#marketing #positioning #strategy

design Intermediate

Logo Design Brief with Brand Pillar Reasoning

Act as a brand strategist briefing an external logo designer. Build a logo desig...

#design #logo #branding

👁 6 views

marketing Advanced

Rewrite Our Positioning When the Market Has Shifted But Our Product Hasn't

Two years ago our positioning landed perfectly. Today the market has moved, thre...

👁 6 views

#excel #automation #power-query

Schedule an Excel file refresh without setting up a server

I have an Excel workbook that pulls data from a CSV in OneDrive via Power Query....

👁 6 views

Build a Sales Pipeline Velocity Tracker in Excel

Act as an Excel expert. I want a single-sheet pipeline velocity tracker. My deal...

#excel #sales #pipeline

👁 5 views

#excel #power-query #vlookup

Excel: Replace a Fragile VLOOKUP Chain With Power Query

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

👁 4 views

#power-query #m-language #etl

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...

👁 4 views

email Advanced

Counter a salary offer that is 15% below your number without burning the relationship

You are a compensation negotiation coach. Draft an email reply to a recruiter wh...

#email #salary-negotiation #offer

👁 4 views

#excel #power query #decision

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...

👁 3 views

excel advanced

Build a working capital model from a P&L extract without manual joins

Act as a finance analyst. I will paste a monthly P&L extract plus a trial-balanc...

#excel #working-capital #finance-model

👁 3 views