Excel Tutorials (Blog)

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

Power Query

Excel Clean Up with Power Query: Say Goodbye to Messy Data Forever

January 16, 2024

Tips & Shortcuts

Power Query Replaces XLOOKUP: Excel Data Merging Made Simple

January 9, 2024

Tips & Shortcuts

Excel New Year’s Shortcut: Update Dates

January 3, 2024

Select Entire Columns with Blank Cells in Excel

Tips & Shortcuts

Selecting Entire Columns That Have Blank Cells

December 18, 2023

Tips & Shortcuts

The 2023 Holiday Gift Guide for Data Diehards

December 1, 2023

Excel Power Query

Power Query

Automating Routine Excel Tasks Using Power Query

November 17, 2023

Excel Slicers on Protected Sheets

Tips

Using Slicers on Protected Worksheets

November 7, 2023

Charts & Dashboards, Tips & Shortcuts

When to Use Pie Charts – Best Practices

November 2, 2023

Tips

Emoji Keyboard Shortcut on Windows: Trick Or Treat! 👻💩

October 27, 2023