Search: "Excel analysis"

Excel XLOOKUP Advanced Techniques Guide

You are an Excel expert. I need to use XLOOKUP for complex data retrieval tasks....

#excel #xlookup #lookup

#excel #pivot-table #reporting

Excel Pivot Table Design for Management Reporting

You are an Excel reporting expert. I need to build a professional pivot table re...

#writing #white-paper #technical

writing advanced

White Paper Structure: Executive Summary to Technical Depth

Act as a technical writer and thought leadership content strategist. Help me pla...

#business #swot #strategic-planning

business intermediate

SWOT Analysis Deep Dive: Strategic Planning Workshop Guide

Act as a strategic planning facilitator with experience running executive worksh...

#data #power-bi #dashboard

Power BI Dashboard Design: Sales Performance Metrics

Act as a Power BI specialist and data visualization expert. Help me design a sal...

#hr #employee-engagement #survey

hr intermediate

Employee Engagement Survey: Design, Analysis, and Action Plan

Act as an organizational psychologist and HR strategist specializing in employee...

#pivot table #grouping #calculated fields

Excel Pivot Table: Advanced Grouping and Summarization Techniques

I have a dataset in Excel with the following columns: [list your columns, e.g., ...

#SQL #GROUP BY #window functions

SQL Advanced Queries: GROUP BY, HAVING, and Window Functions

Help me write advanced SQL queries for [database: PostgreSQL/MySQL/BigQuery/SQL ...

#data visualization #chart design #business intelligence

data beginner

Data Visualization Best Practices: Chart Selection and Design Guide

I have the following data and need to visualize it effectively: Data type: [desc...

#dynamic arrays #FILTER #SORT

excel Intermediate

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

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

#cash flow forecast #financial planning #business finance

finance Intermediate

Cash Flow Forecast: 12-Month Projection Template and Guide

Help me build a comprehensive 12-month cash flow forecast for my business. I nee...

#excel #data-validation #dropdown

Excel Data Validation Dropdown Lists for Error-Free Data Entry

Create a comprehensive guide for implementing Excel data validation with dropdow...

#business #swot #competitive-analysis

business intermediate

Competitor SWOT Analysis Deep-Dive Framework Template

Create a structured deep-dive SWOT analysis framework for competitive intelligen...

#data #sql #cohort-analysis

data advanced

Customer Cohort Analysis SQL Query Templates for Retention Insights

Build a complete SQL-based customer cohort analysis system for subscription or e...

#hr #competency-framework #career-development

hr advanced

Competency Framework Design for Job Levels Career Architecture

Build a complete organizational competency framework and career architecture. In...

#finance #budget #variance-analysis

finance intermediate

Business Budget Variance Analysis Template Monthly Reporting

Build a complete budget variance analysis system for business financial manageme...

Data Cleaning Strategy and Python Script Generator

Help me clean and prepare a messy dataset for analysis. Dataset details: Data s...

#data #cleaning #python

#power-bi #dashboard #dax

Power BI Dashboard Design: Best Practices for Business Intelligence

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

#socratic-seminar #classroom-discussion #critical-thinking

education intermediate

Socratic Seminar Facilitation: Discussion Questions & Classroom Guide

Help me facilitate a Socratic seminar for my class. My details: Text/Topic: [AR...

#childrens-book #picture-book #creative-writing

creative beginner

Children's Picture Book Development: Plot, Character & Age-Appropriate Guide

Help me develop and write a children's picture book. My concept: Core idea or t...

#training-needs-analysis #skills-gap #learning-development

hr intermediate

Training Needs Analysis: Skills Gap Assessment Template & Framework

Conduct a Training Needs Analysis (TNA) for my organization or team. Context: O...

customer-service intermediate

Voice of Customer (VoC) Analysis: Survey Design & Insight Framework

Build a Voice of Customer (VoC) program for my business. Context: Business type...

#voice-of-customer #voc #customer-feedback

#profit-loss #pnl #financial-analysis

finance beginner

Profit & Loss Statement Analysis: Interpretation Guide for Business Owners

Help me understand and analyze my Profit & Loss (P&L) statement. Context: Busin...