1.16.5

Category: Blog

COUNTIF Not Equal to X or Y

Excel Formula – COUNTIF Not Equal to X or Y

Have you ever been in a condition when you need to …

Read more
How to Remove Grand Total from Pivot Table

How to Remove Grand Total from Pivot Table

With a pivot table in Excel, you can maintain your dashboards …

Read more
Reference isn’t Valid Excel Error

Data Source Reference Is Not Valid Excel Error

Have you ever experienced a Data source reference isn’t valid Excel …

Read more
How to COUNT Cells with Text in Excel

How to COUNT Cells with Text in Excel – Count If Cell Contains Text 

Excel spreadsheet is known to be one of the best data …

Read more
Tricks to Use SUM If Not Blank

Excel SUMIF Not Blank – Tricks to Use SUM If Not Blank

At times, we need to sum a range of cells in …

Read more
SUMIF Not Working

SUMIF Not Working – SUMIFs Value Error

Similar to other features used in Excel, SUMIF provides next-level help …

Read more
You’ve Entered Too Few Arguments for This Function

Resolve “You’ve Entered Too Few Arguments for This Function” Excel Error

Let’s start our topic with the basics of functions that we …

Read more
Power Pivot VS Power Query

Power Pivot VS Power Query – Major Differences to Understand

You know Power Pivot and Power Query (Get & Transform) often …

Read more
How to Add Slicer Filters to Tables in Excel

How to Add Slicer Filters to Tables in Excel

Generally, a slicer is something that lets you divide anything into …

Read more
Excel games

Excel Games – Fun Things to Do With Spreadsheets

Did you ever think of Microsoft Excel as a fun-producing thing?  …

Read more