Little by little, knowing how to use Excel is becoming one of the must-have skills in almost every company. That’s why you should know a few things about mastering Excel like a pro.
Check these 5 tips you definitely should try when working on a worksheet.
Keep reading because, at the end of this article, you will have more skills than you started with!
When working with two or more worksheets, you may find it difficult to switch between them quickly. How amazing would it be if there have a shortcut to do this operation! Just like the “Alt + tab” one on your keyboard. Fortunately, there is a way you can do this:
Afterward, you can switch between the windows more efficiently, and when you close your file, all changes you’ve done will generally appear in the same worksheet.
This trick is convenient and more straightforward than you can imagine when submitting a proposal for a client in Microsoft Word or other programs. Thus, to do so, you just need to follow these steps:
After doing that, any change you make in that specific range you selected in the spreadsheet will appear in the Word file. And this not only works with Microsoft tools. You can follow these steps to put in an email as well.
After the first approach and settling into using Excel, you may have noticed some tools you repeatedly use. However, when some of these tools are in different tabs, finding them requires extra effort and time. Hopefully, you can enable a command called “Quick Access Toolbar,” also named “QTA.”
It’s pretty easy to use:
But on the contrary, when you want to remove something from the QAT, you only need to right-click the icon and select the “Remove from Quick Acces Toolbar” option.
Finally, you can add a tool to the ribbon by right-clicking on the aid you want and selecting the “Show Quick Access Toolbar Above the Ribbon” option.
Usually, when you have to use the same worksheet repeatedly with the same formulas or values but with a few changes, the most recommended is to create a copy of the whole worksheet.
Think about this: if you start a new document and just copy and paste the spreadsheet into another Excel file, you must resize, adjust and check everything is correct. But with a copy, you won’t have to worry about that.
Here’s how to do so:
Note: Mark the “Create copy” checkbox before confirming the operation.
Then, in the same Excel workbook, you will have a copy of what you selected.
As in Microsoft Word, you can search, find and replace the cell content with a basic command without scrolling through your whole worksheet. To access this command, you need to do the following:
And that’s it. You can use the same tool if you only need to find something.
Check out our Excel course in Skillademia to improve your skills in this fantastic program! And finally, read these unexpected ways to find motivation if you need encouragement before starting Excel or any course you rather! Good luck!