What I Do · Office

Getting more out of Excel and Google Sheets: VLOOKUP and XLOOKUP, pivot tables, conditional formatting, removing duplicates and the QUERY function.

PowerPoint Copilot: Create New Decks From an Existing PPT Design

PowerPoint Copilot: Create New Decks From an Existing PPT Design

Work AutomationPrompting
Box and Whisker Chart in Google Sheets: New Box Plot vs. Excel

Box and Whisker Chart in Google Sheets: New Box Plot vs. Excel

Google SheetsExcel ReportsData Cleanup
Copilot in Excel: How to Use It for Analysis, Formulas, Formatting

Copilot in Excel: How to Use It for Analysis, Formulas, Formatting

ExcelExcel ReportsWork Automation
Gemini File Creation and Editing: Edit Slides, Sheets, PDFs in Chat

Gemini File Creation and Editing: Edit Slides, Sheets, PDFs in Chat

Work Automation
Google Sheets Pivot Table: New Compact Layout and Excel Compatibility

Google Sheets Pivot Table: New Compact Layout and Excel Compatibility

Google SheetsPivot TablesExcel Reports
Excel ISNUMBER Function: Check Numbers and If a Cell Contains Text

Excel ISNUMBER Function: Check Numbers and If a Cell Contains Text

ExcelExcel FunctionsData Cleanup
Fill with Gemini in Google Sheets: Cell Sources vs AI Function

Fill with Gemini in Google Sheets: Cell Sources vs AI Function

Google SheetsWork Automation
Gemini in Google Sheets for BigQuery: Ask in Plain Language

Gemini in Google Sheets for BigQuery: Ask in Plain Language

Google SheetsGA4Work Automation
Excel TRUE and FALSE Functions: How to Use AND, OR, and NOT

Excel TRUE and FALSE Functions: How to Use AND, OR, and NOT

ExcelExcel Functions
Claude in Google Sheets, Docs and Slides: Workspace Beta Guide

Claude in Google Sheets, Docs and Slides: Workspace Beta Guide

ClaudeGoogle SheetsAI Agents
Excel Comments vs Notes: Add, Show, Copy, and Print Them

Excel Comments vs Notes: Add, Show, Copy, and Print Them

ExcelExcel Reports
Excel Numbers Stored as Text: How to Convert Them to Numbers

Excel Numbers Stored as Text: How to Convert Them to Numbers

ExcelData CleanupExcel Functions
Excel Up and Down Arrows: Add ▲▼ and Colors with Custom Formats

Excel Up and Down Arrows: Add ▲▼ and Colors with Custom Formats

ExcelExcel ReportsExcel Functions
Mask Personal Data in Excel: Hide Names and Phone Numbers with *

Mask Personal Data in Excel: Hide Names and Phone Numbers with *

ExcelExcel FunctionsData Cleanup
Find and Highlight Blank Cells in Excel: Go To Special, ISBLANK

Find and Highlight Blank Cells in Excel: Go To Special, ISBLANK

ExcelExcel FunctionsData Cleanup
Excel Conditional Formatting: See Numbers as Colors, Bars, and Icons

Excel Conditional Formatting: See Numbers as Colors, Bars, and Icons

ExcelExcel ReportsData Cleanup
Excel #### Error Fix: Why Cells Show #### and How to Fix It

Excel #### Error Fix: Why Cells Show #### and How to Fix It

ExcelData Cleanup
Excel Not Equal To (<>) Operator: How to Use It in IF and COUNTIF

Excel Not Equal To (<>) Operator: How to Use It in IF and COUNTIF

ExcelExcel Functions
Google Sheets QUERY Function: Use Your Sheet Like a Database

Google Sheets QUERY Function: Use Your Sheet Like a Database

Google SheetsData Cleanup
Excel Remove Duplicates: Find, Highlight, and Remove Safely

Excel Remove Duplicates: Find, Highlight, and Remove Safely

ExcelExcel FunctionsData Cleanup
Excel PivotTable Report: Slicers and PivotCharts at a Glance

Excel PivotTable Report: Slicers and PivotCharts at a Glance

ExcelPivot TablesExcel Reports
VLOOKUP vs XLOOKUP: Which Excel Lookup Function to Use

VLOOKUP vs XLOOKUP: Which Excel Lookup Function to Use

ExcelExcel Functions
Excel PivotTable Guide: What It Is, How to Create and Refresh

Excel PivotTable Guide: What It Is, How to Create and Refresh

ExcelPivot TablesExcel Reports
Google Ads Scripts: Automate Daily Reports to Sheets and Email

Google Ads Scripts: Automate Daily Reports to Sheets and Email

Google Ads ScriptsGoogle AdsGoogle Sheets
Excel CSV Garbled Text Fix: Import Korean Text with UTF-8

Excel CSV Garbled Text Fix: Import Korean Text with UTF-8

ExcelData Cleanup