5 Basic Excel Practice Tips To Understand
If you are just getting started with Excel, there’s no need to fear. While it can seem rather stressful, what with the overload of information you’ll mostly get when searching through tutorials, here is a good place to start learning about the software. Here are 5 basic excel practice tips to learn:
- Ribbon customisation
One of the most helpful excel practise tips that are first taught to Excel beginners would be how to customise the Excel ribbon for convenient usage. The excel ribbon is a section that displays commonly used options/commands the user uses to perform tasks, so the user eliminates the hassle from having to locate the tool bar or pull down menus each time they want to apply a function. To add tabs to your ribbon, you can select the File tab. Choose options, look for customise ribbon and pick Main tabs. You will then be able to make the customisations and add them to your ribbon.
- Workbook Protection
Prevent others from inadvertently making changes to sensitive data in your Excel spreadsheets by protecting your worksheet or choosing to protect the entire workbook. In order to protect your worksheets, you can choose the Review tab and look under the Changes group. You can then select protect sheet. You can also choose to protect your workbook itself by saving with a password so when entering, you will also need the password to access it. Choose the file tab and look for Info. Once done, choose protect workbook and encrypt with passwords.
- Opening in Bulk
Save yourself some time from having to open up your excel files one by one by opening up the relevant excel files all together in just a single click. Choose whichever files you want opened and simply select the enter key on your keyboard. This will open your files simultaneously. You can also switch between these worksheets with no fuss, simply hold down the CTRL and TAB keys on your keyboard together. With these, you can both open and navigate your workbook files with no trouble. Just make sure you are applying data to the right worksheets.
- Applying borders
Ever come across different spreadsheets with borders or lines across the worksheet and wonder where you can use that feature? With Excel’s border features, you can perform a variety of different functions, including linking the first cell to other cells, separating different row/column attributes and more! This useful function is located under the Home tab. Look for the font option section and choose borders. You will then be able to access different border options, if you are looking for special borders, choose More borders for more options.
- Removing blank cells
To maintain accuracy in your calculations and sift out blank cells in large amounts of data quickly, choose the column you wish to filter the blank cells out of and look for the Data tab. Choose filter and deselect select all. Choose Blanks instead. This will highlight the number of blank cells that are present. Go back to the Home tab and delete them directly. This will ensure that the blank cells are all removed.