Reference Library & Guides
Handy cheat sheets, keyboard shortcuts, dataset documentation, and generative AI prompt libraries for Excel workflows.
AI Excel Installation Guide & Add-in Architecture
Quick technical reference and best practice guide.
AI Excel Prompt Engineering Library
Quick technical reference and best practice guide.
AI Excel Security, Privacy & Enterprise Governance
Quick technical reference and best practice guide.
Professional AI Excel Workflow: The 14-Step Methodology
Quick technical reference and best practice guide.
AI Output Verification Framework
Quick technical reference and best practice guide.
AI Tool Comparison: GPT for MS Excel vs Claude for Excel
Quick technical reference and best practice guide.
AI for Excel: Foundations & Modern Analytics Workflows
Quick technical reference and best practice guide.
Claude for Excel — Anthropic
Quick technical reference and best practice guide.
GPT for MS Excel — Twistly
Quick technical reference and best practice guide.
AI SQL Prompt Library
Quick technical reference and best practice guide.
AI SQL Verification & Hallucination Prevention
Quick technical reference and best practice guide.
AI-Assisted Data Modeling: Best Practices
Quick technical reference and best practice guide.
AI-Assisted Query Debugging & Optimization
Quick technical reference and best practice guide.
AI-Assisted SQL Exploration: Principles & Protocols
Quick technical reference and best practice guide.
Excel Cheat Sheet
Quick technical reference and best practice guide.
Function Reference
Quick technical reference and best practice guide.
Analytics Pipeline & Tool Stack Comparison
Quick technical reference and best practice guide.
Call Center KPI Analytics
Quick technical reference and best practice guide.
DAX Measures and Data Modeling
Quick technical reference and best practice guide.
Data Quality Essentials Guide
Quick technical reference and best practice guide.
Data Quality Framework Mind Map
Quick technical reference and best practice guide.
Dynamic Arrays and Modern Calculation
Quick technical reference and best practice guide.
Enterprise Architecture Mindmap
Quick technical reference and best practice guide.
Excel Interface Blueprint
Quick technical reference and best practice guide.
Excel Navigation and Setup Video Guide
Quick technical reference and best practice guide.
Executive Dashboard Design Principles
Quick technical reference and best practice guide.
Power Query ETL Transformations
Quick technical reference and best practice guide.
XLOOKUP and Modern Lookups
Quick technical reference and best practice guide.
Data Analytics Glossary
Quick technical reference and best practice guide.
Hotel Reservations: Master Dataset Documentation & Practice Ground
Quick technical reference and best practice guide.
Keyboard Shortcuts
Quick technical reference and best practice guide.
Module 4 Dataset Documentation: Tables & Operational Data Models
Quick technical reference and best practice guide.
Module 5 Dataset Documentation: Pivot Tables & Operational Data Models
Quick technical reference and best practice guide.
Module 6 Dataset Documentation: Charts & Executive Visual Analytics
Quick technical reference and best practice guide.
Module 7 Dataset Documentation: Data Cleaning & Enterprise Ingestion
Quick technical reference and best practice guide.
Module 8 Dataset Documentation: Power Query & M Language Laboratory
Quick technical reference and best practice guide.
AdventureWorks2022 OLTP: Enterprise Schema & Ingestion Reference
Quick technical reference and best practice guide.
AdventureWorksDW2022: Dimensional Data Warehouse & Star Schema Reference
Quick technical reference and best practice guide.
Microsoft SQL Server Sample Databases: Official Hierarchy & Source Documentation
Quick technical reference and best practice guide.
Northwind Sample Database: Schema & Ingestion Reference
Quick technical reference and best practice guide.
SQL Server Sample Database Installation & Restoration Reference
Quick technical reference and best practice guide.
SQL Server Learning Environment Architecture
Quick technical reference and best practice guide.
pubs Sample Database: Schema & Ingestion Reference
Quick technical reference and best practice guide.
Sample Superstore: Master Dataset Documentation & Practice Ground
Quick technical reference and best practice guide.