News

Excel's PIVOTBY function allows you to group your figures without needing to recreate your data in a PivotTable. What's more, ...
Microsoft's Excel software is one of the best tools for you to organize, analyze, and manipulate data. Here are three ways to compare data in two columns.
How to Use Column Headings in Excel. For many small business owners, Microsoft Excel 2010 is not only a powerful tool for internal tracking and bookkeeping, but it can also be used to prepare ...
Hiding and then unhiding columns in Excel only takes a few clicks. In this guide, we'll show you how to hide columns and bring them back in no time at all.
How to Make Columns Wider in Excel. When you add text to a cell in your business spreadsheet, that cell will not widen automatically to accommodate your text unless you change a few settings.
You can easily hide and unhide columns in Excel by individually revealing hidden columns or using the "Format" option to unhide all hidden cells.
Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work.
Looking for a way to make your Excel spreadsheets read more clearly? Why not try freezing some of the rows and columns. Here’s how.
You can add a column in Excel by right-clicking or using the “Insert” option. These features are helpful for adding new data to a spreadsheet.
Freezing a row in Microsoft Excel or Google Sheets can organize your spreadsheet and make sorting through data a breeze. Here's how to do it.
Learn how to easily hide and unhide columns, including the tricky column A, in Excel with this step-by-step guide.
Column functions and Columns functions are Lookup and Reference functions in Microsoft Excel. The Column function returns the column number of a reference, and its formula is Column ( [reference]).