Friday, October 31, 2014

Web Data

Numbers from the ether


Excel has had a feature called web query. Here's an add-in that makes it a little easier.

"The Excel 2007 Web Data Add-In makes it easy to use a Web page as a data source in Excel.

The add-in plugs into Excel 2007 seamlessly, its entry point located on the Data Tab under the From Web option. The system extracts data by learning from a user’s selection of data they wish to capture into Excel. The more selections, the more the system is trained."



Web Data

Getting data from the Web in Excel

2013 Web Data YouTube



See all Topics

Thursday, October 30, 2014

Charity or Scam

IRS worthy or not


Did someone call asking for money for the Global Relief Foundation, Inc. or some other charitable organization?

You can look them up with the IRS.

BTW, you might think again about these groups:
  • Benevolence International Foundation, Inc.
    Palos Hills, Illinois

  • Global Relief Foundation, Inc.
    Bridgeview, Illinois

  • Holy Land Foundation for Relief and Development
    Richardson, Texas

  • Rabbi Meir Kahana Memorial Fund
    Cedarhurst, New York
Search for Charities  

Revoked by IRS 


Here's the site for Washington state:
Secretary of State



See all Topics

Wednesday, October 29, 2014

Outlook Shortcuts

Good Strokes


Check names--------------------------------------Ctrl + K or Alt + K
Check spelling-----------------------------------F7
Choose the account from which to send
a message(with focus on the To line)
and then TAB to the Accounts button------------Ctrl + TAB
Convert an HTML or RTF message to plain text-----Ctrl + Shift +O
Delete a mail message----------------------------Delete or Ctrl + D
Display the Address Book-------------------------Ctrl + Shift + B
Find a message ----------------------------------Ctrl + Shift + F
Find text----------------------------------------F3
Forward a message--------------------------------Ctrl + F
Go to folder-------------------------------------Ctrl + Y
Go to next mail message--------------------------Down or Up arrow
Insert signature---------------------------------Ctrl + Shift + S
Mark a message as read---------------------------Ctrl + Enter or Ctrl + Q
Move between the Folders list and message list---Tab
Open or post a new message-----------------------Ctrl + N
Open the Address Book----------------------------Ctrl + Shift + B
Open the Inbox-----------------------------------Ctrl + I
Open the Outbox----------------------------------Ctrl + O
Open the selected message------------------------Ctrl + O or Enter
Post to a folder---------------------------------Ctrl + Shift + S
Print the selected message-----------------------Ctrl + P
Reply to a message-------------------------------Ctrl + R
Reply to all-------------------------------------Ctrl + Shift + R
Send (post) a message----------------------------Ctrl + Enter or Alt + S
Send and receive mail----------------------------Ctrl + M or F5
Switch among Edit, Source, and Preview tabs------Ctrl + Tab
Switch to Inbox----------------------------------Ctrl + Shift + I
Switch to Outbox---------------------------------Ctrl + Shift + O 


Royal National Institute of the Blind:
Outlook Keyboard Shortcuts

Outlook 2013 shortcuts



See all Topics

Tuesday, October 28, 2014

MHTML

One file web pages



When a web page is created using HTML, the coding is normally contained in one file and the graphics in separate folders.

The Mime HTML or MHT/MHTML format changed that.

Starting with Office 2000 as an add-in and carried through XP as a "Web Archive" option, the format emerged in Office 2003 as a "Single file web page" selection in the File Save As dialog box.

Here are the Save As choices available in an application such as Word:
  • Web Page, Complete means that the contents of the page (including any pictures) will be saved into a folder as separate files, similar to those on the server hosting the site.

  • Web Page, HTML only means that only the HTML information will be saved. This option and Web Page, Complete will enable you to open the file for viewing in Internet Explorer (or any other browser) at a later time, even when you are offline.

  • Web Archive means that the page will be saved, along with any images it contains, as a single file. You can view a Web Archive later without being connected to the Internet.

  • Text File means that only the text on the page will be saved, not the HTML (or any other) formatting, including graphics.
MIME Encapsulation of Aggregate HTML Documents (MHTML)  

Short Summary of the MHTML Standard



See all Topics

