📊 Formulas & Functions Excel & Spreadsheets Prompts

Formulas, reports, pivot tables, charts, VBA macros

10 prompts available

All Excel & Spreadsheets 79 Formulas & Functions 10 Reports & Templates 5 VBA & Macros 4 Financial Modeling 3 Formulas 3 Pivot Tables & Analysis 3 Dashboards & Visualization 2 Excel Formulas & Functions 2 inventory management 2 pivot-tables 2 Automation 2 dashboards 2 Power Query 2 Project Management 2 Financial Modeling & Analysis 1 Power Query & Data Transformation 1 Dashboards & Reporting 1 Array Formulas 1 Lookup & Reference 1 What-If Analysis 1 Scenario Planning 1 Data Validation 1 Finance 1 Operations Scheduling 1 budget analysis 1 financial reporting 1 Templates 1 Scheduling & Planning 1 Revenue Analysis 1 Audit 1 Analysis 1 Financial Planning 1 Data Cleaning 1 Financial Tracking 1 Formatting 1 Charts & Visualization 1 Data Management 1 Operations Planning 1 financial forecasting 1 data reconciliation 1 hr tracking 1 Finance Tracking 1 Analytics 1 sales operations 1 formula troubleshooting 1 VBA & Automation 1 Power Query & Automation 1

Showing 10 prompts in Formulas & Functions

Formulas & Functions Beginner

Nested IF Statements for Grading

Write a nested IF formula in Excel that assigns letter grades based on numeric s...

#excel #IF #nested IF

👁 11 views Open →

Formulas & Functions Intermediate

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 Open →

Formulas & Functions Intermediate

SUMIFS with Multiple Criteria

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

#excel #SUMIFS #multiple criteria

👁 10 views Open →

Formulas & Functions Beginner

Dynamic Date Formulas

Give me the most useful Excel date formulas for business: 1) Calculate age from ...

#excel #date #DATEDIF

👁 10 views Open →

Formulas & Functions Intermediate

Text Manipulation Formulas

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

#excel #text #LEFT

👁 9 views Open →

Formulas & Functions Beginner

VLOOKUP for Matching Data Between Sheets

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

#excel #VLOOKUP #formula

👁 7 views Open →

Formulas & Functions advanced

Excel LAMBDA Custom Functions for Business Calculations

Create Excel LAMBDA functions for: 1) CAGR given start value, end value, and yea...

#lambda #custom-functions #excel

👁 5 views Open →

Formulas & Functions intermediate

Excel SUMIF & COUNTIF: Advanced Multi-Criteria Formula Guide

Act as an Excel formula expert. I want to master SUMIF, SUMIFS, COUNTIF, and COU...

#excel #sumif #countif

👁 2 views Open →

Formulas & Functions intermediate

Excel Dynamic Array FILTER SORT UNIQUE Formula Guide

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

#dynamic array #FILTER #SORT

👁 1 views Open →

Formulas & Functions advanced

Excel XLOOKUP Multi-Condition: Advanced Lookup Formulas Guide

I need to look up values in Excel using multiple conditions. My dataset has colu...

#XLOOKUP #INDEX MATCH #multi-criteria lookup

👁 1 views Open →