TechRepublic

How to split a column using an IF() function in Excel

How to split a column using an IF() function in Excel Your email has been sent We all inherit Microsoft Excel sheets that don’t suit our working routine. If it’s a simple tracking sheet of some sort, ...
TechRepublic

How to use the UNIQUE() function to return a count of unique values in Excel

How to use the UNIQUE() function to return a count of unique values in Excel Your email has been sent The TechRepublic article How to create a sorted unique list in an Excel spreadsheet shows you how ...
MUO on MSN

Old Excel functions you should stop using (and what to replace them with)

VLOOKUP has been the go-to function for looking up data in Excel for years, but it comes with limitations. You can only ...
Digital Trends

How to create a drop-down list in Excel on Windows and Mac

Implementing a drop-down list in Excel is a quick and efficient way to choose predefined data. In the process, you’re able to save time compared to manually entering such data into a given spreadsheet ...