YouTube on MSN

How to SUM & COUNT cells by color in Excel

In this video, you'll learn three methods to SUM and COUNT cells in Excel based on cell color, as Excel does not have a built ...
MUO on MSN

These 5 Excel functions are silently slowing down your spreadsheets — use these instead

They may look harmless, but they're certainly capable of turning your spreadsheets into traffic jams.
JournalofAccountancy

How to use Excel’s UNIQUE Function

Q. Could you explain how the UNIQUE function works in Excel? A. Excel’s UNIQUE is a dynamic array function that can be an essential tool for data analysts and accountants. This function allows users ...
Geeky Gadgets

How to solve Excel COUNT problems with COUNTIFS Function

The COUNTIFS function in Excel is a powerful and versatile tool for counting cells based on multiple criteria. It offers a significant advantage over the COUNTIF function, which is limited to handling ...
JournalofAccountancy

Using Excel’s GROUPBY function as a PivotTable alternative

Q. Are there any alternatives to traditional PivotTables in Excel? A. The first thing that comes to mind is the function GROUPBY. The primary purpose of GROUPBY is to make data analysis easier by ...