How-To
How to Separate First and Last Names in Excel
If you use Excel a lot, you have probably run across a situation where you have a name in a...
Microsoft Excel
How-To
How to Delete Blank Rows in Excel
If your Excel document has thousands of rows, manually deleting blank lines can be stressful and virtually impossible. You can...
How-To
How to Hide Sheets, Cells, Columns, and Formulas in Excel
If you use Excel on a daily basis, then you’ve probably run into situations where you needed to hide something...
How-To
How to Track Changes in Excel
Are you looking for a way to track changes made to an Excel spreadsheet? There are many cases where you...
How-To
How to Format Cells using Conditional Formatting in Excel
If you are used to using older versions of Excel, the conditional formatting options in Excel 2007, 2010, and 2013 will...
How-To
How to Make a Simple Graph or Chart in Excel
Excel is a powerful tool that you can use to create charts and graphs for small or large amounts of...
How-To
How to Trace Dependents in Excel (2026 Guide)
Learn how to trace dependents in Excel using the Formulas tab, keyboard shortcuts, and cross-sheet arrows. Covers greyed-out buttons and...
How-To
How to Write an IF Formula/Statement in Excel
Excel is such a powerful spreadsheet program that I doubt anyone can possibly know everything that it can do. There...
How-To
How to Use Excel’s Goal Seek (What-If Analysis) Tool in 2026
Excel's Goal Seek lets you reverse-engineer any formula result in seconds. Here's how to use it in modern Excel, plus...
How-To
How to Group and Collapse Rows and Columns in Excel
Learn to group and collapse rows and columns in Excel, use shortcuts, create nested groups, and fix missing +/– outline...
How-To
How to Preserve Cell References When Copying a Formula in Excel (2026)
Excel keeps changing your cell references when you copy formulas? Here's how to lock them with absolute references, F4, and...
How-To
How to Center a Worksheet on a Page When Printing in Excel
Excel prints in the upper-left corner by default. Here's how to center your worksheet horizontally, vertically, or both before you...
How-To
How to Add Date and Time Stamps in Excel (Static and Dynamic)
Need to stamp today's date or time in Excel? Here's how to insert static and dynamic date/time stamps in Excel...
How-To
2 Ways to Transpose Data in Excel (2026 Update)
Need to flip rows and columns in Excel? Here are 2 ways to transpose data in 2026 — including the...
How-To
How to Use Excel’s What-If Analysis Tools (2026)
Excel's What-If Analysis tools let you test scenarios without touching your data. Here's how to use Scenario Manager, Goal Seek,...
How-To
How to Connect Excel to MySQL in 2026 (Power Query + ODBC)
Connect Excel to MySQL in 2026 using Power Query and MySQL ODBC 9.0. Step-by-step guide for local and Azure MySQL...
How-To
How to Export SQL Data to Excel with Column Headers
If you’ve ever right-clicked query results in SQL Server Management Studio and chosen Save Results As, you already know the...
How-To
How to Enable Excel’s Speak Cells Feature
Excel's Speak Cells feature reads your spreadsheet aloud — here's how to enable it, use it correctly for data entry...
