"How to use (find, fixed, mod) Formulas?
1: (find)
2: (fixed)
3: (mod)
 |
14th Class of Excel Training Video Tutorials in Urdu and Hindi |
Thursday, July 30, 2015
14th 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
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)