18
Jan
Highlighting Values Above or Below Average in Excel
Using conditional formatting in Excel to highlight values above, below, or equal to the average is a great way to quickly visualize tre...
Blog
18
Jan
Splitting and Extracting Text in Microsoft Excel
Microsoft Excel offers several text functions that are useful for extracting, splitting, and manipulating text. These functions, introd...
18
Jan
Combining, Reshaping, and Resizing Arrays in Excel
Excel's new array functions, introduced in August 2022, give users greater flexibility in manipulating data ranges. These functions all...
18
Jan
Using the IFS Function in Microsoft Excel
The IFS function in Excel is an excellent tool for evaluating multiple conditions at once, without the complexity of nested IF statemen...
18
Jan
Excel’s New Feature for Speeding Up Spreadsheets
Microsoft is introducing a Check Performance feature in Excel to help improve spreadsheet performance by identifying and removing unnec...
18
Jan
Finding Circular References in Microsoft Excel
A circular reference in Excel happens when a cell's formula refers to itself either directly or indirectly, creating an endless loop th...
18
Jan
12 Default Excel Settings You Should Change
If you find yourself frequently adjusting the same settings in Excel, you can save time and effort by customizing the default preferenc...
18
Jan
Removing Dotted Lines in Microsoft Excel
Dotted lines in Excel can appear unexpectedly, but they usually have a specific cause, and it’s easy to remove them. Let’s go over why ...
18
Jan
Freezing Multiple Rows in Microsoft Excel
Freezing multiple rows in Excel is a great way to keep headers or other important information visible as you scroll through your spread...
18
Jan
Inserting Data from a Picture in Excel (Windows)
If you have data from a physical source that you'd like to add to Excel, you can simply take a photo of it, save it to your computer, a...