Only 150 people in the world prefer static to dynamic chart titles.

This Excel Q&A by Philip Gamey will show you how to create dynamic chart titles for your pivot charts.

When the DAYS360() can’t solve it, use this…

Today, we take a look at something we’ve been asked several times….does the DAYS360() count the days after 24 Hours. Philip teaches in this video how to fix the problem when you really mean >=24hrs is 1 day.

Want to get text into meaning full components?

In today’s Excel Q&A, Philip Gamey shows how to use RIGHT, LEFT and MID functions to get an account code into meaningful components.