Search: "excel 365"

#data validation #dropdown lists #dependent dropdowns

Excel Data Validation and Dropdown Lists

Teach me how to create advanced data validation and dependent dropdown lists in ...

#excel list reconciliation #duplicate matching #near match cleanup

ChatGPT prompt for reconciling two Excel lists with duplicates and near matches

I need to reconcile two Excel lists that should overlap, but the data is messy. ...

#chatgpt prompt for excel planner #capacity planning #workload tracker

excel Advanced

ChatGPT Prompt for Creating an Excel Capacity Planner for a Small Team

You are an Excel operations consultant. Build a practical team capacity planner ...

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

excel Advanced

ChatGPT Prompt for Creating an Excel Subscription Revenue Waterfall

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

#scenario model #financial modeling #excel planning

excel Advanced

ChatGPT Prompt for Excel Scenario Model Comparing Best Base and Worst Cases

Help me build an Excel scenario model that compares best case, base case, and wo...

#Excel #formulas #automation

Excel Intermediate

Excel Formula Generator

Create Excel formulas for: [DESCRIBE TASK]. Include: the formula, explanation of...

Excel Beginner

Budget Tracker Spreadsheet

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

#Excel #budget #finance

#excel #pivot-table #sales

Excel Pivot Table Sales Trend Analysis

I have a sales dataset with columns: [Date, Region, Sales Rep, Product, Units So...

#finance #financial-model #startup

finance advanced

Financial Model for Startup Revenue Projections

Build a 3-year financial model for a [business type — SaaS / e-commerce / market...

#power query #M code #data transformation

excel advanced

Excel Power Query Data Transformation Pipeline

Help me build an Excel Power Query transformation pipeline. My raw data source i...

#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 SUMIF & COUNTIF: Advanced Multi-Criteria Formula Guide

Act as an Excel formula expert. I want to master SUMIF, SUMIFS, COUNTIF, and COU...

#excel #sumif #countif

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

#power query #data cleaning #ETL

Excel Power Query: Clean & Transform Raw Data Automatically

I have raw data in Excel that needs cleaning and transformation. Help me build a...

#pivot table #grouping #calculated fields

Excel Pivot Table: Advanced Grouping and Summarization Techniques

I have a dataset in Excel with the following columns: [list your columns, e.g., ...

#Python #pandas #data cleaning

data intermediate

Python Pandas: Data Cleaning and Transformation Workflow

I have a dataset ([CSV/Excel/database] file) with the following issues: [describ...

#XLOOKUP #VLOOKUP #Excel formulas

Excel VLOOKUP to XLOOKUP Migration: Formula Modernization Guide

I have existing Excel spreadsheets that use VLOOKUP formulas and I want to moder...

#budget tracker #personal finance #Excel template

excel Beginner

Excel Personal Budget Tracker: Monthly and Annual Template

Help me build a comprehensive personal budget tracker in Excel from scratch. I n...

#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 VBA Macro Generator for Repetitive Tasks

I need to automate a repetitive task in Excel. Here is what I do manually every ...

#excel #vba #macro