The videos discussed on this page were created by Skillsoft. The following conversation deals with videos on Excel. PROBLEM #1: View this picture above. It is from the video (link below). This video shows how to add cells WITHOUT using cell references. This is C.O.M.P.L.E.T.E.L.Y. W.R.O.N.G.and should not E.V.E.R. be shown. Showing how to perform calculations without using cell references defeats the purpose of using Excel (auto answer updated when changing the data inputs.) This video should be banned. To view this travesty, click the video below and fast forward to the 40 second of the video. PROBLEM #2: The Instructor jams too much information into this video. She combines basic addition with using advanced "pre-programmed" FUNCTIONS (in this case she uses SUM). This is way too much information and it is scattered. First teach all the ways to add. Then, in a separate video, teach all the ways to subtract. In a separate video, show all the different ways to multiply. Finally, in a separate video show all the ways to divide. Once that information is presented, then explained the advanced functions and by that I mean SUM, PRODUCT, etc. PROBLEM #3: Finally, the Instructor is difficult to follow as she must scroll up and down to show the calculations and the answers. This is confusing to the student. Both calculations and answers should be shown without scrolling so the student can view the entire process on the screen at the same time. This will increase understanding and retention. This knowledge of how humans learn is something I picked up through 25 years of teaching humans. This entire video is HORRIBLE. View it below. ===>===> Skillsoft Video: Excel Performing Simple Calculations 05:18 (5 minutes and 18 seconds) The videos below (labeled "30secondtraining video) will show the correct way to introduce this information as shown on the 30secondtraining.com website: ===>30secondtraining video: Excel simple addition: Video #1 Only 46 seconds ===>30secondtraining video: Excel simple addition Video #2 Only 56 seconds ===>30secondtraining video: Excel simple addition Video #3 Only 50 seconds ===>30secondtraining video: Excel simple addition Video #4 Only 93 seconds ===>30secondtraining video: Excel simple subtraction Video #1 Only 34 seconds ===>30secondtraining video: Excel simple subtraction Video #2 Only 73 seconds ===>30secondtraining video: Excel simple multiplication Video #1 Only 29 seconds ===>30secondtraining video: Excel simple division Video #1 Only 28 seconds The videos discussed on this page refer to finding and opening Microsoft Excel. View the image above. The instructor tells the audience to use the search box (empty white box in the bottom left corner of the screen) to click inside and type Excel. That white box is the search box. Here is the problem. The instructor is assuming all the students screens (around the world) look like her screen. Bad. A more professional instruction would to tell the audience / show the audience how to open an application using a "universally correct" way. Meaning? Show the audience how to open an application that will work on everyones screen regardless of what their screen has open. To see the proper way to show an audience how to open an application, view the video below. By the way, this mistake is not the Instructors fault. She has never taught (successfully) in a classroom environment. If she had, she would realize all screens can be different than hers and she needs to teach so the task explained is carried out successfully REGARDLESS of the students screen. ======>HERE IS THE BAD VIDEO CREATED BY SKILLSOFT. ===> Skillsoft Video: Excel: Find the app and open Excel 03:17 (3 minutes and 17 seconds) ======>HERE IS THE GOOD VIDEO CREATED BY 30 SECOND TRAINING ===> 30secondtraining video: Excel: Find the app and open Excel Video #1 - Only 22 seconds The videos discussed on this page refer to finding and opening Microsoft Outlook. View the image above. The instructor tells the audience to use the search box (empty white box in the bottom left corner of the screen) to click inside and type Outlook. That white box is the search box. Here is the problem. The instructor is assuming all the students screens (around the world) look like her screen. Bad. A more professional instruction would to tell the audience / show the audience how to open an application using a "universally correct" way. Meaning? Show the audience how to open an application that will work on everyones screen regardless of what their screen has open. To see the proper way to show an audience how to open an application, view the video below. By the way, this mistake is not the Instructors fault. She has never taught (successfully) in a classroom environment. If she had, she would realize all screens can be different than hers and she needs to teach so the task explained is carried out successfully REGARDLESS of the students screen. =====> BAD VIDEO CREATED BY SKILLSOFT===> Skillsoft Video: Outlook: find and open the application 03:27 TO SEE THE CORRECT AND EASY WAY TO SHOW YOUR STUDENTS HOW TO OPEN OUTLOOK, go to 30secondtraining.com, login, click Outlook, and Lesson 1 click Open Outlook. Let us do it together! The videos discussed on this page refer to setting up your workspace in Outlook. View the image above: The instructor shows how to collapse the "FOLDERS PANE". The instructor assumes everyone in the audience has the "shortcuts" in the bottom right corner to turn on and off the FOLDERS PANE. Some might not. The better way to show the students is by using the VIEW TAB at the top of the screen. This way, all of the audience will be successful at turning on and off the FOLDER PANE. Only an instructor would understand this and be able to execute the class successfully. View the bad Skillsoft video below. BAD VIDEO BY SKILLSOFT===> Skillsoft Video: Outlook: setting up the workspace 04:56 The videos discussed on this page refer to line spacing in Microsoft Word. View the image above: The instructor shows how to change line spacing. Online problem: the instructor only says, "go to the PARAGRAPH group"....and never mentions the HOME tab. This is a crucial mistake ONLY IF you want the student to enjoy full understanding and you want the student and audience to be able to follow along easily and simply. View the bad Skillsoft video below. ===> Skillsoft Video: Word: Paragraph spacing 04:16 =======================++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 5. Outlook: setting up the workspace 04:56 6. Outlook: keyboard shortcuts 03:50 7. Outlook: find and open the application 03:20 8. Excel: the interface0 6:50 10. Excel: Find the app and open Excel 03:17