Search: "Excel analysis"

#writing #linkedin #thought-leadership

writing intermediate

LinkedIn Thought Leadership Post Writing Framework and Templates

Create a complete LinkedIn thought leadership content system for executives and ...

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

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

#mortgage refinance #break-even analysis #home loan

finance Intermediate

ChatGPT Prompt: Mortgage Refinance Break-Even Analysis Calculator

Analyze whether I should refinance my mortgage based on these details: Current ...

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

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

writing Advanced

Outline a Long-Form Essay With Argument Mapping

Help me outline a long-form essay (2000-3000 words) on [topic]. Use argument map...

#writing #essay #outline

data Advanced

Run a Power Analysis Before an A/B Test

Help me calculate the required sample size for an A/B test. Walk me through: def...

#data #ab-test #power

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

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

#education #assessment #blooms-taxonomy

education Intermediate

Education: Write Test Questions That Measure Thinking, Not Recall

I need to write assessment questions for a unit. Make them measure understanding...

#anomaly detection #metrics #WAU

data Intermediate

Decide if a weekly metric drop is signal or noise

Our weekly active users dropped 8% week-over-week. Before I escalate, help me de...

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

#finance #forecasting #fpa

finance Advanced

Build a forecast that explains its variance to itself every month

Act as an FP&A lead. Build a monthly revenue forecast for [BUSINESS] that does w...

#education #questions #self-testing

education Intermediate

Turn a dense chapter into questions that test real understanding

I'll paste or describe a chapter or article I'm studying. Generate questions at ...