Leaderboard Ad728 × 90AdSense placeholder — will activate after approval

Search: "excel audit"

384 prompts matching "excel audit"

"excel audit" ✕ Clear all ✕
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
👁 5 views
excel Intermediate

Compare Two Excel Sheets and Highlight Real Differences

I need to compare two Excel sheets that should match but probably don't. Sheet A...

#excel #comparison #vlookup
👁 5 views
excel Intermediate

Excel Inventory Reorder-Point Calculator with Safety Stock

I'm building a reorder-point sheet for [number] SKUs in Excel. For each SKU I ha...

#excel #inventory #reorder
👁 5 views
excel Intermediate

Excel Project Gantt Chart from Task List

Generate an Excel Gantt chart from a task list with columns Task, Start Date, Du...

#excel #gantt #project-management
👁 5 views
data Beginner

Data: Cut a Dashboard Down to the 5 Metrics Anyone Actually Uses

I have a dashboard that's grown to 30 charts and nobody knows where to look. Aud...

#data #dashboards #metrics
👁 5 views
excel Advanced

Excel: Build a Three-Statement Model That Stays Internally Consistent

I need a three-statement financial model (income statement, balance sheet, cash ...

#excel #financial-modeling #three-statement
👁 5 views
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
👁 5 views
excel Advanced

Excel: Write a VBA Macro That Emails a Filtered Report to Each Manager

I have a master sheet with sales data tagged by manager. I want a VBA macro that...

#excel #vba #automation
👁 5 views
design Intermediate

Design: Run an Accessibility Pass That Catches the Top 5 Real Issues

Audit this screen for accessibility, but focus on the 5 issues that real users a...

#design #accessibility #wcag
👁 5 views
In-feed Ad336 × 280AdSense placeholder — will activate after approval
excel Intermediate

Excel: Fix the Formula That Works Until It Doesn't

Here's a formula that works on most rows but breaks on a few: [PASTE FORMULA AND...

#excel #formulas #debugging
👁 5 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
👁 5 views
excel Beginner

Excel: Pick a Chart That Doesn't Need a Caption to Be Understood

I want to show [DESCRIBE COMPARISON OR TREND] to [AUDIENCE]. Tell me the right c...

#excel #charts #data-visualization
👁 5 views
productivity Intermediate

Productivity: Audit My Calendar for Meetings That Should Be Async

Here's my week: [PASTE CALENDAR]. For each recurring meeting, ask: does it need ...

#productivity #calendar #async
👁 5 views
excel Intermediate

Excel: Turn a Pivot Table Into Something an Executive Will Actually Read

I built this pivot table: [PASTE STRUCTURE OR SCREENSHOT DESCRIPTION]. It's accu...

#excel #pivot-tables #executive-reporting
👁 5 views
excel Intermediate

Build a Running Total in Excel That Resets Every Month Without a Pivot Table

I'm working in Excel with a table that has a Date column and an Amount column. I...

#excel #formulas #running-total
👁 5 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
👁 5 views
design Intermediate

Audit a screen for the action you actually want users to take

Audit a screen of mine. The screen is [DESCRIBE: what page, what flow, link or s...

#design #ux #audit
👁 5 views
excel Beginner

Turn a flat sales export into a one-screen monthly summary

I have a sales export with columns: order_id, date, region, sales_rep, product_c...

#pivot tables #dashboard #monthly report
👁 5 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
👁 5 views
excel Intermediate

Build a self-updating commission tracker for a sales team in Excel

Act as a RevOps analyst. Help me design an Excel commission tracker that auto-ca...

#commission #sales #formulas
👁 5 views
excel Advanced

Turn a messy CRM CSV export into a clean Excel dashboard

I will paste a CRM export with inconsistent date formats, duplicate accounts und...

#excel #csv #lambda
👁 5 views
excel Advanced

Detect duplicate-but-different customer records in an Excel list

I have a 5,000-row customer table. Many are the same company entered slightly di...

#excel #fuzzy-match #deduplication
👁 5 views
marketing Advanced

Audit a paid campaign that spends but doesn't convert

Our Google Ads campaign is spending $4k/week but conversion is 1/10th of organic...

#marketing #google-ads #conversion
👁 5 views
excel Intermediate

Reconcile two Excel sheets that almost match but disagree on a few rows

You are an Excel reconciliation specialist. I have two sheets — Sheet A (System ...

#excel #reconciliation #xlookup
👁 5 views
End-of-content Ad728 × 90AdSense placeholder — will activate after approval