Search: "Excel formulas"

#scenario manager #goal seek #sensitivity analysis

Excel Financial Modeling: Scenario Manager and Goal Seek Analysis

I'm building a financial model in Excel for [project/business type]. Help me set...

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

#writing #copywriting #sales-page

writing advanced

Long-Form Sales Page Copywriting Framework High-Converting Template

Write a complete framework for creating a high-converting long-form sales page f...

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

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

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

#excel #index match #formula

excel Advanced

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 #shift schedule #data validation

excel Advanced

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 list reconciliation #duplicate matching #near match cleanup

ChatGPT prompt for reconciling two Excel lists with duplicates and near matches

I need to reconcile two Excel lists that should overlap, but the data is messy. ...

#excel #scheduling #shift planning

excel Beginner

ChatGPT Prompt for Excel Shift Schedule Conflict Checker

Help me build an Excel shift scheduling sheet that automatically flags staffing ...

#scenario model #financial modeling #excel planning

excel Advanced

ChatGPT Prompt for Excel Scenario Model Comparing Best Base and Worst Cases

Help me build an Excel scenario model that compares best case, base case, and wo...

#Excel #formulas #automation

Excel Intermediate

Excel Formula Generator

Create Excel formulas for: [DESCRIBE TASK]. Include: the formula, explanation of...

Excel Beginner

Budget Tracker Spreadsheet

Create a budget tracker Excel structure with: income categories, expense categor...

#Excel #budget #finance

Excel XLOOKUP Formula for Multi-Criteria Search

Help me write an Excel XLOOKUP formula that searches across multiple criteria. M...

#excel #xlookup #formula

#budget analysis #variance #financial template

excel intermediate

Excel Budget vs Actual Variance Analysis Template

Create a complete Excel budget vs. actual variance analysis template for [depart...

#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 VBA Macro Automation for Repetitive Reports

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

#vba #macro #automation

#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 Power Query Data Transformation Masterclass

You are a Power Query specialist. I have raw data that needs cleaning and transf...

#excel #power-query #etl

#excel #array-formulas #sequence

Excel Dynamic Array Functions SEQUENCE SORT FILTER

You are an Excel expert specializing in modern dynamic array functions. I want t...