Tuesday, August 15, 2017

Download Instaset Responsive Personal Blogger Theme

[Free theme blogger] Download Instaset Responsive Personal Blogger Theme - Instaset Blogger Template is the new Premium Blogger Theme for Lifestyle, Food, Personal Blog and Fashion Bloggers. It’s responsive and it has so much options for your needs. Instaset is a clean and minimalist theme that allows your reader to focus on your content. The beauty of this theme is its simplicity.


Instaset Blogger Theme Features

- 100% Responsive
- 100% SEO Friendly
- Google Testing Tool Validator
- Mobile Friendly
- Custom 404 Page
- Minimal
- Ads Ready
- Clean Layout
- Simple Design
- Drop Down Menu
- Social Sharing
- HTML5 & CSS3
- 100% Browser Compatibility

Demo - Download: Link 1

Good Luck!

Complete to Turn Off Windows 10 Laptop Screen

[Tip Computer] Complete to Turn Off Windows 10 Laptop Screen - Desktop computers usually come with a dedicated button to turn off or on the screen/display. The dedicated screen on or off button helps you save a lot of power as the display is the most power consuming component of a computer. Like desktop computers, very few laptops offer a hotkey to turn off the display. If your laptop doesn’t have a key to turn on or off the screen, you can use the provision in Windows 10 to configure the power button to turn off the screen.


Turn Off Windows 10 Laptop Screen

There maybe times when you just want to leave your laptop for a few minutes but don’t want to put it to sleep because it might be doing something like downloading a file from the internet. Similarly, you might be listening to an audio book or some music while on your travels. If you can’t turn the screen off manually using any keyboard function shortcuts to save a bit of power, here’s a selection of simple and easy ways that you can use to manually turn off your laptop’s LCD screen on command (see more: Complete to Disable Visual Effects In Windows 10).

Method 1: Using power button

Step 1: Open Settings app. Navigate to System > Power & sleep.

Step 2: In the Related settings section, click Additional power settings link to open Power Options window.

Step 3: Here, in the left-pane, click Choose what the powers do link. This action will open System Settings window.

Step 4: In the Power and sleep buttons and lid settings section, you can configure what Windows 10 should do when you press the power button. Next to When I press the power button option, select Turn off the display for both on battery and plugged in.


Finally, click Save changes button. That’s all! From now on, whenever you want to turn off laptop display, simply press the power button on the laptop once. To turn on the display again, press the power button again.

To force shut down or turn off your computer, press and hold the power button for a few seconds until your computer is turned off.

Method 2: Use Aplication

Turn off LCD, this simple little tool was developed by Taimur Asad to turn off the LCD screen on the HP notebook he owns because it lacks a basic button to switch off the display whenever he wants to. The author decided to make his own small application which turns off his notebook LCD just with one click. The application is written in C# using Microsoft Visual Studio 2008.

Download Turn off LCD

Turn Off Monitor program enables you to turn off laptop display with a keyboard shortcut or click. The program requires no installation. We suggest you pin this program to taskbar so that you can turn off the display with a click or hotkey. The program has no user interface or settings. Run the program to turn off the screen.

Download Turn Off Monitor

Dark is another little program that can turn off laptop screen in a jiffy. When you install Dark on Windows 10, it creates a Dark shortcut on your desktop. Double-click on Dark.exe shortcut file on the desktop, to launch the program and move it to the system tray.

Download Dark to turn off laptop screen

Good Luck!

Tuesday, August 8, 2017

Complete to use the SEARCH Function Excel

[Tip Excel] Complete to use the SEARCH Function Excel - The Excel SEARCH function returns the location of one text string inside another. SEARCH returns the position of the first character of find_text inside within_text. Unlike FIND, SEARCH allows wildcards, and is not case-sensitive.


Complete to use the SEARCH Function Excel

Description

The Microsoft Excel SEARCH function returns the location of a substring in a string. The search is NOT case-sensitive. The SEARCH function is a built-in function in Excel that is categorized as a String/Text Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the SEARCH function can be entered as part of a formula in a cell of a worksheet (See more: fix Excel Formulas Not Calculating).

Syntax

The syntax for the SEARCH function in Microsoft Excel is:

=SEARCH (find_text, within_text, [start_num])
Arguments

- find_text - The text to find.
- within_text - The text to search within.
- start_num - [optional] Starting position in the text to search. Optional, defaults to 1.

Usage notes

