Leaderboard Ad728 × 90AdSense placeholder — will activate after approval

Search: "excel-tables"

219 prompts matching "excel-tables"

"excel-tables" ✕ Clear all ✕
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
👁 9 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
👁 9 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
👁 9 views
excel Intermediate

Excel Loan Amortization Schedule with Extra Payment Scenarios

Create an Excel amortization schedule for a fixed-rate loan with these inputs at...

#excel #loan #amortization
👁 9 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
👁 9 views
finance Advanced

Investment Decision Analysis Using NPV and IRR

Analyze this investment opportunity using NPV and IRR: - Initial investment: [AM...

#npv #irr #investment analysis
👁 9 views
excel Intermediate

Build a Loan Amortization Schedule in Excel

Act as a financial analyst. Create a step-by-step Excel guide to build a loan am...

#excel #amortization #financial modeling
👁 9 views
excel Intermediate

Reconcile Bank Statements with Ledger in Excel

I have two Excel sheets: my bank statement transactions and my internal accounti...

#excel #reconciliation #bank
👁 9 views
excel Beginner

Excel Personal Budget Tracker: Monthly and Annual Template

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

#budget tracker #personal finance #Excel template
👁 8 views
In-feed Ad336 × 280AdSense placeholder — will activate after approval
excel Advanced

Power Query M Code Generator for Repeatable Data Transformation

Act as a Power Query (M language) developer. I will describe a messy raw export ...

#excel #power query #m code
👁 8 views
excel Advanced

Excel Power Query to Consolidate Monthly Sales Files in a Folder

Generate Power Query M code that consolidates all .xlsx files in a folder into a...

#excel #power-query #etl
👁 8 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
👁 8 views
finance Intermediate

Personal Cash Flow Forecast for Next 12 Months

Build a 12-month personal cash flow forecast. Inputs: - Monthly net income: [AMO...

#cash flow #personal finance #budgeting
👁 8 views
excel Intermediate

Build a Dynamic Project Burn-Down Chart in Excel

Act as an Excel expert. I need to build a project burn-down chart that automatic...

#excel #burn-down #project management
👁 8 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
👁 8 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
👁 7 views
excel Advanced

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

#excel #dynamic-arrays #textsplit
👁 7 views
excel Intermediate

Convert Messy Excel Date Formats to Standardized ISO

I have a column of dates in Excel with inconsistent formats: '03/15/2024', '15-M...

#dates #iso #data cleaning
👁 7 views
excel Advanced

Reconcile Two Bank Statements with Fuzzy Matching in Excel

I have two sheets: 'Bank' with columns Date, Description, Amount and 'Books' wit...

#excel #reconciliation #fuzzy match
👁 7 views
excel Intermediate

Excel Power Query Combine Multiple Sheets Into Master Table

You are an Excel Power Query specialist. Walk me step-by-step through combining ...

#power query #excel #data combine
👁 6 views
excel Intermediate

Excel: Build a Rolling 12-Month Revenue Trend Without Hardcoded Dates

I want a chart that always shows the last 12 months of revenue — so when I add M...

#rolling #trend #dynamic-range
👁 6 views
excel Advanced

Schedule an Excel file refresh without setting up a server

I have an Excel workbook that pulls data from a CSV in OneDrive via Power Query....

#excel #automation #power-query
👁 6 views
excel Intermediate

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
👁 5 views
excel Intermediate

Compare Two Excel Sheets and Highlight Real Differences

I need to compare two Excel sheets that should match but probably don't. Sheet A...

#excel #comparison #vlookup
👁 5 views
End-of-content Ad728 × 90AdSense placeholder — will activate after approval