Search: "Excel formulas"

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

Text Manipulation Formulas

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

#excel #text #LEFT

#excel #pivot table #dashboard

Employee Performance Dashboard Pivot

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

#excel #data cleaning #TRIM

Clean Messy Data Checklist

Give me a complete Excel data cleaning checklist with formulas for each step: 1)...

Auto-Format New Data VBA

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

#excel #VBA #macro

#expense report #auto-categorization #budget tracking

Expense Report Template with Auto-Categorization

Create a comprehensive Excel expense report template with these features: 1. In...

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

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

#Excel #analysis #reporting

Excel Intermediate

Data Analysis Report Template

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

Content Writing Intermediate

Headline A/B Test Generator

Generate 10 headline variations for [ARTICLE/PRODUCT] following different formul...

#headlines #copywriting #testing

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

Excel Dashboard for KPI Tracking

Create an Excel dashboard template for tracking key performance indicators (KPIs...

#excel #kpi #dashboard

#education #study guide #exam prep

education Beginner

Study Guide and Practice Questions for Exam Prep

Create a comprehensive study guide and set of practice questions for [subject/ex...

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

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

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

#invoice #VBA #automation

Invoice Generator with Auto-Numbering VBA

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

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