These are some advanced Excel tricks that will save you hours and hours of work by automating some tasks or greatly improving your visual representation.
Excel is probably one of the most popular programs in the computer world, especially for people who handle large volumes of data and information. For them, all those Excel tricks that save time and effort are especially useful.
For years this application has been perfected with new functions and features that make the life of its users easier. Let’s say that Excel is getting smarter and better predicts what the user will do next, something that ends up also reaching other similar applications such as Google Sheets or LibreOffice Draw.
Of all those that exist, we have chosen four Excel tricks for all levels.
1. Cascade graphic
Excel allows you to generate several types of graphs, some more visual than others. To make one that shows the progression, be it economic of another type, the cascade graphics are perfect.
Its advantage is that the bar begins to grow just where the one from the previous year ended, unlike traditional bar charts. It is one of those that grows the most in users, and surely some similar ones have already arrived.
To insert the one you just have to select all the data and go to Insert> Insert Cascading Chart or Quotes> Cascade.
2. Conditional formatting
Conditional formatting is an Excel trick to better visualize data, budgets and other information that can be highlighted with colors or formats, say bold, italic or underlined.
For example, you can make cells with numbers less than zero automatically colored red.
It’s easy: go to Start> Conditional Formatting and then select the section of the table you want to condition by format. In the window on the right choice in which cases you want to format and what format it will be.
3. Pivot tables
Imagine that you have made a table but now you want the columns to become rows or vice versa, or you directly want to see the data in another way, with other names for each value.
It is easy to do and they are called pivot tables, although it will take several minutes to control them. Simply select the table to pivot and go to Insert> Pivot Table
A new Excel sheet will be created. On the right, you have to drag values to their place and see if it satisfies the aspect that your table is taking.
4. Make forecast tables
We go with another Excel trick to create tables, this time forecast. It is especially advisable to know how a contractable balance will evolve according to the information you now have.
The first step is to select the data series. When you have already done so, go to Data> Forecast> Forecast Sheet.