It’s not too difficult to create a chart, but you need to choose the type that best reflects our data. Excel has a multitude of charts, and every one of them suits best certain types of data. In the text that follows you will meet most commonly used charts, with suggestions on how to choose the right one that will meet your needs.
The data we enter and process is often found in multiple spreadsheets. Depending on the version of Excel you’re using, after starting the program, each new document has one or more worksheets present. The number of worksheets appearing in each new document can be set in general options, and users can add, delete, move, change color or name of the worksheet on their own. The redistribution of the table on the worksheets can help you get a lot more organized.
When working with tables, there is often a need to manipulate rows and columns, and it is adding, deleting, hiding, or displaying hidden rows or columns. Manipulation is usually done by selecting some of the options from the Home toolbar, but there are several shortcuts that can help us perform these operations much faster.
Excel shortcuts for moving and selection are the ones you will use to a large extent in everyday work. You have no choice: when working with tables, these are most commonly performed operations, and if you apply shortcuts, they will make you considerably more productive. Productivity is a consequence of faster work, as most tasks can be done exclusively using the keyboard. Especially when you use a laptop, because when you are on the go, you may not have the favorite programmer’s pet at hand.
In everyday work, we often enter numbers, and then we format the way they are displayed within the cell. This is usually done by activating the Format Cells option, from the Home ribbon or by using the CTRL + 1 shortcut, and then choosing some of the cell content display options that are integrated into the Number tab. But since in practice we are dealing with just a few formats of a number record, it is much more useful to use shortcuts to quickly format content.