Search: "excel audit"

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

#design #accessibility #wcag

design Advanced

Accessibility Audit of a Web UI Against WCAG 2.2 AA

Run an accessibility audit on the screenshot or HTML I'll paste against WCAG 2.2...

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

#excel #audit #performance

Audit a Workbook for Broken or Slow Formulas

You are an Excel auditing specialist. Walk me through a systematic audit of a wo...

#expense report #auto-categorization #budget tracking

Expense Report Template with Auto-Categorization

Create a comprehensive Excel expense report template with these features: 1. In...

#CI/CD #GitHub Actions #deployment

coding Advanced

CI/CD Pipeline Configuration with GitHub Actions

Create a complete CI/CD pipeline using GitHub Actions for my project: - Project...

#excel #scheduling #shift planning

excel Beginner

ChatGPT Prompt for Excel Shift Schedule Conflict Checker

Help me build an Excel shift scheduling sheet that automatically flags staffing ...

#excel #vlookup #index-match

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 XLOOKUP Formula for Multi-Criteria Search

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

#excel #xlookup #formula

#pandas #EDA #data analysis

data intermediate

Python Pandas Data Analysis Pipeline Exploratory Analysis

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

productivity intermediate

Async Communication Playbook Remote Team Efficiency

Create an async-first communication playbook for a remote team of [X people] wor...

#async communication #remote work #productivity

#data #quality #assessment

data intermediate

Data Quality Assessment Framework and Cleaning Checklist

Act as a data quality engineer and analytics architect. Help me build a systemat...

#power query #data cleaning #ETL

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

#break-even analysis #financial modeling #startup finance

finance intermediate

Break-Even Analysis: Startup Product Calculation Template

Help me calculate and model the break-even analysis for [product/business type]....

#dynamic arrays #FILTER #SORT

Excel Dynamic Arrays: FILTER, SORT, and UNIQUE Functions Mastery

Help me master Excel dynamic array functions to replace my manual filtering and ...

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

#tax-planning #small-business-tax #deductions

finance intermediate

Year-End Tax Planning Checklist & Deduction Guide for Small Businesses

Help me do year-end tax planning for my small business. Context: Business struc...

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

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

#dynamic arrays #filter #sort

Excel Dynamic Array FILTER SORT UNIQUE Modern Functions Guide

Act as a Microsoft 365 Excel trainer. Teach me the dynamic-array trio FILTER, SO...

#excel #index match #formula

INDEX/MATCH Formula Generator with Dynamic Multi-Criteria Lookup

You are an Excel formula expert. Help me write an INDEX/MATCH formula that retur...

#excel #power query #m code

Power Query M Code Generator for Repeatable Data Transformation

Act as a Power Query (M language) developer. I will describe a messy raw export ...

customer-service Intermediate

Macro Library Audit and Rewrite for a Support Inbox

Audit my support macro library and rewrite the worst offenders. For each macro I...

#customer-service #macros #zendesk