Written by Debra Dalgleish from Contextures Blog If you create Excel formulas that include table references, and then try to copy those formulas to adjacent columns, you might get incorrect…

Congratulations to you if your job does not involve dead lines. For the rest of us, deadlines are the sole motivation for working (barring free internet & the coffee machine…

Imagine you have a paragraph of text and you want to replace all occurrences of {four, normal, mysterious, nonsense} with {six, casual, confounding, handbags}. How would you do that?You could…

Ever wanted to make an area chart with up down colors, something like this? Then this tip is for you. How to create area chart with up / down colors?…

Back when I was working as a project lead, everyday my project manager would ask me the same question. “Chandoo, whats the progress?” He was so punctual about it, even…

Written by Debra Dalgleish from Contextures Blog When you create a named table in Excel, you can colour the alternating rows with one of the built-in Table Styles. But how…

Written by Debra Dalgleish from Contextures Blog Here's an Excel formula challenge for you, based on an email question that someone sent to me. They wanted help with an Excel…

Do you run an e-commerce website? You are going to love this simple, clear and easy website metrics dashboard. You can track 15 metrics (KPIs) and visualize their performance. The best…

Of all the charting features in Excel, Sparklines are my absolute favorite. These bite-sized graphs can fit in a cell and show powerful insights. Edward Tufte coined the term sparkline…

Slope line is very useful for spotting which values have changed from two sets. You can add a slope line to XY chart (scatter plot) using simple techniques. In this…