CrispExcel Training & Consulting

11/03/2023

How to add automatic row numbers to a list or table

19/02/2023

Subscribe to our YouTube Channel youtube.com/

17/02/2023

How to Add Numbers with Delimiters in Excel

26/01/2023

Yearly Sales Summary With Dynamic Arrays functions in Excel

In this video, we are going to get the yearly sales summary using the following functions, UNIQUE, YEAR, DATE and SUMIFS ...

20/01/2023

In this video I'll show you four main method you can use to combine cells in Microsoft Excel. You'll learn how to use the Ampersand symbol, CONCANT function, CONCATENATE Function and the new TEXTJOIN Function.
.

16/01/2023

UNIQUE RANK IN EXCEL
How to use the Rank function with the CountIF function to return a unique ranking list.
A unique ranking list may be needed when you have duplicate values in the array


https://youtu.be/6sdR2bxuWAk

12/01/2023

How to copy values from status Bar

11/01/2023

Have you ever wanted to include Text in a Number and yet perform Mathematical Operations on the number? 🤔

Here are the 2 Simple steps

Step 1: Watch the Video Below
Step 2:
1. Select cells to format
2. Press Ctrl + 1 to access the cell formatting
3. Scroll down to the custom format

Paste below format

[=1] 0 "Day"; [>1] 0 "Days";;