Learning Microsoft Office 2007

Now learn Microsoft Office 2007 100% free

Learning Microsoft Office 2007

Now learn Microsoft Office 2007 100% free

Learning Microsoft Office 2007

Now learn Microsoft office 100% free

Pages

What is Microsoft Office - Free Microsoft Office training - Microsoft Office 2007


What is Microsoft Office - Free Microsoft Office training - Microsoft Office 2007

 I want to give a little bit information about Microsoft office 2007. Microsoft office is a bundles or packages of programs which uses in offices, banks, factories, industries, business and much more. Microsoft Office offer us to do all those works which are Mathematics, write a letter, write a Projects etc, we can do these all works with the help of MS Office software. Have you noticed that whenever a student get admission in computer institute after finished of "Windows Xp" the teacher starts them Microsoft Office course So from that we can notice that MS office is so important computer learning course. As we talked MS Office have a bundles of courses, like Microsoft Word, Microsoft Excel, Microsoft Power point, Microsoft outlook, Microsoft Access and Microsoft front page, But I will teach in my site Microsoft Word, Microsoft Excel with above 250 functions and formulas, Microsoft Access with projects, and Microsoft PowerPoint. Now I want to give you a little information about the branches of Microsoft offices. 

Microsoft Word:-

Microsoft word is a computer learning course which is a branch of Microsoft office. Microsoft word allows you to perform make a text page with comprehensive tool which need us to create a advance page. For example you can make a style of you text and also you can add a picture. Microsoft word use to create a letter, novel, newspaper, term paper, Result sheet, CV and much more.

Microsoft Excel:-

Microsoft Excel is a computer program which is use for calculation. We can make result sheet, records, projects and much more. Mostly we can use MS Excel in banks, offices, business etc…We calculate our value with the help of formulas and function in MS excel. For example =sum(A2:D2).

Microsoft Access:-

Microsoft access is a branch of Microsoft office but it doesn’t come with other version of Microsoft office. It’s use for creating a database, result sheet, report, project and much more..
The database of Microsoft office is made from 7 parts which is given below.

1)   Table
2)   Query
3)   Forms
4)   Report
5)   Modules
6)   Macros
7)   Relationship

Microsoft PowerPoint:-

Microsoft PowerPoint is a branch of Microsoft office which is use for different presentation. Microsoft PowerPoint has a comprehensive graphic tools which is use to create a advance page and also you can make a style of page. In PowerPoint we can also make slide show of text.

 

Open Microsoft Office - Open Microsoft Word - Open Microsoft Word with different methods


Open Microsoft Office - Open Microsoft Word - Open Microsoft Word with different methods 

First of all I will teach that how to start Microsoft Word by six method.

1)      Click on “Start” Button from start menu go to “All programs” After All programs bring you cursor to “Microsoft Office” and then click on “Microsoft Word”.
2)      Click on “Start” Button then click on “Run” and type “Winword” and click OK.
3)      Clicks on “Start” Button then click on “Run” and type the location of Microsoft word address that where it is located. If you want to open Microsoft word so you should find “Winword.exe“ file address and copy the Address of item and paste it in “Run” as given below. After paste of you address click on “OK” button.

4)      Right click on you Windows Desktop bring you cursor to “New” and then click on “Shortcut” button.
 
Then type the location of your item click on “Browse” Button. This is the address of “MS Word” program "C:\Program Files\Microsoft Office\Office12\WINWORD.EXE" and then click on “Next” button as given below.
 

 
Now ask from us that “Type the name for this shortcut”. So we want to give a name by the name of “Microsoft Word” and then click on finish button.
5)   Right click on “Microsoft Word” icon and go to “Properties”. Now go “Shortcut” menu 
      and type in “Shortcut key” area a shortcut. For example “Ctrl+Alt+W” which is given below.


Now as you click from keyboard “Ctrl+Alt+W” then “MS Word” will directly open.
6)      This was our last method to open “Microsoft Word”. To start this method  Go to “My Computer” then “Local disk C”, “All programs”, “Microsoft office”, “Office12” and lastly click on “Winword” icon... This was our first class lesson I hope you like it so I will post another class as soon as possible.




SUMIF Function | SUMIF Function in Excel | Micorosoft Office training

SUMIF Function | SUMIF Function in Excel | Micorosoft Office training

The tutorial of the day is “SUMIF Function”, which is also an important function of Microsoft Excel so therefore today we will work on it. To learn it, follow the steps which are given below.
1) Start “Microsoft Excel 2007”.
2) Write these information on Excel datasheet as given below.



