Leaderboard Ad728 × 90AdSense placeholder — will activate after approval

Search: "excel audit"

384 prompts matching "excel audit"

"excel audit" ✕ Clear all ✕
excel Intermediate

Design a Pivot Table Reporting Plan

You are an Excel reporting consultant. Based on the dataset I describe, design t...

#excel #pivot-table #reporting
👁 3 views
excel Intermediate

Diagnose Why a Pivot Table Is Showing the Wrong Totals

Help me diagnose why my Excel pivot table is showing wrong totals. Source data r...

#pivot-table #debugging #totals
👁 2 views
excel Beginner

Excel: Build a Pivot Table That Answers the Question Your Boss Actually Asked

I have a dataset and a vague question from leadership. Help me design a pivot ta...

#excel #pivot-tables #reporting
👁 2 views
productivity Intermediate

Productivity: Audit a Week of Calendar Time and Tell Me What's Stealing Focus

I'll paste a week of my calendar. Audit it. Output: (1) % time in meetings vs fo...

#productivity #calendar #time-audit
👁 2 views
customer-service Intermediate

Customer Service: Audit Our Support Macros for the Ones Doing More Harm Than Good

We have a stack of support macros (canned replies) and some of them are aging ba...

#customer-service #macros #templates
👁 2 views
legal Advanced

Draft a Plain-English MSA Summary for a Non-Lawyer Executive

Act as in-house counsel translating contracts for executives. I will paste a Mas...

#msa #contracts #summary
👁 2 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
👁 2 views
excel Advanced

Build a flexible scenario model without nesting IF statements ten layers deep

Act as a financial modeler reviewing my workbook. I have a model that runs base/...

#scenarios #modeling #choose
👁 2 views
excel Intermediate

Find which formula in a 12-tab workbook is wrong without checking every cell

You're an Excel auditor. A summary total on my Dashboard tab is off by $4,200 fr...

#debugging #audit #trace-precedents
👁 2 views
In-feed Ad336 × 280AdSense placeholder — will activate after approval
legal Advanced

Read a vendor contract for the clauses that bite you 18 months in

You're a commercial counsel reviewing a vendor contract on my behalf — but expla...

#contracts #review #vendor
👁 2 views
excel Intermediate

Build a formula that flags rows where two columns disagree

Act as an Excel expert. I have a spreadsheet where two columns should always agr...

#formulas #validation #helper-column
👁 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
excel Intermediate

Write a lookup that survives someone reordering the columns

Act as an Excel expert. My VLOOKUPs keep breaking because colleagues insert and ...

#xlookup #index-match #robust
👁 2 views
excel Beginner

Make a one-cell formula that summarizes a whole row in plain words

You're an Excel helper for non-technical users. I want a single formula that rea...

#textjoin #reporting #plain-english
👁 2 views
excel beginner

Write Excel Formulas from Plain English

Act as an Excel formula assistant. I will describe what I want to calculate in p...

#excel #formulas #automation
👁 2 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
👁 2 views
excel Intermediate

Build an Excel formula that flags duplicates across multiple columns

In Excel I need to find rows that are duplicates based on a *combination* of col...

#excel #duplicates #countifs
👁 2 views
excel Intermediate

Design a Pivot Table for Monthly Sales Analysis

You are an expert Excel reporting analyst. Guide me through building a pivot tab...

#excel #pivot-table #sales
👁 2 views
excel Advanced

Plan an Excel Macro or Office Script

You are an Excel automation expert. I will describe a repetitive task and you wi...

#excel #automation #vba
👁 2 views
excel Advanced

Diagnose a Slow Excel Workbook

You are an Excel performance consultant. I will describe my workbook's symptoms ...

#excel #performance #optimization
👁 2 views
excel Beginner

Reconcile Two Excel Lists for Differences

You are an Excel reconciliation helper. I have two lists (for example, a system ...

#excel #reconciliation #vlookup
👁 2 views
excel Beginner

Clean Messy Imported Data with Formulas

You are an expert Excel data-cleaning specialist. Help me clean a messy column o...

#excel #data-cleaning #trim
👁 1 views
excel Intermediate

Clean Messy Spreadsheet Data Step by Step

You are a data-cleaning specialist. I have a messy Excel sheet with these proble...

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

Build a Dynamic Array Dashboard Formula

You are an Excel power user. I will describe a dataset and a reporting goal, and...

#excel #formulas #dynamic-arrays
👁 1 views
End-of-content Ad728 × 90AdSense placeholder — will activate after approval