Featured Post

Complete Parts and Function of Computer Keyboard


How to Install Windows 10 using USB Flash Drive

windows 10 installation

The Windows 7 operating system is no longer supported in the internet. Many applications including security updates, and new program compatibility could be no longer available. So in this case we need to upgrade or install windows 10 on our computer. So that all our needs for our computer could be available without problems. But of course we must consider the hardware compatibility if your computer could be compatible with the system requirements needs of this operating system. Like the processor, if it will support both 32 bits and 64 bits, memory capacity that have a minimum of 2gb, high capacity of hard disk drive, preferable SSD or solid state drive, and video card or graphics processor unit that it could be optional. As long as your computer meet the system requirements by the Microsoft.

But before to install this Window 10 be sure to backup your important files. Because you need to install this new OS surely that will not create problems after the installation. So in this post you will learn how to install windows 10 using USB Flash drive. Begin to follow the instruction below:

  1. First you need to check what operating system that you have, it could be 32 bit or 64 bit of windows 7 or 8.
  2. Right click in the My PC and click properties.
  3. Check in the preceding current windows, if it 64 bit or 32 bit.
  4. After you check it, open the Microsoft website download.
  5. After you open it, download accordingly the windows 10 either 32 bit or 64 bit, click on it.
  6. After you click it, it will download the installation tools.
  7. After it will downloaded using your browser, click on it.
  8. A pop-up window will display, you have to options, just select “Create Installation Media for another PC”.
  9. After you click it, you need to select a language in the drop down bar, windows edition like windows 10 pro, then architecture like 64 bits.
  10. In the next window you have another options for the creation of the tools, Just select “ USB Flash Drive”.
  11. Then click next button below.
  12. It will automatically detect your USB flash drive if it is connected in your computer. But if not insert your USB flash drive and click refresh.
  13. Then after it, click the next button below.
  14. Wait until it will finish creating the USB Flash drive windows 10 installation tool.
  15. When finish you will see in the window told “Your USB flash drive is ready”.
  16. Click finish button.
  17. Now you need to restart your computer and enter the bios setup for first boot of your USB flash drive tool.
  18. Press f2 or delete, or a instruction you will see in the POST information.
  19. Now when you’re in bios system, go to boot menu and select removable drive. Be sure that your USB flash drive is in the first of the list of drives. Note: not all BIOS systems have the same interface, it will look different of its others, but always use or find the boot menu and follow the instruction position on the right of the screen.
  20. Press F10 key and click yes in the pop up window.
  21. Once you save now the settings the computer will bootstrap that USB flash drive and load the windows startup installation.
  22. Once you’re now in the windows setup windows, click next button in the right side down.
  23. Then click install now in the next window.
  24. In the next window wizard you will ask to type the windows product key if you have. But if don’t have click SKIP button below.
  25. Then accept the terms and conditions in the next window by clicking the box or check box.
  26. Then click next button.
  27. Then select custom install in the next window to create drive partitions.
  28. Select the old partition and click delete command. Repeat this procedure for the rest of the partitions you need to erase. Just click OK to confirm in the pop up window.
  29. After you deleted or erase all partitions, create your partition by clicking the unallocated partitions. Note: In this step it will automatically install the windows files and format the partitions. If you want to create two partitions, click the new command and follow the onscreen instructions.
  30. Click next button below of that window.
  31. In the next window you will see installing windows. Wait until it will finish, it will put a check in every windows file after it installed. it will restart the computer several times. But just wait until it will finish. In this situation don’t press any key on your keyboard.
  32. Once you ask to enter the product key, press and select do it later. Then select use express settings in the next window.
  33. Then just wait a moment the windows loading, until it will ask you “Who Own This PC”. Just click I own it, if your computer doesn't belong to a certain organization.
  34. Then click next button at the bottom of your windows.
  35. In the next window, you will ask to enter your email address, but if you don’t want it just click “ Skip this step”.
  36. Then in the next window you will ask to create your computer account, type your name and your password in your PC.
  37. Then click next button below.
  38. Then wait until the desktop screen will display in your PC. And then you are done.
  • To avoid problems just reads and follow the system requirements in Windows 10 installation.
  • To avoid lost of your important file backup it first before install.
  • Be sure that your HDD have enough capacity or buy a SSD drive.

How to use Multimedia Files in Microsoft PowerPoint

PowerPoint Multimedia FilesOne of the most stunning work of the Microsoft Office Application is playing a movie and SWF file in the Microsoft PowerPoint application. Talking with the movie presentation inside the application is made of very simple. Such as downloading first the movie you like in one of the best video sharing community, such as YouTube. Then insert the movie using the insert menu of the MS-PowerPoint. And this SWF (shock wave file) of the Adobe Macromedia Flash is used to create a better animation you own and created. Both the three new versions that highly made of user friendly environment, you can now insert both the Adobe Macromedia Flash and different movie file format such as WMP created using the windows movie maker.

