Excel's PIVOTBY function allows you to group your figures without needing to recreate your data in a PivotTable. What's more, ...

Another way to split data into multiple columns is to use some of Microsoft Excel's functions. If you choose this route, remember that the split values will be linked to the original values, meaning ...

How to Choose Random Sampling in Excel. Randomly selected samples from a larger population prevent bias in statistical procedures while avoiding the hassle of dealing with the entire dataset. If ...

To create a search field in a spreadsheet, you must first activate the Developer tools menu. To do this, go to Options > ...

With the correct Excel file open on your computer, select "Review" from the drop-down menu at the top of the screen. Choose the range of cells you want to unprotect.

In part 1 of this series on Excel for search engine marketers, I started off by applauding the tool and pointing out how important it is to our industry.

Clean spreadsheets improve data analysis and efficiency. Learn how to remove empty rows in Excel with quick, easy steps for a streamlined workflow.

Excel filters help you find exactly what you want, no matter how big your spreadsheet database is. Here's how to set number, text and data filters.

The CHOOSE function in Microsoft Excel is a Lookup and Reference function, and its purpose is to choose a value from a list of values. Learn how to use it.

Want an easier way to share your spreadsheet or workbook with non-Apple users? We’ll show you how to convert Apple Numbers to Excel on Mac, iPhone, and iPad.