Using Microsoft Excel is not rocket science, and you don’t need to be a super-expert to order your data; indeed, it is very intuitive. But, before creating pivot tables or applying complex rules to your cells, you can perform a couple of operations to start using Excel. Ready to know which they are? Let’s go!
This feature can be handy, especially when having a massive spreadsheet with a lot of content, and it allows you to seal some cells and visualize them as headings or labels at all times, even if you scroll down or right.
The heading usually is located at the top row or the first column. However, you can freeze two or more columns or cells according to your needs; you just ought to do the following:
Click on the row underneath your column headers. If you also want to freeze a row, you must select the column immediately following. Check the example:
In Excel, you will likely use many values in your spreadsheet, which sometimes implies getting different results from any math function, also called formulas. You can make several formulas: obtain an average, search for a specific value, and even more. Nevertheless, as a school, you need first to know the main four math functions and how to write them:
For this and any kind of formula, you must type the equal sign (=) following the operation's name. In this concrete case, the syntaxis is “=SUM.” After that, open a parenthesis, then select the cell range you need and close the parenthesis.
The second option is more manual: You must type the equal sign, then select one by one intersecting the plus sign (+) between each of them.
Note: You can make more complex formulas only with the main four.
It happens that when working with a vast table with several (almost infinite) columns and rows, you could have a few duplicates slipped through your fingers through no fault of your own. But relax, if this occurs to you, you should know that Excel has a fantastic aid to prevent this headache and the extra work of manually scrolling down and searching for each error. You just need to follow the steps below:
Changes across different worksheets:
Alright! So, when working in multiple tabs (not the ones in the ribbon, but those that you create and appear in the worksheet bottom) and having a set to put in everyone, it could be a truly stressful nightmare to go into each tab and make that change. Hopefully, Excel allows you to do this automatically by the following steps:
Of course, there are other functions you can learn, like creating tables, and macros, Using Data Validation, protecting a worksheet, or even splitting and merging cells. So don’t let anything stop your learning process. Good luck!