Tutorials (Blog)

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

How to Unhide and Rehide Multiple Sheets in Excel

July 31, 2019

Select vs Activate in VBA for Excel

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

Convert Text to Dates In Excel with Find and Replace

Tips, Tips & Shortcuts

How to Convert Text to Dates with Find & Replace

July 2, 2019

Excel Number Formatting Shortcuts Ctrl Shift Number Keys

Keyboard Shortcuts, Tips & Shortcuts

Excel Keyboard Shortcuts for Number Formats

June 12, 2019

Text to Time Values - Solution 4 - UDFs VBA 640 Thumb

Convert Text to Time Values with UDFs in VBA

June 5, 2019

User Defined Functions UDFs in Excel with VBA 640

How to Write User Defined Functions (UDFs) in Excel with VBA

May 29, 2019

5 Tips for Formulas in Excel YouTube Thumb 640-2

Formulas, Tips, Tips & Shortcuts

5 Formula Editing Tips for Excel

May 15, 2019