Excel Formulas

Excel Formula to insert date and time

=now()

Gmail incoming outgoing server setting

Standard configuration instructions:

Incoming Mail (POP3) Server - requires SSL:	pop.gmail.com Use SSL: Yes Port: 995
Outgoing Mail (SMTP) Server - requires TLS3 or SSL:	smtp.gmail.com (use authentication) Use Authentication: Yes Port for TLS/STARTTLS: 587 Port for SSL: 465
Account Name:	your full email address (including @gmail.com or @your_domain.com)
Email Address:	your email address (username@gmail.com or username@your_domain.com)
Password:	your Gmail password

100 MB Partition creation issue during installing windows 7

[Fixed] “Setup was unable to create a new system partition or locate an existing system partition” during installing Windows Vista, 7, 8, 8.1 from USB

If you try to install any version of Windows from USB flash drive you may got this error: “Setup was unable to create a new system partition or locate an existing system partition”

I have found solution that will be suitable for any Windows version.

Basically you just need to copy all installation files from USB flash drive to your HDD (or SSD) drive and make it boot able, and then continue installation from HDD to HDD

Step by step instruction:

1. Boot windows installation from USB drive
2. Press Shift+F10
3. In console type diskpart.exe and press enter. In this program execute following:
   1. select disk=0. Disk 0 is your destination drive, so be careful, all information on this drive will be removed.
   2. create partition primary size=xxx, where xxx – is the size of new partition
   3. select partition=1
   4. active
   5. format fs=ntfs quick
   6. assign
   7. exit, now you have bootable drive C
4. Navigate to USB flash drive, in my case: cd d:
5. Copy all files from USB drive to C: drive: xcopy d: c: /e /h /k
6. Go to boot folder: cd boot
7. Make you C: drive bootable with following command: bootsect /nt60 c:
8. Put off USB drive from computer and restart them.
9. Install Windows
10. Remove unnecessary menu item from bootscreen:
    1. Run cmd.exe as Administrator
    2. See boot menu list bcdedit
    3. Find Windows Setup and copy identifier
    4. Run bcdedit /delete {identifier}