Date functions and formulas in Excel
7 Excel date formulas explained for beginner to intermediate levels: TODAY, NOW, ISOWEEKNUM, SUMIFS, etc. Get ready to learn with…
Read Full Story →Functions
COUNTIFS with multiple criteria (Excel)
Use COUNTIFS with multiple criteria like a pro and expand your Excel knowledge with Ted Jordan. Learn some tips and tricks to save time and…
Read Full Story →
TRUE and FALSE in Excel (with examples)
Learn how to use TRUE and FALSE functions in Excel and how to count how many times they appear in your spreadsheet. Become a Spreadsheet…
Read Full Story →
CONCAT vs CONCATENATE in Excel
Learn how to combine cells in Excel with Ampersand, CONCAT and CONCATENATE. Choose the way you prefer to impress your employer and customers.
Read Full Story →
TRANSPOSE: how to rotate data in Excel
What's the TRANSPOSE formula in Excel? How to flip rows and columns and keep the formatting when transposing? Learn how now!
Read Full Story →
How to use COUNTIF: greater than
COUNTIF: greater than, less than, not blank; this Excel function is so handy! Learn how to use it in your spreadsheets with Ted Jordan.
Read Full Story →