Basic Formulae and Functions in Excel

 اگر آپ کے پاس ایک لسٹ ہے اور اس لسٹ کو آپ جمع کرنا چاہتے ہیں۔ تو یہ فارمولہ لگائیں۔ 

دو یا دو سے زیادہ نمبرز کا اوسط معلوم کرنے کے لئے

Microsoft Excel (Excel-01)- Introduction

Microsoft Excel is known as spreadsheet. Spreadsheet consist of Rows and columns. Excel is mainly used for calculation purposes, working with numbers and formulae like making salary sheets, student DMC and other financial tasks.

As discussed Excel consist of Rows and Columns. in Excel 2013 and above version there are 1048576 Rows and 16384 Columns.

when a row and column intersect each other then it form a cell. there 17,179,869,184 cell in excel 2013 and onward version.

each cell has its own address. for example if column A intersect Rows 1 then this cell address is A1. This address is very useful and most important in entering formulae in excel. So now lets see how excel starts and how its interface look like.

in search write Excel and click Excel or click on short cut on desktop

The vertical line are columns and horizontal line are columns and collectively they form gridlines.

Ribbon in Excel

We will mostly discuss the formulae and calculation related task as other commands are mostly same to Ms Word.
So lets start learning by some basic commands in Excel

• What is Sheet

A sheet is a collection of columns and Rows. A file in in Excel consist of one or more sheets.

• What is workbook

A File in Excel is called Workbook. Workbook may have one or more sheets. You can insert more sheets in a workbook by clicking the + sign next to existing sheet.

similarly you can rename a sheet and change color of that sheet name. You can type Data in cell by clicking in that cell and can edit data by pressing F2 button.

To Enter formulae in Excel you must use = sign before every formula starting. This thing must be kept in mind.

for example to add two or more numbers we use the formula:=sum(a1:a5)

This mean to sum numbers from Cell A1 to Cell A5

=A1-A2

This mean to subtract number in A2 Cell from A1 cell data

= A1*A2
This mean to multiply number in A1 cell with A2 Cell
=A1/A2
This mean to divide Number in A1 cell by number in A2 cell
There are hundred of formulae and functions in Excel which we will discussed and learn. So keep follow my blog site

Much of the commands of Excel are same to Word like save, save as , open , cut , copy , paste, page size, page layout etc. etc.

The upper command bar is called Ribbon. There are File Home, Insert and Page layout menu like Ms Word but the menu of Formula, Data menus are special in MS Excel.

 اگر آپ کمپیوٹر کے بنیادی کورسز سیکھناچاہتے ہیں تو یہاں سے ڈاٗون لوڈ کریں۔

MWL-08 -How to use Track Changes in MS Word

 Track changes command is used to track or find out if someone has made changes to my documents. for example if my colleague in office open my document and make some writing then if I have applied track changes command then it will change to different color and i will notice that someone has make changes. than it is my choice whether to accept that changes or reject. 

This command is also used to send a document for review to our Boss. If recommends changes then we can easily identified that changes and incorporate it to the documents by accepting command.

Go to Review Menu- click on Track Changes and Track changes. 

make some changes in the documents and you will see it will appear in different color. 

Microsoft Word Lesson (MWL07) How to Create Table of Contents

Dear Student so far we have learnt much about Microsoft Word.  Now we will learn about how to create

  1.Table of contents, 

2. Table of Figures and 

3. Table of Table

Table of content is a list of topics in a book or report etc. which shows page numbers of each topic as illustrated in below picture.

To create a table of content, first create topics of the book. For example Chapter 1, Chapter 2 and Chapter 3 so on. 

Select each chapter separately and go to home and select heading 1 for each chapter. the chapter color will be change to blue. make more chapter and sub chapter for making table of contents.

Then go to Reference Tab and  select table of contents and select your style for table of contents. It will look like as shown below:

Same is the procedure for creating table of figures.

when you insert a figure or picture in Word file you have to insert a caption for that figure. for example we insert a picture as shown below. Go to Reference Tab, point to Insert caption, in caption menu dialogue box select you name for picture (e.g. Figure, picture or table) and numbering format and ok.

Microsoft Word Lesson (MWL-06)

 Dear Student

Hope you all in Good health.

So far we have learnt a lot about Microsoft Word. Now we will learn about the following important commands of MS Word.

1. Insert Pictures
2. Shapes
3. Screenshot
4. Hyperlink
5. Bookmark
6. Comments
7. Symbols

1.    To insert a picture in MS Word file, go to insert tab, point to illustration group and click picture and     then select you desired picture and click insert. The picture will be inserted and look like as shown below:

2. you can also insert ready made shapes in word document by click insert tab, point to illustration group and click on shape, select the shape you want to insert and then drag it to you choice size as shown illustrated in the below figure.

you can change colors and other format as shown below:

3. Screenshot command is used to take picture of the current screen. For example if i want to take picture of what is have written in MS Word document and want to sent these document to the teacher for examination then  follow these steps

4. Hyperlink command is used to link the current word document with other file. Or to insert a link of other file or web address etc. after inserting hyperlink when we click on the inserted hyperlink file it goes directly to that location. lets see it in the below pictures

when you press the Ctrl button on keyboard and click this link it will jump to that location where the files actually located and will be open.

5. Bookmarks command as clear from the name is used to place a page or text in word document for ready reference and when we click it, it jumps to that location in a documents. for example if we have about 200 page book and we want to go to page 30 easily where a word is mention then this command is very useful. Lets try how it works

Go to Insert Tab, point to Links group and click Bookmark

if you want to delete a bookmark then click on selected bookmark name and click delete.

you can easily go to the selected bookmark by clicking its name and click go to.

6. Comments command is used to insert you review on a text or word or anything in a file. For example if you prepare a document and you sent to you boss for review and he wants to change as line or paragraph or even a word the he will show this by inserting comments in you documents which will be shown as below:

when you received the commented file back from your boss, you can delete the comments after making changes by clicking right mouse on the commented text and click delete comments.

7. The symbol commands are used to inert different kind of symbols in your file. There are thousand of ready made symbols in MS Word 2016 related to different categories Like Maths formulae symbol, chemistry , physics related symbols.

Microsoft Word Lesson (MWL-05)

Dear Students

So far we have completed five lessons where we learn about the basics of MS Word, File creation, saving , password on file, Table creation, Chart etc.etc.

in lesson No. 5 we will  cover the following topics.

1. Header and Footer
2. Page Numbers
3. Date and Time
4. Text Box  and 
5. Word Art

Header and Footer means the text or logo or anything that appears in the top of every page in a book or report etc. for example if we want to make a book and we want the chapter name to be appear in the top of every page the we use header.  The footer is also same to header but the main difference is only that Footer appears in bottom of each page. Normally we enter chapter name in header and page numbers and address etc. in footer. So lets see how it will done.

Click insert tab..... click header and select you desired position...

Click insert tab......click footer and select your desired position and write text etc.

3.To insert page numbers on each page click insert tab, select page number and select position and style of your own

        

4.Text Box command is used for inserting text in a specific place in page. for example if you want to  enter text in right or left or bottom of page in different directions then use text box. Click insert tab select Text Box and drag the box as you requirement.

4.Date and Time is used to insert the current Date and Time in documents. Click Insert Tab, point to Date and Time and select your desired style of Date and time

        

5. Word Art is a stylish text especially used for making heading of book or certificate etc.

    

Save the Word Art, and When saving under Save as Type, Select  Word 97-2003 Document and click    save. 

Then the file after saving will look like as shown below:

 you will see beautiful style of text and you can select any style of your choice.