Every program has its secrets and hardships, especially Microsoft Excel! At the very beginning, it's tough making some simple things. Don’t worry. While you’re learning step-by-step how to use this program, you can start improving your skills with these 5 must-know Excel Tips for Beginners:
Are you ready to improve your skills and knowledge? Then, keep reading, and go ahead!
Usually, you can filter your data by using a base table. However, there exists a method by which you can handle, rearrange and summarize information, and it’s called the “Sort &Filter function.”
To access this tool, you must follow these steps:
Note: You can also hold the Ctrl key while hitting the A on your keyboard.
Notice that now your data set has a dropdown arrow in each column's first cell. This means that from now on, you can filter your data by clicking on the icon and selecting the option that fits you better, just as if you had a table.
And finally, when you want to delete this formatting, you only need to click on any cell from the data set and click again on the “Sort & Filter” button to disable it.
Headers are not just the first cell of a table but also that part you can see at the top when you print something. Although headers and footers are more common in Microsoft Word, you can add those aids to your spreadsheet if you need to print or present a PDF or a physical report.
To make this possible, you must do the following:
Once you do that, you will notice the Header and the footers blanks:
But when you have many pages you need to number or name, you can enter the dynamic texts, which will help you automatize the text for each page. Check how you can do so:
In the same line of thought, when you want to print something specific from your spreadsheet, you can use the “Print Areas” command. This is a handy tip to save time and organize all the information in your worksheet.
Here is how you can do so:
Note: The “Clear the Print Area” option from the dropdown menu allows you to clear and add more cells to your printable area.
Nowadays, you can use graphs to improve a presentation. Actually, they are great visual aids to transmit information. And even more so when they are measurable figures. Ready to insert a simple chart? Let’s see:
If you're not full-convinced after selecting a type, you can always change the style by clicking on the graph and choosing a different kind from the panel.
Note: You can edit its style in the right-side panel.
When you are working with a team in the same workbook in Excel, some formulas and calculations you want to update may affect the whole worksheet. Unfortunately, this problem might consume a lot of time to fix.
Favorably for everyone, Excel offers a method by which you can review which cells depend on others called “Trace Precedents.” And for those cells that contribute to others, you can use the “Trace Dependents” option.
Warning: Both functions work one cell at a time, but when you use any of these operations, you can find the cells more efficiently.
To access these functions, you must follow the steps below:
When you use these tools, you will see some blue icons: The blue dot is the precedent, and the blue arrow is the dependent. So you can follow the directions to monitor the information and values. Check these examples where the first image is when using the Trace Precedent function, and the second one, the Trace Dependent operation:
Finally, to clear the arrows, you just need to click the “Remove arrows” option from the pane just below the function buttons.
There you have it! Now you can show off your new abilities! But do you want to be a real expert and master Excel? Then, check out our Excel course here in Skillademia, and if you want to know more about sorting your data, you should know about Pivot Tables!