Today's Class Topics:
- Putting information into Excel (remember the spelling of Excel).
- Creating Forms
- Converting text to tables.
- Control + "R" arrow will take you to the end of an Excel Row (XFD is the last row in Excel).
- Control + Down Arrow will take you to the end of an Excel Column (1,048,576 cells in Excel).
- Control + Spacebar will return to "unformatted text".
- Learned that when working in Excel and you need a list of the days of the week for a schedule, type in Monday and while left clicking on the mouse, Excel will put in the rest of the days of the week. How to do that is: Put your mouse cursor on the bottom right corner of the cell that contains "Monday" and it will turn into a solid black + sign. While holding down the mouse key drag either up or down and you will see that Excel is putting in the days.
- Converting a text into a table in MS Word. So easy when creating forms, lists, and so forth.
- Forms are used everyday in offices; they are used for getting personal information. There is an easier way than drawing lines across the paper in Word--will be keeping this little secret to myself for now.
- Learned that MS Word has many Templates that can be used to create anything from a Resume to Invoices.
In MS Word you can restrict editing of documents when sending them to recipients of E-mail. On the "Review" ribbon you can protect your documents by allowing only certain individuals or none to edit a document that you have sent them. You may allow them to leave comments and then you can make the changes when you receive the document back. Very useful when writing a report and you would like to have someone else proof-read the document and they do not work in the same office; you can send it to them and they can make comments in the margins and send it back with any suggestions for changes.
Screeshot of My Work:
Form created by using tables in MS Word.
No comments:
Post a Comment