Search: "excel planning"

Inventory Stock Report

Create an Excel inventory management template with columns: Product ID, Product ...

#excel #inventory #stock

👁 12 views

Nested IF Statements for Grading

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

#excel #IF #nested IF

👁 12 views

#excel #attendance #tracker

Employee Attendance Tracker

Build an Excel attendance tracking spreadsheet for a team of 20 employees. Inclu...

INDEX MATCH as VLOOKUP Alternative

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

#excel #INDEX #MATCH

#RFM analysis #customer segmentation #data analysis

data Intermediate

Customer Segmentation Analysis with RFM Model

Help me perform customer segmentation using the RFM (Recency, Frequency, Monetar...

#differentiated lesson plan #teacher prompt #classroom planning

education Beginner

ChatGPT prompt for differentiated lesson plan for mixed ability class

You are an instructional designer helping a teacher plan a lesson for a mixed-ab...

#excel #financial report #monthly report

Monthly Financial Report Template

Act as a financial analyst. Create a detailed monthly financial report template ...

#excel #sales report #weekly

Weekly Sales Report with Charts

Create an Excel weekly sales report template that includes: daily sales by produ...

#excel #SUMIFS #multiple criteria

SUMIFS with Multiple Criteria

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

Dynamic Date Formulas

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

#excel #date #DATEDIF

#excel #pivot table #sales analysis

Sales Analysis Pivot Table

Guide me step by step to create a pivot table in Excel for sales analysis. My da...

#excel #data cleaning #TRIM

Clean Messy Data Checklist

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

#data #sales analysis #insights

data Intermediate

Analyze Sales Data and Find Insights

Act as a data analyst. I have sales data with columns: Date, Product, Category, ...

productivity Intermediate

Goal Setting with OKR

Help me set quarterly goals using the OKR framework. My role: [job title/busines...

#productivity #OKR #goals

#curriculum design #course planning #learning objectives

education Intermediate

Course Curriculum Design with Learning Objectives

Design a complete course curriculum for: - Subject: [e.g., 'Introduction to Dig...

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

#excel #inventory #tracker

ChatGPT prompt for creating an Excel inventory tracker with automatic reorder alerts

Act as an Excel inventory management specialist. I need to build an inventory t...

Text Manipulation Formulas

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

#excel #text #LEFT

#podcast #content planning #interview questions

creative Intermediate

Podcast Episode Outline and Questions

Help me plan a podcast episode. Podcast name: [your podcast name] Niche: [your ...

#expense report #auto-categorization #budget tracking

Expense Report Template with Auto-Categorization

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

#A/B testing #sample size #statistical significance

data Intermediate

A/B Test Sample Size Calculator and Analysis

Help me plan and analyze an A/B test: **Planning Phase:** - Current conversion ...

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

#productivity #weekly review #GTD

productivity Beginner

Weekly Review Checklist and Planning System

Act as a productivity coach certified in GTD (Getting Things Done). Design a com...