DVD Selection

 Home / DVD Selection

Complete Excel 2010 Video Tutorial in Hindi

(HB 10)

Duration: 450 MB
SYLLABUS:
Ms-Excel VIDEO TUTORIAL 2010
 
1. Introduction to Excel & Using Formula
2. Formula, Cut, Copy, Paste, Format Painter, Alignment
3. Wrap Text, Merge & Centre, Number
4. Conditional Formatting, Format as table, Cell Style, Cell Insert, Cell Delete
5. Format, AutoSum, Fill, Clear
6. Sort & Filter, Find & Select
7. Pivot Table, Table, Picture, Clipart
8. Shapes, Smart Art, Screen Shot, Charts
9. Hyperlink, Text box, Header & Footer, Word Art, Signature, Equation, Symbol
10. Page Setup, Scale to Fit, Sheet Options
11. Formulas
12. Text to Column, Remove Duplicate, Data Validation, Consolidate, What if analysis, 
13. Group, UN Group, Sub Total, Spelling, Thesaurus
14. New Comment, Protect Sheet, Protect Work Book, Track Change
15. Page Break, Full Screen, Zoom, Freeze Pane, Macros
 
ADVANCE EXCEL VIDEO TUTORIAL 2010
 
1. Converting, Copying Formulas
2. Vlook Up
3. Choose Index, Match
4. Count if, Sum if, Average if
5. Rank, Median, Average
6. Date, Time Weekday, Workday
7. Array, Frequency
8. Find Data Extract, Left, Right
9. Replace, Substitute, Concatenate, Upper, Lower
10. Pmt and Fv
11. Is Function
12. Offset, Data Extract
 
FORMULAS OF EXCEL 2010
1. Count, Count Blank, Count if
2. Dated if, Abs, Average
3. Edate, Len
4. Large, Sum Product
5. Power, Rand Between
6. Repeat, Find
7. Round, Fixed
8. Small, Roman and
9. Time, Trim, Year, Today, Now
 
 
 
 
 
 
 
 

Support/Help

Contact Us

Bank Details

  • M/S SOFTCOM COMPUTER INSTITUTE
  • ICICI BANK
  • SUBZI MANDI,KOTA-(RAJ.)-324005
  • AC.NO.: 688305023877
  • RTGS/NEFT/IFSC CODE: ICIC0006883
  • Branch: Subji Mandi Kota(Raj) India
  • OR IN THE CASE OF D.D. IS IN FAVOUR OF "SOFTCOM COMPUTER INSTITUTE" PAYABLE AT - KOTA (RAJ.)

Have any Questions

If you have any questions, feel free to call us

Contact No:
+91-9214493851

10AM-7PM (Working Days)

Copyright © 2015 tallyonlinetraining.com All rights reserved.