Search: "Excel formulas"

#excel #cash flow #dashboard

ChatGPT prompt for building a monthly Excel cash flow dashboard from messy exports

I want you to act as an Excel financial analyst. My goal: turn messy bank and e...

#excel #xlookup #index match

excel Beginner

ChatGPT prompt for fixing broken Excel lookup formulas across multiple sheets

Act as a senior Excel troubleshooting expert. I have a workbook where lookup fo...

#cohort retention analysis #subscription churn #sql retention

data Advanced

ChatGPT prompt for cohort retention analysis from subscription data

You are a product data analyst. I need help analyzing subscription retention by ...

#clean CRM export #sales data cleanup #pipeline analysis

data Intermediate

ChatGPT prompt for cleaning CRM export before sales analysis

Act as a sales operations analyst. I have a messy CRM export that I want to clea...

#exam review sheet #study guide prompt #chapter summary

education Beginner

ChatGPT prompt for creating exam review sheet from textbook chapter

Act as a study coach. I will paste a textbook chapter excerpt, lecture notes, or...

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

#sumif #countif #averageif

excel beginner

Excel SUMIF, COUNTIF & AVERAGEIF Conditional Aggregation Mastery

I need to master Excel conditional aggregation formulas. Please provide: 1. A c...

excel Beginner

VLOOKUP for Matching Data Between Sheets

Explain how to use VLOOKUP in Excel to match data between two sheets. Scenario: ...

#excel #VLOOKUP #formula

#excel #pivot table #dashboard

Employee Performance Dashboard Pivot

Create a pivot table setup for employee performance analysis. Data columns: Empl...

Auto-Send Email Report VBA

Write an Excel VBA macro that: 1) Takes data from the active sheet, 2) Creates a...

#excel #VBA #macro

Auto-Format New Data VBA

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

#excel #VBA #macro

#invoice #VBA #automation

Invoice Generator with Auto-Numbering VBA

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

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

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

#excel inventory tracker #reorder point #stock management

ChatGPT prompt for Excel inventory reorder tracker with lead times

Act as an Excel operations specialist. I need an inventory reorder tracker for a...

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

#finance #cash flow #forecast

finance Intermediate

Cash Flow Forecast for Small Business (12-Month)

Create a 12-month cash flow forecast template for a [business type] with the fol...

#excel #dashboard #slicer

excel intermediate

Excel Dashboard with Slicers and Conditional Formatting

Act as an Excel dashboard designer. I want to build an interactive dashboard wit...

#finance #budget #variance

finance intermediate

Budget Variance Analysis Report: Monthly Management Template

Act as a finance manager and management reporting expert. Help me build a monthl...

#dynamic arrays #FILTER #SORT

Excel Dynamic Arrays: FILTER, SORT, and UNIQUE Functions Mastery

Help me master Excel dynamic array functions to replace my manual filtering and ...

#data validation #dropdown lists #dependent dropdowns

Excel Data Validation and Dropdown Lists

Teach me how to create advanced data validation and dependent dropdown lists in ...

👁 7 views