top of page

"Micro Training Videos"

I have created hundreds of Micro Training Videos that teach you how to perform the tasks that are needed to either secure a job in the workforce or keep yours.

Excel Training Videos Available on a Thumb  Drive for $195.00.

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

Extra Micro Videos

43 Micro Training Videos in Word

40 Micro Training Videos in PPP

29 Micro Training Videos Outlook

Let’s Work Together

4560 Lake Street

Lake Charles, LA 70605

Tel: 337.245.0245

    Thanks for submitting!

    4560 Lake Street - Lake Charles, LA 70605 - 337.245.0245 - Cell: 337.764.7073

    bottom of page