Sunday, November 30, 2014

Privacy is Gone

Hide that search


We're not alone in the great world-wide internet.

"In 2006, AOL unwittingly divulged the personal lives of 650,000 customers by publishing their search histories as research data. Despite AOL's attempts to anonymize the info, the New York Times quickly outed a 62-year-old lady in Georgia whose searches revealed her dog was wetting the upholstery."

Slate.com



See all Topics

Saturday, November 29, 2014

More than Sudoku

Game with Excel


"IT may be the biggest tool in the Office, but Microsoft Excel can be cool too"

Here's an article on off-prescription Excel.

Play with Excel

Here are some of the games you can play for free:

  • Excel fun

  • 3D Viewer

  • Battleship

  • Blackjack

  • Breakout

  • Golf Stats

  • Mastermind

  • Maze

  • Minesweeper

  • Reversi

  • Rubix

  • Slots

  • Sudoku Solver

  • Tetris

  • Video Poker
ExcelTrick.com  

Mashable.com



See all Topics

Friday, November 28, 2014

25 Chickens and a Rooster

Small change(s)


Changing The Present is a 501(c)(3) nonprofit website offering gifts that make a difference.

Fund A Business
Loan for a woman

International Medical Corps.
Your gift of $200 can help IMC to give a deserving woman a loan to start her own business. Through a proven "community investment" model, women pay back their loans not to IMC, but to a community bank that consists of the pooled contributions of a group of women.

Expand A Business
Loan for a mother
Foundation for International Community Assistance.

Added income from a $50 loan can help a Tanzanian mother expand her business and feed her children more nutritious food.. And you're providing a self-employment loan, not a gift. Your donation will build discipline, responsibility, and self-confidence as women create their own business.


Rent A Market Stall
Loan for a woman
Foundation for International Community Assistance.

With a $100 loan, a Haitian woman can rent a market stall and increase her income two-fold. And you're providing a self-employment loan, not a gift. Your donation will build discipline, responsibility, and self-confidence as women create their own business.


Support Development
25 chickens & rooster
Operation USA.

Give the gift of life – literally! Giving a loan to purchase and raise animals, such as cows, rabbits, sheep, chickens and roosters is the perfect gift for someone who cares deeply about providing opportunity and empowering a family to lift itself out of poverty.




ChangingthePresent.org



See all Topics

Thursday, November 27, 2014

Meeting Methods

More than name tags


Outlook has tools to facilitate:
Appointments, Meetings, and Events


Here are a few of the suggestions:

  • Turn a message into a meeting request
  • Update a meeting request
  • Automatically process requests and responses
  • Counter-proposals for Meeting Times
  • Cancel meeting if you are an attendee
  • Troubleshoot meetings
One of the subjects is: Outlook meeting requests: Essential do's and don'ts
Here are a few of the items:
If you change it, update it:

After modifying one of your own meeting requests, remember to click Send Update to send the updated request to all recipients.
Don't move meeting requests:

Don't move a meeting request from your Inbox to a different folder before you accept or decline the request or before the meeting appears in your calendar. Soon after a meeting request arrives in your Inbox, a piece of Outlook code -- nicknamed the "sniffer" -- automatically adds the meeting to your calendar and marks it as tentative. This is a fail-safe to keep you from missing the meeting in case you don't see the request in your Inbox. However, the sniffer doesn't reply to the meeting organizer. You still need to do that by accepting, accepting as tentative, or declining the request. If you or a rule that you create moves an incoming meeting request from your Inbox before the sniffer can process the request, the meeting never appears in your calendar, and you might miss the meeting.
Get a fresh start:

If a meeting series requires several changes -- a new organizer, a different frequency or time slot, the addition or removal of attendees -- just cancel the series and create a new one. Don't try to modify the original meeting request.
Also:
Slipstick.com:
Scheduling Resources

And:

Meeting Name tags



See all Topics

Wednesday, November 26, 2014

Viewer

Portable PowerPoint



If you have to show your presentation on a machine that does not have PowerPoint installed, you can use " Package for CD. "

Before 2003 it was named "Pack and Go."

Go to File> Package for CD ...
The Dialog box will walk you through the process and offer to include the PowerPoint Viewer.

PowerPoint Viewer

