Build dashboards and practice job interview assessments with step-by-step instructions.

Add a certificate of completion to your LinkedIn profile.

1. Number Formatting Shortcuts
2. Cell Selection Shortcuts
3. COUNT Function
4. True & False
5. IF Function
6. SUM Function
7. Arrow Keys
8. Wildcard Characters
9. SUMIF Function
10. SUMIFS Function
11. SUM Functions Skill Summary
12. SUMIF Practice
13. SUMIFS Practice
14. COUNTIF Function
15. COUNTIFS Function
16. COUNT Practice
17. COUNT Skill Summary
18. AND, OR, XOR Functions
19. IS Functions
20. IFS Function
21. SWITCH Function
22. Larger Cell Selections
23. Row and Column Selections
24. Cell Selection Shortcuts 2
25. Larger Cell Selections 2
26. Cell Selection Skill Summary
27. VLOOKUP Function
28. VLOOKUP Function 2
29. VLOOKUP Practice
30. HLOOKUP Function
31. HLOOKUP Function 2
32. XLOOKUP Function
33. XLOOKUP Function 2
34. MATCH Function
35. INDEX Function
36. INDEX MATCH Lookup
37. INDEX MATCH Practice
38. Index Match Skill Summary
39. LEN, LEFT, and RIGHT Functions
40. MID Function
41. LEN, LEFT, RIGHT, MID Practice
42. FIND Function
43. SEARCH Function
44. Intro to Shortcuts
45. Text Formatting Shortcuts
46. Cut, Copy, Paste
47. Data Shortcuts
48. AVERAGE Function
49. MIN, MAX, LARGE, SMALL Functions
50. MIN, MAX, LARGE, SMALL Practice
51. FLOOR & CEILING Functions
52. DATE Function
53. TODAY Function
54. DATEDIF Function
55. DAYS Function
56. DATE Functions Skill Summary
57. CONCAT Function
58. TEXTJOIN Function
59. UPPER, LOWER, and PROPER Functions
60. SUBSTITUTE Function
61. Pivot Tables 1
62. Pivot Tables 2
63. Table Filters
64. Tables Skill Summary
65. ODD and EVEN Functions
66. Worksheets
67. Conditional Formatting
68. MEDIAN Function
69. MODE Function