## The Pain of Losing Data and a quick way to recover it – Stellar Repair for Excel Review

There are three unforgettable pains; these are pains you feel both psychologically and physicallyâ€”toothache, childbirth and losing your Excel data. Data loss looms ominously in the fast-paced world of data management and analytics, where Excel is the backbone for...

## When The TRIM Function Doesn’t Work

Invisible characters are a great threat to accurate results when working with texts. Trim functions work well to remove Char(32) [spaces] but not Char(160) [non-break space] characters. The solution to cleaning non-break spaces is using the SUBSTITUTE function....

## How to SUM Data Per Week Using Pivot Table

If you love low-code solutions then sum data per week using a pivot table is the way to go. The only trick here is to remember, Pivot tables lack the Week grouping. A way around this issue is to group 7 days together. See the below Video for steps to follow: DOWNLOAD...

## XOR logic in Excel

Unlike the OR function which returns TRUE if only 1 condition is TRUE, the XOR function returns TRUE if the number of TRUE conditions is ODD and FALSE if the number of TRUE Conditions is EVEN. Like the OR Function, at least one of the test conditions must evaluate to...

## OR Logic in Excel Formula

When testing for multiple conditions, OR logic is used to determine if ANY condition in the test is TRUE. The only time OR function evaluates to FALSE is if all conditions in a test are false =OR( 2>5, 6>5 ) will evaluate to TRUE though the first logical test...

## How to Use What If Analysis – Goal Seek Feature

This is part 1 of the 4 part series on What if analysis. This blog will cover the Goal Seek feature. What is the Goal Seek feature? Goal seek enables you to see how a change in one value in a model can change the final result. Instead of guessing what impact a value...