The problem with the earlier versions of PowerPoint, through 2002, was that the viewer only handled the features available in PowerPoint 97.


The PowerPoint 2007 Viewer lets you view full-featured presentations created in PowerPoint 97 and later versions.
Here is the download location for the PowerPoint 2007 Viewer:

PP 2007 Viewer


How to package and copy a presentation to a CD in PowerPoint 2003

PP Tools:
Downloads and descriptions for other versions



See all Topics

Tuesday, November 25, 2014

Medical Untruths

They say it isn't so


For instance:
Everyone must drink at least eight glasses of water a day

This advice is thought to have originated in 1945 from the Nutrition Council in the US, which suggested people needed to consume 2.5 litres of water a day. But the water contained in food, particularly fruit and vegetables, as well as in milk, juice, coffee and soft drinks, also counts towards the total.

Reading in dim light ruins your eyesight

Generations of parents have warned their children not to read in poor light, telling them that it could somehow damage their sight. Though dim lighting can cause stress in the eye, the important thing to remember, say the researchers, is that the effects are not permanent. "Suboptimal lighting can create a sensation of having difficulty in focusing. It also decreases the rate of blinking and leads to discomfort from drying. The important counterpoint is that these effects do not persist."


And more:

The Guardian:
Medical Myths



See all Topics

Monday, November 24, 2014

Resize Form

It's fitting


When you switch between Design and Form views, the size of the form is dictated by the size of the Design view window, not the size of the form sections.

You often need to expand the window to be able to see the rulers and scroll bars in addition to all of the sections. This means you're left with wasted space when viewing the form in Form view, assuming that you forget to shrink the window back down.

A solution to this annoyance is to use the Size To Fit Form feature.

Simply view the form in Form view and choose Window>Size To Fit Form from the menu bar. If your view of the form is maximized, the menu option will be unavailable and you'll need to click the Restore Window button on the form window to enable the choice.

Once Access has resized the form, you can save its current dimensions by clicking the Save button.

With Access 2007+ go to the Office button, choose Access Options and click Overlapping Windows. The Size To Fit Form icon will appear on the Home tab.





See all Topics

Sunday, November 23, 2014

Page Breaks

Demo tutorial


You can control when Word decides to break for a new page.
Ctrl+Enter is the keyboard shortcut, but there are a number of variations.

This MS link has both Demos and text tutorials.
Page breaks

BTW, a merged document is made up of Section breaks, not Page breaks.

For ease of printing, Replace ^b with ^m



See all Topics

Saturday, November 22, 2014

Change Info Box

Make up your own


When you press the Windows key + Break, you'll see the properties window with the standard manufacturer's data/ad.

The How to Geek shows how to change this. There is also a registry file that can be downloaded to make the basic entries.



Customize support info



See all Topics

Friday, November 21, 2014

Word News (Still)

Here's another good newsletter



Editorium
Jack M. Lyon, a book editor who got tired of working the hard way and started creating programs to automate editing tasks in Microsoft Word. He's been editing more than twenty years and started working on the computer in 1985.
(Unfortunately has not published recently, but still full of good information)


A few back issues of Editorium Update arranged chronologically:

  • Deleting Unused Styles
  • Pasting Tracked Revisions
  • Indexing with a Two-Column Concordance
  • Fancy Sorting
  • Editing by Concordance
  • Making a Concordance
  • Numbers by Chicago
  • Fixing Typos Automatically
And more.



See all Topics

Thursday, November 20, 2014

Date Arithmetic

The drunken cousin


Working with dates has a few twists.

Excel believes that time began on January 1, 1900.

Each day since then is counted so that September 1, 2003 in Excel-speak would be → 37,865.
9/1/03 7:33 A.M. is a decimal → 37865.31458333333

When you subtract one date from another, for instance 9/1/2003 (A1)minus 7/4/2001 (A2),
Excel displays the odd answer of → 2/27/1902.

Excel formats the result of a formula with the same format as the source cells,
Right-click the formula cell (=A1-A2).
Select Format Cells ..., and then choose a Number format with zero decimals.

The correct number of days → 789 will now be displayed.

Another way is to use the rarely documented DATEDIF function. Chip Pearson calls it "the drunken cousin of the Function family."

