Search: "excel audit"

#lambda #custom-functions #excel

excel advanced

Excel LAMBDA Custom Functions for Business Calculations

Create Excel LAMBDA functions for: 1) CAGR given start value, end value, and yea...

productivity intermediate

Delegation Framework for Managers and Executives

You are an executive coach and leadership development specialist. I struggle wit...

#productivity #delegation #management

#sumif #countif #averageif

excel beginner

Excel SUMIF, COUNTIF & AVERAGEIF Conditional Aggregation Mastery

I need to master Excel conditional aggregation formulas. Please provide: 1. A c...

excel Beginner

Project Budget Tracker

Design an Excel project budget tracker with: budget categories (Labor, Materials...

#excel #budget #project

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

#excel #pivot table #dashboard

Employee Performance Dashboard Pivot

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

Auto-Send Email Report VBA

Write an Excel VBA macro that: 1) Takes data from the active sheet, 2) Creates a...

#excel #VBA #macro

Auto-Format New Data VBA

Write a VBA macro that automatically formats any new data pasted into an Excel s...

#excel #VBA #macro

#invoice #VBA #automation

Invoice Generator with Auto-Numbering VBA

Create an Excel invoice generator with automatic invoice numbering using VBA. B...

#conditional formatting #KPI #dashboard

Conditional Formatting Rules for KPI Dashboards

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

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

#data quality #anomaly detection #data monitoring

data Advanced

Automated Data Quality Report with Anomaly Detection

Create a data quality monitoring report for my dataset: - Data source: [e.g., '...

#GDPR #data processing agreement #DPA

legal Advanced

Data Processing Agreement (DPA) for GDPR Compliance

Draft a Data Processing Agreement (DPA) that complies with GDPR requirements: -...

#Eisenhower matrix #priority planning #time management

productivity Beginner

Eisenhower Matrix: Weekly Priority Planning System

Help me implement the Eisenhower Matrix as a weekly priority planning system: M...

#excel inventory tracker #reorder point #stock management

ChatGPT prompt for Excel inventory reorder tracker with lead times

Act as an Excel operations specialist. I need an inventory reorder tracker for a...

#Excel #analysis #reporting

Excel Intermediate

Data Analysis Report Template

Design a data analysis report template in Excel for [DATA TYPE]. Include: execut...

#Excel #Gantt #project management

Excel Intermediate

Project Timeline Gantt Chart

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

#coding #sql #stored-procedure

coding advanced

SQL Stored Procedure for Data Transformation

Write a SQL stored procedure in [MySQL / PostgreSQL / SQL Server] for the follow...

#productivity #time management #time audit

productivity Beginner

Time Audit Template to Identify Productivity Leaks

Create a comprehensive time audit system to help me identify where my time is ac...

#CRO #landing page #conversion rate

marketing advanced

Conversion Rate Optimization Audit Landing Page

Conduct a conversion rate optimization (CRO) audit framework for a landing page....

#excel #dashboard #slicer

excel intermediate

Excel Dashboard with Slicers and Conditional Formatting

Act as an Excel dashboard designer. I want to build an interactive dashboard wit...

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