Search: "Excel forms"

Excel VBA Macro to Automate Repetitive Report Formatting

Write an Excel VBA macro that automates the formatting of a weekly report I rece...

#VBA #macro #automation

#excel #conditional formatting #dashboard

Excel Conditional Formatting Heatmap Project Status Dashboard

You are an Excel dashboard designer. Build a conditional-formatting heatmap for ...

#power query #excel #web scraping

ChatGPT Prompt: Excel Power Query M Code for Web Data Scraping

Write Power Query M code to scrape and transform data from [URL OR DESCRIBE WEBP...

#excel formulas #dynamic arrays #dashboard

ChatGPT Prompt: Excel Dynamic Array Formulas for Reporting Dashboards

Build a reporting dashboard using Excel 365 dynamic array formulas (FILTER, SORT...

#excel #index match #formula

INDEX/MATCH Formula Generator with Dynamic Multi-Criteria Lookup

You are an Excel formula expert. Help me write an INDEX/MATCH formula that retur...

#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 #formula #duplicates

Excel Formula to Detect Duplicate Customer Records Across Multiple Columns

Act as an Excel expert. I need a formula that flags duplicate customer rows wher...

Excel Macro to Automate Monthly Report

Write a VBA macro for Excel that automates my monthly reporting process. The mac...

#excel #vba #macro

#kpi #scorecard #dashboard

Excel Dashboard KPI Scorecard with Traffic Lights

Design an Excel KPI scorecard dashboard for [department] with: 1) KPI table with...

excel advanced

Excel VBA Macro: Automate Repetitive Report Generation

Act as an Excel VBA expert. I need to automate a repetitive report generation ta...

#excel #vba #macro

#excel #data-validation #dropdown

Excel Data Validation Dropdown Lists for Error-Free Data Entry

Create a comprehensive guide for implementing Excel data validation with dropdow...

#audit-trail #change-tracking #version-history

Excel Audit Trail & Change Tracking for Collaborative Workbooks

I need to set up audit trails and change tracking in Excel for a shared workbook...

#privacy policy #GDPR #CCPA

legal Advanced

Privacy Policy Template for Websites and Mobile Apps

Draft a privacy policy template for [type of website/app, e.g., a B2B SaaS platf...

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

#xlookup #formulas #excel

Excel XLOOKUP Formula Builder for Multi-Criteria Match

Act as an Excel power user. I need an XLOOKUP-based formula that returns [RETURN...

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

#excel #data-validation #dropdown

ChatGPT Prompt: Excel Data Validation Drop-Down with Dependent Lists

You are an Excel expert. Build me a cascading drop-down where the second list de...

customer-service Intermediate

Customer Apology Email After Service Outage with Credit Offer

You are a customer success leader. Draft a post-outage apology email to affected...

#customer service #apology #outage

Excel XLOOKUP Advanced Techniques Guide

You are an Excel expert. I need to use XLOOKUP for complex data retrieval tasks....

#excel #xlookup #lookup

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 #conditional-formatting #accounts-receivable

excel Beginner

Excel Conditional Formatting Rule to Highlight Aging Invoices

Help me build a conditional formatting rule for an invoices sheet so each row hi...

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