=DATEDIF(EarliestDate,LatestDate,Interval)

=DATEDIF(A2,A1,"d")


Here's THE source for date math:
Chip Pearson:
All About Dates
Also:

John Walenbach:
Extended Date Functions Add-In
"Many users are surprised to discover that Excel cannot work with dates prior to the year 1900. The Extended Date Functions add-in (XDate) corrects this deficiency, and allows you to work with dates in the years 0100 through 9999."


MS Knowledge Base:
How To Use Dates and Times in Excel

The drunken cousin


Working with dates has a few twists.

Excel believes that time began on January 1, 1900.

Each day since then is counted so that September 1, 2003 in Excel-speak would be → 37,865.
9/1/03 7:33 A.M. is a decimal → 37865.31458333333

When you subtract one date from another, for instance 9/1/2003 (A1)minus 7/4/2001 (A2),
Excel displays the odd answer of → 2/27/1902.

Excel formats the result of a formula with the same format as the source cells,
Right-click the formula cell (=A1-A2).
Select Format Cells ..., and then choose a Number format with zero decimals.

The correct number of days → 789 will now be displayed.

Another way is to use the rarely documented DATEDIF function. Chip Pearson calls it "the drunken cousin of the Function family."

=DATEDIF(EarliestDate,LatestDate,Interval)

=DATEDIF(A2,A1,"d")


Here's THE source for date math:
Chip Pearson:
All About Dates
Also:

John Walenbach:
Extended Date Functions Add-In
"Many users are surprised to discover that Excel cannot work with dates prior to the year 1900. The Extended Date Functions add-in (XDate) corrects this deficiency, and allows you to work with dates in the years 0100 through 9999."


MS Knowledge Base:
How To Use Dates and Times in Excel



See all Topics

Wednesday, November 19, 2014

HTML Preview

HTML Tester



There you are, out in the wilderness of PCdom without a copy of FrontPage (Expression) around. How do you find out what HTML tags looks like?
(fire up notepad, save the file, open with a browser)


HTML Preview
Preview HTML in a new window by entering it into the form. This script allows you to pass anything to a new window.
Instructions help you create a preview on your own web page.

Such as:
HTML TEST BED



See all Topics

Tuesday, November 18, 2014

Snowflake Patterns

Cut your own


You can create your own cutout snowflakes and the down load the patterns.









Snowflakes.Barkleyus.com



See all Topics

Monday, November 17, 2014

Quickly Query Table Names

Change by code


If you've ever developed a dozen or more complex queries, then had to change one of the table names, you know how frustrating it can be to all but rebuild the queries in the Query Design view grid by changing the table name in each cell.

One quick alternative is to choose View >SQL View while the query is open and then cut and paste all the SQL code into Word.

Next, do a Find and Replace, changing all the instances of the old table name to the new table name.

Finally, copy and paste the SQL statements back into the SQL view of your Access queries.

When you go back to the QBE, the new table will replace the old one.





See all Topics

Sunday, November 16, 2014

Reset Shortcut Menu

Context menu redo


For some reason (to be determined later) my shortcut menu started to accumulate a string of "Edit Formula" and "Delete Formula" entries.

They didn't cause a problem, but were distracting.

This little VBA code puts it back to the original settings until I can find a cause.



Sub ResetShortcutMenu()
Application.CommandBars("Cell").Reset
End Sub


Macros that Customize and Control Shortcut Menus



See all Topics

Saturday, November 15, 2014

Office VBA Tricks

Video + Free code


"Learn tips and use sample code for several Office applications. These tips can help you to be more productive and can also be a starting point for developing your own tools, utilities and techniques."

  • Update Word Document Statistics in the Title Bar
  • Create Outlook Rules Programmatically
  • Delete Repeated Text Throughout a Word Document
  • Run Macros Based on the Value of One or More Excel Spreadsheet Cells
  • Disable Related Controls on a PowerPoint Slide After a User Clicks an Input Control
  • Display Reminder Information When a User Opens an Office Document
  • Synchronize an Access Main Form to a Subform and Vice Versa
  • Log Worksheet Changes to an XML File
  • Merge Body Text from Multiple Outlook E-mail Messages to a Word Document
  • Use the Office Assistant as an Alternative to Displaying and Retrieving User Input
