This tutorial guides the reader to use Microsoft Excel Web App. However, the steps are also applicable to the Desktop version of Microsoft Excel. In this tutorial, we will be creating an Excel document called 'Research-Assessment'.
A) CREATING NEW DOCUMENT
1) If you are using Desktop version of Microsoft Excel, e.g Microsoft Excel 2010, you may skip this step. Browse the url http://skydrive.live.com. You need to log in using your outlook.com or hotmail.com credential in order to access this page.
Click Create/Excel workbook.
2) Type the name of the workbook, social-media-test.
3) The workbook main page is displayed.
The page consists of few parts.
3.1) The top most part contains:
a) The document name.
b) The application name.
c) The application window control.
d) The user log control.
a) The document name.
b) The application name.
c) The application window control.
d) The user log control.
3.2) The second part is contains tabs and their associated command buttons.
Microsoft calls this as 'Ribbon'.
When a new document is created, the application initially displays HOME tab.
HOME tab provides command buttons that you need while editing a workbook.
Command buttons are grouped by sections, i.e Clipboard, Font, Alignment, Number, Tab, Cells, Formulas, Data and Web.
Microsoft calls this as 'Ribbon'.
When a new document is created, the application initially displays HOME tab.
HOME tab provides command buttons that you need while editing a workbook.
Command buttons are grouped by sections, i.e Clipboard, Font, Alignment, Number, Tab, Cells, Formulas, Data and Web.
3.3) The next part is the workbook panel.
By default, the first sheet is called Sheet1.
By default, the first sheet is called Sheet1.
3.4) The bottom most part shows the status of the document.
If you click the Drop Down button besides the word "1 Person Editing", you would see your username.
4)
4.1) Download a text file from https://sites.google.com/site/notaskydrive/home/beginner/social-media-test.txt?attredirects=0&d=1
4.2) If you open the text file using a Notepad program, it looks like below.
4.2 Highlight the texts and copy them ([Ctrl]+[C]).
4.3) Switch to your Research-Assessment workbook, click the Cell A1 and paste ([Ctrl]+[V]).
Notice that on the Row 1 and Row 2, the texts go to specific cells instead of the first cell in the row.
4.4) Actually the texts have been separated by a special character called Tab.
5.1) Hover mouse pointer over the column border until pointer icon change to the split icon. Double-click the icon.
5.2) Repeat the steps for other column until you get as follows:
If you click the Drop Down button besides the word "1 Person Editing", you would see your username.
B) COPY-PASTE DATA
4)
4.1) Download a text file from https://sites.google.com/site/notaskydrive/home/beginner/social-media-test.txt?attredirects=0&d=1
4.2) If you open the text file using a Notepad program, it looks like below.
4.2 Highlight the texts and copy them ([Ctrl]+[C]).
4.3) Switch to your Research-Assessment workbook, click the Cell A1 and paste ([Ctrl]+[V]).
Notice that on the Row 1 and Row 2, the texts go to specific cells instead of the first cell in the row.
4.4) Actually the texts have been separated by a special character called Tab.
C) COLUMN SIZE
5) You can set the auto width for a column.5.1) Hover mouse pointer over the column border until pointer icon change to the split icon. Double-click the icon.
5.2) Repeat the steps for other column until you get as follows:
No comments:
Post a Comment