Excel
-
Technology
How to convert a date of birth to an age without an expression using Microsoft Excel Power Query
You don’t need an expression at all to calculate someone’s age. Use Power Query to simplify the process. Image: Alexei/Adobe…
Read More » -
Technology
How to extract data from another sheet in Excel
If your Excel spreadsheet contains a lot of data, consider using different sheets to organize it. To extract data from…
Read More » -
Technology
How to apply a formula to an entire column in Excel
Copying and pasting formulas into Excel can be time consuming. If you want to apply a formula to an entire…
Read More » -
Technology
2 Ways to Display Negative Numbers in Red in Microsoft Excel
Learn how to use either of these methods in Microsoft Excel to display negative values in red. Image: Viktor Pazemin/Adobe…
Read More » -
Technology
How to count unique values in Excel
Looking to find the number of unique values in an Excel dataset? You can count unique values in Excel in…
Read More » -
Technology
How to Add Months to a Date in Excel
Do you want to manipulate date values in Excel? A simple way to do this is to add months to…
Read More » -
Technology
How to Break Links in Excel
You can reference other worksheets in Excel, but moving the file will break your data. You can break links in…
Read More » -
Technology
How to Limit Columns in a Filtered Result Set in Microsoft Excel
Microsoft Excel’s advanced filter feature displays records that match specific criteria. You can also limit the columns returned by this…
Read More » -
Technology
30 years ago, this comical Excel advertisement was already boasting of the tools it is today the reference for spreadsheets
Microsoft’s first spreadsheet was released in 1992 under the name Multiplan. —developed by Charles Simonyi, whose we recently wrote here—;…
Read More » -
Technology
How to Insert a Checkbox in Microsoft Excel
A checkbox is a useful way to add yes or no answers to a form or list. If you want…
Read More »
