When you calculate with large numbers, you might want to only show the values as thousands or millions. Unfortunately, Excel doesn’t offer such option with a single click.
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.
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?
You receive an Excel workbook with a Pivot Table and don’t know what data it is referring to? Or you have added a column or row to your data and want to adapt the Pivot Table?
Formatting an Excel table often takes more time than creating its contents. Borders, background colors, fonts and so on must be set to match your workbook and maybe even company guidelines.
Let’s enhance your Excel skill with some handy keyboard shortcuts: How to insert a new row (or column) within 1 second without using the mouse?
You might want to use numbers of weeks especially when you create timelines, schedules or calendars. The formula is called WEEKNUM().
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.
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.
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.