Resources

How to take advantage of regular expressions to extract and manipulate text.

Covering all the major methods, so you are equipped to handle different scenarios.

Let's look at 7 reasons why the current checkboxes are bad and 7 reasons why the new ones are good.

Counting characters and words comes in handy for many scenarios, but what is the best method for each?

Excel skills are a must in the modern world, and greater proficiency will enable you and your company reap the rewards.

Generating a PivotTable using a formula is now possible! Does this make them redundant?

Extracting content from a webpage has never been Excel's biggest strength, but this update changes that.

Working with UTC time can cause confusion, but a simple formula solves that problem.

These simple solutions solve the problem of waiting an age for resource-intensive tasks to finish loading.