Monday, September 28, 2009

Microsoft tutorial 1-5


Introduction
This assignment entails the use of Microsoft excel and the step by step teachings which was demonstrated by a video professor on youtube.com which was then documented by me.
Microsoft excel tutorial shows how to adjust a cell, the expanding or contraction of a designated column. The tutorial goes more in debt by showing exactly how to add values using auto-sum, it also shows how to edit a cell and even goes further by explain how to use Aggregate Function.




Introduction to Microsoft excel tutorial-Over View
Introduction to Microsoft excel starts by showing us how to write in any given cell and also to delete any selected information. Furthermore, it explains how to expand or contract a designated column which in spreadsheet is label by alphabetically letters. The tutorial goes more in debt by showing exactly how to add values using auto-sum or the commonly use way of adding number which is either typing in the range or selecting it.
The tutorial also explains how to border, bold, add or change colour in a given cell or column, merge and centre and changing the font size. The next topic that was brought up teaches us how to delete a row, assigning a painting grid which had to be highlighted thus using that highlighted range to create a graph chart which can be done easily by the simple means of collecting the range and selected numbers, there is also a discussion about the changing of currency and how changing the values can affect the outcome of the total

Introduction to Microsoft excel tutorial-Get Start
A cell can be edit to fit in a given text so that it doesn’t overlap into the next cell by simply using the pointer to double click a column or use the pointer to pull the header to the right or left of the page, but sometimes when editing a cell we are more likely to be deleting your work by accident by just selecting back space but the safe way to complete one’s work is to use F2 which brings me to the topic of moving to and fro in different cells, this tasks can be applied by pressing the arrow keys on the keyboard.
The next thing which was mention in the Microsoft excel tutorial was how to undo and save a spreadsheet by clicking F12 on the keyboard.

Introduction to Microsoft excel tutorial-Calculation
Recognising Math Operation
There was not much said on Microsoft excel Calculation but the given diagram explain the function clearly
Symbols
Operation
Use of Mathematical Operation
/
Division
=B3/B4
*
Multiplication
=B3*B4
+
add
=B3+B4
-
Subtraction
=B3-B4

Using the equal sign while selecting the cell is a fast and accurate way of getting information in cells, while the fill feature is one of Microsoft excel speciality
    
Introduction to Microsoft excel tutorial-Function
Aggregate Function
There are five aggregate which is demonstrated below.
Function
Demonstration
Average
=Average(Range)
Maximum
=Max(Range)
Minimum
=Min(Range)
Sum
=Sum(Range)
Count
=Count(Range)
  The Aggregate can also be use by clicking the Fx function then Selecting the range

Introduction to Microsoft excel tutorial-Number Format

Number Formatting entail a lot about different type of formats for example Currency which can be obtain by clicking symbol on your toolbar then you can also increase or decrease the number of decimal points, then there is Comma Formatting which you click on the toolbar also which can be identify by the symbol    
Lastly there is the Percentage format which is identify by the symbol           you can click the symbol the achieve it task but number format also describes ways in which you can do multiple changes to your spreadsheet.






Conclusion
What I’ve concluded from Introduction to Microsoft word beginner Tutorial is that it gives you step by step instruction on the basic training of how use of spreadsheet by relating to each topic in its simplest form possible for example auto sum, formatting and chart range  just to list a few. The tutorial also gave detail description of what not to do on spreadsheet which was also made very clear.