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
If you work with formulas a lot in Excel, you know that the value of a single cell can be...
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
Using Excel’s What-If Analysis Goal Seek Tool
Although Excel’s long list of functions is one of the most enticing features of Microsoft’s spreadsheet application, there a few...
How-To
Group Rows and Columns in an Excel Worksheet
Excel is one of the applications in the Office suite that is equally useful in the workplace and in a...
How-To
Preserve Cell References when Copying a Formula in Excel
When you copy a cell containing a formula, you will notice that the cell references in the formula also move...
How-To
Center Your Worksheet Data in Excel for Printing
If you have created a small worksheet in Excel, you may want to center it on the page when you...
How-To
Quickly Add Date and Time Stamps to an Excel Worksheet
You can easily change the format of any cell in an Excel worksheet to let the application know what type...
How-To
2 Ways to Use Excel’s Transpose Function
If you work extensively with Excel at home, at work, or in a home office, you have the luxury of...
How-To
How to Use Excel’s What-If Analysis
One often overlooked feature of Excel is the What-If Analysis tool that allows you to explore different scenarios without changing...
How-To
Connecting Excel to MySQL
Sure Excel is used for spreadsheets, but did you know you can connect Excel to external data sources? In this...
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...
