Micro Training Videos

​

Excel Micro Training Videos:

1. Saving a Workbook Properly

2. Saving in Different Versions

3. Name – Rename – Move a Worksheet

4. Quick Access Toolbar

5. Three Ways in Edit Mode

6. AutoCorrect Options

7. Fill Color Certain Cells

8. Aligning Text and Numbers

9. AutoSum * MAX * MIN* AVERAGE

10. Using the Handler to Calculate

11. Adding Cells at Random

12. Task Bar Checking Totals

13. Freeze Panes

14. Select All to Copy Worksheet

15. Find and Replace

16. Name a Range

17. Titles at Top Multiple Sheets

18. Creating a Chart

19. Inserting a Hyperlink

20. Inserting a Comment

21. Setting Filters

22. Format Cells

23. Filters More Finite

24. Hide a Column Properly

25. Insert Header of Footer

26. Move Data

27. Sort Alphabetically

28. Using the Range to Calculate

29. Using the “Go To” Feature

30. Inserting Symbols

31. Rename and Color Code Tabs

32. Create a Formula Manually

33. Splitting the Panes

34. Fill Series

35. Absolute Reference

36. IF Functions

37. Commands Using the “Ctrl” button

38. Adding Totals Between Two Workbooks

39. Print Gridlines or Not

40. Format a Table of Data

41. Paste Special

42. Trace the Dependents and Precedents

43. Wrapping the Text

44. Set Printing to Landscape Orientation

45. ZOOM Mode to Enlarge Font

46. Set Print Area to Print

47. Build a Macro

48. Track Changes That are Made

49. Wrap Text

50. Flash Fill for the Names

51. Speak Cells

52. Count Names of Employees

53. Cumulative Sum

54. SUMIF Conditional Formula

55. SUMIFS Certain Criteria

56. SUMIFS Multiple Criteria

57. SUMIFS Negative Values

58. VLOOKUP Formula

59. HLOOKUP Formula

60. Circular Reference

61. Array Formula

62. Array Formula for Percent

63. Multiple Criteria Formula

64. Counting Formulas

65. Counting Differences in Range

66. Calculate Workdays (Network)

67. Time Sheet

68. Conditional SUMS

69. Array SUM with Errors

70. Array that Finds all Errors in Range

71. Array Summary of Largest in Range

72. Array that would Add the Largest

73. Average Excluding Zeros

74. Array Finds Difference in 2 Ranges

75. Array to Find Value in Range

76. Array to Find Location of MAX data

77. Array to Find Round Totals

78. Calculating Total Wages Array

79. Copy and Paste in One Step

80. Adding Background to Worksheet

81. Cell Address Find

82. Table Totals One Click

83. Separate First, Middle, Last Name

84. Counting Different Criteria

85. Pivot Tables

86. Pivot Tables Different Criteria

87. Conditional Formatting

88. Formula to Calculate Grades

89. Charts Using Pie Charts

90. Charts Using Stock Charts

91. Conditional Formatting

92. Creating a Custom Style

93. Password Protection

94. Edit Formulas in Formula Bar

56 Extra Micro Videos

43 Micro Training Videos in Word

40 Micro Training Videos in PPP

29 Micro Training Videos Outlook