- Use the SEARCH function to get the location of one text string inside another.
- SEARCH returns the position of the first character of find_text inside within_text.
- Unlike FIND, SEARCH allows the use of wildcards, and is not case-sensitive.
- SEARCH allows the wildcard characters question mark (?) and asterisk (*), in find_text.
- The ? matches any single character and the * matches any sequence of characters.
- To find a literal ? or *, use a tilde (~) before the character, i.e. ~* and ~?.

Applies To

Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000

Example (as Worksheet Function)

Let's look at some Excel SEARCH function examples and explore how to use the SEARCH function as a worksheet function in Microsoft Excel:


Good Luck!

Monday, July 31, 2017

Complete to Disable Visual Effects In Windows 10

[Tip computer] Complete to Disable Visual Effects In Windows 10 - If you have a Windows 10 computer with amazing specs, great RAM and processor, you can enjoy the effects seamlessly without a single doubt. But if your computer is not that efficient with mediocre specifications, then it’s never a good idea to keep the extra visually appealing features at the cost of your computer’s performance and efficiency.


Complete to Disable Visual Effects In Windows 10

Like its predecessors, Windows 10 also offers many visual effects, and Windows enables most of them by default. Window animations, shadows under mouse pointer, aero peek, drop shadows for icon labels on desktop, animations in taskbar, and shadows under windows are visual effects (see more: Fix Error Code 0xc000012f on Windows).

Disabling all Windows 10 visual effects or disabling specific visual effects is easy. You don’t need to edit Registry or system files to disable visual effects.

Tip: Did you know that by switching to SSD, you can increase PC’s performance by up to 50%?

Step 1: In the Start/taskbar search field, type Sysdm.cpl and then press Enter key to open System Properties dialog.

Step 2: Switch to the Advanced tab. In the Performance section, click Settings button. You should now see Performance options dialog.


Step 3: Here, choose Adjust for best performance if you want to turn off all visual effects and gain the best possible system performance. Finally, click Apply button.


But if you want to keep certain visual effects, select Custom option, deselect visual effects that you don’t want to see and then click Apply.

Good Luck!

Wednesday, July 19, 2017

Complete to Fix Error Code 0xc000012f on Windows?

[Fix Windows] Complete to Fix Error Code 0xc000012f on Windows - This bug is Windows specific and seems to be prevailing on Windows 8 and 10 versions. Usually, it is caused by misconfigured system settings, corrupted registry entries, excessive startup programs, fragmented files, and similar. Not to mention, 0xc000012f error may also occur due to precarious applications or virus infections. Unfortunately, but the pop-up or BSOD error reporting about 0xc000012f error code is not the only problem what so ever. This bug is always accompanied by system slowdowns, crashes, programs work slower and lag when responding (See more: OneDrive Folder Can’t Be Created In The Location).


Complete to Fix Error Code 0xc000012f on Windows?

Alternatively, there are several things that you can try in order to fix 0xc000012f bug manually.

Method 1: Run sfc/scannow

1. Click Win key + S and type cmd in the search box.
2. Right-click on the Command Prompt and select Run as Administrator.
3. Type sfc /scannow and press Enter.
4. Let the system perform the repair automatically.
5. After that, reboot the system.

Method 2: Clean up junk files

1. Press Win key + R simultaneously.
2. Type cleanmgr and hit Enter.
3. Then select OS partition and press OK.
4. Finally, select Clean up System Files and wait for the process to finish.

Method 3: Use a System Restore Point

If you can’t uninstall Windows updates for some reason, then you can use a system restore point. However, this can only be done if you have created such point before. If you have, the perform the following:

1. Click Win key and type Create a Restore point in the search bar.
2. Select System Protection on the new window.
3. Click on System Restore and then hit Next.
4. Select the last Restore point that you have created and then click Next.
5. Click Finish and wait for the system to restore. After that, restart the system.

Method 4: Uninstall Cumulative Windows 10 update

Some specialists claim that 0xc000012f error code is caused by KB2879017 update. Therefore, if you have recently installed it, you should uninstall it right away.

1. Open Settings app.
2. Navigate to Update & security -> Windows Update.
3. Select Advanced options and then click View your update history.
4. After that, select Uninstall updates.

Good Luck

Monday, July 10, 2017

How to use Excel's MAX Function

