Archive for March, 2009
See Tasks in the Calendar
posted by Rob Johnson on Mar.31, 2009, under Tips
In Microsoft Office Outlook, you can link tasks to calendar days to increase your productivity and provide a record of when tasks were completed. If you complete them on the designated day, they’re linked to that day to show a record of your work completed. If not, tasks roll over to the next day and continue to accumulate until completed. You can see a list of current tasks displayed below a specific day on the calendar. You can add your tasks to the list on any day you choose.
Windows Mail
posted by Rob Johnson on Mar.30, 2009, under Tips
Windows Vista includes a program that can provide you with communications and e-mail access. Although not as comprehensive as many e-mail and communication software packages, it does offer basic management capabilities.
Here’s how to access Windows Mail:
1. Click Start.
2. Click All Programs.
3. Click Windows Mail.
Patch your systems for the conficker worm!!!
posted by Rob Johnson on Mar.29, 2009, under CornDog News
As some of you may be aware, a new worm is on the loose called “Conficker”. It is set to activate itself on April 1st. This one is very serious and can cause a stop to your workflow.
Instructions:
Download the patch from Microsoft here:
If you are infected already, you may not be able to download it, because the worm will block that address. If you can’t, download it from my website:
http://www.corndogcomputers.com/dl/ConfickerPatch.exe
After you download, and install it, let it do a FULL system scan to make sure you are protected. For all of you that I have remote access to your servers, I will remote in and install it today.
Contact me by email if you have questions.
Sorry for the lack of activity…
posted by Rob Johnson on Mar.29, 2009, under Tips
Sorry for the lack of activity. I have been battling computer issues, and finally broke down and ordered a new computer. When it gets here, I get it all setup, I will start posting all the usual info again. Keeping up to date on the site is definitely a priority for me. I need to have the right tools and time to incorporate it into my workflow. I plan on doing a whole new revamp on screencasts by June, (possibly sooner.) So stay tuned for more CornDog info!
Enter a Fraction in a Cell
posted by Rob Johnson on Mar.29, 2009, under Tips
Microsoft Office Excel can display, and take data entry as, fractions as well as decimal numbers. To enter a fraction, simply prefix it with a zero and a space. So to display the fraction one-third, type 0 1/3. This will display 1/3 but will have an underlying value of 0.33333333.
Using the To-Do Bar
posted by Rob Johnson on Mar.28, 2009, under Tips
You can organize your daily activities by using the new To-Do Bar in Microsoft Office Outlook. The To-Do Bar, located on the right side of your Outlook Inbox, brings together tasks, calendar information, and e-mail messages flagged for follow-up into one view. Now you don’t need to switch back and forth between your Inbox, diary, and task list.
Create Random Numbers
posted by Rob Johnson on Mar.27, 2009, under Tips
Sometimes it’s useful to have random numbers in a Microsoft Office Excel spreadsheet—even if it’s just for creating test data. To put a random number in a cell, type the formula =RAND(). For bulk random numbering, copy that formula to a large number of cells—each will be random.
Creating Forms
posted by Rob Johnson on Mar.26, 2009, under Tips
To assist with data entry, Microsoft Office Access 2007 offers different types of forms. To create a simple form:
1. Open the table that has the fields you want to include in your form.
2. On the Ribbon, on the Create tab, click Form.
The split form is new to Office Access 2007, and it enables you to see both a datasheet view of your data and a traditional form view of your data at the same time. You can use the splitter bar to adjust the size of the datasheet.
Add More Levels of Undo
posted by Rob Johnson on Mar.25, 2009, under Tips
You can go back farther in Microsoft Office PowerPoint to undo actions.
1. With PowerPoint open, click the Office button, and then click PowerPoint Options.
2. On the Advanced tab, change the Maximum number of undos from the default 20 to any number from 3 to 150.
Choose a Signature for Different Recipients in Microsoft Office Outlook 2007
posted by Rob Johnson on Mar.24, 2009, under Tips
If you want to use a different e-mail signature for different recipients (a different one for coworkers than for customers, for example), you can change your signature with two mouse clicks. Right-click your signature, and then click the other signature that you want to use.
Rob Johnson