If your spreadsheet is complex and chock-full of data, it might help to learn how to group, or nest, your rows in...
If you need to calculate a Z-Score from your data, here's how to do that in Excel.
Are you struggling to save your Excel spreadsheet? Here's what to try if you're getting an Excel document not saved error.
Are you getting warnings about Excel running out of memory? Here are some steps to try to fix the Excel out of...
Through the powerful features of Excel, learn how you can extract just the year from a date or series of dates.
To help enter consistent data in your spreadsheets, drop-down lists are invaluable tools. Here's how to add, change, or remove a drop-down...
The blue page break lines are handy in Excel, once you know how to add or remove them. Here's how.
Are you looking to extract text from a cell in Microsoft Excel? This guide walks you through using the LEFT, RIGHT, MID,...
Calculating averages is a good way to learn more about your data in Excel. Learn how to calculate averages using Excel here.
Is Excel not recognizing dates in your spreadsheet? There could be a few reasons why. To fix the problem, follow the steps...
Struggling to add columns in Excel? If Excel can't insert columns, follow this guide to fix the problem.
By default, Excel converts longer numbers into scientific notation to save space. Learn how to disable scientific notation in Excel using this...
Is the order of your Excel columns not working for you? It's easy to switch them around. Learn how to swap columns...
Are you having trouble selecting cells in Excel? Here's what to try if you're having issues with Excel not highlighting cells.