1: How to Use (Counta) Formaula in Attendance Program?

2: How to Use (Countif) Formaula in Attendance Program?

3: How to Use (IF) Formula in Fixed Two Assignment?

4: How to Use (IF) Formula in Fixed Increase Salary?

7th Class of Excel Training Video Tutorials in Urdu and Hindi

Watch Video

• DailyMotion.Com
 
• Vimeo.Com
 
• Playit.PK
 
• Youtube.Com

7th Class of Excel Training Video Tutorials in Urdu and Hindifrom A2zithelps

6th Class of Excel Training Video Tutorials in Urdu and Hindi

1: How to Use the (Min) Formula?

2: How to Use the (Max) Formula?

3: How to Use the (Count) Formula?

4: How to Use the (Average) Formula?

5: How to Use the (Counta) Formula?

6th Class of Excel Training Video Tutorials in Urdu and Hindi

Watch Video

• DailyMotion.Com
 
• Vimeo.Com
 
• Playit.PK
 
• Youtube.Com

6th Class of Excel Training Video Tutorials in Urdu and Hindifrom A2zithelps

1: How to Apply Borders to the Currently Selected Cells?

2: How to Use (Merge & Center) Option?

3: How to Edit the Fonts Size?

5th Class of Excel Training Video Tutorials in Urdu and Hindi

4: How to Make Bold Text?

  (i); (Ctrl+B)
  (ii); (Using Through the Mouse)

5: How to Make Italic Text?

  (i); (Ctrl+I)
  (ii); (Using Through the Mouse)

6: How to Make Underline Text?

  (i); (Ctrl+U)
  (ii); (Using Through the Mouse)

7: How to Edit the Fonts Color?

8: How to Fill Selected Cells Color?

9: How to Use the (+),(-),(*),(/) Formulas?

10: How to Use the (+),(-),(*) Formulas in Diffrents Company?

11: How to Convert the Pakistani Rupees in Dollars?

Watch Video

• DailyMotion.Com
 
• Vimeo.Com
 
• Playit.PK
 
• Youtube.Com

5th Class of Excel Training Video Tutorials in Urdu and Hindifrom A2zithelps

::Make Marks Sheet in Office Excel::

1: How to Make Marks Sheet?

2: How to Use (SUM) Formula?

3: How to Find the Total Marks in All Subjects with (SUM) Formula?

4: How to Find the (Persentage)?

5: How to Use the (IF) Formula?

6: How to Find the (Grade) with (IF) Formula?

7: What is the advantage the using of formulas in office excel?

4th Class of Excel Training Video Tutorials in Urdu and Hindi

Watch Video

• DailyMotion.Com
 
• Vimeo.Com
 
• Playit.PK
 
• Youtube.Com

4th Class of Excel Training Video Tutorials in Urdu and Hindifrom A2zithelps

1: How to Move in Diffrents Cells(Rows and Columns)?

Move UP = Press UP Arrow From Your keyborad

Move Down = Press Down Arrow From Your keyborad

Move Left = Press Left Arrow From Your keyborad

Move Right = Press Right Arrow From Your keyborad

Move to Start of the Page Your Selected (Column or Row) THen Press the Buttons(Ctrl+UP Arrow)

Move to End of the Page Your Selected (Column or Row) THen Press the Buttons(Ctrl+Down Arrow)

Move to Left of the Page Your Selected (Column or Row) THen Press the Buttons(Ctrl+Left Arrow)

Move to Right of the Page Your Selected (Column or Row) THen Press the Buttons(Ctrl+Right Arrow).

3rd Class of Excel Training Video Tutorials in Urdu and Hindi

2: How to Auto Genrate the Series in X(axis) and Y(axis)?

Type the any numaric NO in Your Selected Cell

For Example: ( 1 )

Select Your Cell and Press the left Button From Your Mouse and Press the (Ctrl) Button From Your Keyboard and Draw... in X(axis) OR Y(axis).

3: How to Auto Genrate Randomly Series in X(axis) and Y(axis)?

Type the Two numaric NO in Your Selected Cell

For Example: (3 and 6)

Select Your Randomly Numbaric NO Cell and Press the left Button From Your Mouse and Press the (Ctrl) Button From Your Keyboard and Draw...in X(axis) OR Y(axis).

4: How to Make the Custom Lists and Auto Genrate the Lists Text?

Click the office Button and go to (excel options) and Select the (Popular) Tab and Click the (Edit Custom Lists...) and create your list and click the save button.

Select the Cell And Type the any text from your list and Press the left Button From Your Mouse and Draw...in X(axis) OR Y(axis).

Watch Video

• DailyMotion.Com
 
• Vimeo.Com
 
• Playit.PK
 
• Youtube.Com

