Keyboard shortcuts have contributed to optimizing the time of users and professionals since time immemorial. Control C to copy, Control V to paste, Control F to search… However, there are other tricks that only a few know despite their great utility.
Excel is one of the most popular desktop applications in the world. Its spreadsheets allow a multitude of applications, from making an invoice to keeping a company’s accounting. Professionals who use this tool are used to handling large volumes of data, so knowing the ins and outs of the application makes their work much easier.
If you want to earn the Excel Power User award, you must first know how to apply the autofill function. This can be very useful for when in the documents you work with you have to fill several rows with information in series of names, addresses or any other pattern that Excel is able to recognize.
There is a shortcut that can save you hours in front of the computer chopping this information in a monotonous way. When faced with a series in which you must extract data about which there are references in a previous column, for example to cover the last names and initials of a previously written full name. Fill in the first row as an example, then type Control E. Voilà! Excel will automatically fill in the gaps until the column is complete.
Another time-saving trick is to import a printed document into an Excel spreadsheet without having to manually enter the data.
Who hasn’t gotten over the boring Excel formulas? Above all, if a slip when making a wrong cell has unbalanced the cells of the entire document. Luckily there is a way that this never happens to you again.
Once you have written all the values ??of your budget or your sales balance, select the cells with the data and those that will find the results. With the Alt = Excel command you will get the accounts automatically without having to spend time repeating the same formula over and over again
