How to Copy as Picture include Row and Column Headings

Sometimes, if you want to talk about Excel formulas with your colleagues, you must want to give your colleagues complete information by […]
How To Autofill Number Series In Merged Cells

How To Autofill Number Series In Merged Cells

As far as we know auto numbering will not work in merged cells. If you need to number a column that it […]
How To Extract Formulas From Excel At Once

How To Extract Formulas From Excel At Once

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

How To Correct Excel Formula Errors

This post teaches you how to correct Excel formula errors. Correct common errors in formulas Start every function with the equal sign […]
Excel 2013 Quick Start Guide (Cheat Sheet)

Excel 2013 Quick Start Guide (Cheat Sheet)

Microsoft Excel 2013 looks different from previous versions, so we created this guide to help you minimize the learning curve. If you’re new […]
How To Use Fill Justify Function Transfer Rows to a Column In Excel

How To Use Fill Justify Function Transfer Rows to a Column In Excel

In Excel, Fill Justify function is an interesting feature that allows users to reformat text so that it fits into a pre-selected […]
How To Create Tornado Chart (Butterfly Chart)

How To Create Tornado Chart (Butterfly Chart)

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

How To Use Clustered Bar to Create Tornado Chart

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