As far as we know auto numbering will not work in merged cells. If you need to number a column that it […]

Sometimes you may need to convert formula to text string in Excel, such as =A1+B1, how to extract formulas from Excel at […]

This post teaches you how to correct Excel formula errors. Correct common errors in formulas Start every function with the equal sign […]

Microsoft Excel 2013 looks different from previous versions, so we created this guide to help you minimize the learning curve. If you’re new […]

In Excel, Fill Justify function is an interesting feature that allows users to reformat text so that it fits into a pre-selected […]

There's many ways to create Tornado Chart, I'll share with you another example, see the final chart: This chart is really looks […]

Yesterday, I post how to use Conditional Formatting to create Tornado Chart, today, I'll show you how to use Clustered Bar to […]

Tornado Chart is a special type of Bar Chart, also called Tornado Diagram. Tornado Chart is useful for deterministic sensitivity analysis. We […]

If you are a beginner of Excel VBA, you will be confused with Worksheets and Sheets. What is the difference between Worksheets and […]

When you create a chart to analyze the trend of the data, it is useful to add a horizontal Average Line across […]