Monday, October 27, 2014

Product Key Finder

Search machine


You have a legal copy. You installed it and activated the application.

Now your machine blew up and you have to install it again. Where's the Product key? Probably gone sometime in the past 10 years.


"The Magical Jelly Bean Keyfinder is a freeware utility that retrieves your Product Key (cd key) used to install windows from your registry.

It has the options to copy the key to clipboard, save it to a text file, or print it for safekeeping.

It works on Windows 95, 98, ME, 2000, XP, Server 2003, Windows 7, Office XP, Office 2003, and Office 2007-10.


Keyfinder



See all Topics

Sunday, October 26, 2014

New Tables in Town

Bigger and better (?)


Pre '07 versions of PowerPoint limited tables to a maximum of 25 rows and columns. You were able to ungroup the table cells before, but that has been taken away.


"In this release, we have increased that maximum to 75x75 within the UI.

We were able to do this because we made the decision to move away from the metaphor of a table simply being a group of shapes, as it was in previous versions.
This has been one of the largest enabling factors in our performance gains, and as a result, tables are workable at sizes much greater than that of 25x25.

A tradeoff made in order to obtain these gains in performance was the ability to "ungroup" a table.

While this tradeoff means that there are a set of scenarios no longer present, specifically the ability to ungroup a table to animate individual pieces, we feel that the performance gains (not to mention all the other aspects talked about in this section of the blog) along with the ability to use multiple tables and/or shapes in these scenarios will benefit users in a much greater way."

PowerPoint Tables

It can still be done:

Workaround for animating a table:

  1. Right-click the table, choose Save as Picture

  2. Save as EMF (choose EMF from the "save as type dropdown list)

  3. InsertPicture, insert the EMF

  4. Ungroup the EMF twice

  5. Now regroup the parts you need to animate -- rows, columns, or whatever
microsoft.public.powerpoint



See all Topics

Saturday, October 25, 2014

Mailbox Diet

Prune the fat


Microsoft provides a tutorial on the mechanics of Outlook 2007 mailboxes.
Learning how to manage your Microsoft Outlook 2007 Mailbox and keep it within a specific size limitation.

After completing this course you will be able to:

  • View the size of your mailbox and its folders.

  • Understand what makes an e-mail message big and find the size of any message.

  • Set up some simple processes and use tools built into Outlook to prevent e-mail pileup from happening in the first place.
Battle mailbox size  

Performance problems with a large .pst file  

Manage with Mailbox Cleanup



See all Topics

Friday, October 24, 2014

DOS were the Days

Take CMD


Here's an introduction to the Command Prompt:
Command Line


Microsoft has provided product documentation on the use of the Command line in Windows.

Hopefully this won't be something you need in an emergency.
Use it in good health.

Details for Command line

  • Cmd
  • Command-line reference A-Z
  • Command shell overview
  • Change the command history settings
  • Change the size of the command prompt cursor
  • Change command prompt display option settings
  • Change the command prompt screen layout
  • Change command prompt window Edit Options settings
  • Copy and paste MS-DOS text using the mouse
  • Change MS-DOS command prompt window fonts
  • Change colors of command prompt elements




See all Topics

Thursday, October 23, 2014

Move the Show

Portable hints


A speaker can be called upon to present programs almost anywhere. Every site is unique and has its own problems. Your show may, also, have to be sent out on its own.

Here are some suggestions that may help on the road:

Distributing PPTs - Pitfalls, Panics & Pleasures
By Steve Rindsberg

There are several potential problem areas:
  • Recipients who don't have PowerPoint
  • PowerPoint version compatibility
  • Links - to images, sounds, movies and OLE content (graphs, charts, spreadsheets, Word pages etc.)
  • Sound and movie compatibility
  • Fonts
  • Timing/Synchronization
  • VBA code and Controls
  • Recipients using assistive technology




See all Topics

Tuesday, October 21, 2014

High-Res Wallpaper

Details apparent


Choose from a broad selection of free pictures to use for wallpaper.

Download sizes from 1920x1200 to 320x240.



Free High-Resolution Widescreen Wallpaper



See all Topics

Word to PP

Send outline to PowerPoint


That old 2003 version allowed you to send a Word file to PowerPoint and have it create a slide show.

After styling with Heading 1, 2, etc, go toFile > Send To > Microsoft Office PowerPoint.

2007+ is a little different (duh!)

For Microsoft Office 2007+

Word 2007+ doesn't allow you to publish to PowerPoint 2007 by default.

Here's the solution:

After you are done in Word 2007+, save it as a Word document.

Now open PowerPoint 2007+.

Click on the Office Button at the top left hand corner.

Click Open.

Under Files of type, select All Outlines.

Now select the Word document and click Open.

Alternately,

In Word 2007+, right click on the ribbon.

Select Customize Quick Access Toolbar.

Under "Choose commands from:", select Commands not in the ribbon.

Look for "Send to Microsoft Office PowerPoint".

Click OK.

The command will then be added onto the Quick Access Toolbar (QAT).



Word to PowerPoint

Word 2010 to PP 2010



See all Topics

Monday, October 20, 2014

Last Name First

Phonebook style


Sort the Contacts list by the File as field.

To do this, use one of the following methods depending on the version of Outlook that you are using.

In Outlook 2007+, follow these steps:

1. Start Outlook 2007+.

a. On the Tools menu, click Account Settings.

b. Click the Address Books tab, and click Change.

c. Under Microsoft Office Outlook Address Books, click the address book that you want to change the contact display format for.



For example, Contacts: Mailbox - Personal Folders, and then click File As (Smith, John).

In Outlook 2003, follow these steps:

1 Start Outlook 2003.

a. On the Tools menu, click E-mail accounts.

b. Click View or change directories or address books, and then click Next.

c. Click Outlook Address Book, and then click Change.

d. Under Outlook Address Books, click the address book that you want to change the contact display format for. For example, Contacts: Personal Folders, and then click File As (Smith, John).

e Click Close, and then click Finish.

2. Quit and restart Outlook.

3. Verify that the newly created contacts are sorted in the LastName, FirstName format. To do this:

a. On the Tools menu, click Options.

b. Click the Preferences tab, and then click Contact Options.

c. In the Contacts Options box, click Last, First in the Default File As order list.

d. Click OK two times.

4. Edit the properties of any contacts that have the File as option configured individually. This setting overrides the setting that you made in step 1.

a. Double-click any contact that does not appear in the LastName, FirstName format in your Contacts list.

b. Click the General tab, click the down arrow next to File as, and then click Lastname, Firstname, where Lastname, Firstname is the name of the contact.

Lastname first

Outlook 2010



See all Topics

Sunday, October 19, 2014

All the Basics

All(most) all you need to know


Office.Microsoft.com has a short demo that shows you the main things anyone needs to know about Excel.

There are many thousands of users who find that this is all they ever need.
  • Add numbers
  • Subtract numbers
  • Multiply numbers
  • Divide numbers
Use simple formulas to do the math



See all Topics

Saturday, October 18, 2014

New Window

Pick your target



Expression Web/FrontPage/HTML provides the opportunity to choose how a page opens when you click on a hyperlink.

Create a hyperlink as you usually would by selecting the text (or graphic) you want to use for the link.

Choose Insert > Hyperlink...
(or use Ctrl-K or the toolbar icon Link icon as a shortcut),
and locate the page in the current web or enter an address in the URL field.

On the right side of the Create Hyperlink window you'll see a button named "Target frame"; click the button.

You'll get the Target Frame dialog box.

In the "Common targets" field, select New Window.

Click OK, then click OK to close the Create Hyperlink dialog box.

Your hyperlink will now open a new browser window when clicked.

Target page

The code would appear like this:
<a target="_blank" href="TCC/Blog/blogger.html">Blog</a>

To make it the page default, place the following code in the "head" section:
<base target="_blank">




See all Topics

Friday, October 17, 2014

Night Skies

The real stars




JPL NASA

Also:
Arachnoid.com

In 1826, the astronomer Heinrich Olbers asked, "Why is the sky dark at night?" By his time, physicists had learned enough to realize that, in a stable, infinite universe with an even distribution of stars, the entire universe should gradually heat up.

You will also discover the connection between a rubber band, your refrigerator, and the universe.

Photographs:
Events in the night sky

StarDate Online
StarDate is the public education and outreach arm of the University of Texas McDonald Observatory.

English and Spanish radio programs air daily on more than 500 stations.

Fourmilab Switzerland
To make a sky map, enter the latitude and longitude of your observing site and press the "Make Sky Map" button

This site is developed and maintained by John Walker, founder of Autodesk, Inc. and co-author of AutoCAD:

Space Watch
by Imaginova Spaceware



See all Topics

Thursday, October 16, 2014

Null Parameter

Show something


If a user doesn't specify a parameter value, you can use a wildcard with the parameter in the format
Like [Enter Name] & "*"

The problem with this is that the query will return records that partially match the criteria.

For instance, if users searching for records based on last name enter a parameter value of "Smith" they'll also get the records for Smithers, Smithfield and Smithson.

Another problem is that the parameter query will ignore any records where the field being searched contains a Null value when you try to return the entire recordset with a blank parameter.

To fix this, set up a query to limit responses to explicit parameter entries, but still allow users to return all records by leaving the parameter blank.

If you're searching for LastName, open the query design grid and add LastName to it.

In the Criteria row for the field, enter the parameter prompt
[Enter Name]

Then, in the next blank column of the design grid, enter the same parameter (everything between and including the square brackets) in the Field text box.

Finally, in the Or row, enter the criteria Is Null .

If you're using any additional criteria for other fields, make sure to copy that criteria to the Or line as well.



See all Topics

Wednesday, October 15, 2014

Custom Shortcuts

Hands on keys


Ed Bott reminds us how to set up custom keyboard shortcuts to start applications.



Create custom keyboard shortcuts



See all Topics

Tuesday, October 14, 2014

Google Shows

Presentation alternative


Google Docs now has a presentation element.

You can create documents, spreadsheets and presentations online.

They're a bit restricted and simplex at this point, but you can also import files and convert them for sharing or publication.

Google Docs

Review of Google presentation



See all Topics

Monday, October 13, 2014

Desktop Calendar

Stare at the day


Outlook on the Desktop places your Microsoft Outlook Calendar on your desktop.

You can adjust its appearance. You can switch to Inbox, Tasks, Contacts, or Notes as well.

Double-click any item on the calendar to open in Outlook.

It works with all versions of Outlook from 2000 SR-1 forward; it also works with Vista and it's free.

Outlook on your desktop



See all Topics

Sunday, October 12, 2014

Chart Art

Apple π


Look at how different media organizations have used graphics/graphs to illustrate the news.

Lee LeFever:
The Art of Explanation


While Edward Tufte has concerns about representing data accurately in charts, he does, use pictures to demonstrate relationships.
(See Edward Tufte)

If you would like to try your hand, here are some links that will help to spice up your condiment report.

PC Magazine:
Add Images to Excel Projects

MacWorld:
Excel Chart Art

Andy Pope:
Dividing a graphic into sections

Excel 2007-13 has a great graphic look for charts, but these links still work



See all Topics

Saturday, October 11, 2014

Who's Smarter?

My barista can take your electrician


I.Q. is not really a guarantee of vocational/financial success.

There are about as many college professors with scores below 100 as there are Kindergarten teachers who register above 120.

Here's a link to how the testing breaks down:


IQ Distribution of Various Jobs



See all Topics

Friday, October 10, 2014

Loan Payment

Basic tutorial


Microsoft provides a number of learning activities related to fundamental tasks.

Here's one that walks the student through a worksheet designed to calculate interest and total payment for a purchase, based on different loan terms.


"This practical spreadsheet lesson offers easy answers to life's perplexing math problems like How much will my dream car really cost after financing?

Students will calculate the cost of purchasing their very own Lamborghini sports car and determine if the ultimate price tag is really worth the investment. "



Dream Car

Also:
Basic Financial Calculations



See all Topics

Thursday, October 09, 2014

Single Space +

2007+ gives you more than you ask for


This quote from The Microsoft Office Word Team's Blog explains their thinking behind making line spacing "looser" in 2007 than it was earlier.


"(A) lesson here for me is that lots of people seem to think of Word as a typewriter (remember typewriters?). There are many examples of this, in the way people construct a table of contents for their Word documents, use the TAB key to align columns, and the way they always hit ENTER twice after typing each paragraph (for those who are fans of extra space between paragraphs).

Many, many of the feedback comments on the line-spacing issue had to do with wanting "single spacing." But, of course the line spacing in the new template is single spacing. It's just that it's a little bit "more" than single spacing used to be: 1.15, instead of 1.0.

But what is 1.0? You might think that if you're using an 11-point font that line spacing of 1.0 would be 11 points. But if you lay out paragraphs that way - depending on the font you're using - the parts that stick below one line will crash into the parts that stick up from the line below. You need to allow some extra space between lines.

In a former life when I set type on a Compugraphic phototypesetting machine, the convention we used was about 20% extra space, so we'd set 10-point type on a 12-point line. Larger fonts demanded more breathing room. This was at a newspaper, so we spaced things a bit tighter than you'd expect to see in, say, a report or a brochure (or, dare I say a professional looking document).

What does single spacing really mean anyway?



How to fix it:
Default line spacing in Word 2007 differ from earlier versions of Word



See all Topics

Wednesday, October 08, 2014

Save the Warning

Easy record


It happens. Your machine balks and spits out an obscure warning message.

You grab a pen and scribble out the error code, which typically is 90 characters long.

Too much hassle!

When the warning box appears, just hit Ctrl+C. The contents of the box are now on the Clipboard and can be pasted into Notepad.






See all Topics

Tuesday, October 07, 2014

Handy Master View

It's mouse and keyboard quick!


With PowerPoint 2007-13, View>Presentation Views>Slide Master will take you to the Slide Master View. The same location shows Handout and Notes Masters.

A shortcut involves using the Shift key.


"At the bottom left hand corner of PowerPoint (bottom right for PowerPoint 2007), you will see 3 mini buttons. They are: Normal View, Slide Sorter View, and Slide Show. Now here's a quick trick:

When you hover over these 3 mini buttons, hold down the Shift key. The mini buttons will now become Slide Master view, Handout Master view, and Set Up Show respectively."

The Setup Show is on the Slide Show tab in the Setup group. The Shift key is a cooler way to bring it up quickly.



The Art of PowerPoint-ing



See all Topics

Monday, October 06, 2014

Edit Subject Line

Organization trick



By editing the subject lines of messages you receive, you can organize your mail. If you get faxes or voicemail sent to you automatically via email, you can change the subject to something that makes sense to you.

Open the message, edit the subject line, close the message and, when prompted, save the changes. The trick with this is the subject line does not look editable because it is on a grey background, but it works nevertheless.

Turn on in-cell editing and you can change the subject line without having to open the email and re-save it at all. This works best if you have the Preview Pane turned on:

Outlook 2000/2002:

From the View Menu select
Current View > Customize Current View
View Summary > Other Settings
Rows, enable the Allow In-cell Editing option.

Outlook 2003-13:

From the View Menu select
Current View
Customize Current View > Other Settings
and enable Allow In-cell Editing.



Slipstick.com:
To change the subject of an incoming message or fax



See all Topics

Sunday, October 05, 2014

Learn HTML

More tutorials



I like to read more than one author on a subject. It helps to clarify the sticky parts and each writer has a little bit different perspective on the subject.

WebReference.com has a good collection of material related to the Web and the Internet in general.

Stephanos Piperoglou has written a number of tutorials on Web design and construction.
From HTML 101 to I Shot the Serif and The Seven Habits of Effective Web Sites .

About HTML with Style


W3 Schools

Also:
HTML Tutorials



See all Topics

Saturday, October 04, 2014

2003-07-10-13 Compatibility

Exchange the future and the past


"Microsoft has added new file formats to Microsoft Office Word, Excel, and PowerPoint 2007+. To help ensure that you can exchange documents between Microsoft Office releases, Microsoft has developed a Compatibility Pack for the Office Word, Office Excel, and Office PowerPoint 2007+ File Formats"

Use earlier versions of Excel, PowerPoint, and Word to open and save files from 2007-13 Office programs

Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint



See all Topics