In the following series of paragraph below, its a complete instruction listed in the proper order that came from the Microsoft Help. You can use this to create your own stunning movie and swf presentation using the Microsoft Office new versions, the Microsoft Office 2007, 2010, and 2013.
If you have an animated graphic that was created by using Adobe Macromedia Flash and saved as a Shockwave file with an .swf extension, you can play the file in a Microsoft Office PowerPoint 2007 presentation by using the ActiveX control called Shockwave Flash Object and the Adobe Macromedia Flash Player. To play the Flash file, add an ActiveX control to the slide and create a link from it to the Flash file, or embed the file in the presentation.

ActiveX control, security settings are located in the Trust Center, where you can find security and privacy settings for 2007 Microsoft Office system programs. You may need to adjust your security settings to allow Active X controls to run. ActiveX settings in the Trust Center apply to all 2007 Office release products. For example, if you change a setting in PowerPoint, that setting is also changed for other Office programs that use the Trust Center. For more information about Active X controls and changing settings, enable or disable ActiveX controls in Office documents
The Shockwave Flash Object must be registered on your computer for you to play the Flash file within a presentation. To see whether the Shockwave Flash Object is registered, on the Developer tab, in the Controls group, click More Controls. If the Shockwave Flash Object appears in the list of controls, it is registered on your computer. If it is not registered, download the latest version of the Flash Player from the Adobe Web site to register the Shockwave Flash Object on your computer.
To guarantee that complex animations run properly, install the latest version of the Flash Player, even if older versions of the Shockwave Flash Object are registered on your computer. 
Add a Flash file to a presentation:
  1. Install the Flash Player on your computer.
  2. In PowerPoint, in Normal view, display the slide on which you want to play the animation.
  3. Click the Microsoft Office Button , and then click PowerPoint Options.
  4. Click Popular, and then under Top options for working with PowerPoint, select the Show Developer tab in the Ribbon check box, and then click OK.
  5. On the Developer tab, in the Controls group, click More Controls .
  6. In the list of controls, click Shockwave Flash Object, click OK, and then drag on the slide to draw the control. Resize the control by dragging the sizing handles.
  7. Right-click the Shockwave Flash Object, and then click Properties.
  8. On the Alphabetic tab, click the Movie property.
  9. In the value column (the blank cell next to Movie), type the full drive path, including the file name (for example, C\: MyFile.swf) or uniform resource locator (URL) to the Flash file that you want to play.
  10. To set specific options for how the animation plays, do the following, and then close the Properties dialog box:
    • To play the file automatically when the slide is displayed, set the Playing property to True. If the Flash file has a Start/Rewind control built into it, you can set the Playing property to False.
    • If you don't want the animation to play repeatedly, set the Loop property to False.
    • To embed the Flash file so that you can share the presentation with others, set the Embed Movie property to True. (For the Flash file to run, however, the Shockwave Flash Object control must be registered on any computer that runs the presentation.)

Preview an animation in Slide Show view
  • On the View tab, in the Presentation Views group, click Slide Show or press F5. To exit the slide show and return to Normal view, press ESC.
If you don’t have any program installed on your computer just download here the Adobe Macromedia Flash, just click this link: Macromedia Flash 8. That’s all again, see you in the next post. “End”

How to use Logical Function of Microsoft Excel Worksheets

Microsoft Office Excel widely uses in our community. It is a common use as a simulation of spreadsheets paper. This is a part of automation in our office works as widely use in the calculation. There are hundreds of formulas built-in in this program to meet our needs in our worksheets of data, from simple to more complex application of a formula such as the logical. This is common to the programming platform of computer from basics to advance such as the coding of the database.

Logical function is a form of different conditions itself to meet an exact decision of data without changing its reference data in a worksheet. It can decides even it is hundreds of range of data in a single worksheet using the autofill. It can decides even nested in different logical operators both addition, subtraction, division, and multiplication.

Now this post will help you learn what is the IF function of the Microsoft Excel using even it is Excel 97, 2003, or 2007 buildup and even using the other Office Application such as Open Office and Star Office. Or else using the cloud application of both the Google Drive spreadsheets and the Skydrive application of the Microsoft Outlook.com of the MSN.

According of the Microsoft Office, IF means; “returns one value if a condition you specify evaluates to TRUE and another value if it evaluates to FALSE. Use IF to conduct conditional tests on values and formulas.”

Syntax IF (logical_test, value_if_true, value_if_false) Logical_test is any value or expression that can be evaluated to TRUE or FALSE. For example, A10=100 is a logical expression; if the value in cell A10 is equal to 100, the expression evaluates to TRUE. Otherwise, the expression evaluates to FALSE. This argument can use any comparison calculation operator. Value_if_true is the value that is returned if logical_test is TRUE. For example, if this argument is the text string "Within budget" and the logical_test argument evaluates to TRUE, then the IF function displays the text "Within budget". If logical_test is TRUE and value_if_true is blank, this argument returns 0 (zero). To display the word TRUE, use the logical value TRUE for this argument. Value_if_true can be another formula.

