Search: "formula"

INDEX MATCH as VLOOKUP Alternative

Show me how to use INDEX MATCH in Excel as a more powerful alternative to VLOOKU...

#excel #INDEX #MATCH

👁 10 views

#excel #SUMIFS #multiple criteria

SUMIFS with Multiple Criteria

Explain SUMIFS in Excel with 3 practical examples: 1) Sum sales where region is ...

👁 10 views

#excel audit #formula debugging #reporting

ChatGPT Prompt for Excel Formula Audit on a Broken Reporting Sheet

Act as an expert Excel analyst. I have a reporting workbook that suddenly shows ...

👁 10 views

Text Manipulation Formulas

Show me essential Excel text formulas with examples: 1) Extract first name from ...

#excel #text #LEFT

👁 9 views

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

👁 8 views

hr Advanced

Employee Skills Gap Analysis and Training Plan

Act as an L&D (Learning & Development) specialist. Create a comprehensive skills...

#hr #skills gap #training plan

👁 8 views

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

#exam review sheet #study guide prompt #chapter summary

👁 8 views

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

#business #freelance #pricing

business Beginner

Freelancer Rate Card and Pricing Calculator

Act as a freelance business coach. Help me create a comprehensive rate card and ...

productivity Intermediate

Notion Database System for Project and Task Management

Act as a Notion power user and productivity systems designer. Create a complete ...

#productivity #Notion #project management

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

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

#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 #Google Sheets #dashboard

data Intermediate

Google Sheets Dashboard with Automated Data Import

Act as a Google Sheets expert. Create a complete marketing dashboard in Google S...

#sales commission tracker #tiered commission excel #clawback formula

excel Advanced

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

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

#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 XLOOKUP Formula for Multi-Criteria Search

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

#excel #xlookup #formula

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