Search: "Excel formulas"

#excel cash flow forecast #13 week cash flow #excel formulas

ChatGPT prompt for Excel cash flow forecast from messy exports

You are an Excel analyst helping me build a 13-week cash flow forecast from mess...

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

#sales commission tracker #tiered commission excel #clawback formula

ChatGPT prompt for Excel sales commission tracker with tiered rates and clawbacks

Act as a sales operations analyst who is great at Excel. I need a commission tra...

#chatgpt prompt for excel planner #capacity planning #workload tracker

ChatGPT Prompt for Creating an Excel Capacity Planner for a Small Team

You are an Excel operations consultant. Build a practical team capacity planner ...

#Excel #Gantt #project management

Excel Intermediate

Project Timeline Gantt Chart

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

#education #study guide #practice questions

education Beginner

ChatGPT prompt for creating a study guide with practice questions for any exam topic

Act as an expert tutor and exam preparation specialist. Create a comprehensive ...

#excel #pivot-table #sales

excel intermediate

Excel Pivot Table Sales Trend Analysis

I have a sales dataset with columns: [Date, Region, Sales Rep, Product, Units So...

#excel #vlookup #index-match

excel beginner

VLOOKUP vs INDEX-MATCH: Smart Data Lookup Formulas

I need to retrieve data from a lookup table in Excel. My main table has [column ...

#excel #pivot table #sales analysis

excel Beginner

Excel Pivot Table Sales Analysis from Raw Data

Guide me through creating a comprehensive sales analysis using Excel Pivot Table...

#dynamic array #FILTER #SORT

excel intermediate

Excel Dynamic Array FILTER SORT UNIQUE Formula Guide

Teach me how to use Excel dynamic array functions (FILTER, SORT, UNIQUE, SEQUENC...

#excel #scenario-manager #what-if

excel advanced

Excel Scenario Manager and What-If Analysis Business Planning

You are a financial modeling expert using Excel. I need to build a what-if analy...

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

#excel #data-validation #dropdown

excel beginner

Excel Data Validation: Drop-down Lists and Input Controls

Act as an Excel data integrity specialist. I need to set up data validation with...

#Python #pandas #data cleaning

data intermediate

Python Pandas: Data Cleaning and Transformation Workflow

I have a dataset ([CSV/Excel/database] file) with the following issues: [describ...

excel beginner

Excel Formula Troubleshooter and Optimizer

I have an Excel formula that is not working correctly or returning unexpected re...

#excel #formula #debug

data intermediate

Data Cleaning Strategy and Python Script Generator

Help me clean and prepare a messy dataset for analysis. Dataset details: Data s...

#data #cleaning #python

#dynamic arrays #filter #sort

Excel Dynamic Array FILTER SORT UNIQUE Modern Functions Guide

Act as a Microsoft 365 Excel trainer. Teach me the dynamic-array trio FILTER, SO...

#pivot-table #yoy #analysis

Pivot Table Refactor for Year-over-Year Analysis

Act as a financial analyst. Help me build a pivot table from [DATA RANGE] (colum...

#finance #cash flow #forecast

finance Advanced

Cash Flow Forecast Model Build with Scenario Analysis

Act as an FP&A lead. Walk me through building a 13-week cash flow forecast for a...

Auto-Send Email Report VBA

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

#excel #VBA #macro

#excel #shift schedule #data validation

Dynamic Employee Shift Schedule with Drop-downs and Conflict Detection

Act as an Excel expert. Create a weekly employee shift schedule spreadsheet for ...

#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 #cash flow #forecast

ChatGPT Prompt for Excel Monthly Cash Flow Forecast with Collections Delay

I need a monthly cash flow forecast in Excel for a business with uneven customer...