Leaderboard Ad728 × 90AdSense placeholder — will activate after approval

Search: "excel 365"

272 prompts matching "excel 365"

"excel 365" ✕ Clear all ✕
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

Reconcile two Excel sheets that almost match but disagree on a few rows

You are an Excel reconciliation specialist. I have two sheets — Sheet A (System ...

#excel #reconciliation #xlookup
👁 6 views
excel Intermediate

Replace nested IFs with a clean LET formula that future-you can read

You are an Excel formula refactorer. Here is a nested IF formula that works but ...

#excel #let-function #formulas
👁 6 views
excel Advanced

Build a self-checking Excel template that catches user-entered errors before they propagate

I'm building a template that non-technical colleagues will fill in monthly. Past...

#excel #template #validation
👁 6 views
excel Beginner

Design a self-updating Excel tracker with data validation

Help me build an Excel tracker (for tasks, inventory, or expenses — I'll tell yo...

#excel #data validation #conditional formatting
👁 6 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
excel Intermediate

Excel Inventory Reorder-Point Calculator with Safety Stock

I'm building a reorder-point sheet for [number] SKUs in Excel. For each SKU I ha...

#excel #inventory #reorder
👁 5 views
excel Intermediate

Excel Inventory Reorder Point Calculator

Build an Excel template that calculates the reorder point for each SKU using lea...

#excel #inventory #reorder-point
👁 5 views
excel Beginner

Excel: Pick the Right Chart for the Story You're Trying to Tell

I have data and a point I want to make, but I don't know which chart conveys it ...

#excel #charts #visualization
👁 5 views
In-feed Ad336 × 280AdSense placeholder — will activate after approval
excel Advanced

Excel: Build a Three-Statement Model That Stays Internally Consistent

I need a three-statement financial model (income statement, balance sheet, cash ...

#excel #financial-modeling #three-statement
👁 5 views
excel Intermediate

Excel: Convert a Messy Paste-from-PDF Table Into a Clean Dataset

I pasted a table from a PDF and Excel split it badly — values are stuck together...

#excel #power-query #data-cleaning
👁 5 views
excel Advanced

Excel: Write a VBA Macro That Emails a Filtered Report to Each Manager

I have a master sheet with sales data tagged by manager. I want a VBA macro that...

#excel #vba #automation
👁 5 views
excel Advanced

Excel: Replace a Fragile VLOOKUP Chain With Power Query

I have a workbook stitched together by [N] VLOOKUPs across [M] sheets, and it br...

#excel #power-query #vlookup
👁 5 views
excel Beginner

Excel: Pick a Chart That Doesn't Need a Caption to Be Understood

I want to show [DESCRIBE COMPARISON OR TREND] to [AUDIENCE]. Tell me the right c...

#excel #charts #data-visualization
👁 5 views
excel Intermediate

Excel: Turn a Pivot Table Into Something an Executive Will Actually Read

I built this pivot table: [PASTE STRUCTURE OR SCREENSHOT DESCRIPTION]. It's accu...

#excel #pivot-tables #executive-reporting
👁 5 views
excel Intermediate

Clean a Messy Excel Customer List Where Names Are in Six Different Formats

I have an Excel sheet with about 4,000 customer records. The Name column is a di...

#excel #data-cleaning #names
👁 5 views
excel Intermediate

Reconcile two lists that should match but somehow never do

You are an Excel power user. I have two lists in Excel that are *supposed* to be...

#excel #vlookup #reconciliation
👁 5 views
excel Beginner

Turn a flat sales export into a one-screen monthly summary

I have a sales export with columns: order_id, date, region, sales_rep, product_c...

#pivot tables #dashboard #monthly report
👁 5 views
excel Advanced

Replace a fragile nested IF with a clean LET-based formula

Here is a nested IF that has grown to 7 branches and is breaking when someone ad...

#LET function #nested IF #refactor
👁 5 views
excel Advanced

Automate Variance-to-Budget Reporting in Excel with LET and LAMBDA

You are an FP&A automation specialist. I have a monthly actuals sheet and a budg...

#lambda #let #variance
👁 5 views
excel Advanced

Excel Power Query Recipe to Clean and Unify Multi-Sheet Sales Data

You are an Excel Power Query expert. I have a workbook with 12 monthly sales she...

#power-query #m-language #etl
👁 5 views
excel Intermediate

Build a self-updating commission tracker for a sales team in Excel

Act as a RevOps analyst. Help me design an Excel commission tracker that auto-ca...

#commission #sales #formulas
👁 5 views
excel Advanced

Turn a messy CRM CSV export into a clean Excel dashboard

I will paste a CRM export with inconsistent date formats, duplicate accounts und...

#excel #csv #lambda
👁 5 views
excel Advanced

Detect duplicate-but-different customer records in an Excel list

I have a 5,000-row customer table. Many are the same company entered slightly di...

#excel #fuzzy-match #deduplication
👁 5 views
End-of-content Ad728 × 90AdSense placeholder — will activate after approval