Thursday, September 29, 2016

Color Scales

Conditional colors

Here is some information on Conditional color scales in Office 2010.

Excel-Easy



See all Topics

Wednesday, September 28, 2016

Where's the Template?

Find and/change storage spots



Describes the different template categories and the locations of templates in 2007 & 2010 Office programs. Also describes the registry settings that control where to find your custom templates.

Support.Microsoft.com



See all Topics

Tuesday, September 27, 2016

Character Codes

HTML and ALT+


Here's another table with the codes needed to insert characters that do not appear on the keyboard:

Keyboard Shortcuts



See all Topics

Monday, September 26, 2016

Clean PC

Wash and dry

"Your computer could fry if you don't keep it clean," says Jonathon Millman, chief technology officer for Hooplah Interactive.
Dust clogs the vents behind your computer, which causes your CPU to heat up—and heat is the biggest cause of component failure in computers. Regular cleaning could save you costly maintenance fees down the road.
Here are some suggestions for Winter/Spring/Summer/Fall cleaning:

PC Gamer



See all Topics

Sunday, September 25, 2016

Presentation Tips

Start with the end in mind


"Before you even open up PowerPoint, sit down and really think about the day of your presentation. What is the real purpose of your talk? Why is it that you were ask to speak? What does the audience expect? In your opinion, what are the most important parts of your topic for the audience to take away from your, say, 50-minute presentation?

Remember, even if you've been asked to share information, rarely is the mere transfer of information a satisfactory objective from the point of view of the audience. After all, the audience could always just read your book (or article, handout, etc.) if information transfer were the only purpose of the meeting, seminar, or formal presentation."

Garr Reynolds has more tips on presentations, delivery, and slide design:


GarrReynolds.com



See all Topics

Saturday, September 24, 2016

Outlook Tips

Suggestions

Outlook-Tips.net was put together by Diane Poremsky

Outlook-Tips.net



See all Topics

Friday, September 23, 2016

CSS Coding

Put by the keyboard

Cascading Style Sheets (CSS) is a simple way to define styles (e.g. fonts, colors, spacing) on Web pages.
Of course there is coding involved. Here is a printable cheat sheet you can keep close at hand.

LeslieFranke.com



See all Topics

Thursday, September 22, 2016

Help IDs

VBA code

When you build a macro, you can call up information from the Excel Help file.
Ron DeBruin has the information needed through 2007-2013.

Right clicking the Helpfile and choosing Properties will show the HP####### number in 2010+.

Help Context IDs for Excel



See all Topics

Wednesday, September 21, 2016

Dryer Sheet Uses

Not just for machines


Use Dryer Sheets to:
  1. Freshen smelly shoes.
  2. Remove static from clothing, hair, TV screens, and computer monitors.
  3. Clean pet hair from the floor or furniture.
  4. Replace a sachet.
  5. Loosen caked-on food from a pan.
  6. Tackle suitcase and gym-bag odors.
  7. Prevent old books from smelling musty when in storage.
  8. Wipe up sawdust after working in the garage.
  9. Prevent thread from tangling when sewing.
  10. Dust venetian blinds.
RealSimple.com

DoItYourself.com

Curbly.com



See all Topics

Tuesday, September 20, 2016

Access Transition Tutorials

Available in PDF


This collection relates to the transition to 2007, but most are also appropriate for 2010+.

