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.

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.

PowerPivot: No More Trouble Working with Big Data in Excel

You got a large amount of data which you want to evaluate in a Pivot Table. In such case, Excel crashes often or gets very slow. You might want to consider using PowerPivot, a free Excel Add-In provided by Microsoft. You can download it from the Microsoft webpage. Once successful installed, you’ll see a new ribbon called “PowerPivot”.