KeyCuts

Your #1 source for Excel tutorials, tips, and shortcuts.

We love data analysis, productivity hacks, thinking critically, and making you an Excel and Google Sheets star. Learn more about us at http://www.thekeycuts.com. Take my Excel for the Real World class at https://skl.sh/2lsi6up

Find or check if a cell contains text from a list of values in Google Sheets (3 methods) - Tutorial
Find or check if a cell contains text from a list of values in Google Sheets (3 methods) - Tutorial
New 2023 Google Sheets functions to transform, clean, and organize your data - Tutorial
New 2023 Google Sheets functions to transform, clean, and organize your data - Tutorial
How to count the number of colored cells or formatted cells in Google Sheets - Tutorial
How to count the number of colored cells or formatted cells in Google Sheets - Tutorial
How to do a VLOOKUP with multiple conditions or criteria (3 methods) Excel/Google Sheets - Tutorial
How to do a VLOOKUP with multiple conditions or criteria (3 methods) Excel/Google Sheets - Tutorial
How to use Slicers in Excel to filter multiple PivotTables and charts - Tutorial & Walkthrough
How to use Slicers in Excel to filter multiple PivotTables and charts - Tutorial & Walkthrough
Top 3 tips for using the most important Excel feature for data analysis: Pivot Tables
Top 3 tips for using the most important Excel feature for data analysis: Pivot Tables
Cleaning up data and doing exploratory analysis in Excel with Friends episodes data
Cleaning up data and doing exploratory analysis in Excel with Friends episodes data
4 methods to AutoFit column widths in Excel on Mac with only keyboard shortcuts - Tutorial
4 methods to AutoFit column widths in Excel on Mac with only keyboard shortcuts - Tutorial
Create Google Calendar events by sending yourself an email in Gmail on mobile - Productivity Hack
Create Google Calendar events by sending yourself an email in Gmail on mobile - Productivity Hack
Extract first name, multiple middle names, & last name into columns in Google Sheets/Excel
Extract first name, multiple middle names, & last name into columns in Google Sheets/Excel
Count the number of words in a cell in Google Sheets or Excel - Tutorial
Count the number of words in a cell in Google Sheets or Excel - Tutorial
Creating a percentage with a calculated field in Google Sheets or Excel - Tutorial
Creating a percentage with a calculated field in Google Sheets or Excel - Tutorial
How to import data from another Google Sheet and filter the data with the IMPORTRANGE function
How to import data from another Google Sheet and filter the data with the IMPORTRANGE function
Generate unique IDs for your dataset for building summary reports - Excel & Google Sheets
Generate unique IDs for your dataset for building summary reports - Excel & Google Sheets
How to update and add new data to a PivotTable and keep reference updated - Excel & Google Sheets
How to update and add new data to a PivotTable and keep reference updated - Excel & Google Sheets
Use OpenRefine to clean a messy dataset about Bitcoin Tweets - Microsoft Power Query alternative
Use OpenRefine to clean a messy dataset about Bitcoin Tweets - Microsoft Power Query alternative
How to extract text from a middle of a cell in Google Sheets or Excel using MID and FIND functions
How to extract text from a middle of a cell in Google Sheets or Excel using MID and FIND functions
How to structure your data for a PivotTable in Excel or Google Sheets (denormalizing data)
How to structure your data for a PivotTable in Excel or Google Sheets (denormalizing data)
Tutorial to fill values down into empty cells in Google Sheets and Excel (Google Apps Script & VBA)
Tutorial to fill values down into empty cells in Google Sheets and Excel (Google Apps Script & VBA)
How to use VLOOKUP when doing a lookup to the left without INDEX/MATCH in Google Sheets
How to use VLOOKUP when doing a lookup to the left without INDEX/MATCH in Google Sheets
How to prevent incorrect cell references in your formulas using Reinhart & Rogoff Excel error
How to prevent incorrect cell references in your formulas using Reinhart & Rogoff Excel error
How to Generate a Random List of Names Based On Set List of Names in Google Sheets/Excel
How to Generate a Random List of Names Based On Set List of Names in Google Sheets/Excel
Clear Contents
Clear Contents
Fresh Prince Carlton Dances To Taylor Swift's Shake It Off
Fresh Prince Carlton Dances To Taylor Swift's Shake It Off
KeyCuts Promo Video
KeyCuts Promo Video
Using 3-D References in Excel
Using 3-D References in Excel