Leaderboard Ad728 × 90AdSense placeholder — will activate after approval

Search: "excel-tables"

232 prompts matching "excel-tables"

"excel-tables" ✕ Clear all ✕
excel Intermediate

Replace nested IFs with a lookup table you can actually maintain

I have a worksheet with nested IF formulas like: =IF(A1="Bronze",0.05,IF(A1="Sil...

#excel #formulas #xlookup
👁 19 views
excel Advanced

Build a sensitivity table that stress-tests three assumptions at once

Act as a financial modeling instructor. Walk me through building a two-input dat...

#excel #sensitivity-analysis #data-table
👁 19 views
excel Intermediate

Build a Rolling 12-Month Cash Flow Forecast in Excel

You are an Excel financial modeling expert. Help me build a rolling 12-month cas...

#excel #cash flow #forecast
👁 19 views
excel Advanced

Excel Macro to Automate Monthly Report

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

#excel #vba #macro
👁 18 views
data intermediate

Data Cleaning Strategy and Python Script Generator

Help me clean and prepare a messy dataset for analysis. Dataset details: Data s...

#data #cleaning #python
👁 18 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
👁 18 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
👁 18 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
👁 18 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
👁 18 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
👁 18 views
excel Advanced

Excel: Build a Capacity Model That Doesn't Pretend Everyone Works 40 Hours

I'm modeling team capacity in Excel for the next quarter: [TEAM, ROLES, HOLIDAYS...

#excel #capacity-planning #modeling
👁 18 views
excel Intermediate

Build a Running Total in Excel That Resets Every Month Without a Pivot Table

I'm working in Excel with a table that has a Date column and an Amount column. I...

#excel #formulas #running-total
👁 18 views
excel Advanced

Create a Dynamic Dashboard with Slicers and PivotTables

You are an Excel dashboard designer. Guide me through building an interactive sa...

#excel #dashboard #pivottable
👁 18 views
excel Intermediate

Excel Data Validation and Dropdown Lists

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

#data validation #dropdown lists #dependent dropdowns
👁 17 views
excel Intermediate

Expense Report Template with Auto-Categorization

Create a comprehensive Excel expense report template with these features: 1. In...

#expense report #auto-categorization #budget tracking
👁 17 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
👁 17 views
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 #vlookup #index-match
👁 17 views
data advanced

Power BI Dashboard Design Executive Sales Report

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

#Power BI #DAX #dashboard
👁 17 views
excel intermediate

Excel Dashboard KPI Scorecard with Traffic Lights

Design an Excel KPI scorecard dashboard for [department] with: 1) KPI table with...

#kpi #scorecard #dashboard
👁 17 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
👁 17 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
👁 17 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
👁 17 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
👁 17 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
👁 17 views
End-of-content Ad728 × 90AdSense placeholder — will activate after approval