"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