February 18th 2007
Tags:
Tips 'n Tricks,
Web
No Comments
Google Tutor gave some valuable information out about creating better links in relation to the Google search engine. The gist of it is that when you make a link with text like "click here" the search engines are not indexing the link effectively.
No matter how intelligent Google may seem ...
One thing I've found annoying about the way Windows handles the display of open applications is the inflexibility in the Taskbar. With XP they gave the ability to group Taskbar items from the same application together, but still no way for me to organize the lineup how I really ...
This is old news by some measure, but it is a timeless piece of trickery with Excel.
Make a calendar in Excel:
=IF(MONTH(DATE(YEAR(NOW()),MONTH(NOW()),1))
<>MONTH(DATE(YEAR(NOW()),MONTH(NOW()),1)-
(WEEKDAY(DATE(YEAR(NOW()),MONTH(NOW()),1))-1)+
{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1),"",DATE(YEAR(NOW()),
MONTH(NOW()),1)-(WEEKDAY(DATE(YEAR(NOW()),
MONTH(NOW()),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1)
To use it:
Copy the formula text to the clipboard
Activate an Excel sheet and select a 7-col by 6-row range
Press F2
Press Ctrl+V to paste the formula into the active cell
Press ...
I used to work for a financial analysis company developing Excel macros/applications in VBA. There were -- and still are -- some 10th level Excel blackbelts that work there. I picked up quite a few keystroke tricks while working there. Even though I don't work there anymore, ...