Excel tricks to help you be faster and more efficient

One of the most used office automation applications both at work, at home or at the student level is Excel. And it is that the program to make spreadsheets that we find within the Office suite and Microsoft 365, is one of the most used worldwide. With it we can generate financial reports, budgets, invoices, accounting, as well as everything that we can express with tables of accounts and graphs.

Excel can also be used to perform basic operations so that any user without prior knowledge can navigate its interface. That is why it is important to know some key elements of the application that can help us to be faster and more efficient in our daily tasks. Although it may sometimes seem that working with Excel is complicated, there are tricks that help us to make working with spreadsheets as simple and productive as possible.

Use the AutoComplete feature

A function that we cannot ignore in Excel and that will help us to be much faster and more productive is your autocomplete. This tool will help us quickly insert functions and arguments while minimizing typing and syntax errors that we can make. This menu shows us the available options depending on the context so that we can choose what we want to insert in the formula. This function is especially useful for applying the same formulas from one cell to consecutive cells. For example, if we add the values ​​A1, B1 and C1 in cell D1, we can use autocomplete so that cell D2 adds the values ​​of A, B2 and C2 and so on. It can also be used to autocomplete words that we have previously written.

Master keyboard shortcuts

Another trick that we must take advantage of in Excel to work more efficiently is to learn to master keyboard shortcuts that will help us move quickly through our document, as well as perform certain tasks. Some of the most useful shortcuts are:

  • Control + Shift + Right: select the data in the row, from the selected cell to the last one to the right.
  • Control + Shift + Left: Select the data in the row, from the selected cell to the first one to the left.
  • Control + Shift + down: select the data in the column, from the selected cell to the last one.
  • Control + Shift + up: select the data in the column, from the selected cell to the first one.
  • Shift + Ta: move to the previous cell in a worksheet or the previous option in a dialog box.
  • Ctrl + Shift + End: Extends the cell selection to the last cell used in the worksheet.
  • Ctrl + Alt + =: Zoom in
  • Ctrl + Alt + -: Zoom out

Take advantage of predefined templates to save time

In the event that we have to work with the same type of documents, the possibility of use predefined templates It can help us to work more quickly and comfortably in Excel. The application has templates included so that we can select them quickly, just as we can use templates downloaded from the Internet. Thanks to them, it will not be necessary to start from scratch when we want to make invoices, inventories, estimates, agendas, schedules or other types of documents.

Excel templates

Use the automatic corrector and review the autograph

In the event that we have to write the same data repeatedly, but it is difficult to write, we can try to use the Automatic Corrector function. This tool will be in charge of replacing the text that we enter with the correct data. To do this, just click on File and then on the Options section. Now click on Review and finally on AutoCorrect Options. Here we must enter the texts we want in the Replace field. With self-correction we can correct text errors of formulas, sheet controls, text boxes, and chart labels.

Excel AutoCorrect

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *