Evolve Your Excel

Save time & effort at work with these must-know tips & tricks!

Start Course Continue Course Retake Course Preview Course Learn More

Lessons

78 Lessons

Retake this course?

Retaking this course from the beginning will reset all of your tracked progress.

Retake

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