Year: 2015

  • Excel Keyboard Shortcuts

        Action Shortcut Bold the selection Ctrl+B Italicize the selection Ctrl+I Underline the selection Ctrl+U Strike through the selection Ctrl+5 Open the Style dialog box Alt+’ Open the Format Cells dialog box Ctrl+1 Apply the General format Ctrl+Shift+~ Apply the Currency format Ctrl+Shift+$ Apply the Percentage format Ctrl+Shift+% Apply the Date format Ctrl+Shift+# Apply…

  • Using VLookup for Excel

    Credit – gcflearnfree.org How to use Excel’s VLOOKUP function Many of our learners have told us they want to learn how to use Excel’s VLOOKUP function. VLOOKUP is an extremely useful tool, and learning how to use it is easier than you think! Before you start, you should understand the basics of functions. Check out our…

  • Favorite Yoda Sayings

    Favorite Yoda Quotes   “Fear is the path to the dark side. Fear leads to anger. Anger leads to hate. Hate leads to suffering.” “Death is a natural part of life. Rejoice for those around you who transform into the Force. Mourn them do not. Miss them do not. Attachment leads to jealously. The shadow…

  • Older_than:365d – Gmail Delete old emails

    Older_than:365d Search for gmails older than 365 days search for old gmails delete old gmails filter gmails Or use Older_than:400d To search for all emails older than 400 days old.

  • WD My Cloud Configuration Notes

    You need to make sure that the following 4 settings are set to “Automatic” and that they are (even) started: 1. DHCP Client 2. NET TCP Port Sharing Service 3. SSDP Discovery 4. UPnP Device Host For the technically challenged, the way that you access the above settings is to: 1. Right click on My…

  • Windows 7 Login to Windows 2000 Servers

    On the Workstation 1. Run regedit. 2. Navigate to: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa 3. Create a DWORD value under Lsa LmCompatibilityLevel 4. Set the value to 1 5. quit regedit 5. from Start/Run type gpupdate /force     On The Files Server On Windows 2000 Server: go to start, run, type gpedit.msc and click ok. Under computer comfiguration,…

  • Deleting Carriage Returns in Microsoft Word

    ^p = carriage return ^l = a line break (that’s an L) Using Find and Replace Sometimes, however, you will not want to paste as unformatted text. In that case, what you will most likely get is text with a line break at the end of each line. Provided there is an empty line at…

  • Alexander the Great

    ALEXANDER THE GREAT Raphael’s AlexanderAlexander III of Macedon—Alexander the Great (356 to 324 B.C.)—was perhaps the greatest conqueror of all time. In 334 B.C., at the age of 21, he left the small Greek of Kingdom of Macedonia with 43,000 foot soldiers and 6,000 horsemen to seek revenge against the Persian empire, which had sacked…

  • Confucius Proverbs

    1. Never impose on others what you would not choose for yourself. “Never impose on others what you would not choose for yourself.” ~ Confucius 2. To see and listen to the wicked is already the beginning of wickedness. “To see and listen to the wicked is already the beginning of wickedness.” ~ Confucius 3.…

  • Davao Philippines Annual Weather Pattern

      * Coolest Months:  January, December, February, July * Hottest months:  April, October   The warm season lasts from March 27 to May 10 with an average daily high temperature above 90°F. The hottest day of the year is April 10, with an average high of 91°F and low of 76°F. The cold season lasts from December 25 to February 1 with an average daily high temperature below88°F. The coldest day of…