Search: "excel-fix"

#excel #invoice tracking #XLOOKUP

Automated Invoice Tracker with XLOOKUP and Running Balance

Act as an Excel specialist. Build me an invoice tracking spreadsheet with these ...

#excel #inventory #tracker

ChatGPT prompt for creating an Excel inventory tracker with automatic reorder alerts

Act as an Excel inventory management specialist. I need to build an inventory t...

#financial-model #seed-round #fundraising

finance advanced

Startup Fundraising Financial Model for Seed Round

Build a financial model for a seed-stage fundraise for [startup type]. Cover: 1)...

#excel #dashboard #visualization

excel intermediate

Excel Dashboard Builder from Raw Data

I have raw data in Excel and want to create a professional dashboard. My data in...

#data validation #error prevention #spreadsheet

Excel Data Validation Rules for Error-Free Spreadsheets

Create comprehensive Excel data validation rules for a spreadsheet used for [des...

Executive KPI Dashboard Template Build in Excel

Design a one-page executive KPI dashboard in Excel for a [INDUSTRY] company. The...

#excel #dashboard #kpi

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

Auto-Format New Data VBA

Write a VBA macro that automatically formats any new data pasted into an Excel s...

#excel #VBA #macro

#conditional formatting #KPI #dashboard

Conditional Formatting Rules for KPI Dashboards

I need to set up conditional formatting in Excel for a KPI dashboard. My spreads...

Excel Macro to Split One Sheet into Multiple Files by Column Value

Write a VBA macro for Excel that takes a master spreadsheet and splits it into s...

#excel #VBA #macro

#budget variance report #excel finance analysis #accounting export cleanup

ChatGPT prompt for monthly budget variance report from exported accounting data

I need help turning exported accounting data into a monthly budget variance repo...

#excel #cohort analysis #retention

ChatGPT Prompt for Excel Cohort Retention Tracker from Raw Transactions

I have raw transaction data in Excel with columns for customer_id, first_purchas...

#Excel #analysis #reporting

Excel Intermediate

Data Analysis Report Template

Design a data analysis report template in Excel for [DATA TYPE]. Include: execut...

#Excel #Gantt #project management

Excel Intermediate

Project Timeline Gantt Chart

Design an Excel-based Gantt chart template for project tracking. Include: task l...

#excel #attendance #leave tracker

ChatGPT prompt for creating an Excel employee attendance and leave tracker

Act as an Excel automation specialist with HR operations experience. Build an e...

#conditional formatting #dashboard #icon sets

excel intermediate

Excel Conditional Formatting Advanced Rules Dashboard

Help me set up advanced conditional formatting rules in Excel for a [sales / HR ...

excel advanced

Excel VBA Macro Automation for Repetitive Reports

Write a VBA macro for Excel that automates the following repetitive reporting ta...

#vba #macro #automation

#financial-model #three-statement #excel

excel advanced

Excel Financial Model Three-Statement Integration

Build a three-statement financial model in Excel for [company type, e.g., a SaaS...

#lambda #custom-functions #excel

excel advanced

Excel LAMBDA Custom Functions for Business Calculations

Create Excel LAMBDA functions for: 1) CAGR given start value, end value, and yea...

#XLOOKUP #VLOOKUP #Excel formulas

Excel VLOOKUP to XLOOKUP Migration: Formula Modernization Guide

I have existing Excel spreadsheets that use VLOOKUP formulas and I want to moder...

#excel #conditional formatting #dashboard

Excel Conditional Formatting Heatmap Project Status Dashboard

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

ChatGPT Prompt: Excel Macro VBA Generator for Repetitive Data Cleanup Tasks

You are a VBA developer. I want a macro that automates a repetitive cleanup task...

#excel #vba #macro

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