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

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

:Discuss on Home Tab Tools:

1: Clipboard Tool Group;

cut, copy, paste, format painter...etc

2: Font Tool Group;

Font Styles, Font Size increase | decrease, Bold, italic, underline, borders, filling, font colors

3: Alignment Tool Group;

Height Position, Width Position, Wrap Text, Merge & Center...etc

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

4: Number Tool Group;

Number Formats, Sign, Percentage, Remove Signs, Increase (.0) 
Value | Decrease (.0) Value

5: Styles Tool Group;

Conditional Formating, Format as Table, Cell Styles ... etc.

6: Cells Tool Group;

Insert cells, rows, colums, Delete cells, rows, colums, Format, Row 
height, width, auto adjust width, sheet rename, sheet protect, cell 
protect, hide or unhide

7: Editing Tool Group;

Auto Sum, Fill up, down, left, right, clear all , clear format, 
clear content, clear comment, Sort & Filter , Filter A to Z, Filter 
Z to A, Find & Search, Find, Replace, Go to , Go to Special, 
Formulas, Comments, Conditional Formating, Contents...etc.

Watch Video

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

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

http://computerithelp86.blogspot.com/feeds/posts/default

download now

Read More

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

How to use (rept, roman, round, round up, round down) Formulas?

1: (rept)

2: (roman)

3: (round)

4: (round up)

5: (round down)

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

Watch Video

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

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

http://computerithelp86.blogspot.com/feeds/posts/default

download now

Read More

Menonaktifkan Generate Full Class Names di Netbean

Menonaktifkan Generate Full Class Names di Netbean

<!– @page { margin: 0.79in } P { margin-bottom: 0.08in } –>

Seringkali kita jumpai ketika bekerja dengan netbean untuk desain GUI adalah penulisan script yang sangat kompleks seperti berikut ini:

// Variables declaration – do not modify

private javax.swing.JMenuBar MenuBar;

private javax.swing.JMenu MenuFile;

private javax.swing.JMenu MenuHelp;

private javax.swing.JMenu MenuTools;

private javax.swing.JMenu MenuView;

// End of variables declaration

Penulisan script diatas seharusnya dapat disingkat menjadi cukup dengan mengimport packagenya sekali saja seperti berikut ini:

import javax.swing.JMenu;

import javax.swing.JMenuBar;

// Variables declaration – do not modify

private JMenuBar MenuBar;

private JMenu MenuFile;

private JMenu MenuHelp;

private JMenu MenuTools;

private JMenu MenuView;

// End of variables declaration

Untuk mempersingkat waktu langsung saja saya demokan seperti yang terdapat pada gambar dibawah, klik kanan pada Form Main kemudian pilih Properties setelah itu hilangkan tanda check or centang pada menu Generate Code Full Names kemudian tekan tombol close….

yupp… mudah-mudahan anda tidak bosan lagi dengan motode generate script otomatis yang dilakukan oleh IDE Netbeans… selamat mencoba…. :D

Sumber : sajarwo87.wordpress.com

download now

Read More

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

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

http://computerithelp86.blogspot.com/feeds/posts/default

download now

Read More

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

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

http://computerithelp86.blogspot.com/feeds/posts/default

download now

Read More

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

1: How to Create the Carts in Excel?

2: How to show or hide the formulas in your sheets?

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

Watch Video

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

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

http://computerithelp86.blogspot.com/feeds/posts/default

download now

Read More

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

"How to use (month, year, power, rand) formulas?

1: (month)

2: (year)

3: (power)

4: (rand)

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

Watch Video

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

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

http://computerithelp86.blogspot.com/feeds/posts/default

download now

Read More

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

How to use (sum if, sum product, time, today, trim) Formulas?

1: (sum if)

2: (sum product)

3: (time)

4: (today)

5: (trim)

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

Watch Video

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

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

http://computerithelp86.blogspot.com/feeds/posts/default

download now

Read More

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

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

"Discuss on only Three Formulas"

1: (day)

2: (day360)

3: (dollar)

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

Watch Video

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

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

http://computerithelp86.blogspot.com/feeds/posts/default

download now

Read More

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

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

"Basic Formulas"

1: Future Value (fv)

2: (PMT)

Next Basic Formulas Discuss in 12th class......

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

Watch Video

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

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

http://computerithelp86.blogspot.com/feeds/posts/default

download now

Read More

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

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

http://computerithelp86.blogspot.com/feeds/posts/default

download now

Read More

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

::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

http://computerithelp86.blogspot.com/feeds/posts/default

download now

Read More

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

:Discuss the View Tab and Design the Marks Sheet:

1: View Tab;

Page Preview, Normal, Page Layout, Page Break Preview, Custom Views, Full Screen, Gridlines Hide & unhide, Formula bar, Heading, Zoom, 100%, 200%, 300%,....etc, Zoom Selection, New Window, Arrange All, Freeze Panes, Split, Hide, Unhide, View Side by Side...etc.

2: Marks Sheet Designing using the Excel Tabs...

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

Watch Video

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

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

http://computerithelp86.blogspot.com/feeds/posts/default

download now

Read More

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

::Discussion on (Insert, Page layout, Formulas, Data, Review, View) Tabs::

1: Insert Tab;

Insert Picture, Clip Art, Shapes, Smart Art, Carts, Hyperlink, Text Box, Header & Footer, Word Art, Signature, Object, Symbol...etc.

2: Page Layout Tab;

Page Preview, Themes, Colors, Fonts, Effect, Margins, Orientation, 
Size, Print Area, Breaks, background, Print Tiles, Page Width, Page
Heigth, Page Scale, Sheet Left-to- Right, Sheet Right-to-Left, View
Gridlines, Heading, Arrange...etc.

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

3: Formulas Tab;

Insert Function, Auto Sum, Financial, Logical, Text, Date & Time,
Lookup & Reference, Math & Trig, More Functions in Formula Function
Library...etc.

4: Data Tab;

Insert Data From Access, Web, Text, other Sources, Existing
Connections, Refresh All, Sort & Filter, Text to Colums, Remove
Duplicates, Data Validation, Consolidate, What-if Analysis, Group,
Ungroup, Subtotal...etc.

5: Review Tab;

Check Spelling, Research, Thesaurus, Translate, Comments,
Protection, Protect Sheet, Protect Workbook, Share Workbook...etc.

Watch Video

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

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

http://computerithelp86.blogspot.com/feeds/posts/default

download now

Read More