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…
-
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…
-
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…