TedJordan.Org - Logo

Analytics Posts 2

Do you want to upgrade your Excel worksheet to the next level? Use dynamic values in Excel text box to give a professional look to your spreadsheet. What is a dynamic value in Excel? A dynamic value corresponds to the result of a calculation made within a specific range. If the content within the specific […]

TRUE and FALSE in Excel (with examples)

TRUE and False in Excel

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 Master with Ted Jordan!

How to use SUMIF in Excel?

Sumif Function in Excel

We explain the SUMIF function in Excel by sharing several examples and showing you how its formula works for different types of criteria.

Excel: Date to Text (dd/mm/yyyy)

Date Formatting in Excel with the Text Function

Convert a date to text in Excel within seconds with our free online Excel tutorial! Discover the handy TEXT function for dates.

How to trim spaces in Excel

Trim Function Excel

Remove extra spaces quickly in your spreadsheets with the TRIM function! Watch our videos to learn from examples.

How to use dynamic values in text (Excel)

Learning how to use dynamic values in text in Excel.

Learn how to use dynamic values in text in your Excel spreadsheets. Mix text and functions within cells easily and present professional tables to your colleagues or customers.

How to use the LEFT, RIGHT and MID functions

Left, Right, and Mid Functions Spreadsheet

Learn how to extract text in Excel with the LEFT, RIGHT and MID functions. Plenty of examples to learn from and functions are explained with simple words. If you start in Excel or if you are an expert, this guide is for you!

Blog

Do you want to upgrade your Excel worksheet to the next level? Use dynamic values in Excel text box to give a professional look to your spreadsheet. What is a dynamic value in Excel? A dynamic value corresponds to the result of a calculation made within a specific range. If the content within the specific […]