In professional life, the use of Microsoft Excel is essential. Indeed, this software is an integral part of a company to facilitate the completion of daily tasks. Therefore, not mastering this tool will cause you significant harm. For this reason, we tested a tutorial to master Excel well on the site apprendreexcel.com. Many tutorials are offered on this site, but we chose the one titled: “Excel: the keyboard shortcuts to recognize.” To save more time, given that “Time is money,” as the old saying goes, it is essential to have a good mastery of the various keyboard shortcuts in Excel.
The advantages of using keyboard shortcuts
When we tested the keyboard shortcuts listed on the site apprendreexcel.com, we had the opportunity to execute commands in the quickest way possible since we refrained from using the mouse. For the first time, we managed to finish our tasks an hour early.
A découvrir également : The different known methods to treat hemorrhoids
The different types of keyboard shortcuts in Excel
Indeed, there are numerous keyboard shortcuts in Excel. Moreover, as we mentioned above, they are all essential for completing tasks quickly. On the site apprendreexcel.com, we discovered keyboard shortcuts that we had not known before, such as specific shortcuts. As for the classic shortcuts, some of them are already familiar. But thanks to this tutorial, we gained new knowledge. You will find more information on this blog dedicated to Excel.
A lire en complément : The best ways to express gratitude in daily life
Classic shortcuts
With these classic shortcuts, the CTRL key is widely used; it is the common key for shortcuts. To define the function we want to perform, we simply hold down the CTRL key while also pressing another key on the keyboard. For example, to copy and paste, we used the keyboard shortcut CTRL + C and CTRL + V. Moreover, we no longer had difficulties repeating an action because we just had to press CTRL + Y, saving a significant amount of time. To undo an action after a typing error, we pressed CTRL + Z, and that’s it. When we finished the tasks to be performed in Excel, we proceeded to save it so that the changes would not be lost. For this, we pressed CTRL + S. To then close our Excel file, we used the shortcut keys CTRL + F4.
Specific shortcuts
Regarding these specific shortcuts, they allow for performing more complicated functions easily, still without using a mouse. For example, to select the entire table, we used the keyboard shortcut CTRL + *. During our task, it was useful for us to insert a new tab to organize our calculations well, and we did it easily and quickly. For this, we just had to press the keys SHIFT + F11. After entering all the numbers on the sheets of all the open workbooks, to then perform all the calculations, using the keyboard shortcut F9 is perfect.