[Tip Excel] How to use Excel's MAX Function - The MAX function is a computer program that you run from a worksheet cell formula. It determines the maximum value out of a group of values. You run the MAX worksheet function by typing its name in a formula then followed by the information it is suppose to analyze. This function is capable of analyzing thousands of cell values for a maximum value (largest). The MAX worksheet function is most commonly used to look at a row of numbers or a column of numbers on the worksheet (See more: How to fix Excel Formulas Not Calculating).


MAX FUNCTION SYNTAX AND ARGUMENTS

A function's syntax refers to the layout of the function and includes the function's name, brackets, comma separators, and arguments.

The syntax for the MAX function is:

=MAX( Number1, Number2, ... Number255 )

Number1 - (required)

Number2 : Number255 - (optional)

The arguments contain the numbers to be searched for the largest value - up to a maximum of 255.

Arguments can be:

- Numbers;
- Named ranges;
- Arrays;
- Cell references to the location of the data in a worksheet;
- Boolean values typed directly into the list of arguments.

Things to Know About the MAX Function

1. The arguments for this function can either be numbers or names, arrays, or range references that contain numbers.
2. You can type logical values and text representations of numbers directly into the argument list and they will be counted.
3. If an argument is range reference or an array, only numbers the numbers are analyzed. Empty cells, logical values and text are ignored.
4. Any arguments that produce error values or text that cannot be translated into numbers can cause errors.
5. If you want to include logical values and text representations of numbers in a reference as part of the calculation, try using the MAXA function.

Good Luck

Complete to OneDrive Folder Can’t Be Created In The Location

[Fix OneDrive] Complete to OneDrive Folder Can’t Be Created In The Location - After the recent OneDrive update, a lot of Windows 10 users have been reporting that they are getting the message "Your OneDrive folder can’t be created in the location you selected". The OneDrive application doesn't explain the cause of the issue. The error dialog looks as follows:

The location you were trying to create OneDrive folder belongs to a drive with an unsupported file system. To have OneDrive use a different location, click "Set up OneDrive" and point OneDrive to a NTFS drive. To use the existing location with OneDrive, you need to format it with NTFS and then click Set up OneDrive to configure your account.


Complete to OneDrive Folder Can’t Be Created In The Location

As the error description says, the error appears if you created the OneDrive folder on a drive formatted with a file system other than NTFS. That is, if you saved OneDrive folder on a drive formatted with FAT32, exFAT, or ReFS file system, you get the above error (See More: Remove Test Mode Watermark From Windows 10 Desktop).


Step 1: When the error dialog shows up, click Set up OneDrive button to open Set up OneDrive dialog. If the error dialog is not appearing now, simply double-click on the OneDrive icon in the notification area.

Step 2: Fill in your Microsoft account email address. Click Sign in button.

Step 3: Type your password for the account. Click Sign in to proceed further.

Step 4: When you see the following screen, click Change location link and select a location on a drive formatted with NTFS.


Tip: You can check the file system of a drive by right-clicking on the drive icon in This PC and then clicking Properties (refer to the picture below).

Step 5: From here on, follow the usual on-screen instructions to set up your OneDrive.

If you do not have a drive with the NTFS file system, you can try to convert the existing FAT32 partition to NTFS without data loss. If this scenario is suitable for your user case, do the following.

1. Open an elevated command prompt.
2. Type the following command
3. convert c: /fs:ntfs
4. Replace the "c:" portion with the actual drive letter you need to convert.
5. Follow the instructions on the screen. Don't restart your PC unless you prompted.

Good luck!

Friday, July 7, 2017

Complete to Disable PDF Reader in Google Chrome

[Web Browser] Complete to Disable PDF Reader in Google Chrome - Google Chrome has feature has changed drastically since Chrome upgraded to version 57 and above. With the latest Chrome browser, you can’t disable the PDF plugin anymore in chrome://plugins. As stated in chrome bug tracking, they mentioned that  chrome://plugins will be depreciated soon.

Google is about to remove the entire chrome://plugins page, which provides the plugin management user interface. But that's not all. Not only is Google going to remove the plugins page but Chrome will enable all plugins with the next update, even if you have disabled some of them. So with Chrome 57, all plugins will be enabled if they are installed on your PC.


Complete to Disable PDF Reader in Google Chrome

If you wish to disable the built-in PDF reader option in Google Chrome, you need to change the browser's configuration. Here is how (See more: change default zoom at Google Chrome).

# Method 1: Use Settings in Google Chrome

