8 article(s)
Learn how to use IFS in Excel instead of using IF with multiple conditions and OR. Learn at your own...
Discover shortcuts to create Excel tables and rename them; learn how to define selections and name them. Use structured references...
What's the TRANSPOSE formula in Excel? How to flip rows and columns and keep the formatting when transposing? Learn how...
We explain the SUMIF function in Excel by sharing several examples and showing you how its formula works for different...
The Excel absolute reference shortcut will become one of your favourites to save time! Switch from relative to absolute references...
Check how many cells contain numbers or data in your Excel table with COUNT and COUNTA functions! If you are...
Do you want to know what day was a specific date? Or maybe you want to know what day will...
Learn how to use dynamic values in text in your Excel spreadsheets. Mix text and functions within cells easily and...
