Leaderboard Ad728 × 90AdSense placeholder — will activate after approval

Search: "excel-functions"

230 prompts matching "excel-functions"

"excel-functions" ✕ Clear all ✕
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
👁 17 views
excel Advanced

Auto-Format New Data VBA

Write a VBA macro that automatically formats any new data pasted into an Excel s...

#excel #VBA #macro
👁 16 views
excel Advanced

Dynamic Employee Shift Schedule with Drop-downs and Conflict Detection

Act as an Excel expert. Create a weekly employee shift schedule spreadsheet for ...

#excel #shift schedule #data validation
👁 16 views
excel Beginner

ChatGPT prompt for fixing broken Excel lookup formulas across multiple sheets

Act as a senior Excel troubleshooting expert. I have a workbook where lookup fo...

#excel #xlookup #index match
👁 16 views
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 excel planner #capacity planning #workload tracker
👁 16 views
Excel Intermediate

Excel Formula Generator

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

#Excel #formulas #automation
👁 16 views
Excel Beginner

Budget Tracker Spreadsheet

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

#Excel #budget #finance
👁 16 views
data intermediate

Python Pandas Data Analysis Pipeline Exploratory Analysis

Write a Python data analysis script using Pandas for exploratory data analysis (...

#pandas #EDA #data analysis
👁 16 views
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
👁 16 views
In-feed Ad336 × 280AdSense placeholder — will activate after approval
excel intermediate

Excel Dashboard with Slicers and Conditional Formatting

Act as an Excel dashboard designer. I want to build an interactive dashboard wit...

#excel #dashboard #slicer
👁 16 views
excel intermediate

Excel Power Query: Clean & Transform Raw Data Automatically

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

#power query #data cleaning #ETL
👁 16 views
excel intermediate

Excel Pivot Table: Advanced Grouping and Summarization Techniques

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

#pivot table #grouping #calculated fields
👁 16 views
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
👁 16 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
👁 16 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
👁 16 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
👁 15 views
excel advanced

Excel Financial Modeling: Scenario Manager and Goal Seek Analysis

I'm building a financial model in Excel for [project/business type]. Help me set...

#scenario manager #goal seek #sensitivity analysis
👁 15 views
excel intermediate

Excel Conditional Formatting Rules for KPI Dashboard Indicators

Create a complete system of Excel conditional formatting rules to build a profes...

#excel #conditional-formatting #kpi
👁 15 views
finance intermediate

Business Budget Variance Analysis Template Monthly Reporting

Build a complete budget variance analysis system for business financial manageme...

#finance #budget #variance-analysis
👁 15 views
excel Intermediate

Excel Pivot Table Report for Monthly Sales Analysis

Design a step-by-step guide for creating an Excel pivot table report to analyze ...

#pivot table #sales analysis #monthly report
👁 15 views
excel Intermediate

Excel XLOOKUP Formula Builder for Multi-Criteria Match

Act as an Excel power user. I need an XLOOKUP-based formula that returns [RETURN...

#xlookup #formulas #excel
👁 15 views
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
👁 15 views
excel Advanced

Excel VBA Macro to Email Each Manager Their Filtered Sheet

Write a VBA macro that splits the Master sheet by [Manager Name], saves each man...

#excel #vba #outlook
👁 15 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
👁 15 views
End-of-content Ad728 × 90AdSense placeholder — will activate after approval