Professor Excel

Merge Sheets: Copy All Worksheets Underneath Each Other (+Download)

Say you have many worksheets, all in the same structure. You want to combine them into one worksheet. For example copying them underneath each other so that you can conduct lookups or insert PivotTables. In this article, you learn four methods to merge sheets in Excel. […]

Combine Text in Excel

Combine Text in Excel: 4 Best Ways (+Download)

Excel offers three distinct formulas as well as a fourth way to combine multiple text cells into one cell. There are countless examples in which you might need this: Combine given– and family names or preparing primary keys for multi-conditional lookups. For example, in a VLOOKUP or INDEX/MATCH formula combination. In this article you learn 4 methods and in the end, you learn how to deal with a large range of cells.


combine, chart, types, excel

How to Combine Two Chart Types in Excel

Creating charts in Excel is quite easy: Select the data and choose your desired chart type on the ‘Insert’ ribbon. But when it comes to combining two chart types – for example a column chart with a line on top – many users suddenly struggle. But actually, it’s almost as simple as inserting a normal chart. Let’s have a look at how to do it and how to further adjust your chart. […]