Week 7

It was our first class after the midterm exams.Everyone was so excited to know about their marks in the exams.Before announced the result our lecturer gave us introductory speech about the midterm result and he also encourage us for the the final exams.So that we can get good marks in the final marks.In this week we learnt about the Microsoft excel.Now, I am going to share my understanding with my blog.

Introduction:

Software developed and manufactured by Microsoft Corporation that allows users to organize, format, and calculate data with formulas using a spreadsheet system broken up by rows and columns. Microsoft Excel usually comes bundled with Microsoft Office and is compatible with other applications offered in the suite of products. The first software program similar to Excel was released in 1982 and was called Multiplan

.

Cell basic Include:

In excel we can use cell to organize the data and also for analysis.In which we can copy the text,paste the text,and also drop the cell.

Modifying columns,rows and cell:

According to the size of the text we can modify columns and rows width.We can also merge the cell.

Use of formula on MS Excel:

Microsoft Excel, you can enter numbers and mathematical formulas into cells. Whether you enter a number or a formula, you can reference the cell when you perform mathematical calculations such as addition, subtraction, multiplication, or division. When entering a mathematical formula, precede the formula with an equal sign.

Formatting:

By formatting we can change the style of our document.We can change the font size and also we can change the style of the text to make it more professional.We can also put margins in the document.


This class was so important for all us.Because next week, we are going to give our lab text and this test was about Ms excel and Ms word.In this week our lecturer taught us about the some other features of the MS excel which ,I am going to describe below.

Sparklines:

A spark line is a small embedded line graph that illustrates a single trend. Sparklines do not include axes or labels; context comes from the related content.

Types of Sparklines:

There are three main types of spark line such as

• Line Sparklines
• Column Sparklines
• Win/Loss Sparklines

Pivot table:

In data processing, a pivot table is a data summarization tool found in data visualization programs such as spreadsheets or business intelligence software.

Reviewing and sharing Workbooks:

• To track changes
• Add comments
• Compare two version of a worksheet
• To prepare a final version for sharing including how to check spellings