Search: "excel planning"

#business case #technology investment #ROI

business Advanced

Business Case Template for New Technology Investment

Create a comprehensive business case document for investing in [technology/tool,...

#weekly-review #gtd #productivity

productivity Beginner

Weekly Review Template for Knowledge Workers

Act as a productivity coach. Build me a weekly review template I can run in 45 m...

#education #teaching #lesson-plan

education Intermediate

ChatGPT Prompt: Lesson Plan for Teaching a Hard Concept With a Concrete Analogy

You are an experienced teacher trained in cognitive science. Build a 45-minute l...

#okr #goal setting #strategic planning

business Intermediate

ChatGPT Prompt: OKR Framework Setup for Quarterly Goal Setting

Build a quarterly OKR framework for [TEAM/DEPARTMENT/COMPANY]. Inputs: - Annual...

#finance #cash-flow #forecasting

finance Advanced

Build a 13-Week Cash Flow Forecast With Scenario Toggles

Walk me through building a 13-week cash flow forecast for a small business. Outp...

#excel #inventory #reorder-point

Excel Inventory Reorder Alert with Lead Time and Safety Stock

Build an Excel reorder-alert sheet for a small warehouse. Inputs (one row per SK...

#excel #loan #amortization

Excel Loan Amortization Schedule with Extra Payment Scenarios

Create an Excel amortization schedule for a fixed-rate loan with these inputs at...

Forecast Monthly Revenue with Seasonality Using FORECAST.ETS

Act as a financial analyst. I have 36 months of revenue history. Show me how to ...

#excel #forecasting #ets

#dates #iso #data cleaning

Convert Messy Excel Date Formats to Standardized ISO

I have a column of dates in Excel with inconsistent formats: '03/15/2024', '15-M...

#npv #irr #investment analysis

finance Advanced

Investment Decision Analysis Using NPV and IRR

Analyze this investment opportunity using NPV and IRR: - Initial investment: [AM...

#excel #reconciliation #bank

Reconcile Bank Statements with Ledger in Excel

I have two Excel sheets: my bank statement transactions and my internal accounti...

#business #pricing #strategy

business Advanced

Pressure-Test a Pricing Increase Before You Roll It Out

Act as a pricing strategist. I'm planning to raise [PRODUCT] price from [OLD] to...

#education #Feynman #lesson plan

education Intermediate

Design a Lesson That Uses the Feynman Technique

Design a 45-minute lesson on [TOPIC] for [AGE/LEVEL] using the Feynman technique...

#productivity #habits #change

productivity Beginner

Quit a productivity habit that used to work and now doesn't

I have a productivity habit (morning planning ritual, end-of-day review, weekly ...

#chatgpt prompt for excel tracker #invoice aging #accounts receivable

ChatGPT Prompt for Building an Excel Cash Collection Tracker from Invoices

Act as an expert Excel analyst for accounts receivable. Help me build a cash col...

#SMART goals #goal setting #annual planning

productivity Beginner

SMART Goal Setting: Annual Planning and Goal Achievement Framework

Help me create a comprehensive goal-setting and annual planning system using the...

Excel VBA Macro to Automate Repetitive Report Formatting

Write an Excel VBA macro that automates the formatting of a weekly report I rece...

#VBA #macro #automation

#power query #excel #data combine

Excel Power Query Combine Multiple Sheets Into Master Table

You are an Excel Power Query specialist. Walk me step-by-step through combining ...

#net-worth #personal-finance #balance-sheet

finance Beginner

Personal Net Worth Statement Template

Act as a personal finance planner. Build me a structured net worth statement tem...

#excel #pivot-table #calculated-field

ChatGPT Prompt: Excel Pivot Table Calculated Field for Custom Metrics

You are an Excel pivot table expert. Help me add a calculated field to my pivot ...

#pivot tables #excel #data analysis

ChatGPT Prompt: Excel Pivot Table with Calculated Fields and Slicers Setup

Help me build a comprehensive pivot table report for [DATA TYPE]. Data context:...

productivity Intermediate

Personal OKR Template Aligned to Annual Themes

You are a personal coach. Help me set quarterly personal OKRs aligned to my annu...

#productivity #okr #goals

Excel Power Query to Consolidate Monthly Sales Files in a Folder

Generate Power Query M code that consolidates all .xlsx files in a folder into a...

#excel #power-query #etl