Functions are the driving force of any Microsoft Excel spreadsheet, generating a single value or an array of results based on certain arguments you input. However, combining—or nesting—functions ...

Q. Traditional PivotTables have always intimidated me. I see there is a new Excel function called PIVOTBY. What is the difference between it and the traditional PivotTable? With the PIVOTBY function, ...

When you're working on an especially chunky spreadsheet in Microsoft Excel or Google Sheets, it can get annoying to have to scroll up, down, and around to keep track of where all the information is ...