# Excel 2010 Video Tutorials in Hindi by Saurabh Kumar (DVD)

Excel is the widely used spreadsheet program. You can use it from basic accounting to serious business. Many firms organizations use excel to keep records of various resources. In this video book you will get basic and advance knowledge of Excel. You will be able to work proficiently on Excel.

SKU: BC001
₹ 210.00 (including all taxes)
Catalog:

## What's in the Course?

1. Over 64 lectures and 8 hours of content!
2. Apply mathematical formulas.
3. Apply Financial Formulas
4. Apply Logical Formulas
5. Text Related Formulas
6. Date and Time Formulas
7. Lookups Formulas
Section 1: Introduction to Excel 2010
• Lecture 1: Introduction
• Lecture 2: Excel Interface
• Lecture 4: Sheet
• Lecture 5: Cell
• Lecture 6: AutoFill
Section 2: Formatting
• Lecture 7: Conditional Formatting
• Lecture 8: Conditional Formatting 2
• Lecture 9: Conditional Formatting 3
• Lecture 10: Formatting Numbers
• Lecture 11: WRAP text
• Lecture 12: Merge Center
• Lecture 14: Print
Section 3: Formulas
• Lecture 15: Sum
• Lecture 16: Average
• Lecture 17: SumIf
• Lecture 18: Count CountA
• Lecture 19: AverageIf
• Lecture 20: CountIf
• Lecture 21: IsNumber IsBlank
• Lecture 22: Date Time Now
• Lecture 23: Max Min
• Lecture 24: Power Fact
• Lecture 25: Rank
• Lecture 26: Rows Column
• Lecture 27: SumProduct
• Lecture 28: SumIfS
• Lecture 29: CountIfS
• Lecture 30: Transpose
• Lecture 31: AutoFilter
• Lecture 33: Data Validation
• Lecture 34: Custom Data Validation
• Lecture 35: Text Function
• Lecture 36: Text Function part 2
• Lecture 37: If formula
• Lecture 38: isBlank with if
• Lecture 39: Date with if
• Lecture 40: Absolute Cell References
• Lecture 41: Vlookup
• Lecture 42: Hlookup
• Lecture 43: PMT Formula
• Lecture 44: FV Formula
• Lecture 45: IPMT Formula
• Lecture 46: PPMT Formula
• Lecture 47: Present Value (PM) Formula
• Lecture 48: NPER Formula
• Lecture 49: Rate Formula
• Lecture 50: CumIPMT Formula
• Lecture 51: Upper Lower Proper Formula
• Lecture 52: LEFT, RIGHT, MID, Concatenate Formula
• Lecture 53: TRIM, LEN, REPLACE FORMULA
• Lecture 54: CountBlank Formula
• Lecture 55: Consolidate
• Lecture 56: PIVOT table
• Lecture 57: PIVOT Table 2
• Lecture 58: Macros
Section 4: Charts in Excel
• Lecture 59: Use Chart
• Lecture 60: Line Chart
• Lecture 61: PIE Chart
• Lecture 62: Bar Chart
• Lecture 63: Area Chart
• Lecture 64: PIVOT Chart

## Course Requirements:

1. Microsoft Excel 2010

## Who Should Attend?

1. Students with basic knowledge of computer
Type:
PC DVD-ROM
No. of videos:
64
Total Running Time:
7+ hours
User Level:
Fresher, Experienced
Video Resolution:
1280px x 720px
Language:
Hindi
Processor:
IBM/PC or compatible processor or 1.5 GHz or faster
Hard Drive:
1 GB
Other Requirements:
1024 x 768 pixels, 32 bit colour, CD or DVD ROM, audio device and a pointing device.
Operating System:
Windows 2003, Windows Xp, Windows Vista, Windows 7, Windows 8
Memory:
512 MB RAM
DVD:
1 Unit