Search: "excel planning"

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

#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 #dynamic-arrays #textsplit

Excel Dynamic Array Formula to Split Comma-Separated Tags into Columns

I have column A filled with comma-separated tags like 'urgent, vip, refund, bill...

#productivity #time-blocking #planning

productivity Beginner

Plan Your Week Using Time-Blocking and Energy Levels

Act as a productivity coach. Help me plan next week. I have these commitments: {...

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

#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 #pivot tables #data cleaning

Convert Messy Sales Data into a Pivot Table Report

You are an Excel expert. I will paste a messy sales dataset with columns for dat...

Build a Sales Pipeline Velocity Tracker in Excel

Act as an Excel expert. I want a single-sheet pipeline velocity tracker. My deal...

#excel #sales #pipeline

#excel #scenarios #data tables

Create a What-If Scenario Comparison Table With Data Tables

I have a financial model with three driver inputs (cells B2: pricing, B3: churn,...

#marketing #budget #channel-mix

marketing Advanced

Quarterly Marketing Mix Allocation Plan

Given a quarterly marketing budget and historical channel performance (CAC, conv...

#sensitivity #what-if #modeling

Excel: Two-Way Sensitivity Table Without the Data Table Feature

Excel's built-in Data Table feature recalculates the whole workbook and freezes ...

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

#power-query #m-language #etl

Excel Power Query Recipe to Clean and Unify Multi-Sheet Sales Data

You are an Excel Power Query expert. I have a workbook with 12 monthly sales she...

#excel #reconciliation #xlookup

Reconcile two Excel sheets that almost match but disagree on a few rows

You are an Excel reconciliation specialist. I have two sheets — Sheet A (System ...

#excel #sensitivity-analysis #data-table

Build a sensitivity table that stress-tests three assumptions at once

Act as a financial modeling instructor. Walk me through building a two-input dat...

#differentiated instruction #inclusive education #lesson planning

education advanced

Differentiated Instruction Plan Diverse Learning Needs

Create a differentiated instruction plan for teaching [lesson topic] to a class ...

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

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

productivity Intermediate

Build a Personal Operating System for the Next 90 Days

Act as a productivity coach. Help me design a personal operating system for the ...

#productivity #goals #systems

#cash flow #personal finance #budgeting

finance Intermediate

Personal Cash Flow Forecast for Next 12 Months

Build a 12-month personal cash flow forecast. Inputs: - Monthly net income: [AMO...

productivity Intermediate

Run a Weekly Review That Actually Sticks

Design a 30-minute weekly review I can run every Friday. Cover: clearing inboxes...

#productivity #weekly-review #planning

#excel #reconciliation #fuzzy match

Reconcile Two Bank Statements with Fuzzy Matching in Excel

I have two sheets: 'Bank' with columns Date, Description, Amount and 'Books' wit...