Ten Tips for Office VBA Developers

VBA Tips & Tricks

Getting Started with VBA in Office 2010

Download Office 2013 VBA Documentation


(VBA is VBA and is, in most cases, usable in all versions of Office)



See all Topics

Friday, November 14, 2014

Background Templates

Fresh material



After seeing a few PowerPoint presentations, all of the backgrounds and graphics included with Office, start to look alike.

Luckily, there are generous folk who supply fresh material.

Sonia Coleman is one of the best.

She presents over 200 templates for download.

Free PowerPoint Templates

Explore the rest of her site including the Gallery section

Also see:

PoweredTemplates.com



See all Topics

Wednesday, November 12, 2014

Onscreen Keyboard

Tap or Click?


If you would like to have a keyboard on your screen that can be activated with your mouse you're in luck

Type osk in Start Run





See all Topics

Add Objects to the Query Grid

Easy additions


If you need to add a table or query to a query you're building in Design view, you most likely click the Show Table button, drag the appropriate objects from the resulting dialog box, and then close the dialog box.

However, there's a much easier way to do this.

Simply drag the table or query object's icon directly to the gray background of the query design grid. This same technique also works with the Access Relationships window.



See all Topics

Tuesday, November 11, 2014

Chiropractics for Excel

Knead and pound numbers

Chad Rothschiller, a program manager on the Excel team, discusses using formulas to 'clean up' data in Excel.


Excel is a great tool to use when you need to take data in one format, manipulate it into another format, and push the results along to another process, e.g. a database. In this context, Excel is a great landing pad or middle man, serving as a data transformation tool to move data from one system to another.

This example considers a sample data set and walks through the steps to clean up the data and perform various transformations on the data set to massage it into a more desirable format.


I'm sure you've been faced with at least one of theses problems:

  • Import the data and don't accidentally drop the leading zeros!

  • Formatting SSN

  • Inserting hyphens

  • Fixing up names

  • Lower case E-Mail Address

  • Format Home Phone

  • Inserting parenthesis & hyphens

  • Trim extra spaces from Address

  • Add City values to the new table

  • Make all State value upper case

  • Fill in Postal Code

  • Finalize the values
Manipulate and massage  



See all Topics

Monday, November 10, 2014

Image Sources

No cost


After awhile the graphics in Office Clipart or even the ones found on Microsoft's Office online appear the same.

Here is a list of 100 locations for royalty free stock images.




Free stock images



See all Topics

Sunday, November 09, 2014

Resetting the Body Clock

So very SAD


SAD

A wistful feeling comes over us in late autumn, as the last remaining leaves drop, morning frosts cover the ground, and the sun sets earlier each day. Hot cider and the warmth of a favorite old coat may be all you need to face the coming winter with good cheer, but for many people, fall melancholy deepens to winter depression.


Winter depression is still a mystery to scientists who study it. Many things, including brain chemicals, ions in the air, and genetics seem to be involved. But researchers agree that people who suffer from winter depression -- also known as "seasonal affective disorder," a term that produces the cute acronym SAD -- have one thing in common. They're particularly sensitive to light, or the lack of it.

"Research shows that bright light visual stimulation (light which enters the eyes), can change the timing of the body clock and its timing of sleep or awakening signals to the body. Thus, bright light therapy has been used to treat the range of disorders caused by a mis-timed body clock including shift work, jet lag, sleep onset and early morning insomnia mentioned above as well as winter depression (Seasonal Affective Disorder, SAD)."

"Probably the greatest use of bright light therapy is for the treatment of winter depression, especially in very northern countries which have little sunlight in the winter months. These sufferers appear to have delayed body clocks and benefit most from morning light therapy.

At present, the blue LED glasses are still experimental devices. They are not yet commercially available. The Flinders University owns the intellectual property rights and a provisional patent. A commercial partner to manufacture and market the devices under license is still being sought."

Seasonal Affective Disorder



See all Topics

Saturday, November 08, 2014

Drawing Canvas

More than I want


The Draw layer has been around since about Word 97, but it has not been as intrusive as it is in Word 2002+.

Try to place an AutoShape on a page and the Drawing Canvas pops up by default.

