Sunday, 7 April 2013

week 7

 Microsoft Excel
In this week, I've got plenty of new information about Microsoft Excel and how to use it.
In first session, we have learnt about Microsoft Excel basis

Cell basics. In general, basic cells and cell content in Excel is able to use calculating, analyzing , and organzing data.

 Cell basics include:
  - Insert content, select cells, cell content and delete cells
  - Cut, copy and paste cells as well as drag,drop cells and fill cells using the fill handle.

After becoming aware of this, we did in class activity(approximately 5 minutes), namely we watched the video to learn about cells and cell content in Excel workbooks.
Then,briefly,lecturer expained about the ways of modifying columns, rows and cells. These ways are: change row height and column width, insert and delete rows and columns, wrap text in a cell, merge cells.
In addition, i became familiar about formating in excel. Formating in excel includes following commands: 1)change font and font size;2)use the bold,italic,and underline commands;3)Add a border;4)Change the font color and add fill color;5) Change horizontal and Vertical text alignment.

As a summary i can say that by now, i have been familiar already with these :

 *Cell basics including modifying and formatting Columns, Rows, and Cells
 *Saving and printing a worksheet
 *Working with basic functions
 *Sorting, outlining and filtering data
 *Formatting Tables.

In second session, i have strengthened my knowledge about Microsoft ExcelFirs of all, i've been introduced to Spark lines. As a rule, Sparklines are miniature charts that fit into a single cell.
Why we use sparklines? We use it, because they are ideal for situations where you just want to make the data clearer and more easy-catching. Also, they are ideal for situations where you want to represent the data in greater detail, and they are often better for comparing different data series.

There are 5 phases of using Sparklines:
 -Select the cells that you will need for the first Sparkline
 -Click the Insert tab. In the Sparkline, select Line. A dialog box will appear.
 -Make sure the insertion point is next to Location Range. Click the cell where you want the Sparkline to be.
 -Click OK. The Sparkline will appear in the document. Click and drag the fill handle downward.
 -Sparkline will be created for the remaining rows.

Second of all, i've became aware of using pivot tables in Microsoft Excel. In fact, Pivot tables make the data in worksheets much more manageable by summarizing the data and allowing user to manipulate it in different ways. Likewise, Pivot tables can be beffiting when used with large, complex spreadsheets, but they can be used with smaller spreadsheets as well.
After that, watched tutorial video about using Pivot Tables as well as using filters,slicers, and Pivot Charts.
To tell the truth, by the time of this session i felt headache and i missed the summarizing part of lecture.

In third session, our class was fully covered by activity.
 Instuction to this activity was:
 *You need to do the exercise and mark will be awarded upon completion
 *You also need to complete the task given and email to your lecturer

 Requirements: *Referring to Activity sheet in our module and follow the instruction.
 *Save and Email exercises to your lecturer with the subject "FCC113 Microsoft Excel-'your name'" into one folder.

Time allocated: 55 minutes.That activity was mainly about calculating the percentages,grades,total using different formulas and tools.
As a summary, this session will give an exposure to the me with tools that i can apply to enhance my learning process. Besides that, at the end of this session, i am able to create and develop my own document a using appropriate application software.
To be honest, that activity which has been held in third session was very easy in case of difficulty, because i've already known about using Microsoft Excel tools and formulas. Thus, I finished that activity within only 15 minutes.

No comments:

Post a Comment