top of page

Training Videos!

This is just a partial list of all the Micro Training Videos that come loaded onto a Thumb Drive to help you learn the tasks in Excel, Word, Outlook and PowerPoint that you need to better qualify yourself as a viable employee in the Workforce of 2022, as well as 2023 and the Future! And yes, the "Future" is NOW, so to speak!

​

There is no reason why a person in the Workforce of Today can justifiably say, "I know how to use Excel", if he or she does not know essentials such as "IF Function" and "VLOOKUP"! And there is no reason why you should feel that you are of the small majority when you are part of the "Greater Majority"! Do not let it deter you in any way! 

​

After I teach anyone online, in my Classroom, at their home, One on One, they receive my Flash Drive with over "200 Micro Training Videos installed on it! These Micro Training Videos are MP4 Video files that are approximately 2 to 3 minutes long and they show you how to do all the Lessons in Excel, Word, Outlook and PowerPoint that are taught in my Classroom! Even if you decide not to subscribe to my Training, these videos will train you at your own pace and the Flash Drive can be purchased alone.

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

If you want to order the "Micro Training Videos" on a Thumb Drive to teach you how to use Excel, do it now while the "Special" is still offered! Use PayPal or any Credit Card!

"Thumb Drive - Micro Training Videos - 200+"

Click on the Thumb Drive below!

flash drive for Videos.jpg

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

Circular Reference

Array Formula

Array Formula for Percent

Multiple Criteria Formula

Counting Formulas

Counting Differences in Range

Calculate Workdays (Network)

Time Sheet

Conditional SUMS

Array SUM with Errors

Array that Finds all Errors in Range

Array Summary of Largest in Range

Array that would Add the Largest

Average Excluding Zeros

Array Finds Difference in 2 Ranges

Array to Find Value in Range

Array to Find Location of MAX data

Array to Find Round Totals

Calculating Total Wages Array

Copy and Paste in One Step

Adding Background to Worksheet

Cell Address Find

Table Totals One Click

Separate First, Middle, Last Name

Counting Different Criteria

Pivot Tables

Pivot Tables Different Criteria

Conditional Formatting

Formula to Calculate Grades

Charts Using Pie Charts

Charts Using Stock Charts

Conditional Formatting

Creating a Custom Style

Password Protection

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

bottom of page