Search: "Excel analysis"

Excel VBA Macro Automation for Repetitive Reports

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

#vba #macro #automation

excel intermediate

Excel XLOOKUP Advanced Techniques Guide

You are an Excel expert. I need to use XLOOKUP for complex data retrieval tasks....

#excel #xlookup #lookup

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 #scenario-manager #what-if

Excel Scenario Manager and What-If Analysis Business Planning

You are a financial modeling expert using Excel. I need to build a what-if analy...

Excel VBA Macro: Automate Repetitive Report Generation

Act as an Excel VBA expert. I need to automate a repetitive report generation ta...

#excel #vba #macro

#data #power-bi #dashboard

data intermediate

Power BI Dashboard Design: Sales Performance Metrics

Act as a Power BI specialist and data visualization expert. Help me design a sal...

#data visualization #chart design #business intelligence

data beginner

Data Visualization Best Practices: Chart Selection and Design Guide

I have the following data and need to visualize it effectively: Data type: [desc...

#excel #data-validation #dropdown

excel intermediate

Excel Data Validation Dropdown Lists for Error-Free Data Entry

Create a comprehensive guide for implementing Excel data validation with dropdow...

#competitive-intelligence #competitor-analysis #battlecard

business advanced

Competitive Intelligence Deep Dive: Monitoring & Analysis Framework

Build a competitive intelligence system for my business. My context: My busines...

#data cleaning #CSV #pandas

data Intermediate

Data Cleaning Checklist for Messy CSV and Excel Datasets

Create a systematic data cleaning checklist and workflow for a messy dataset in ...

#xlookup #excel formulas #index match

Excel XLOOKUP Multi-Criteria Lookup Replacing INDEX-MATCH

Act as an Excel formula expert. Help me replace nested INDEX-MATCH and VLOOKUP f...

#excel #data-validation #dropdown

ChatGPT Prompt: Excel Data Validation Drop-Down with Dependent Lists

You are an Excel expert. Build me a cascading drop-down where the second list de...

#business #competitive analysis #porter

business Advanced

Competitive Teardown Framework Using Porter's Five Forces

You are a strategy MBA professor. Run a Porter's Five Forces analysis for [INDUS...

writing Intermediate

Long-Form Blog Post Outline With Search Intent and SERP Gap Analysis

Build a detailed outline for a long-form blog post (2,500-3,500 words) targeting...

#writing #seo #blog

#finance #real-estate #rent-vs-buy

finance Advanced

Rent vs. Buy Decision Model With Sensitivity Analysis

Build a rent vs. buy decision model for a specific property. Inputs (I'll provid...

data Advanced

SQL Window Function to Find Customer Churn Cohort by First-Purchase Month

Write a Postgres query to produce a monthly cohort retention table. Source table...

#data #sql #postgres

#excel #power-query #data-cleaning

Convert a Messy Paste from PDF into a Clean Table

I pasted a table from a PDF into Excel and the data is jumbled — some rows are s...

#power query #CSV import #data transformation

excel Advanced

Power Query: Merge and Transform Multiple CSV Files

I have a folder containing monthly CSV files (January.csv, February.csv, etc.) w...

#excel #invoice tracking #XLOOKUP

Automated Invoice Tracker with XLOOKUP and Running Balance

Act as an Excel specialist. Build me an invoice tracking spreadsheet with these ...

#education #rubric #grading

education Beginner

Rubric Generator for Any Assignment Type

Act as an experienced educator. Create a detailed grading rubric for a [assignme...

#hr #skills gap #training plan

hr Advanced

Employee Skills Gap Analysis and Training Plan

Act as an L&D (Learning & Development) specialist. Create a comprehensive skills...

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

#vendor comparison matrix #software selection prompt #buying software evaluation

business Intermediate

ChatGPT prompt for software vendor comparison matrix before purchase

Act as a procurement and operations advisor. I need a software vendor comparison...