Search: "excel planning"

#content marketing #content strategy #90-day plan

marketing Advanced

Content Marketing Strategy Template for 90-Day Planning

Create a 90-day content marketing strategy for [company/brand] in the [industry]...

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

#excel #formulas #commission

Build a Dynamic Commission Calculator With Tiered Rates in Excel

I need an Excel commission calculator that supports tiered rates (e.g. 5% on the...

#excel #conditional-formatting #accounts-receivable

excel Beginner

Excel Conditional Formatting Rule to Highlight Aging Invoices

Help me build a conditional formatting rule for an invoices sheet so each row hi...

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

#excel #pivot-table #calculated-field

Excel Pivot Table Calculated Field for Margin Percentage by Segment

I have a sales table with columns: order_id, date, customer_segment, product, re...

#business #swot #strategy

business Intermediate

Build a Lean SWOT Analysis Tied to Concrete Actions

Act as a strategy consultant. Build a SWOT analysis for {{company / product / te...

#excel #dashboard #index-match

Build a Dynamic Dashboard Using INDEX-MATCH and Slicers

Act as an Excel power user. I have a sales dataset with columns: Date, Region, P...

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

#excel #reconciliation #bank

Reconcile Bank Statements with Ledger in Excel

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

excel Advanced

Forecast Sales with Excel FORECAST.ETS

I have monthly sales data in Excel for the last 3 years. Help me build a 12-mont...

#excel #forecast #ets

#excel #burn-down #project management

Build a Dynamic Project Burn-Down Chart in Excel

Act as an Excel expert. I need to build a project burn-down chart that automatic...

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

#finance #tax #self-employed

finance Intermediate

Build a Tax Estimate Worksheet for Self-Employment Income

Help me build a quarterly tax estimate worksheet for self-employment income. Inp...

#excel #goal-seek #solver

excel Advanced

Excel Goal Seek Alternative for Multi-Variable What-Ifs

I have an Excel model where multiple inputs affect one output and Goal Seek only...

#excel #gantt #project-management

Excel Project Gantt Chart from Task List

Generate an Excel Gantt chart from a task list with columns Task, Start Date, Du...

#fp&a #financial-modeling #drivers

finance Advanced

Build a Driver-Based Financial Model from Scratch

Act as a senior FP&A modeler. Walk me through building a driver-based financial ...

#excel #working-capital #finance-model

excel advanced

Build a working capital model from a P&L extract without manual joins

Act as a finance analyst. I will paste a monthly P&L extract plus a trial-balanc...

excel Advanced

Excel Macro to Automate Monthly Report

Write a VBA macro for Excel that automates my monthly reporting process. The mac...

#excel #vba #macro

#finance #budget #personal finance

finance Beginner

Personal Budget Template with Savings Goals

Create a comprehensive personal budget template and guide for someone with the f...

#meeting agenda #meeting facilitation #team meetings

productivity beginner

Meeting Agenda Design: Effective Structured Meeting Template

Help me design meeting agenda templates for these common meeting types at my com...

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

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