ViewTube

Some Excel functions return a #VALUE! error when you give them a range, even though you expect the result to spill. In this video ...

This 5-minute Excel automation has saved me 100+ hours over the past 5 years. Every month I had to create invoices (sometimes ...

In this video, I'll show you how to create in-cell chart visualizations in Excel using the REPT function and a bit of formatting.

In this video I'll show you five ways to combine columns in Excel. I'll start with simple methods, such as using the & operator or ...

In this video, I'll show you how to calculate the date difference in Power Query. You'll learn how to get the total number of days, ...

In this video, I'll show you four methods to convert numbers to words in Excel. While there is no built-in function in Excel to do this.

In this video, I'll show you three simple ways to clip text in Excel (so that it doesn't overflow) While this is an in-built option in ...

In this video, I'll cover 30 Power Query tricks that you can use in your day-to-day work. Whether you're just getting started with ...

Most people use Power Query with the default settings and never think twice about it. But changing just 7 settings can dramatically ...

In this video, I cover how to get all dates between two given dates in Power Query and get every date in a separate row. This can ...