Value_if_false   is the value that is returned if logical_test is FALSE. For example, if this argument is the text string "Over budget" and the logical_test argument evaluates to FALSE, then the IF function displays the text "Over budget". If logical_test is FALSE and value_if_false is omitted, (that is, after value_if_true, there is no comma), then the logical value FALSE is returned. If logical_test is FALSE and value_if_false is blank (that is, after value_if_true, there is a comma followed by the closing parenthesis), then the value 0 (zero) is returned. Value_if_false can be another formula. The above STATEMENT can be understood in the following example, using the IF function: The final grades of the students set as example table below:

Name of Students
Final Average
Juan Juan 70 70 70 failed
Pedro C. Pedro 90 99 94.5 passed
The syntax above states that IF (logical_test, value_if_true, value_if_false), now basing the worksheet table the remarks are only passed or failed. Combining the logical as stated I use the logical by writing it in the worksheet as follows; =if (d2>75,”passed”,”failed”) now it is understood that =if is a logical function, d2 is a logical reference or reference data, greater than 75 is a logical test, and both using the double quotation the passed and failed is the logical condition that will base of the data reference and will depend of the logical test you provided.
See the image shown above.

A lot of examples will follow such as using the multiple IF function of the Microsoft Excel, it will help you to decide a hundreds of data using the remarks of your worksheets in different categories such as using the is greater than or equal to the principle. Just follow always this post, “End”

Use Windows Memory Diagnose Tools to Test RAM Failure

Windows Memory Tools
One of the problems of our computer is “windows lagging”, this logging is not only the cause of a damage files of windows or cause by a virus. But actually one of the problem is cause of the Random Access Memory Modules or RAM. The cause of the problem is might be the dust buildup or an over temperature inside the case or even the modules happen to be old. That's one of the chips of the RAM modules is damaged.

Through this, bad physical memory needs to be tested in order to know it and subject for replacement. Or else, a test for the better performance of the computer system. So the best way in checking this one of the main hardware of the computer is using the built-in utility tools of the Microsoft Windows Operating system. Through the backbone system called the MS-DOS, known as the Memory Diagnostic Tools in windows 7, 8, 8.1, and windows 10.

In this article you will learn how to use and run this utility on your computer using the MS-DOS.

  1. To run the utility you must click the start button, then type in search bar CMD. Or simply if you see the MS-DOS on your desktop or start menu to open it.
  2. In command line, type the command execution, mdsched.exe, like the command you will see in the post picture above.
  3. After you type it, press enter key.
  4. Then you will see a pop-up window on your screen, instructed you with the two options to restart your computer to check the problem.
  5. After you restart your computer and return to post, it will automatically start with checking for memory problems. The application will display a blue window that will display the memory status of your computer.
  6. After 100% memory check status, it will display the status of your memory, whether it has a problem.

When you see there are problems indicated after the check, you need to open your system unit cover. And carefully remove the RAM and replace it with the new compatible memory. But before to replace it, it must better clean or remove the dust buildup. Be sure to check that you installed the RAM tightly and correctly in the slots.

Backup Your Files Using Windows 10 Operating System

Windows 10 Backup

Important files on our computer are the number one attentions we need when we have a computer. Because our computer is always in the center of the fault, because of the different factors or cause. Like the damage caused by viruses, user error- like not properly shut down, and damage cause of total blackout. Because our computer has no UPS or the battery of the UPS is drained. Another, we need also to backup the important files on our laptop. Because our laptop could be accidentally bumped and drop that will suffer the most data loss. And additionally, the 2.5 HDD platter or SSD could be damaged due to longer or regular use. So, Microsoft equip this new Windows OS for this problem may encounter by the users of desktop or in laptop computer. You can follow the instructions below.

Windows 10

How To Backup Important Files
  1. Use the start menu bottom left of your screen or else use or press the Windows key on your keyboard.
  2. Then click on settings.
  3. On the next screen, click on the “Update and Security”.
  4. On the left panel of your screen, “Select Backup”.
  5. Then connect your external HDD by connecting it in your USB port or use the docking port of your system using the SATA port. Be sure that your HDD has a big capacity like the 1 TB and 2 TB of HDD.
  6. Once you have connected it, “+” button next to add drive at the center of your screen.
  7. Once you see and select the drive letters where your backup HDD drive is detected and your content will be back up and the selection is complete, the slider will appear under the “Automatically Backup My Files”. All your files and folder will be a backup or copy to the backup HDD by default.
  8. Click on the “More Options” located under the slider.
  9. Then scroll down to “Backup This Folders” and add folders as you see the “+” button add folder option. If you want to exclude folder and files, simply click the folders and files you want to exclude. Find the “Remove” button on the lower right hand corner of its selection.
  10. You can configure the “Frequency and Duration” of backup history in this procedure.

Now and then your system will perform to backup every time you use your computer with windows 10 OS, so you don’t worry now about your files. Because its secure now and backup to your backup HDD. See you next post.