Currently unavailable.
We don't know when or if this item will be back in stock.
Select delivery location
Have one to sell?
Sell on Amazon

Advance MS Excel DVD Tutorial

3.3 3.3 out of 5 stars 13 ratings
Not Returnable
Secure transaction
Your transaction is secure
We work hard to protect your security and privacy. Our payment security system encrypts your information during transmission. We don’t share your credit card details with third-party sellers, and we don’t sell your information to others. Learn more
Currently unavailable.
We don't know when or if this item will be back in stock.
informationAre you a business? Get GST invoice and bulk discounts

Sign in/Create a free business account

Product information

Technical Details

Additional Information

Feedback

Advance MS Excel DVD Tutorial

Found a lower price? Let us know.

Where did you see a lower price?

URL:
Price incl. VAT: (INR)
Shipping cost: (INR)
Date of the price:
/
/

Store name:
Town/City:
State:
Price incl. VAT: (INR)
Date of the price:
/
/

Please sign in to provide feedback.

Product description

1. Excel Structure 2. Cell Properties 3. Autofill in Excel 4. Equation in Excel 5. Text Functions & Text to Column 6. Text to Column 7. Printing in Excel - Page Layout 8. Protection in Excel and Security 9. Protect File 10. Hide Formulas, Specific range protection 11. Share Workbook 12. Logical Function - IF, AND & OR 13. More Advance IF Function 14. AND & OR Function 15. Nesting Logical Function with Text Function 16. More AND & OR Example 17. MATH Function - SUMIF, COUNTIF, AVERAGEIF and More 18. SUMIF, COUNTIF & AVERAGEIF 19. SUMIFS, COUNTIFS & AVERAGEIFS 20. Wild Card in Match Function 21. Data Validation 22. Learn to set Criteria in Data Validation 23. Data Validation - Input Message & Error Alert 24. Pivot Table 25. Create Pivot Table 26. Managing Field List, Field Area, Buttons and Headers 27. Managing Value Field settings 28. Slicer in Pivot Table 29. Managing Date in Pivot Table 30. Creating Calculated Field in Pivot Table 31. CHART in Excel 32. Creating Chart - Layout and Format Option 33. Design Chart, Create Secondary Axis, Format Axis and Change Series Chart Type 34. Chart - Customize options 35. LOOKUP and REFERENCE Function 36. VLOOKUP Function 37. VLOOKUP with TRUE match type 38. HLOOKUP Function 39. MATCH Function 40. INDEX Function - Nesting with MATCH Function 41. VLOOKUP Array 42. VLOOKUP - Trick to get all Column data 43. VLOOKUP - Trick to get all Column data when Sequence not matching 44. Conditional Formatting 45. Setting Rule and Clear Rule in Conditional Formatting 46. Setting Top and Bottom Rules, Data Bars, Color Scale & Icon Sets 47. Managing Conditional Formatting Rules 48. Make your own Customization Rule 49. Setting Formula based Conditional Formatting Rules 50. What if Analysis 51. PMT Function to create EMI Calculator 52. DATA TABLE 53. GOAL SEEK 54. Scenario Manager 55. RECORD MACRO

Looking for specific info?

See questions and answers

Customer reviews

3.3 out of 5 stars
3.3 out of 5
13 global ratings
5 star
15%
4 star
28%
3 star
34%
2 star
13%
1 star
10%

Top reviews from India

Sourav Mondal
5.0 out of 5 stars Value for money
Reviewed in India 🇮🇳 on 7 July 2019
Verified Purchase
One person found this helpful
Helpful
 Report
Pritam
1.0 out of 5 stars No use
Reviewed in India 🇮🇳 on 15 November 2018
Verified Purchase
Helpful
 Report
avik
5.0 out of 5 stars Five Stars
Reviewed in India 🇮🇳 on 24 October 2017
Verified Purchase
2 people found this helpful
Helpful
 Report
Aditya Kumar Dash
5.0 out of 5 stars Comprehensively
Reviewed in India 🇮🇳 on 7 September 2018
Verified Purchase
Helpful
 Report
Mahammad A.
5.0 out of 5 stars Five Stars
Reviewed in India 🇮🇳 on 5 December 2017
Verified Purchase
One person found this helpful
Helpful
 Report
Mayank
5.0 out of 5 stars Worth it
Reviewed in India 🇮🇳 on 28 February 2019
One person found this helpful
Helpful
 Report
Barun Das
5.0 out of 5 stars Good training videos
Reviewed in India 🇮🇳 on 29 October 2017
Helpful
 Report