TedJordan.Org - Logo
Student Portal

Blog Posts

Dive into a realm of media mastery, data analytics and business acumen, coupled with innovative marketing consulting and training.

Learn how programmatic advertising works, master Excel functions and tools, and reinforce your knowledge by reading our blog posts.

These posts are a great addition to our certifying online courses!

Popular Posts

Advertising
Analytics

Advertising News – 09 June 2024

Advertising News 09 June 2024
This week, we'll explore Google's latest algorithm update and it's massive impact on independent websites, the newly passed media Freedom Act in the EU aimed at protecting journalists, and a recent study on brand safety in advertising by IAS.
View Post

Programmatic targeting options: reach the right audience

Programmatic Audience Targeting
Increase your conversion rate with Programmatic audience targeting options. Discover how to reach the right audience in a cost-effective way thanks to Ted Jordan.
View Post

MarTech vs AdTech stacks: what’s the difference?

MarTech vs AdTech stacks - what’s the difference?
MarTech, AdTech, MadTech: what’s the difference between these marketing and advertising terms? What are tech stacks and who uses them? Find out now!
View Post

In-feed ads: Definition and Examples

In-feed ads Definition and Examples
What exactly are in-feed ads? Are they only available on mobile? Are in-feed ads available on Programmatic platforms? Get answers to your questions, with Ted Jordan!
View Post

Contextual Targeting in Programmatic

Contextual Targeting in Programmatic
We define contextual targeting in Programmatic, for you, with simple words. Learn what contextual advertising is and why it is used by so many advertisers.
View Post

Advertising Pixels and Cookies: Types, Definition and Examples

Programmatic: Pixels in Advertising 101
Wondering how to differentiate advertising pixels from cookies? You don’t understand the difference between first-party data and third-party data? Good news! Ted Jordan, our advertising expert, explains all these terms in this article. Best practices, pixel examples, troubleshooting tips, and much more!
View Post

Using Subqueries in SQL – A Guide to Nested Queries

How to use next queries in SQL?
View Post

Scroll to top button in Excel: how to add one?

Navigation Button in Excel
Add a scroll to top button in Excel to impress your customers and use shortcuts to go back to the first cell of your worksheet. Learn Excel tips and trick with Ted Jordan!
View Post

SUMIFS between two dates (Excel)

SumIF Function for Dates in Excek
SUMIFS between two dates, with multiple criteria or different types of criteria: learn how to use Excel conditional sum like a pro! If you don’t know what’s the difference between SUMIF and SUMIFS, this article is for you!
View Post

SQL Dialects – Understanding the Variations Across Platforms

SQL Dialects – Understanding the Variations Across Platforms
View Post

SQL Best Practices – Writing Clean, Secure, and Efficient Queries

SQL Best Practices – Writing Clean, Secure, and Efficient Queries
View Post

Optimizing SQL Queries – Tips for Better Performance

SQL - Query Optimization
View Post
Advertising
Analytics

Categories

AllAdvertisingFormatsPlatformsKPI'sAd News

What is O&O Advertising?

Discover one more important jargon term used in Programmatic Advertising: O&O advertising. Get familiar with O&O formats and advantages.

Read More

Best DSPs for Programmatic Advertising

Ted Jordan shares his 2025 list of the best DSPs for Programmatic, so you don’t have to lose time searching the internet for the right Demand-Side Platform.

Read More

2025 Programmatic Advertising and AdTech conferences (8 events)

8 Programmatic Advertising and AdTech conferences to attend in 2025. Learn, network, discover, attend workshops: get better at Programmatic.

Read More

Programmatic Acronyms: 44 Terms to Know

Learn what these 44 Programmatic Advertising acronyms mean to understand what your colleagues or customers are saying when they use it. Explained with simple words, by Ted Jordan, for Digital...

Read More

Advertising News – 09 June 2024

This week, we'll explore Google's latest algorithm update and it's massive impact on independent websites, the newly passed media Freedom Act in the EU aimed at protecting journalists, and a...

Read More

Brand advertising: Homepage Takeover ads (HPTO)

What are Homepage Takeover ads? Why are these Premium Display ad placements great for branding campaigns? Are they worth it? Discover it now!

Read More

Categories

AllFunctionsToolsShortcut KeysSQL
TRUE and False in Excel

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

Read More
Split Semicolon Separated Value in Excel

How to split semicolon separated values in Excel

Split semicolon separated values in Excel into columns and rows, or convert columns to semicolon separated values, like an Excel Master!

Read More

How to change shapes in Excel column charts

Learn how to easily change the columns shape in your Excel charts so your colleagues and customers will remember your impacting graphs.

Read More
Today and Now Functions in Excel

TODAY and NOW formulas in Excel

Calculate the number of remaining days before a date in Excel easily with TODAY and NOW functions. Learn how to check when a worksheet was last refreshed or set deadlines...

Read More
IF vs IFS Functions in Excel

What is the IFS function? (Excel)

Learn how to use IFS in Excel instead of using IF with multiple conditions and OR. Learn at your own pace!

Read More
Absolute Referencing in Excel

Locking cells: what’s the Excel dollar sign shortcut?

The Excel absolute reference shortcut will become one of your favourites to save time! Switch from relative to absolute references in seconds using this trick.

Read More