There are dozens of times we have reviewed the best tricks, secrets or formulas of Microsoft spreadsheets. Today we want to give you a battery of tips to improve basic skills with Excel.
Although it may be lazy to learn at the beginning or in the beginning it seems a very difficult task, the truth is that learning Excel is essential nowadays, in addition to an indispensable requirement of multiple job offers. Since its first appearance on the scene in 1987, it has become one of the most popular software programs for both home and business of all kinds.
In addition to downloading templates, exploring the main formulas or learning some of the most important functions, it is essential that you improve the following Excel skills. Remember that patience is indispensable; since repetition will help you save time and improve the use of the program.
7 basic keys to master Excel
- Master the shortcuts: Learning some keyboard shortcuts can help you save precious time. In this article you can find more than 100 Excel shortcuts. Some of the most famous ones are Ctrl + c and Ctrl + v to copy and paste, Ctrl + z to undo the last action, Ctrl + PgUp to switch between the tabs of the worksheet, Ctrl + a to select the complete worksheet , Ctrl F to search for items and Ctrl K to insert hyperlinks.
- Import data from a website: This feature is very important and can greatly speed up your workflow. If you come across a website with tons of useful data for one of your projects, you can convert it into a spreadsheet by clicking File> Import external data and clicking on New web query. When you click on this tab, a new window opens showing the home page of your browser with the URL of the highlighted page. Choose the web page you want to show, then copy and paste the link in the Address box. Click on OK, and go!
- Filter your results: If you have a large spreadsheet with a lot of information, using the automatic filtering function is the smartest thing you can do. To do this, click on Data> Filter> AutoFilter. Then you can click on one of the small boxes and filter the results according to your needs.
- Calculate the sum: Using shortcuts to calculate the sum of a full column or a range of cells can save you a lot of time, especially if you use Excel regularly. Instead of manually entering the formula, simply use the shortcut Alt + = after selecting the first empty cell in the column. After executing this command, press Tab and you will get the result.
- AutoCorrect and AutoFill: AutoCorrect is a feature that automatically corrects words and typographical errors. To enable AutoCorrect, click on the Tools tab and select AutoCorrect. For its part, the AutoComplete function is useful to save time, especially when trying to manually write a numbered list. To activate it, go to the Edit menu, select Fill and click on Series.
- Show formulas: Just by pressing a key, you can toggle between the normal standard Excel screen and the screen mode, which shows you how the formulas actually appear in the system. The formula is Ctrl + ~. Press this combination once you are on a spreadsheet and Excel will display the formulas instead of the results of the same formulas.
- Manage page layout: If you want to make sure your impressions look as good as the screen display, click on the Page Layout tab. From there you can play with a wide range of options such as the numbering of pages, columns and page borders to see how they work.