Search: "split data"

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

#code review #pull request #quality assurance

coding Intermediate

Code Review Checklist for Pull Request Quality Assurance

Create a comprehensive code review checklist for [programming language/framework...

#UX design #design brief #product redesign

design Intermediate

UI/UX Design Brief Template for Product Redesign Projects

Create a comprehensive UI/UX design brief for redesigning [product/feature, e.g....

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

#privacy-policy #gdpr #ccpa

legal Advanced

Privacy Policy Section Drafting Prompt

Act as a data protection lawyer. Draft the privacy policy section for [COMPANY],...

#excel #pivot-table #calculated-field

ChatGPT Prompt: Excel Pivot Table Calculated Field for Custom Metrics

You are an Excel pivot table expert. Help me add a calculated field to my pivot ...

#net worth #personal finance #financial tracking

finance Beginner

ChatGPT Prompt: Personal Net Worth Statement Builder with Trend Analysis

Help me build a personal net worth statement and track changes over time. Here's...

#pivot tables #excel #data analysis

ChatGPT Prompt: Excel Pivot Table with Calculated Fields and Slicers Setup

Help me build a comprehensive pivot table report for [DATA TYPE]. Data context:...

#writing #op-ed #thought leadership

writing Advanced

Op-Ed Article Framework for Thought Leadership Submissions

Act as an op-ed editor for a major publication. Help me draft a 750-word op-ed. ...

Excel Power Query to Consolidate Monthly Sales Files in a Folder

Generate Power Query M code that consolidates all .xlsx files in a folder into a...

#excel #power-query #etl

#excel #dynamic-arrays #textsplit

Excel Dynamic Array Formula to Split Comma-Separated Tags into Columns

I have column A filled with comma-separated tags like 'urgent, vip, refund, bill...

#data #data-quality #monitoring

data Advanced

Data Quality Monitoring Rules for a Production Table

I need to monitor data quality on a production table loaded daily from upstream ...

#data #quality #validation

data Intermediate

Write a Data Quality Checklist for a New Pipeline

Act as a data reliability engineer. I'm shipping a new pipeline that loads {{sou...

#buyer persona #customer research #marketing

marketing Intermediate

Build a Buyer Persona from Customer Interview Data

Synthesize a buyer persona from these [N] customer interview notes: [PASTE NOTE...

#excel #pivot tables #data cleaning

Convert Messy Sales Data into a Pivot Table Report

You are an Excel expert. I will paste a messy sales dataset with columns for dat...

#data #data modeling #star schema

data Advanced

Design a Star Schema for an E-commerce Warehouse

Act as a data architect. Design a star schema for an e-commerce warehouse on [DB...

#data #communication #forecasting

data Intermediate

Explain a Forecasting Model to Non-Technical Stakeholders

I built a [MODEL_TYPE] forecasting model with MAPE [MAPE_VALUE]. Write a 1-page ...

#excel #burn-down #project management

Build a Dynamic Project Burn-Down Chart in Excel

Act as an Excel expert. I need to build a project burn-down chart that automatic...

#data #visualization #charts

data Beginner

Choose the Right Chart Type for the Question You're Asking

I have [DATA DESCRIPTION] and I'm trying to answer [QUESTION] for [AUDIENCE]. Wa...

#excel #goal-seek #solver

Excel Goal Seek Alternative for Multi-Variable What-Ifs

I have an Excel model where multiple inputs affect one output and Goal Seek only...

#sensitivity #what-if #modeling

Excel: Two-Way Sensitivity Table Without the Data Table Feature

Excel's built-in Data Table feature recalculates the whole workbook and freezes ...

#metrics #variance #signal-vs-noise

data Intermediate

Data: Spot When a Metric Movement Is Just Noise

My weekly metric moved 12% — is that signal or noise? Help me decide without doi...

#data #analysis #statistics

data Advanced

Data: Stop a Stakeholder From Acting on a Spurious Correlation

A [ROLE] just sent me [CHART/CLAIM] showing [X correlates with Y] and they're ab...