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 |
Thursday, July 30, 2015
20th Class of Excel Training Video Tutorials in Urdu and Hindi
19th Class of Excel Training Video Tutorials in Urdu and Hindi
How to use (percentage) formula?
1: (percentage)
2: (lookup) formula is using in this video for percentage example.
 |
19th Class of Excel Training Video Tutorials in Urdu and Hindi |
Watch Video
18th Class of Excel Training Video Tutorials in Urdu and Hindi
How to use (left, right. middle, upper, lower, proper, concatenate, lookup) Formulas?
1: (left)
2: (right)
3: (middle)
4: (upper)
5: (lower)
6: (proper)
7: (concatenate)
8: (lookup)
 |
18th Class of Excel Training Video Tutorials in Urdu and Hindi |
Watch Video
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
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
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
14th Class of Excel Training Video Tutorials in Urdu and Hindi
"How to use (find, fixed, mod) Formulas?
1: (find)
2: (fixed)
3: (mod)
 |
14th Class of Excel Training Video Tutorials in Urdu and Hindi |
Watch Video
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
12th 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......
 |
12th Class of Excel Training Video Tutorials in Urdu and Hindi |
Watch Video
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
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
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.
Insert Function, Auto Sum, Financial, Logical, Text, Date & Time,
Lookup & Reference, Math & Trig, More Functions in Formula Function
Library...etc.
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.
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.
Protection, Protect Sheet, Protect Workbook, Share Workbook...etc.
Watch Video
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 Sign's, 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, Content's...etc.
Watch Video
Subscribe to:
Posts (Atom)