We do not learn from experience. We learn from reflecting on experience.
John Dewey
Monthly Archives: March 2023
TEXTBETWEEN function in Excel
Excel has new TEXTBEFORE and TEXTAFTER functions. It doesn’t have a TEXTBETWEEN function. Let’s make one.
Creativity is not a talent it is a way of operating.
John Cleese
Extract Text Before a Number in Excel
Excel’s new TEXTBEFORE function simplifies extracting text from the left. In this example I share how to extract all the text before a number in a code.
Budgets are a tool, not a weapon.
Seth Godin
Excel Dashboards #1 Guidelines & Techniques
In this recording of a live webinar I ran in March 2023 you will learn about guidelines and technique for building dashboards in Excel.
Use the button below the video to download the materials.
This is the first session is a series of five webinars on Excel dashboards. The other four sessions are paid sessions.
In this free session we will focus on chart and dashboard guidelines plus some techniques used to create better dashboards. We will also look at creating a bullet chart which is a better alternative to a gauge or dial chart.
The session covers
- general chart guidelines
- questions to ask yourself to develop better charts
- best charts to use
- charts and formats to avoid
- using text boxes on dashboards
- how to create small charts
- chart templates
- lining up and re-sizing charts
- useful number formats for dashboard charts
- using the #N/A error with charts
- how to create a bullet chart
As always I will share a few other tips.
Forcing a Spill with the Magic Plus Sign
I posted recently about a technique to force a function to spill if it didn’t spill automatically. I have since learned of a much easier way.
Excel VBA and the TRUNC Function
Excel has a TRUNC function that truncates numbers. For example =TRUNC(15.75) returns 15. It doesn’t round it just removes the fraction leaving the whole number. Excel VBA does not have the TRUNC function. It does have the Fix function that works the same.