Search: "excel audit"

#power query #excel #data combine

Excel Power Query Combine Multiple Sheets Into Master Table

You are an Excel Power Query specialist. Walk me step-by-step through combining ...

#excel #pivot-table #calculated-field

ChatGPT Prompt: Excel Pivot Table Calculated Field for Custom Metrics

You are an Excel pivot table expert. Help me add a calculated field to my pivot ...

#weekly review #gtd #productivity system

ChatGPT Prompt: Weekly Review System Based on GTD and Bullet Journal Hybrid

Design a weekly review process tailored to my workflow. Context: - Role: [DESCR...

excel Advanced

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

#excel #pivot-table #calculated-field

Excel Pivot Table Calculated Field for Margin Percentage by Segment

I have a sales table with columns: order_id, date, customer_segment, product, re...

#excel #dynamic-arrays #textsplit

excel Advanced

Excel Dynamic Array Formula to Split Comma-Separated Tags into Columns

I have column A filled with comma-separated tags like 'urgent, vip, refund, bill...

#cash flow #personal finance #budgeting

finance Intermediate

Personal Cash Flow Forecast for Next 12 Months

Build a 12-month personal cash flow forecast. Inputs: - Monthly net income: [AMO...

#design #accessibility #a11y

design Intermediate

Audit a UI for Accessibility Wins You Can Ship This Week

Help me audit my product for accessibility wins I can ship within a week, not th...

#excel #commission #sales

Excel Sales Commission Tiered Calculator

Create an Excel formula that calculates sales commission using tiered rates: 5% ...

#excel #formulas #xlookup

Replace nested IFs with a lookup table you can actually maintain

I have a worksheet with nested IF formulas like: =IF(A1="Bronze",0.05,IF(A1="Sil...

#data-quality #audit #validation

data Intermediate

Data Quality Audit Framework for New Source

Act as a data quality lead. I am onboarding a new data source: [SOURCE NAME], fo...

#dates #iso #data cleaning

Convert Messy Excel Date Formats to Standardized ISO

I have a column of dates in Excel with inconsistent formats: '03/15/2024', '15-M...

#excel #reconciliation #fuzzy match

excel Advanced

Reconcile Two Bank Statements with Fuzzy Matching in Excel

I have two sheets: 'Bank' with columns Date, Description, Amount and 'Books' wit...

data Intermediate

Spot-Check a Dataset for Quality Issues Before Modeling

I'm about to train a model on this dataset: [DESCRIBE COLUMNS, ROW COUNT, SOURCE...

#data #data quality #EDA

#productivity #meetings #time management

Cut Your Meeting Load in Half Without Causing Chaos

Help me cut my meeting time by 50% over the next 4 weeks without breaking trust ...

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

#excel #scenarios #data tables

Create a What-If Scenario Comparison Table With Data Tables

I have a financial model with three driver inputs (cells B2: pricing, B3: churn,...

#calendar-audit #meetings #time-management

Audit My Calendar for Hidden Coordination Tax

Audit my calendar for hidden coordination tax. Last 2 weeks: [PASTE EVENTS OR DE...

Excel: Replace a Wall of Nested IFs With One Clean SWITCH or IFS

I have a nested IF formula that's grown unmaintainable. Rewrite it using SWITCH,...

#excel #formulas #switch

#productivity #time-management #meetings

Audit a week of calendar time to find the meetings that secretly cost the most

I'll paste my last week of calendar entries below (or summarize them). I want to...

hr Advanced

Diversity Hiring Funnel Audit with Bias Checkpoints

You are a DEI hiring expert. Audit a hiring funnel and propose interventions. I...

#hr #diversity #hiring

👁 6 views