Adjust Rows and Columns in Excel: The 4 Easy Ways!

Do you spend a lot of time changing the column width in Excel? On the one hand, you’d like to see as many columns as possible for having a good overview, but on the other hand, you want to see as much content as possible within a column. In the worst case, you’d only see ### instead of values.

Combine Two Chart Types in Excel: How to Create Combo-Charts?

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… Continue reading Combine Two Chart Types in Excel: How to Create Combo-Charts?

How to Save an Excel File Comfortably to PDF

When you save an Excel file to PDF, you usually go to File, Export, Create PDF/XPS and follow the steps. Let’s have a look at how to add a button to the Quick Access Toolbar so that it’s only one click to save PDF, instead of searching through the menus.

How to Use the IF Formula in Excel

The IF formula is very useful in many different cases. It checks if a condition is true and performs defined steps, depending on the result. The IF formula is highly adjustable and can be extended by other formulas easily.

Sort: How to Sort Data in Excel

There are several ways to sort data: Using filters, Pivot Tables or the built in Sort function. The sort function has the advantage that it’s easy to use and can be modified in detail.