Rank function #spreadsheetmagic #officehacks #exceltips

Recover Unsaved Work!

Quickly calculate percentage change

Impress your boss with PivotTables

What’s your best email sign off?

Quick way to add the SUM function

WRAPROWS function

Flash Fill Magic! #spreadsheetmagic #officehacks #exceltips

2 Ways to Copy a Tab in #excel #officehacks #spreadsheetmagic

3 Quick Ways to Format Numbers

2 ways to remove duplicates #spreadsheetmagic #officehacks

Quickly resize rows and columns in Excel

How to Switch Rows and Columns in Excel or Google Sheets #excel #spreadsheetmagic #exceltips

Create a Heat Map in 3 Steps #excel #spreadsheetmagic

Quick Numbered Lists

Get multiple lines in one cell with this shortcut

Combine cells with TEXTJOIN

Split Text into Columns and Rows with TEXTSPLIT

TOCOL = The Data Flattener You Didn’t Know You Needed

Make a checklist in Excel

Active Cell Transport in Excel #spreadsheetmagic

Excel Hack: Ctrl + Drag and Shift + Drag

Excel Hacks You Didn't Know Existed: Paste Special Multiply

Excel Hacks You Didn't Know Existed: Filter by Cell Color

How to Create Drop Down List in Excel or Google Sheets

Copy formatting in Excel with Format Painter or Paste Formatting #excel

Convert Roman Numerals in #excel or #googlesheets

Split cells using the function TEXTSPLIT #excel #googlesheets

How to quickly select blanks #12daysofspreadsheets

Two ways to remove duplicates in Excel #12daysofspreadsheets

How to do an XLOOKUP, which is better than VLOOKUP. #12daysofspreadsheets

Insert the current day quickly in Excel or Google Sheets #spreadsheets #12daysofspreadsheets

SUMIFS function in Excel or Google Sheets #12daysofspreadsheets

Get multiple lines in one cell in #excel or #googlesheets #12daysofspreadsheets

How to recover a file if you didn’t save or Excel crashed #12daysofspreadsheets

How to get a list of workdays in Excel or Google Sheets #12daysofspreadsheets

Quickly resize rows and columns #12daysofspreadsheets #workhacks #excellife

Get a numbered list in a few seconds in Excel or Google Sheets #12daysofspreadsheets

Quickly get a sum with this shortcut #12daysofspreadsheets

Flash Fill for the win! #12daysofspreadsheets

Add data visualizations in Excel with Sparklines or Data Bars #excel #excelmagic

Text functions in Excel or Google Sheets to make your data cleaner #excel #googlesheets #workhacks

Gift guide for parents or anyone else who works an office job #officegifts

Create a heat map in 3 steps #excel #googlesheets #workhacks #excelmagic

Thanksgiving + Spreadsheets! Basically a Gantt chart but with a Thanksgiving twist

Win your holiday party this year!

What’s the most unhinged email sign off you’ve seen?

Win your white elephant office party!