Clear windows 8 startup in registry editor.

Run Regedit

HKCU\Software\Microsoft\Windows NT\CurrentVersion\Windows
Clear any value in key Load

Find out old AC Computers

PowerShell script:

# Gets time stamps for all computers in the domain that have NOT logged in since after specified date

$time = Read-host "Enter a date in format mm/dd/yyyy"
$time = get-date ($time)
$date = get-date ($time) -UFormat %d.%m.%y

# Get all AD computers with lastLogonTimestamp less than our time
Get-ADComputer -Filter {LastLogonTimeStamp -lt $time} -Properties LastLogonTimeStamp |

# Output hostname and lastLogonTimestamp into CSV
select-object Name,@{Name="Stamp"; Expression={[DateTime]::FromFileTime($_.lastLogonTimestamp)}} | export-csv old_users.csv -notypeinformation

Source: http://blog.mattvogt.net/

When VLOOKUP is not working because of numbers stored as text

If you want to store data with leading zero (Format cell-> Special) - you will have problems with LOOKUP formulas because of "The number in this cell is formatted as text or preceded by an apostrophe". The simplest solution is to multiply search range with 1.

Example:
=VLOOKUP($A$2:$A$718*1;Sheet2!$A$3:$B$725;2;FALSE)

Create symbolic link from remote to local folder

To create  symbolic link to remote folder:

C:\Windows\system32>mklink /d "D:\DATA\IT\ISO" "\\SERVER_NAME\ISO"

To check does link already exists

if exist "D:\DATA\IT\ISO" (
goto next
)else (
ECHO Creating Symlcnc...
mklink /d "D:\DATA\IT\ISO" "\\SERVER_NAME\ISO"
)
:NEXT
PAUSE

When access a symbolic link on a file server, sometimes you may see the following error:
"The symbolic link cannot be followed because its type is disabled". This is because by default remote to remote symbolic links are disabled.

You can enable it with fsutil.

C:\Windows\system32>fsutil behavior query SymlinkEvaluation - check status
C:\Windows\system32>fsutil behavior set SymlinkEvaluation R2R:1 - enable from Remote to remote

Run phone activation in windows

Start-> Run slui 4 OK
And you get directly to the windows phone activation screen!

If cannot install .NET framework 3.5 from Windows Update under Windows 8

1. Insert Windows 8 installation DVD
2. Run cmd as administrators

3. Run the following command Dism.exe /online /enable-feature /featurename:NetFX3 /All /Source:D:\sources\sxs /LimitAccess

Excel shortcuts to insert current date and time

Current date     Select a cell and press CTRL+;
Current time     Select a cell and press CTRL+SHIFT+;
Current date and time     Select a cell and press CTRL+; then SPACE then CTRL+SHIFT+;