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:
-
Saving a Workbook Properly
-
Saving in Different Versions
-
Name – Rename – Move a Worksheet
-
Quick Access Toolbar
-
Three Ways in Edit Mode
-
AutoCorrect Options
-
Fill Color Certain Cells
-
Aligning Text and Numbers
-
AutoSum * MAX * MIN* AVERAGE
-
Using the Handler to Calculate
-
Adding Cells at Random
-
Task Bar Checking Totals
-
Freeze Panes
-
Select All to Copy Worksheet
-
Find and Replace
-
Name a Range
-
Titles at Top Multiple Sheets
-
Creating a Chart
-
Inserting a Hyperlink
-
Inserting a Comment
-
Setting Filters
-
Format Cells
-
Filters More Finite
-
Hide a Column Properly
-
Insert Header of Footer
-
Move Data
-
Sort Alphabetically
-
Using the Range to Calculate
-
Using the “Go To” Feature
-
Inserting Symbols
-
Rename and Color Code Tabs
-
Create a Formula Manually
-
Splitting the Panes
-
Fill Series
-
Absolute Reference
-
IF Functions
-
Commands Using the “Ctrl” button
-
Adding Totals Between Two Workbooks
-
Print Gridlines or Not
-
Format a Table of Data
-
Paste Special
-
Trace the Dependents and Precedents
-
Wrapping the Text
-
Set Printing to Landscape Orientation
-
ZOOM Mode to Enlarge Font
-
Set Print Area to Print
-
Build a Macro
-
Track Changes That are Made
-
Wrap Text
-
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+"
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