Search: "Excel automation"

#productivity #inbox-zero #email

productivity beginner

Inbox Zero Email Management System: Daily Reset Protocol

Act as a productivity coach specializing in email management and digital declutt...

#charts #data-visualization #visual-storytelling

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

#cicd #github-actions #automation

coding intermediate

CI/CD Pipeline Setup with GitHub Actions: Automation Workflow Guide

Set up a CI/CD pipeline using GitHub Actions for my project: Project type: [WEB...

#power-bi #dashboard #dax

data intermediate

Power BI Dashboard Design: Best Practices for Business Intelligence

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

#data validation #error prevention #spreadsheet

Excel Data Validation Rules for Error-Free Spreadsheets

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

#pivot table #sales analysis #monthly report

Excel Pivot Table Report for Monthly Sales Analysis

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

excel Advanced

Excel VBA Macro to Automate Repetitive Report Formatting

Write an Excel VBA macro that automates the formatting of a weekly report I rece...

#VBA #macro #automation

#business case #technology investment #ROI

business Advanced

Business Case Template for New Technology Investment

Create a comprehensive business case document for investing in [technology/tool,...

#data cleaning #CSV #pandas

data Intermediate

Data Cleaning Checklist for Messy CSV and Excel Datasets

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

#xlookup #excel formulas #index match

Excel XLOOKUP Multi-Criteria Lookup Replacing INDEX-MATCH

Act as an Excel formula expert. Help me replace nested INDEX-MATCH and VLOOKUP f...

#audit-trail #change-tracking #version-history

excel intermediate

Excel Audit Trail & Change Tracking for Collaborative Workbooks

I need to set up audit trails and change tracking in Excel for a shared workbook...

👁 2 views

#power query #excel #data combine

Excel Power Query Combine Multiple Sheets Into Master Table

You are an Excel Power Query specialist. Walk me step-by-step through combining ...

👁 2 views

#pivot-table #yoy #analysis

Pivot Table Refactor for Year-over-Year Analysis

Act as a financial analyst. Help me build a pivot table from [DATA RANGE] (colum...

👁 2 views

marketing Intermediate

Email Marketing Segmentation Strategy for Higher Open Rates

Design an email list segmentation strategy for [business type] with a list of ap...

#email segmentation #email marketing #open rates

#excel #conditional formatting #dashboard

Excel Conditional Formatting Heatmap Project Status Dashboard

You are an Excel dashboard designer. Build a conditional-formatting heatmap for ...

#net-worth #personal-finance #balance-sheet

finance Beginner

Personal Net Worth Statement Template

Act as a personal finance planner. Build me a structured net worth statement tem...

#xlookup #formulas #excel

Excel XLOOKUP Formula Builder for Multi-Criteria Match

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