1. Open Chrome and click the three dots menu button to open the menu. Chrome Open Menu

2. Click the Settings item.Chrome Settings Menu Item

3. Scroll down to the Show advanced settings link. Click it.Chrome Advanced Settings

4. Under Privacy & Security, click on Content Settings.Chrome Settings Content Settings Link

5. In Content Settings, click on PDF documents.Chrome Settings Content Pdf Settings

6. In PDF documents, enable the option Open PDFs using a different application.

# Method 2: Open the required option directly

You can save your time and open the required option directly. Type or copy-paste the following text in the address bar of Google Chrome:

chrome://settings/content/pdfDocuments

This will open the "PDF documents" options in the current tab, so you can quickly change settings.

That's it. You just disabled the built-in PDF reader option in Google Chrome.

Google Chrome is the most popular web browser as of this writing. While it looks very simple, it is a powerful and extensible browser. Thanks to its settings, flags and extensions, you can configure many of its settings as you wish and extend its functionality.

Good Luck!

Wednesday, July 5, 2017

Complete to Remove Test Mode Watermark From Windows 10 Desktop

[Tip Computer] Complete to Remove Test Mode Watermark From Windows 10 Desktop - Test Mode to enable developers of drivers to test programs without having to provide an authentication certificate. Under the Windows 10 test mode, users can load and install unsigned drivers, and the Windows 10 test mode watermark will display (See More: How to fix Notification Area Icons Are Not Hiding).


What is Test Mode? 

Test Mode is a feature in Windows operating system which allows users to install and use drivers that are not digitally signed by Microsoft. The feature comes in handy for users who want to run or test programs that don’t have an authenticate certificate.

Turn on or off Test Mode in Windows 10 

Note: Please recall that killing the Test Mode highlight may compel the program/driver which is not carefully marked quit working.

#Method 1: Use CMD

To remove the test mode watermark in Windows 10, you could use Command Prompt to fix it. Follow these steps:

Step 1. Open Command Prompt as an Administrator

Step 2. Type in the following command and hit Enter

bcdedit.exe -set loadoptions ENABLE_INTEGRITY_CHECKS

Step 3. Enter the command below and press Enter

bcdedit.exe -set TESTSIGNING OFF
If the above command didn’t work, this one must work:
Bcdedit.exe -set loadoptions ENABLE_INTEGRITY_CHECKS
Bcdedit.exe -set TESTSIGNING OFF

Step 4. Close the Command Prompt window

Step 5. Reboot your computer to make changes take effect

#Method 2: Watermark Remover Utility

You could also apply a simple watermark remover utility to get rid of the Windows 10 test mode watermark. The commonly-used tools include Universal Watermark Disabler, Remove Watermark, etc.

Remember to reboot your computer after you run the water remover software to get rid of the watermark, the test mode watermark will be removed from your Windows 10 desktop.

Good Luck!

How to fix Notification Area Icons Are Not Hiding

[Fix computer] How to fix Notification Area Icons Are Not Hiding in Windows 10 - As a matter of course, Windows 10 enables you to conceal symbols in the warning range to maintain a strategic distance from mess. When you shroud a symbol, it will show up in the flood segment of the notice territory.

You can essentially relocate a symbol from the notice range to the outside of the taskbar to shroud it (will show up in flood area). When you need to see concealed symbols, essentially tap on the little up bolt catch by the warning territory.

On occasion, the up-bolt symbol on the taskbar may disappear, and all symbols (counting those that were already in the flood segment) will show up in the warning region. When you attempt to shroud a symbol by relocating it outside the taskbar, nothing happens.

In the event that you can't conceal warning region symbols, it's is likely in light of the fact that you or a program which you as of late introduced has arranged the taskbar to dependably demonstrate all symbols in the notice territory (See more: fix 0xc000007b when you play the game).



Making notice territory symbols stow away once more 

On the off chance that the notice region symbols on Windows 10 taskbar are not stowing away, take after the bearings offered beneath to shroud them.

Step 1: Right-tap on an unfilled spot on taskbar and afterward click Taskbar settings to open Task Properties page. On the other hand, you can explore to Settings application > Personalization > Taskbar to get to a similar page.


Step 2: Under Notification zone area, click Select which icons appear on the taskbar link.


Step 3: Here, turn off Always show all icons in the notification area option. Turning it off will shroud all notice territory symbols. You should now observe a little up bolt on the taskbar. Tap the up bolt to see every shrouded symbol.


