background preloader

Microsoft

Facebook Twitter

Attention Required! Count Number of Instances in a Cell. This example describes how to count the number of instances of text (or a number) in a cell. 1.

Count Number of Instances in a Cell

Use the LEN functon to get the length of the string (25 characters, including spaces). 2. The SUBSTITUTE function replaces existing text with new text in a string. How to Fix ''Failure Configuring Windows Updates'' Issue. Windows usually downloads and installs updates when the auto updater is turned on.

How to Fix ''Failure Configuring Windows Updates'' Issue

However, you may sometimes get stuck with an update configuration issue with an error on your screen saying ”Failure configuring Windows updates, Reverting changes, Do not turn off your computer”. If it occurs, it usually takes 30 minutes to one hour to revert the changes so don’t freak out and think your computer is stuck. Give it time to revert the changes. Now let’s see how we can try to solve this problem. Follow the steps given below. Step 1 – Creating System Restore Point (Optional) "Failure configuring Windows updates. Reverting changes. Do not turn off your computer" error when you try to install Windows updates.

When you try to install Windows updates, you get the following error: Failure configuring Windows updates.

"Failure configuring Windows updates. Reverting changes. Do not turn off your computer" error when you try to install Windows updates

Reverting changes. Do not turn off your computer. Note If this issue occurs, it may take about 30 minutes to revert the changes, and then the system will show the Windows logon screen. To resolve this issue, use the following methods starting with the first method below. Restart your computer (Windows 8 only) To restart Windows 8, follow these steps:Swipe from the upper-right corner of the screen (or if you're using a mouse, move your pointer to the upper-right hand corner of the screen), and then tap or click Settings.Tap or click Power, and then tap or click Restart.Try to install Windows Updates again.

Unplug your removable media from the computer (Windows 8, Windows 7, and Windows Vista) Download Revo Uninstaller Freeware - Free and Full Download - Uninstall software, remove programs, solve uninstall problems. Windows startup programs. What are they? Are they required? How can I disable them? Last database update :- 28th March, 2014 38961 items listed Concerned about why your Windows 7/Vista/XP PC takes so long to boot when you switch it on?

Windows startup programs. What are they? Are they required? How can I disable them?

One of the main reasons is due to the number of programs that run at system startup - and this is the place for you to identify and disable them. Such programs typically (but not always) include an icon in the System Tray in the bottom right-hand corner of the screen - next to the clock. Windows task manager processes, Windows startup, Startup programs, Vista tweaks. Offline Windows Password & Registry Editor. Autoruns for Windows. What’s Taking So Long? How to Fight Slow Startup Times in Windows 7. Fixing a Corrupted UEFI Partition in Windows 8 or 8.1. We get this question often lately.

Fixing a Corrupted UEFI Partition in Windows 8 or 8.1

Introduction - Bulk Rename Utility.

Outlook & Exchange

vThoughts of IT: Reset your lost Domain Administrator password in 2 minutes. Recovering or resetting a password can be a tedious job requiring purchase of dodgy tools that promise you everything but you'll never know if they do until you bought them.

vThoughts of IT: Reset your lost Domain Administrator password in 2 minutes

This blog will show how I reset my Windows 2012 domain administrator password in under 2 minutes without any tools, just by using Microsoft tooling that you have at hand. WirelessKeyView Free Download. Laptop users who often need to connect to wireless networks surely know how hard it may be to remember the password for each of them, especially when having to deal with more complex passphrases.

WirelessKeyView Free Download

If that's the case, you most likely need WirelessKeyView, a simple yet very efficient solution that can help you recover a wireless network password that was used on your system a while ago. Only recovers passwords for saved connections As we found out while testing it, the application is very easy to use and it doesn’t even require installation. All you have to do is to download the archive, decompress the files and double click the executable. The interface is very simple, almost minimal and this is perhaps the best thing about this utility. You should note that WirelessKeyView is able to recover only the network WPA / WPA keys that were stored by Windows and not by a third-party software. Neatly displays gathered data. Speed up your PC.

Process Explorer. Introduction Ever wondered which program has a particular file or directory open? Now you can find out. Process Explorer shows you information about which handles and DLLs processes have opened or loaded. The Process Explorer display consists of two sub-windows. The top window always shows a list of the currently active processes, including the names of their owning accounts, whereas the information displayed in the bottom window depends on the mode that Process Explorer is in: if it is in handle mode you'll see the handles that the process selected in the top window has opened; if Process Explorer is in DLL mode you'll see the DLLs and memory-mapped files that the process has loaded.

The unique capabilities of Process Explorer make it useful for tracking down DLL-version problems or handle leaks, and provide insight into the way Windows and applications work. Download Download Process Explorer(1,215 KB) Regain your PC's administrator rights, even if you don't have the password. LouieB62 needs administrator-level access to his Windows PC, but he doesn't have the password. He asked the Answer Line forum for help. Your Windows PC has at least one administrator-level account. If you can't access that account, you've got a problem--you can't install or uninstall programs, or change certain settings. I'll tell you a way to gain this access, but first, ask yourself if you really should be doing this.

Revo Uninstaller Pro - Uninstall Software, Remove Programs easily, Forced Uninstall. IObit Uninstaller Portable. Uninstaller and cleaner IObit Uninstaller helps you uninstall and remove unwanted programs and folders from your computer fast and easily.

IObit Uninstaller Portable

Where the built-in and sluggish "Windows Add or Remove Programs" option fails, IObit Uninstaller works as always and picks up the slack. This application requires administrative rights. Inconsistent indents. When working in a bulleted list, I use Ctrl-M and Ctrl-Shift-M to invoke the standard Indent and UnIndent commands (i.e., increase and decrease the current indentation).

inconsistent indents

But they don't work consistently. For example, if I start with a new bullet in my current list, I see Left indent set to 0.25". If I hit Ctrl-M once, that gets increased by +0.25" (to 0.50"). But if I hit Ctrl-M a second time, this time it gets increased by +0.50" (to 1.00"), instead of +0.25". Select multiple objects in a PowerPoint slide. Select multiple objects so you can move, format, and even delete related objects at the same time.

Select multiple objects in a PowerPoint slide

Using Shift and Ctrl to create contiguous and non-contiguous blocks of text, file names, and so on is almost second nature to most of us. You might not realize that you can use the same trick to select multiple objects in a PowerPoint slide. Doing so allows you to move, format, and even delete multiple objects at the same time. Click The easiest way to select multiple objects on a slide is to hold down the Shift key and start clicking.

When you have several objects to move as a group, you might prefer the selection box. To format a multiple selection, right-click any of the selected items, and choose Format Object. Use the Selection Pane Starting with Office 2007, you can use the selection pane to select multiple items for moving, formatting, and so on. Click the Home tab.In the Editing group, click the Select dropdown.Choose Selection Pane. Excel - extracting data based on another list.