Tips to make your Windows 10 PC run faster

Here are some “very basic” tips to keep your Windows 10 PC running smooth

Experts say, Windows 7 and XP are best in terms of UI and hardware management. And the latest Windows 10 is somewhat a “bulky” OS. So if you are among the people who have updated their Windows, you may be facing issue of reduced performance(specially if you were a Windows 7 user). We are providing some stuff here, These tips should help you improve performance on your computer by cleaning the clutter you don’t really need.

1: Prevent programs from loading on startup

Some programs are launched at startup, these programs are ones which Windows tries to provide fast access to . But this approach is less efficient at times when such programs are seldom used.

You have to visit the Startup tab of the Task Manager (Ctrl+Shift+Esc) or use Microsoft’s official (and free) “Autoruns for Windows” tool to see what’s launching alongside the OS. From there, you can disable anything you don’t want. If there’s a particular entry you’re not sure about, err on the side of caution and leave it to be.

2:Uninstall unnecessary apps

Unused applications don’t necessarily do your PC any direct harm, but they take up valuable hard disk space and room in the memory, and tend to mean Windows is working harder than it needs to. They can also cause unexpected bugs and incompatibility issues with other devices and apps.

Type “uninstall” in the taskbar search box then pick Change or remove a program to see all the applications currently stored on your machine. For any that have been gathering dust for a few months, click the relevant icon and select Uninstall, then follow the instructions on screen to complete the process.

3:Disable background apps

Some apps run in background by default, and luckily you can change this setting.
To modify software running in the background, go to Settings from the Start menu then click Privacy and Background apps. Turn off the toggle switches next to the apps you don’t want to have running all the time. Of course, you can still launch these programs manually if you need them.

4.Clean up the disks:

Microsoft’s Disk Cleaner utility has survived through all of the recent Windows upheaval, and it’s still a great way to sweep out some of the temporary data and unnecessary files taking up room on your hard drive. Even better, now it’s mostly automatic and easy to navigate.

Right-click on any drive in File Explorer, then choose Properties and Disk Cleanup (under the General tab) to find the program. It targets files including system memory dump files and temporary internet files, and you can review its findings before clicking on the OK button to confirm.

A great idea is to use a speedup tool like CCleaner Professional, which will perform everything mentioned above for you.

Create Bootable USB without any software on Windows 10:

• Insert your USB flash drive to your computer.
• Search for ‘cmd’ in Windows 10 from the taskbar, Command Prompt will appear. Alternatively, you can also open the  Command Prompt by pressingwindows+R at the same time and typing in ‘cmd’ in the ‘Run’ window and hitting enter.
• Right click on Command Prompt and select ‘Run as Administrator’ in case you have searched for cmd in the Windows 10 Taskbar.
• Once the Command Prompt window appears, type diskpart and hit enter. Wait until the diskpart utility runs in another window.
• In the new diskpart window, type list disk and hit enter. It will show you all active disks on your computer.

Most probably, you will see two Disk types.

• Disk 0 for hard drive and,
• Disk 1 for your USB Flash Drive with its total capacity.

Since we are going to work on to create bootable USB drive, we will work with Disk 1.

• Type select disk 1 in the same windows and hit Enter. You will get a message ‘Disk 1 is now the selected disk’. That means, any further operation that you do will affect your disk 1 directly.
• Type clean and hit Enter to remove all of the data in the USB drive. Clean command will format your bootable drive. You will get a message like ‘Diskpart succeeded in cleaning the disk’.
• Type create partition primary and hit Enter. You will get a message likeDiskpart succeeded in creating the specified partition.
• Type select partition 1 and hit Enter. It will choose partition 1 for setting up it as an active partition.
• Type active and hit Enter. It will activate the current partition.
• Type format fs=ntfs quick and hit Enter. This command will format your current partition as NTFS file system quickly.
• Type exit and hit Enter. Exit command will close the Diskpart program. But do not close the command prompt Windows.

Now before we proceed, let us assume that the USB drive is the G: drive and the DVD installer is located on drive E:. And, you also have inserted a DVD inside the DVD drive from where you want to copy the data to create a bootable USB drive.

By default, Command Prompt’s active directory for Administrator permission is on C:\Windows\System32>. We will navigate Command Prompt to set on DVD (E:) as its active directory. Remember there should be a DVD inside DVD installer.

• Just type E: then hit Enter, and then the active directory is changed to E.
• Type cd boot and hit Enter. Now the active directory is changed to E:\boot>
• Type bootsect /nt60 g: and hit Enter. It will create the boot sector on G: drive (USB Flash drive).
• Type exit and hit Enter to close the Command Prompt.

Until this step, we have been successfully able to create a bootable USB drive and the flash drive is ready to be used as a boot media.

To install Windows from a bootable USB drive, we just need to copy the whole installation files contained on the DVD installer to the USB flash drive.

• To do this, open the Command Prompt as in previous steps.
• Once the command prompt is open, type xcopy e: \ *. * G: \ / E / H / F and then press Enter. Wait until all the files in the DVD installer are copied onto the flash drive.

Now bootable USB drive is ready to be used for installing Windows from the Flash drive and you’re done.

VBA Code To Unlock A Locked Excel Sheet

If you have ever forgotten a password for one of your excel worksheets you know how frustrating that can be.

The code used in this instruction is one of the simplest I've found. It will generate a usable code that will unlock your protected sheet.

I can't take credit for the code as I merely found it in a moment of need (and I can not find where the site is anymore)... sooo I wont be much help if it doesn't work for you but I've had success with it and thought I'd share.

Step 1: Open VBA

Open the worksheet you forget your password to.

Use Alt+F11 to enter the macro editor.
Once in VBA double click the sheet you need to unlock from the menu listing on the left.
This will open the general declarations page for the sheet.

Step 2: Cut And Paste The Code Breaker

Insert the code below in the general declarations page you have opened.

You should not have to change anything , sheet name etc... Just cut and paste.
_______________________

Sub PasswordBreaker()

'Breaks worksheet password protection.

Dim i As Integer, j As Integer, k As Integer
Dim l As Integer, m As Integer, n As Integer
Dim i1 As Integer, i2 As Integer, i3 As Integer
Dim i4 As Integer, i5 As Integer, i6 As Integer
On Error Resume Next
For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
If ActiveSheet.ProtectContents = False Then
MsgBox "One usable password is " & Chr(i) & Chr(j) & _
Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
Exit Sub
End If
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
End Sub
________________________

Step 3: Run The Macro

Once the code is added run the Macro by selecting Run from the menu tab bar at the top of the VBA editor screen or simple press F5

Step 4: Use The Generated Code

The macro will return you to the worksheet you want to unprotect. An alert style box will appear with a usable code.

In the Review menu tab click Unprotect sheet.
Enter the generated code as the password and your done. Your sheet should be unlocked!

You should use this power wisely and responsibly only to unlock your own worksheets.