As should be obvious in the photo above, there are alternatives to show or conceal framework symbols. You can show or conceal clock, OneDrive, battery symbol, volume symbol and other program symbols ideal from this page.

Good Luck!

Friday, April 14, 2017

Tips fix 0xc000007b when you play the game

[Fix windows] Tips fix 0xc000007b when you play the game - Windows is a standout amongst the most utilized and progressed working framework. Presently every body is utilizing Windows as their working framework. It is the stage which is exceptionally easy to use and simple to get to whenever with no trouble. Be that as it may, here and there while getting to some application, clients need to face a few issues and blunders. However, this is very regular in each working framework notwithstanding when you are utilizing them on your versatile gadget.

A standout amongst the most irritating blunder clients need to confront nowadays while getting to some application including Games like Fifa, Far Cry, Assassins Creed, Call of Duty and numerous different recreations and application which are exceptionally utilized by the general population. So here I'm with the answer for Fix Error Code 0xc000007b in Windows 7, 8, 8.1. This blunder 0xc000007b for the most part show up when you attempt to open any application.


Tips fix 0xc000007b when you play the game

You gleefully download a game as massive machine, you proceed to install and it goes smoothly but when click in icon game to play, then an error message appears as follows, "The application was unable to start correctly (0xc000007b)" (See more: Create Bootable USB Of Windows).

The main reasons leading to the development of:
The failure of the installation caused the game to lack the file or the wrong data
The software has been installed, and then took the wrong error resulting in registry
The software, the game is not compatible with the version of the operating system (Windows 32 bit and 64 bit).
But these errors can be overcome after you pass.

  1. First we download the files of the computer here, or here.
  2. When extracting files and folders, copy all the files in the folder decompression
  3. Execution: on the Windows 32 - you go to C > Windows > system32 and paste into and save the override, Press SKIP the question. On the 64 bit Windows, in C > Windows > syswow64 and paste into and save the override, Press SKIP the question.
  4. Finally, restart your computer and run the game!


Another way to make up for this error, you can refer to the following.

#1 Add new solutions

Note for this method can be applied in a number of games like Dead Light, Assassin Creed ... and some other games I have not tested it!

First visit this link to download the file "dll.zip" after the download is complete unzip them and copy all the dll in the folder and paste into the game installation directory is finished!

#2 Add new solutions

Use tools are available on this link.

After the download is complete please first remove the Game faulty before, should use the program to remove the root, then run this tool and wait for the tool to perform the job until the job done Members (End) and restart your computer, download the latest installation from the homepage game and perform the installation again.

Good Luck!

Thursday, April 13, 2017

Complete Guide to Create Bootable USB Of Windows

[Tips and tricks] Complete Guide to Create Bootable USB Of Windows - You can create a bootable USB pen drive for Windows or Linux setup and then boot your system using it and then you can install the OS without any worries. Creating bootable USB is not an easy task. You need to run some DOS commands and copy the setup files from your hard disk to USB stick.


Complete Guide to Create Bootable USB Of Windows

To prepare the bootable USB drive of Windows, we recommend using a free tool called Rufus over Microsoft’s Windows 7 USB/DVD Tool as Rufus is more reliable and offers more features when compared to other tools in the market (See more: set Default Printer In Windows 10).

With that out of the way, let's look at the requirements for Rufus:

PC running Windows XP or later (preferably Windows 7+)
Rufus application (download here)
ISO (supported operating systems)
8 GB USB flash drive (minimum recommended)

Fist, Connect your 8GB+ USB drive to your PC where you have installed Vista, Windows 7, Windows 8, or Windows 8.1 or Windows 10. Be sure to backup all data from your USB drive. Run Rufus utility.

Under the Device section, select your USB drive that you want to make bootable, select MBR partition scheme for BIOS or UEFI computers, or GPT partition scheme for UEFI computer depending the type of partition type on your PC.


Next, select the File system as FAT32 (default) as it supports both BIOS and UEFI. Enter a volume label, click on the CD/DVD drive icon to browse to the Windows ISO image file. Select the file.

Finally, click Start button, click OK button when you see the warning dialog to continue its job.

When using ISO images, Rufus will automatically modify the settings to best match it. Once everything is set correctly, click the Start button to begin the process. You'll be prompted with a warning that all data on the UFD will be destroyed.

Once Rufus completes its job, you’ll see “Done” message. That’s it!