To turn off this feature, go to:
Tools>Options.
On the General tab, remove the check mark from
"Automatically create drawing canvas when inserting AutoShapes"

To just dismiss it each time, choose your AutoShape and then touch the Delete or Esc key before drawing the object.

Here's some more information.


Knowledge Base
General Information About Floating Objects
(a discussion of Word's floating objects and layers)

As I understand it, the Drawing canvas is not really a new layer. The following illustration shows the classic layers. It is from the Knowledge base article:
How to Place Text over a Graphic


___________________
/                   /
/   <SURFACE OF     /
/       PAPER>      /
/                   /  /
Front drawing layer  -------------------  /
MAIN TEXT LAYER  =================== / /
Back drawing layer  -------------------/ / /
/ /
Front drawing layer  -------------------/ /
(Header/footer) BOTTOM TEXT LAYER  =================== /
Back drawing layer  -------------------/



You can dump the layer in 2007 in the Office button Word Option equivalent of Tools>Options:



Smart Art 2013



See all Topics

Friday, November 07, 2014

Free Contact Templates

Free electronic business cards


Microsoft has business card templates that can be used in Outlook.

Just download the file and edit the information.



Contact Cards



See all Topics

Thursday, November 06, 2014

Keyboard Alt Codes

Quick inserts


Here is a collection of Alt codes. There is also a free download that you can post near your computer.

  • Alt Codes for Letters with Accents for Languages
  • Alt Codes for Bullets, Symbols and Other Special Characters
  • Alt Codes for Mathematical Symbols - Symbols used in Mathematics
  • Alt Codes for Currency Symbols
  • Alt Codes for Drawing
  • Alt Codes for Characters from the Greek Alphabet
  • Alt Codes for "Additional" Letters particularly for Nordic / Scandanavian Languages
  • Alt Codes for Spanish
  • Intellectual Property Right symbols.
  • Alt Codes for Arrows
  • Alt Codes for Punctuation and Editing
  • Alt Codes in Computer Programming
Alt Codes



See all Topics

Wednesday, November 05, 2014

Shuffle Music

Like those fruity machines


Microsoft Media player can do more things than just play the odd sound file. You can set it up to go through a play list is random order; playing music all day long.



Shuffle Sort



See all Topics

Tuesday, November 04, 2014

IE Temp Files

Storage area


Every once in awhile when the Berners-Lee pipeline clogs up, you are instructed to delete the temporary files that IE saves.

You can do it with the Click of an IE Options button.

Here's where those files are stored:




As you see, you could move that location if you wanted to.

Ed Bott mentioned this in his Blog:

Finding the Temporary Internet Files folder



See all Topics

Monday, November 03, 2014

Spreadsheet Boo-Boos

Design suggestions


A few links to sites with advice on spreadsheet design and error detection.

European Spreadsheet Risks Interest Group:
Spreadsheet mistakes - news stories

Microsoft Assistance:
Worksheet design strategy



Raymond R. Panko, PhD University of Hawaii
What We Know About Spreadsheet Errors



See all Topics

Sunday, November 02, 2014

YouTube in PowerPoint

Imbedded videos


Shyam Pillai has provided a free wizard to imbed YouTube clips into a PowerPoint Presentation

"Use this to insert YouTube videos into a PowerPoint slide. All you need to do is to provide the YouTube video URL that appears in the browser address bar, the rest is taken care of by the YTV Wizard.

Note: YouTube videos are streamed so a live internet connection is required to playback the video during the slideshow. Use the free FlashBack add-in to play/rewind the YouTube video automatically."

YouTube Video Wizard



See all Topics

Saturday, November 01, 2014

Gmail Features

The top 10


Bill Kee, Associate Product Marketing Manager for Gmail, has a blog and has listed 10 major features of the free web based email system.
Including:

"When you get an email that references an address, look to the right and you'll probably see a link from Gmail pointing you to a map of the address on Google Maps.

Gmail also recognizes email text that refers to an event (e.g., 'dinner tomorrow at 8pm'), and will give you a link to add it to your calendar.

It'll even pick up on package tracking numbers from UPS and link you directly to the tracking page, so you don't have to copy and paste the number. I really like this last one when I order stuff online and want the instant gratification of knowing a package is on its way.


Gmail features Part 1

Gmail features Part 2



See all Topics