Search: "Microsoft Excel"

Excel XLOOKUP Formula for Multi-Criteria Search

Help me write an Excel XLOOKUP formula that searches across multiple criteria. M...

#excel #xlookup #formula

#excel #dashboard #slicer

Excel Dashboard with Slicers and Conditional Formatting

Act as an Excel dashboard designer. I want to build an interactive dashboard wit...

#data #quality #assessment

data intermediate

Data Quality Assessment Framework and Cleaning Checklist

Act as a data quality engineer and analytics architect. Help me build a systemat...

#finance #budget #variance

finance intermediate

Budget Variance Analysis Report: Monthly Management Template

Act as a finance manager and management reporting expert. Help me build a monthl...

#excel #dashboard #charts

Professional Dashboard with Charts

Create instructions for building a professional Excel dashboard with these chart...

#budget variance report #excel finance analysis #accounting export cleanup

ChatGPT prompt for monthly budget variance report from exported accounting data

I need help turning exported accounting data into a monthly budget variance repo...

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

#chatgpt prompt for MRR waterfall #subscription revenue #excel finance model

ChatGPT Prompt for Creating an Excel Subscription Revenue Waterfall

Act as a finance analyst who specializes in subscription businesses. Help me bui...

#excel #cohort analysis #retention

ChatGPT Prompt for Excel Cohort Retention Tracker from Raw Transactions

I have raw transaction data in Excel with columns for customer_id, first_purchas...

Excel Beginner

Budget Tracker Spreadsheet

Create a budget tracker Excel structure with: income categories, expense categor...

#Excel #budget #finance

#excel #vlookup #index-match

excel beginner

VLOOKUP vs INDEX-MATCH: Smart Data Lookup Formulas

I need to retrieve data from a lookup table in Excel. My main table has [column ...

excel advanced

Excel VBA Macro Automation for Repetitive Reports

Write a VBA macro for Excel that automates the following repetitive reporting ta...

#vba #macro #automation

#financial-model #seed-round #fundraising

finance advanced

Startup Fundraising Financial Model for Seed Round

Build a financial model for a seed-stage fundraise for [startup type]. Cover: 1)...

excel advanced

Excel Power Query Data Transformation Masterclass

You are a Power Query specialist. I have raw data that needs cleaning and transf...

#excel #power-query #etl

#excel #data-validation #dropdown

excel beginner

Excel Data Validation: Drop-down Lists and Input Controls

Act as an Excel data integrity specialist. I need to set up data validation with...

#break-even analysis #financial modeling #startup finance

finance intermediate

Break-Even Analysis: Startup Product Calculation Template

Help me calculate and model the break-even analysis for [product/business type]....

#dynamic arrays #FILTER #SORT

Excel Dynamic Arrays: FILTER, SORT, and UNIQUE Functions Mastery

Help me master Excel dynamic array functions to replace my manual filtering and ...

#Gantt chart #project management #Excel timeline

Excel Gantt Chart: Project Timeline and Milestone Tracker

I want to build a professional Gantt chart in Excel for project management witho...

Excel Macro to Automate Monthly Report

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

#excel #vba #macro

#dynamic array #FILTER #SORT

Excel Dynamic Array FILTER SORT UNIQUE Formula Guide

Teach me how to use Excel dynamic array functions (FILTER, SORT, UNIQUE, SEQUENC...

#budget analysis #variance #financial template

Excel Budget vs Actual Variance Analysis Template

Create a complete Excel budget vs. actual variance analysis template for [depart...

#conditional formatting #dashboard #icon sets

Excel Conditional Formatting Advanced Rules Dashboard

Help me set up advanced conditional formatting rules in Excel for a [sales / HR ...

#Power BI #DAX #dashboard

data advanced

Power BI Dashboard Design Executive Sales Report

Help me design a Power BI executive sales dashboard. Data sources: [CRM data / S...