33 article(s)
Learn how to use TRUE and FALSE functions in Excel and how to count how many times they appear in...
Add passwords to Excel workbooks and control who can open and edit your data. Learn how to create a password...
You don't know how to use Flash Fill in Excel? No worries, Ted Jordan is here to teach you how...
What's the TRANSPOSE formula in Excel? How to flip rows and columns and keep the formatting when transposing? Learn how...
Drop-down in Excel: learn how to insert Data Validation, modify drop-down lists and remove them with ease. And discover why...
The AutoSum shortcut or how to save time to calculate sum of columns or rows in Excel. Learn how to...
Learn how to do Custom Sort in MS Excel, discover the shortcuts to create custom lists and to Custom Sort...
SUMIFS between two dates, with multiple criteria or different types of criteria: learn how to use Excel conditional sum like...
We explain the SUMIF function in Excel by sharing several examples and showing you how its formula works for different...
Check how many cells contain numbers or data in your Excel table with COUNT and COUNTA functions! If you are...