3) Now we want to SUM “Doctors” salary, we have 2 “doctors” in our list and now we want SUM their salary, To SUM their salary, type this Function (=SUMIF(D4:D11,"Doctor",E4:E11)) as given below.


4) Our function means that SUM all “Doctors” Salary which is on “Salary” column.
(D4 and D11 is the area of cell which means that select from D4 cell to D11) after that we should type a Position of an Employee which is “Doctor” and the last one is (E4:E11) which is the area of Salary so the complete meaning of our function is in easy words (Sum all “Doctors” salary which is in selected range of table)

5) After type of function press “Enter”, After Enter you will see “1250$”, which is the SUM salary of 2 doctors.


MIN Function | MIN function in Excel | Microsoft Office training

MIN Function | MIN function in Excel | Microsoft Office training
MIN Function is one of the most important Function of Excel, MIN is the contraction form of “Minimum” so it’s used to show the smallest number which is selected in a range of a table. Now we are going to work on it that how we can use it on our Office work. To learn it, follow the steps which are given below.

1) Start Microsoft Excel 2007.
2) Now write this information on Excel datasheet as given below.


3) Now we want to find the smallest salary of the table, To find the smallest salary, You should type this function (=MIN(G4:G10)) on a cell as given below.


4) After type of function press “Enter”. G4 and G10 is the place of our selected area. Which is like this (G4:G10), its mean select from G4 to G10. As you will type this function you will find your smallest salary. Now our tutorial of the day become Finished and I hope it’s one of the interesting Function of Excel for you people,  I will try to teach other Excel Functions on these days because as I told you that we should learn above 250 function so therefore in these days I am teaching Functions for you dear people. Good bye and have a great day for you people, See you on next Function.

COUNT Function | COUNT Function in Excel | Microsoft Office training

COUNT Function | COUNT Function in Excel | Microsoft Office training


Count Function is Use to add the number of Cell which is in a selected range of cell. Its only count up Numbers, not alphabet and symbols and Count Function ignore those cells which contains symbols, text and an Empty cell. Now we are going to learn this function with its different uses. We will of 4 different methods which are given below.

First Method:-

1) Start Microsoft Excel 2007
2) Type a few different kinds of number, text and symbols as given below.


3) Now is the turn to use our Function, Type (=Count(B4:D9)) anywhere you want to find the answer. In this Function you will see (B4:D9), which means “select from B4 cell to D9” as given below.


4) After type of function press Enter from keyboard, After Enter you will see “4”, which say that in your selected area we have found only “4” number, which is “52”,”34”,”3” and “53”.

2nd Method:-

Now use the First one function, after “D9” use a comma and add a number with it, Like (=COUNT(B4:D9,23). Now press Enter, as you will press Enter, you will see “5” because we add a number with our function so therefore our value become 5.




NOT Function | NOT Function in Excel | Microsoft Office training

NOT Function | NOT Function in Excel | Microsoft Office training


The next Function is "Not Function" which is used to return the reversed logical value its means that the answer of our typed value will become opposite. In easy words, if your answer will "TRUE" so it will be show "FALSE" because from the name, we should notice that what the name is of our Function, The name of function is NOT so if our answer will TRUE it will show us FALSE.
So let's study it practically. Follow the below steps to learn it.

1st Method:- 

1) Start Microsoft Excel 2007
2) Write a few numbers and words, As I type “100, and Knowledge” on a cell as given below.





3) Now is the time to use our Function, Type this Function (=Not(B2>50)) at the front of cell “C2”. The Answer will show you False because 100 is more than 50 so it’s TRUE but our Function is Not which means that 100 is not more than 50 and its more than 50.

2nd Method:-


Now I will teach you two simple uses of NOT Function.
 Number 1st: Type this function (=NOT(True)) at a cell of datasheet, After type and Enter, you will see “FALSE” in that cell and if we type (=NOT(False)) in a cell so it will display True, As I told you that the purpose of the function is to show Opposite value.

3RD Method:-

IF we type this function (=NOT(10+5=15)) in a cell so it will display False and if we type (=NOT(15+5=10))
So it will display TRUE.

4TH Method:-

Now we will work on our last method, if you didn’t type Knowledge so Now type “Knowledge” or something else, As I typed “Knowledge”. Now we are going to use it, Type this function at the Front of “Knowledge” as given below and number first method function is also given below.



Now our NOT Function has been finished, Today we worked on four method with its example, I hope you like it.