Leaderboard Ad728 × 90AdSense placeholder — will activate after approval

Search: "Microsoft Excel"

272 prompts matching "Microsoft Excel"

"Microsoft Excel" ✕ Clear all ✕
excel Intermediate

Pivot Table Refactor for Year-over-Year Analysis

Act as a financial analyst. Help me build a pivot table from [DATA RANGE] (colum...

#pivot-table #yoy #analysis
👁 11 views
excel Advanced

ChatGPT Prompt: Excel Power Query M Code for Web Data Scraping

Write Power Query M code to scrape and transform data from [URL OR DESCRIBE WEBP...

#power query #excel #web scraping
👁 11 views
excel Intermediate

ChatGPT Prompt: Excel Dynamic Array Formulas for Reporting Dashboards

Build a reporting dashboard using Excel 365 dynamic array formulas (FILTER, SORT...

#excel formulas #dynamic arrays #dashboard
👁 11 views
excel Intermediate

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 #formulas #commission
👁 11 views
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 #conditional-formatting #accounts-receivable
👁 11 views
excel Beginner

Generate Realistic Test Data With Random Functions

I need to generate {{number, e.g., 500}} rows of realistic test data in Excel fo...

#excel #test-data #random
👁 11 views
excel Intermediate

Excel Formula to Detect Duplicate Records Across Columns

I need an Excel formula to detect duplicate records based on a combination of mu...

#duplicates #data cleaning #excel
👁 11 views
excel Advanced

Excel VBA Macro to Auto-Format Monthly Reports

Write a VBA macro that, when run, formats the active sheet as a monthly report: ...

#excel #vba #macros
👁 11 views
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
👁 11 views
In-feed Ad336 × 280AdSense placeholder — will activate after approval
excel Intermediate

Forecast Monthly Revenue With Excel's FORECAST.ETS

I have 36 months of revenue data (column A: month-end dates, column B: revenue)....

#excel #forecasting #revenue
👁 11 views
excel Intermediate

Build a Reusable Excel Template With Input Validation Built In

Help me design a reusable Excel template for [USE CASE: e.g. expense report, pro...

#template #data-validation #conditional-formatting
👁 11 views
excel Advanced

Excel: Audit a Spreadsheet I Inherited Before I Trust Its Numbers

I just inherited this workbook from someone who left: [DESCRIBE TABS, KEY OUTPUT...

#excel #audit #inherited-work
👁 11 views
excel Advanced

Invoice Generator with Auto-Numbering VBA

Create an Excel invoice generator with automatic invoice numbering using VBA. B...

#invoice #VBA #automation
👁 10 views
data Advanced

Automated Data Quality Report with Anomaly Detection

Create a data quality monitoring report for my dataset: - Data source: [e.g., '...

#data quality #anomaly detection #data monitoring
👁 10 views
excel intermediate

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
👁 10 views
excel advanced

Excel LAMBDA Function Custom Formula Library Creation Guide

Design a library of reusable custom Excel functions using the LAMBDA function fo...

#excel #lambda #custom-functions
👁 10 views
excel Beginner

ChatGPT Prompt: Excel SUMIFS Formula Builder for Multi-Condition Aggregation

You are an Excel formula expert. I need to build a SUMIFS formula that totals va...

#excel #sumifs #formulas
👁 10 views
excel Intermediate

Pivot Table Mastery for Multi-Year Sales Data Analysis

Act as an Excel data analyst. I will paste a sales dataset with columns Date, Re...

#excel #pivot table #sales analysis
👁 10 views
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...

#finance #cash-flow #forecasting
👁 10 views
excel Advanced

Excel Inventory Reorder Alert with Lead Time and Safety Stock

Build an Excel reorder-alert sheet for a small warehouse. Inputs (one row per SK...

#excel #inventory #reorder-point
👁 10 views
finance Advanced

Three-Statement Financial Model for a Bootstrap SaaS Startup

Build a 36-month, monthly three-statement financial model (P&L, cash flow, balan...

#finance #financial-model #saas
👁 10 views
excel Intermediate

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

#excel #dashboard #index-match
👁 10 views
excel Advanced

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
👁 10 views
excel Advanced

Excel Budget Variance Report with Conditional Logic

Build me a complete Excel budget vs actual variance report. I have monthly budge...

#budget #variance #reporting
👁 10 views
End-of-content Ad728 × 90AdSense placeholder — will activate after approval