Leaderboard Ad728 × 90AdSense placeholder — will activate after approval

Search: "Excel formulas"

303 prompts matching "Excel formulas"

"Excel formulas" ✕ Clear all ✕
excel Intermediate

Excel Data Validation Rules for Error-Free Spreadsheets

Create comprehensive Excel data validation rules for a spreadsheet used for [des...

#data validation #error prevention #spreadsheet
👁 18 views
excel Intermediate

Excel Formula to Detect Duplicate Customer Records Across Multiple Columns

Act as an Excel expert. I need a formula that flags duplicate customer rows wher...

#excel #formula #duplicates
👁 18 views
excel Intermediate

Reconcile Two Spreadsheets and Highlight Mismatched Rows

Act as a finance analyst. I need to reconcile two Excel sheets, {{Sheet A: e.g.,...

#excel #reconciliation #vlookup
👁 18 views
finance Advanced

Build a Three-Statement Model Skeleton From Scratch

Act as an FP&A senior. Sketch the structure of a three-statement model (Income S...

#finance #modeling #three-statement
👁 18 views
excel Intermediate

Sales Analysis Pivot Table

Guide me step by step to create a pivot table in Excel for sales analysis. My da...

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

Employee Performance Dashboard Pivot

Create a pivot table setup for employee performance analysis. Data columns: Empl...

#excel #pivot table #dashboard
👁 17 views
excel Advanced

ChatGPT prompt for Excel cash flow forecast from messy exports

You are an Excel analyst helping me build a 13-week cash flow forecast from mess...

#excel cash flow forecast #13 week cash flow #excel formulas
👁 17 views
finance advanced

Startup Fundraising Financial Model for Seed Round

Build a financial model for a seed-stage fundraise for [startup type]. Cover: 1)...

#financial-model #seed-round #fundraising
👁 17 views
excel Advanced

Executive KPI Dashboard Template Build in Excel

Design a one-page executive KPI dashboard in Excel for a [INDUSTRY] company. The...

#excel #dashboard #kpi
👁 17 views
In-feed Ad336 × 280AdSense placeholder — will activate after approval
excel Beginner

VLOOKUP for Matching Data Between Sheets

Explain how to use VLOOKUP in Excel to match data between two sheets. Scenario: ...

#excel #VLOOKUP #formula
👁 16 views
excel Beginner

Dynamic Date Formulas

Give me the most useful Excel date formulas for business: 1) Calculate age from ...

#excel #date #DATEDIF
👁 16 views
excel Intermediate

Text Manipulation Formulas

Show me essential Excel text formulas with examples: 1) Extract first name from ...

#excel #text #LEFT
👁 16 views
excel Advanced

Professional Dashboard with Charts

Create instructions for building a professional Excel dashboard with these chart...

#excel #dashboard #charts
👁 16 views
data Intermediate

Analyze Sales Data and Find Insights

Act as a data analyst. I have sales data with columns: Date, Product, Category, ...

#data #sales analysis #insights
👁 16 views
excel Intermediate

Conditional Formatting Rules for KPI Dashboards

I need to set up conditional formatting in Excel for a KPI dashboard. My spreads...

#conditional formatting #KPI #dashboard
👁 16 views
data Intermediate

ChatGPT prompt for cleaning CRM export before sales analysis

Act as a sales operations analyst. I have a messy CRM export that I want to clea...

#clean CRM export #sales data cleanup #pipeline analysis
👁 16 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
👁 16 views
Excel Intermediate

Project Timeline Gantt Chart

Design an Excel-based Gantt chart template for project tracking. Include: task l...

#Excel #Gantt #project management
👁 16 views
excel Advanced

ChatGPT prompt for creating an Excel employee attendance and leave tracker

Act as an Excel automation specialist with HR operations experience. Build an e...

#excel #attendance #leave tracker
👁 16 views
finance advanced

Financial Model for Startup Revenue Projections

Build a 3-year financial model for a [business type — SaaS / e-commerce / market...

#finance #financial-model #startup
👁 16 views
excel intermediate

Excel Conditional Formatting Advanced Rules Dashboard

Help me set up advanced conditional formatting rules in Excel for a [sales / HR ...

#conditional formatting #dashboard #icon sets
👁 16 views
excel beginner

Excel Data Validation: Drop-down Lists and Input Controls

Act as an Excel data integrity specialist. I need to set up data validation with...

#excel #data-validation #dropdown
👁 16 views
excel intermediate

Excel VBA Macro Generator for Repetitive Tasks

I need to automate a repetitive task in Excel. Here is what I do manually every ...

#excel #vba #macro
👁 16 views
excel intermediate

Excel Dashboard Builder from Raw Data

I have raw data in Excel and want to create a professional dashboard. My data in...

#excel #dashboard #visualization
👁 16 views
End-of-content Ad728 × 90AdSense placeholder — will activate after approval