Automatic Calculation
The calculation is the process of completing formulas and then displaying the results in the cells instead of the formulas. When a formula is complicated, you can leave it to Excel to automatically calculate the formula correctly.Dynamic update
To avoid unnecessary calculations, Microsoft Excel automatically recalculates formulas only when the cells that the formula depends on have changed. For example, if you make a mistake of some sort in excel and change one number, it will automatically update the previous numbers and change them based on the new numbers or formula's provided.
Data analysis (charts and graphs)
In Excel, you are given the decision to make a graph based on the table you have created, of your desire. You can also manipulate it to be any kind of them, including a map of the world. If you want to present a particular world or country change, you can take your project to meetings and show them off, since it is a better way to provide an understanding of something using a chart as a presentation.
Comments and Notes
In Excel, you can make one document and share the document with different people. When someone has an individual comment, you are able to see a yellow triangle on the side of the cell it is basing its comment on. As well as comments the person or people can leave not only a comment but also a note, maybe a memory note for people to remember, this time there will still be a triangle at the edge of the cell the note is basing on. However, the difference is the triangle with a not is black. The colors are made different for people to notice which one is commenting and which one is leaving notes.
Text wrap, clip and column merge
When you write something down in a cell, and it goes past the length of the cell there is a format called the wrap that will allow you to write not across the cell but down towards the cell bellow in the same column. If you want to clip something which is moving across something the effect will be you will be cutting the letters that move past the cell. Instead, the column merge of two cells is when you put together two cells and join them to create one, it is the same thing as the wrap except when you wrap something you can still see the lines that separate each cell from each other.
Create a header
There are millions of cells, and you can see this when you scroll down, the column's numbers increase. When you click on the button separating columns from the rows, you will then drag a certain line towards where you want the header to be. Most of the time, header's are used to being the headings of charts, saying what the numbers or letters mean below it. Now if you scroll down the names which it was before still stays in its recent position.
Width and length resize of columns
When your columns are too small or too large, you can explore the width and length of the columns and rows you want and it will automatically largen it for you so that you can have it given a better size. You can do this by firstly click on the button that separates the column and the rows, this will select all of the cells, rows, and columns and then you must click the line that separates A and B then drag the line to chose the width of the cell. You can do the same thing with the length, here you had to pick the line that separates the columns 1 and 2 and wanted the size of all the columns if you only want to change one particular cell's size then only select that cell and so the same thing.
If you want to change where the text is inside a cell then chose either the middle, bottom or the top of the cell. Firstly wanted a particular button with a surface and an arrow pointing to it. Chose either of the diagrams while having clicked an individual cell or even all the cells, and chose your pick, this will then change where the text is placed in the cell.
Data Validation
If you go under data and click on data validation, you can find a sort of box that shows you a certain amount of options. Click on the list for range, and then there are other options, you must click on the list of items. Type a few different things and separate them with "," in this way whenever you click on a cell, it will give you the option of the different things you wrote. For example, if I wrote "Rebecca, Lissa, Dina" then whenever I click on a cell it will show me the options to click either of those names.
Conditional formatting
If I use text validation, you will find that I can make rules which allow you to complete different things. To do this, you must go under formatting then under conditional formatting which will then turn out to the side of the sheet. Click on the text that is not empty. Then go under text contains, afterward write anything you want in the writing space. Click on whatever color of text boldness and so on and once you click done to try to type whatever you just did in a cell. You can see that now, however, I changed the word has become a rule and is now completely exactly what you changed it to be either bold or different color or whatever you changed it to be.
Adding a Link to bring from one sheet to another
In Excel, you can have a choice of making any amount of spreadsheets bellow the sheet there is a button saying add click on that button to acquire the second sheet. If you go under insert, it will give you an option to add anything you want if it is a picture a graph and even a link. If you click on a certain cell and then on the insert link button you will find a series of buttons, click on "sheets in spreadsheets," then you will see sheet 1 and sheet 2 if you are ing sheet 1 click on layer 2 if you are in sheet 2 clicks on sheet 1. Once you are done, you can see your writing on the cell has been underlined if you click on the layer it will immediately transport you from sheet 1 to sheet 2.
Reflection:
I learned a lot of new features of excel along the way of doing this project, I was able to firstly look over excel and discover new things, and personally, I found these things quite fascinating, because I have never experienced this complexity while exploring excel. One thing that I found fascinating was probably conditional formatting because I had never experienced how things can change and stay that way if you only manipulate it to be so. Another really thought tracking thing was the data validation feature because when people take a long time to write something down, to believe that you will always have the option to choose from the different options is a really cool thing. Personally, I would say that my features were very complicated, especially understanding how fascinating they were, even by questioning how humans were able to create this, it would definitely involve a lot of programming skills, to be able to do all of these things. I also believe that they are quite useful features because mot of the time we come across these times where we are facing a problem, and to know that these problems are very often, it is a good thing that people were able to find a way to fix the problems. We as students, could use excel in a various amount of subject, mainly math, because we will be able to discover how to make charts, and graphs, and change them depending on our skills, also because we can use it for calculating, it is a good experience to work with a device, and since in the future excel will be useful for us as we will be able to organize ourselves by using this. Also, we might also need it for science since there we are also learning about graphs.
No comments:
Post a Comment