3rd Class of Excel Training Video Tutorials in Urdu and Hindifrom A2zithelps

1: How to Move in Diffrents Sells(Rows and Columns)?

Move UP = Press UP Arrow From Your keyboard

Move Down = Press Down Arrow From Your keyboard

Move Left = Press Left Arrow From Your keyboard

Move Right = Press Right Arrow From Your keyboard

Move to Start of the Page Your Selected (Column or Row) THen Press the Buttons(Ctrl+UP Arrow)

Move to End of the Page Your Selected (Column or Row) THen Press the Buttons(Ctrl+Down Arrow)

Move to Left of the Page Your Selected (Column or Row) THen Press the Buttons(Ctrl+Left Arrow)

Move to Right of the Page Your Selected (Column or Row) THen Press the Buttons(Ctrl+Right Arrow)

2nd Class of Excel Training Video Tutorials in Urdu and Hindi

2: How to Auto Genrate the Series?

Type the any numaric NO in Your Selected Cell

For Example: ( 1 )

Select Your Cell and Press the left Button From Your Mouse and Press the (Ctrl) Button From Your Keyboard and Draw...

3: How to Auto Genrate Randomly Series?

Type the Two numaric NO in Your Selected Cell

For Example: (3 and 6)

Select Your Randomly Numbaric NO Cell and Press the left Button From Your Mouse and Press the (Ctrl) Button From Your Keyboard and Draw...

4: How to Auto Genrate the Days Name?

Type the Any Day Name in Your Selected Cell

For Example: ( SUN )

Select Your Cell and Press the left Button From Your Mouse and Draw...

5: How to Auto Genrate the Date With Month and Year?

Type the Any Date With Month and Year in Your Selected Cell

For Example: ( 27-Jun-15 )

Select Your Cell and Press the left Button From Your Mouse and Draw...

6: How to Make Many Copies of 1 Cell?

Type the Any Text Selected Cell

For Example: ( Arslan ) or (8045)

Select Your Cell and Press the left Button From Your Mouse and Draw...

7: How to Make Responsive Place in Rows and Columns For Content?

Type the Any Longer Text (Maximaum 10 Words) Selected Cell

For Example: ( Muhammad Arslan Azmat Attari )

::Follow the Screenshot Image::

Draw Your Mouse Curser on this place and Double click this place then You Make Responsive Place...

8: How to Write the Text(any form) in Every Sell?

Select any Cell( Row and Column) and simple write the any text after the sell selection

Watch Video

• DailyMotion.Com
 
• Vimeo.Com
 
• Playit.PK
 
• Youtube.Com

2nd Class of Excel Training Video Tutorials in Urdu and Hindifrom A2zithelps

1st Class of Excel Training Video Tutorials in Urdu and Hindi

::Excel Office Button Video Tutorials in Urdu and Hindi::

1: How to Use a Excel Office Button?
2: Introduction All Excel Programs....!
3: How to Customize Quick Access Toolbar...?
4: How to Show Quick Access Toolbar Below the Ribbon?
5: How to Minimize the Ribbon?
6: How to Edit the Excel Options?

All About the excel menus,tabs,tools...etc.

1st Class of Excel Training Video Tutorials in Urdu and Hindi

Tabs;

Home, Insert, Page Layout, Formulas, Data, Review, View, Developer...

Excel Office Button;

1: How to Create a New Files/Sheets or Documents...etc.?
Simply Press the (Ctrl+N) buttons From your Keyboard
     OR
Click the excel office button and select the (New) option From your
Mouse (Left Click)

2: How to Open a Files or Documents?
Simply Press the (Ctrl+O) buttons From your Keyboard
     OR
Click the excel office button and select the (Open) option From
your Mouse (Left Click)

3: How to Save the Files or Documents with Recommended Programs?
Simply Press the (Ctrl+S) buttons From your Keyboard
     OR
Click the excel office button and select the (Save) option From
your Mouse (Left Click)

4: How to Save AS the Files or Documents With Manually Programs?
Click the excel office button and select the (Save As) option From
your Mouse (Left Click)

5: How to Print the Files/Sheets or Documents...etc.?
Simply Press the (Ctrl+P) buttons From your Keyboard
     OR
Click the excel office button and select the (Print) option From
your Mouse (Left Click)

Edit the Excel Options;

(1):Popular  (2):Formulas  (3):Proofing  (4):Save  (5):Advanced  (6):Customize  (7):Add-Ins  (8):Trust Center  (9):Resources

Download Microsoft Office 2007

This file Format in utorrent

Watch Video

• DailyMotion.Com
 
• Vimeo.Com
 
• Playit.PK
 
• Youtube.Com

1st Class of Excel Training Video Tutorials in Urdu and Hindifrom A2zithelps