More About Excel

Today the teacher taught us more on Excel. The teacher told us one point about Microsoft that was very useful, that most of the tools in Microsoft Office programs are the same, there are only a few differences in each one, so if you recognize all the tools in 1 of the Microsoft Office Programs you basically know most of the tools in other programs, so this is very useful information. We learned how to name sheets it is quite simple:



Naming Spread Sheets:



Double click the sheet number, type in the name



It is a very simple thing to do. You can reorder the sheets by left clicking them and drag them to whatever place you want. This applies for cells too because if you wrote it in some test, a value, or a formula in a wrong cell you can just drag the cell into the right place so you can prevent rewriting it. this is very useful information for excel.



The teacher also taught us how to arrange the information from ascending and descending order. There are many ways to do it but for every way you must highlight all the values with the text in the columns and rows or else it will bet messed up:



Arranging infromation (Microsoft Excel 2007):



1. Highlight, Home, Sort Filter, there are 3 choices (sort z-a, sort a-z, custom sort), if custom sort (you can sort on column, type of sort ex value, order of sort), choos the sorts, and ok.



2. Highlight, Right Mouse Button, Sort, 3 choices, If custom sort fill in (column, type, and order), then enter



The teacher also taught us how to insert columns and rows just go to insert, then click on rows or colums you want to inser it in between. This class was basically a review for Microsoft Excel and we just went over the things like tools on excel. We also reviewed how to colour cells and also many new neat things.