"The main intent of these tutorials is to guide frequent users of Microsoft Access through the transition of earlier versions to the new 2007 edition. Throughout the different tutorials . . . topics from program specifications through features added, dropped, or unchanged as well as demonstrating implementations of subjects discussed."
  • Microsoft Access 2007 in the box (Office editions and what's new)

  • Microsoft Access Head-to-Head (Access 2003 vs. Access 2007)

  • Microsoft Access Side-by-Side (Access 2003 vs. Access 2007 continued)

  • Microsoft Access 2007 PDF and XPS support

  • Microsoft Access 2007 Ribbon/Office menu customization

  • Microsoft Access 2007 Navigation Pane customization

  • Microsoft Access 2007 Working with the Attachment DataType

  • Microsoft Access 2007 Working with the Rich Text Feature

  • Microsoft Access 2007 Collect Data Through Emails

Access-Freak.com



See all Topics

Monday, September 19, 2016

Merge to PDF

Not just MailMerge anymore

Sure, you can create a merged letter and have 30 pages of individualized information.
What now? How do you create separately named documents to, maybe, send as attachments?
Another task might be to convert those 30 docs to PDF. Oh, the hours wasted!

Graham Mayor, a retired newsgroup junkie, offers a solution.
It's a macro that will convert the merged output as individually named doc(x), and/or PDF files.
I've used it, and now wonder what I can do with the time I'm saving.



GMayor.com



See all Topics

Sunday, September 18, 2016

Slide Show Flash

PPT to SWF

"ANVSOFT Flash Slide Show Maker is a Flash album creator that will help you build animated photo slideshows with SWF file as the output format."

Anvsoft.com
Photoaxe.com



See all Topics

Saturday, September 17, 2016

Name That File

Rules, more rules


There are still some restrictions on what a file can be named. Here are a couple of links that give more details:

VLaurie.com

MSDN.Microsoft.com

Microsoft.com



See all Topics

Friday, September 16, 2016

Customize Your Calendar

Do it your way

. . . you can view your days and weeks in increments of 5 minutes, 60 minutes, and a variety of periods in between. You can adjust the view of your calendar according to your work week and work day; for instance, you can display Sunday through Thursday and show a normal day as being 11 in the morning to 7 in the evening if you like. Use different color schemes, and show more or less detail in your calendar.

Office.Microsoft.com



See all Topics

Thursday, September 15, 2016

Text Files to Excel

A hard way to do an easy job

Text files can be imported or just pasted into Excel. If you want to learn more about SQL statements and non-code coding, look at this blog:
"Excel doesn't have an easy way to append multiple text files into one worksheet through the user interface. From time to time I hear customers asking how to do this in an easy way. Do you have to use Access or VB code to solve this problem? No. There's a way to do it in Excel by using a simple SQL statement in the connection string."
Use a text file:

Blogs Office.com



See all Topics

Tuesday, September 13, 2016

Merge Access with Word

Database integration



"You can merge Microsoft Office Access 2007+ data with a Word 2007+ document by using the Mail Merge Wizard. This demo shows you how to create a simple form letter and how to troubleshoot problems. You can also use this feature to create address labels or any other type of Word document in which you want to display Access data."
MailMerge Access-Word



See all Topics

Monday, September 12, 2016

Hard Drive Innards

Hidden workings


Early on computers did not always have "Hard drives". The TRS-80 worked off a portable tape recorder.
If you want to see how they work today, look at:
HowStuffWorks.com

Here are a couple of videos that explore the entrails.

Break.com-Inside a Hard Drive

and

How a Hard Drive Works



See all Topics

Sunday, September 11, 2016

Taskmanager Look

You control


"If you want to leave your Task Manager showing on your desktop for a period of time, it can be nice to hide the title bar and gain that space for displaying more information. To do this, simply double-click on the empty area to the right of the tabs. Once it has switched views, you can switch back quickly by double-clicking anywhere on the border."



DigitalTrends



See all Topics

Saturday, September 10, 2016

PowerPoint 2010+

PowerPoint 2-10-13


Here's a preview of what PPT2010 and 2013 can do with animation and presentation.



MSDN PowerPoint Blog



See all Topics

Friday, September 09, 2016

Automate Shutdown

Close everything

It's generally considered good form to close all forms and reports when you're shutting down a database.
Here's a link to some code that takes care of it for you.

Microsoft.com



See all Topics

Thursday, September 08, 2016

Typography and Word

Shape and display

Here are some suggestions about how to make your text easier to read.

"Ever wonder why some text seems easier to read than others? A few basic formatting changes can make reading text much easier. Factors like line spacing, font choice, font size and margins are key to legibility. "

Office.Microsoft.com



See all Topics

Wednesday, September 07, 2016

Signature Move

Sign it your way

Here is a tutorial about Outlook pre-set signatures:

"Signatures can be created in different formats and it can contain various elements. A basic signature will have just the sender’s name. Along with the name you can include acknowledgments like "Thank you", "Yours Lovingly", etc. Official or business signatures will have company name, contact number, company address, website URL, etc. Company logo or any other relevant graphic can also be used. Any text in the signature can be hyperlinked. Sometimes electronic business card or scanned signature is also used. The text of the signature can be formatted to make it more attractive. Occasionally signature will also contain disclaimer blocks like stating, "If you are not the intended recipient of the e-mail then you should delete the e-mail".


Office-Watch.com



See all Topics

Tuesday, September 06, 2016

Convert to B&W

Photoshop tip


Pictures can be converted to black and white by just clicking on an action off of the menu.
If you want to have more control, here is a step by step instruction list.

GingerPixel.com



See all Topics

Monday, September 05, 2016

Keyboard and Key Tips

Finger it out



2007-13 apps look different because of the ribbon, but the keyboard can still be used to speed up tasks.
Microsoft has an online courses that may help

After completing this course you will be able to:
Accomplish tasks by using sequential shortcut keys, known as Key Tips, shown on the Ribbon.
Navigate around the Ribbon using the TAB key and arrow keys.
Accomplish tasks by using key combinations — keys you press at the same time - exactly as you've done in previous versions of Office.
Office.Microsoft.com/Training



See all Topics

Sunday, September 04, 2016

New Calendars

Another year

Here are free Excel calendars for downloading.

Twelve months on one sheet or one month per tab.



DotXLS.com



See all Topics

Saturday, September 03, 2016

Print Spool Cleaning

When all else fails

When you can't get a document out of the Print queue, here's a suggestion:

Type "services.msc" at the Command prompt. That will open the Services
Window.

Scroll down the alphabetical list in the right window pane until you come
to "Print Spooler"

Right-click this entry, then select "stop".

Open Windows Explorer.

The usual path to the spool folder is:
C:\WINDOWS\System32\Spool\PRINTERS

Delete every file within this folder to empty the print queue

Close the explorer window.
Return to your Services window.
Right-click the Print Spool entry and select
"Start" from the list. Close the services window and try printing again.

(You can also go to a command prompt and type net stop spooler or net start spooler to start and stop the service.)

See TopFreeStuff.com

For the brave, here’s a macro that will do the job:

@echo off
echo.
echo Purging the print queue . . .
net stop Spooler
echo Deleting all print jobs . . .
ping localhost -n 4 > nul
del /q %SystemRoot%\system32\spool\printers\*.*
net start Spooler
echo Done!
ping localhost -n 4 > nul




See all Topics

Friday, September 02, 2016

Forms in Word

With and without code


Data entry forms can be designed and presented using VBA code. Another simpler way to do it is to construct a form directly in the Word document.
"Have you ever been asked to fill out a form in a word processor, only to discover that when you attempted to enter information, the lines on the form moved all over the page? Not to mention that the form was difficult and time-consuming to fill out? Most people don't realize that you can easily create professional-looking forms in Word."
  • Part I: Create professional looking forms in Word

  • Part II: Adding Automation to your Word forms

  • Part III: Learn more about VBA macros to automate your form

  • Part IV: Use custom dialog boxes in your Word forms

  • Part V: Linking your AutoForm to a database
Please Fill Out This Form!

By Dian Chapman at TechTrax

Also:

 Fun with Forms

Cindy Meister

Word on YouTube



See all Topics

Thursday, September 01, 2016

Chart Null Data Gaps

Fill in the spaces



When creating a chart, data can sometimes be missing. You have a choice of leaving the cells empty or making them zero.

By default, an empty cell will leave gaps in your graph. Zero entries will send a line graph down to the base line.

One way to force Excel to interpolate the data is to enter the function =NA() in the empty cells.

Another way is to go to Tools>Options and choose the Chart tab.

Pick how you want data plotted - with gaps, as zero, or interpolated.






Microsoft also has this suggestion:

Gaps between the dates
"If the datasheet data for the category axis contains date number formatting, Microsoft Graph automatically uses a special type of axis in your chart called a time-scale axis.
A time-scale axis shows a blank category for dates for which you have no data. If you do not want to see these gaps — for example, if you have data for 1-Jan, 15-Jan, 3-Feb, 12-Feb, and 2-Mar, and you want to plot the days next to each other - you can change the time-scale axis to a standard category axis.
On the Chart menu, click Chart Options, click the Axes tab, and then click Category under Category (X) axis."

Note, For 2007+, on the Design tab, click Select Data in the Data area, and then click Hidden and Empty Cells on the Select Data dialog box.



See all Topics

Wednesday, August 31, 2016

Close Forms

Auto Shutdown

Here's how to close a form after it’s used:

  1. Open the first form in Design view.
  2. Double-click the Form Properties button.
  3. Click on the Event tab.
  4. Click in the On Deactivate text box.
  5. Select Event Procedure.
  6. Click the Build button.
  7. At the prompt, enter: Me.TimerInterval =1.
    (Try something like 30000 milliseconds)
  8. Press [Alt][Q].
  9. In the Form Properties window, click in the On Timer property text box.
  10. Select Event Procedure.
  11. Click the Build button.
  12. At the prompt, enter: DoCmd.Close.
  13. Press [Alt][Q].
  14. Save the form.

Microsoft Support



See all Topics

Tuesday, August 30, 2016

Time it Right

No need to wind your PC


Windows will go out to the Internet to verify or correct its time settings.


"If you wish to check your synchronization settings, look for the clock at the bottom right and double click on the time to bring up your time settings.
  • You can adjust your local time and date by hand on the first tab,
  • you can adjust your time zone location on the second,
  • and on the third, labeled Internet Time, you can view your current atomic clock sync settings."


Worldtimeserver.com:
Atomic Clock Sync Settings

National Institute of Standards and Technology:
Time and Frequency Division

Time signals can also be heard on shortwave radio or by phone.
"The audio portions of the WWV and WWVH broadcasts can also be heard by telephone.
The time announcements are normally delayed by less than 30 ms when using land lines from within the continental United States, and the stability (delay variation) is generally 1 ms.
When mobile phones are used, the delays are often more than 100 ms due to the multiple access methods used to share cell channels.
In rare instances when the telephone connection is made by satellite, the time is delayed by 250 to 500 ms.
To hear these broadcasts, dial (303) 499-7111 for WWV (Colorado), and (808) 335-4363 for WWVH (Hawaii). Callers are disconnected after 2 minutes. These are not toll-free numbers; callers outside the local calling area are charged for the call at regular long-distance rates.

The telephone service is very popular. The WWV number receives over 1 million calls per year, and the WWVH number receives more than 50,000."



See all Topics