Progress Evolve Your Excel Complete & Continue Next Lesson Learn More Lessons 78 Lessons 1. Introduction 2. Mathematics 3. Math Shortcuts 4. Introduction to Functions 5. Combining Functions 6. IF Function 7. IF Family of Functions 8. SUMIF Function 9. COUNTIF Function 10. AVERAGEIF Function 11. MAXIFS & MINIFS Functions 12. IFERROR Function 13. Equalities & Inequalities 14. AND Function 15. OR Function 16. Entering Equations 17. Locking Cell References with $ 18. Entering Values in Cells 19. Adding Notes to Cells 20. Paste Special 21. Inserting Rows & Columns 22. Find & Replace 23. Go To & Go To Special 24. Named Ranges 25. Hyperlinks 26. Customized Shortcuts 27. Save As You Go 28. SUMIFS Function 29. INDEX Function 30. MATCH Function 31. INDEX MATCH Combination 32. VLOOKUP & HLOOKUP Functions 33. INDIRECT Function 34. OFFSET Function 35. SUMPRODUCT Function 36. CONCATENATE Function 37. CHOOSE Function 38. ROUND Function 39. ABS Function 40. Dates 41. DATE Function 42. YEAR, MONTH and DAY Functions 43. EDATE and EOMONTH Functions 44. DAYS and NETWORKDAYS Functions 45. Text Functions 46. Using Wildcards 47. Partial Formula Solving 48. Evaluate Formula Tool 49. Unlocked Cell References 50. Avoiding Misplaced Brackets 51. Avoiding Missing Inputs 52. Avoiding Different Range Sizes 53. Error Types 54. Trace Precedents and Dependents 55. Selecting Precedents & Dependents 56. Searching the Web 57. Inserting Charts 58. Choosing Your Chart Type 59. Combination Charts 60. Adding Chart Elements 61. Chart Formatting 62. First Time Chart Technique 63. Chart Templates 64. Choosing Chart Colours 65. General Chart Formatting 66. Map Charts 67. Chart Filters 68. Dynamic Chart Titles 69. Chart Slicers 70. Dashboards 71. Set Print Areas 72. Workbook Navigation 73. Jump to Any Worksheet 74. Freeze Panes 75. Creating Links Between Worksheets 76. Worksheets 77. Worksheet Names 78. Move and Copy Worksheets Evolve Your Excel Complete & Continue Next Lesson Learn More Lessons 7. IF Family of Functions
