Leaderboard Ad728 × 90AdSense placeholder — will activate after approval

Search: "excel-functions"

230 prompts matching "excel-functions"

"excel-functions" ✕ Clear all ✕
excel advanced

Excel VBA Macro Automation for Repetitive Reports

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

#vba #macro #automation
👁 18 views
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...

#data visualization #chart design #business intelligence
👁 18 views
excel intermediate

Excel Data Validation Dropdown Lists for Error-Free Data Entry

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

#excel #data-validation #dropdown
👁 18 views
data Intermediate

Data Cleaning Checklist for Messy CSV and Excel Datasets

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

#data cleaning #CSV #pandas
👁 18 views
excel Intermediate

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

#excel #data-validation #dropdown
👁 18 views
excel Advanced

Build Dynamic Dashboard With Slicers and Pivot Charts

Act as an Excel dashboard designer. I have a dataset of {{describe data: e.g., m...

#excel #dashboard #pivot
👁 18 views
excel Advanced

Power Query: Merge and Transform Multiple CSV Files

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

#power query #CSV import #data transformation
👁 17 views
excel Intermediate

Automated Invoice Tracker with XLOOKUP and Running Balance

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

#excel #invoice tracking #XLOOKUP
👁 17 views
excel Intermediate

ChatGPT prompt for monthly budget variance report from exported accounting data

I need help turning exported accounting data into a monthly budget variance repo...

#budget variance report #excel finance analysis #accounting export cleanup
👁 17 views
In-feed Ad336 × 280AdSense placeholder — will activate after approval
excel Advanced

ChatGPT prompt for Excel sales commission tracker with tiered rates and clawbacks

Act as a sales operations analyst who is great at Excel. I need a commission tra...

#sales commission tracker #tiered commission excel #clawback formula
👁 17 views
excel Advanced

ChatGPT prompt for creating Excel macros to automate repetitive report formatting

Act as an Excel VBA developer who writes clean, maintainable macros. Create VBA...

#excel #vba #macros
👁 17 views
excel Intermediate

Excel XLOOKUP Formula for Multi-Criteria Search

Help me write an Excel XLOOKUP formula that searches across multiple criteria. M...

#excel #xlookup #formula
👁 17 views
excel Beginner

Excel Pivot Table Sales Analysis from Raw Data

Guide me through creating a comprehensive sales analysis using Excel Pivot Table...

#excel #pivot table #sales analysis
👁 17 views
excel intermediate

Excel Budget vs Actual Variance Analysis Template

Create a complete Excel budget vs. actual variance analysis template for [depart...

#budget analysis #variance #financial template
👁 17 views
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
👁 17 views
excel advanced

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 #scenario-manager #what-if
👁 17 views
excel advanced

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
👁 17 views
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 #power-bi #dashboard
👁 17 views
excel Intermediate

Excel Gantt Chart: Project Timeline and Milestone Tracker

I want to build a professional Gantt chart in Excel for project management witho...

#Gantt chart #project management #Excel timeline
👁 17 views
excel advanced

Excel Power Pivot Data Model for Cross-Table Business Analysis

Build a complete Excel Power Pivot data model for multi-table business analysis....

#excel #power-pivot #dax
👁 17 views
excel beginner

Excel Chart Types Selection & Visual Storytelling Guide

Help me choose the right Excel chart type and tell a compelling data story. I ha...

#charts #data-visualization #visual-storytelling
👁 17 views
data intermediate

Power BI Dashboard Design: Best Practices for Business Intelligence

Help me design an effective Power BI dashboard. My situation: Data source: [EXC...

#power-bi #dashboard #dax
👁 17 views
finance Advanced

Cash Flow Forecast Model Build with Scenario Analysis

Act as an FP&A lead. Walk me through building a 13-week cash flow forecast for a...

#finance #cash flow #forecast
👁 17 views
excel Intermediate

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

#excel #power-query #data-cleaning
👁 17 views
End-of-content Ad728 × 90AdSense placeholder — will activate after approval