Search: "excel audit"

design Intermediate

Mobile Form Design Audit for Conversion and Accessibility

Audit my mobile form (signup/checkout/etc.) for conversion AND accessibility. I'...

#design #forms #mobile

#excel #test-data #random

excel Beginner

Generate Realistic Test Data With Random Functions

I need to generate {{number, e.g., 500}} rows of realistic test data in Excel fo...

#duplicates #data cleaning #excel

Excel Formula to Detect Duplicate Records Across Columns

I need an Excel formula to detect duplicate records based on a combination of mu...

productivity Intermediate

Eliminate Recurring Meetings Decision Framework

Create a decision framework to audit and eliminate unnecessary recurring meeting...

#meetings #decision framework #productivity

Excel VBA Macro to Auto-Format Monthly Reports

Write a VBA macro that, when run, formats the active sheet as a monthly report: ...

#excel #vba #macros

Forecast Sales with Excel FORECAST.ETS

I have monthly sales data in Excel for the last 3 years. Help me build a 12-mont...

#excel #forecast #ets

#excel #forecasting #revenue

Forecast Monthly Revenue With Excel's FORECAST.ETS

I have 36 months of revenue data (column A: month-end dates, column B: revenue)....

#template #data-validation #conditional-formatting

Build a Reusable Excel Template With Input Validation Built In

Help me design a reusable Excel template for [USE CASE: e.g. expense report, pro...

#excel #audit #inherited-work

Excel: Audit a Spreadsheet I Inherited Before I Trust Its Numbers

I just inherited this workbook from someone who left: [DESCRIBE TABS, KEY OUTPUT...

#invoice #VBA #automation

Invoice Generator with Auto-Numbering VBA

Create an Excel invoice generator with automatic invoice numbering using VBA. B...

#data quality #anomaly detection #data monitoring

data Advanced

Automated Data Quality Report with Anomaly Detection

Create a data quality monitoring report for my dataset: - Data source: [e.g., '...

#design sprint #UX #product design

design advanced

Design Sprint Facilitation Guide 5-Day Process

Create a complete Design Sprint facilitation guide for a [product team / startup...

excel intermediate

Excel SUMIF & COUNTIF: Advanced Multi-Criteria Formula Guide

Act as an Excel formula expert. I want to master SUMIF, SUMIFS, COUNTIF, and COU...

#excel #sumif #countif

#excel #lambda #custom-functions

excel advanced

Excel LAMBDA Function Custom Formula Library Creation Guide

Design a library of reusable custom Excel functions using the LAMBDA function fo...

productivity intermediate

Time Blocking Schedule System Deep Work Productivity Framework

Design a complete time blocking system for knowledge workers to maximize deep wo...

#productivity #time-blocking #deep-work

#inbox-zero #digital-minimalism #email-management

productivity beginner

Digital Minimalism & Email Management: Inbox Zero Sustainable System

Help me design a sustainable inbox zero and digital minimalism system. My situat...

productivity Intermediate

Delegation Framework for Managers to Multiply Team Output

Create a practical delegation framework for a manager leading a team of [team si...

#delegation #management #leadership

productivity Intermediate

Focus Block Calendar Design Deep Work Protection System

You are a productivity strategist. Design a focus-block calendar system for [ROL...

#deep work #focus #calendar

excel Beginner

ChatGPT Prompt: Excel SUMIFS Formula Builder for Multi-Condition Aggregation

You are an Excel formula expert. I need to build a SUMIFS formula that totals va...

#excel #sumifs #formulas

coding Advanced

ChatGPT Prompt: REST API Endpoint Naming and Versioning Convention Reviewer

You are an API design reviewer. Audit my endpoint list for naming, REST semantic...

#coding #api #rest

#excel #pivot table #sales analysis

Pivot Table Mastery for Multi-Year Sales Data Analysis

Act as an Excel data analyst. I will paste a sales dataset with columns Date, Re...

#legal #contracts #vendor

legal Advanced

Vendor Contract Redline Checklist with Risk Tiers

You are an in-house contracts attorney. I will paste a vendor contract. Run it t...

#finance #cash-flow #forecasting

finance Advanced

Build a 13-Week Cash Flow Forecast With Scenario Toggles

Walk me through building a 13-week cash flow forecast for a small business. Outp...