Excel Tutorials (Blog)

Learn how to use Excel more efficiently with our in-depth articles and videos.

Keyboard Shortcuts, Tips, Tips & Shortcuts

7 Uncommon Excel Shortcuts to Share with Your Coworkers

September 17, 2019

Formulas

How to Prevent VLOOKUP Errors when Inserting or Deleting Columns

September 6, 2019

XLOOKUP Explained Pros and Cons YouTube Thumbnail 640

Formulas

The New XLOOKUP Function for Excel + Video Tutorial

September 4, 2019

Excel Convert Text to Dates with Text to Columns YouTube Thumb

Tables & Data, Tips, Tips & Shortcuts

How to Convert Text to Dates with Text to Columns

August 28, 2019

Vlookup Assistant Preview Thumbnail 2 640

Formulas, Macros & VBA

VLOOKUP Assistant – Preview

August 21, 2019

Macros & VBA

How to Unhide and Rehide Multiple Sheets in Excel

July 31, 2019

Select vs Activate in VBA for Excel

Macros & VBA

Difference Between Select and Activate Methods in VBA

July 25, 2019

Hold Ctrl Key Selecting Multiple Cells for Formula References and Commas

Keyboard Shortcuts, Tips & Shortcuts

How to Add Multiple Range References to Formulas in Excel

July 17, 2019

Enter Key Behavior in Excel

Keyboard Shortcuts, Tips, Tips & Shortcuts

How to Change the Behavior of the Enter Key in Excel

July 10, 2019