Basics in Excel

nnIt is always necessary to be able to know a little more about the knowledge you have, and what better way than reading and putting into practice, what we then make known with these Excel tricks.n

nt
1. If what we want to do is create tables or graphs, then you will see that it is very easy because we can choose several styles and customize our chart, what we will do will be create a table, we will proceed to select a cell that contains values, then in the tab styles section, which is in the starting option we click there, and he will tell us which format takes our table or which style, there we can find many styles of tables to choose, and if we did not like the table we only give you the option “CTRL” + “Z” and we will do the table again.

nt

2. To give is touch to the cells that we want to use a conditional format in the Excel tables, since this simply gives a different format to each cell that we choose according to the value that we add, we go to start then to conditional format, then color scales and there we choose the color according to the value that the cell carries.

nt

3. If what we are looking to create in Excel is a graph with the values that contain the cells, the first thing we will do is select the area with the data in the cells and proceed to press the “F11” key, then to customise the graph we use the “graphic tools” tab, this is a very simple option to embed a graph in the same sheet, to do so we press the “ALT” + “F1” keys.

nt

4. To create a web page with a graph, we can do it the following way we go to the menu, then to the file option then save as…. And there we will ask what type we will select and we will put as “web page”, mark and save in “graphic selection” then press the “publish” button.

nt

5. To insert the date in Excel in any cell we only press the key combination “CTRL” + “,” (coma).

nt

6. If we want to repeat the last action done, we only use the “F4” key and it repeats the same thing we did, for example if we put color on a cell and press “F4” will do the same in the next cell.

No, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no. no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no,