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 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. 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, Calculation, Refresh & Create Analysis Sheet 28. using Slicer in Pivot Table 29. Managing Date and Value in Pivot Table 30. Creating Calculated Field in Pivot Table 31. CHART in Excel 32. Creating Chart 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 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
Reviews
There are no reviews yet.