Saturday, May 31, 2014

Unkept Secrets

From Microsoft


"After supporting Microsoft Excel for years, technical Support Professionals have found that some of the most powerful and useful features and functions in Microsoft Excel remain undiscovered by you, our users.

For example, you may create a new macro to perform a calculation when an existing formula or function can perform the task. Or, you may create a new macro to perform a task when you could use an existing feature that performs the task."

Undiscovered Tips About Microsoft Excel for Windows
Here are just a few:
  • Secret #1: Joining Text Together

  • Secret #3: Excluding Duplicate Items in a List

  • Secret #7: Using a Data Form

  • Secret #11: Linking a Text Box to Data in a Cell

  • Secret #12: Linking a Picture to a Cell Range

  • Secret #17: Using OFFSET to Manipulate Data in Cells that are Inserted

  • Secret #21: Using INDEX and MATCH to Look up Data

  • Secret #25: Returning Every Nth Number

  • Secret #29: Using One Keystroke to Create a new Chart or Worksheet

  • Secret #30: Setting up Multiple Print Areas on the Same Worksheet




See all Topics

Friday, May 30, 2014

Ripple the Ribbon

Change the look


"Learn how you can create a custom Office Fluent Ribbon for an Access 2007-13 database by using only Office Fluent extensibility markup XML and macros.

Discover how to create a command space without writing any code and also learn about more advanced scenarios that require code."

Customizing the Office Fluent User Interface



Customize the Ribbon



See all Topics

Thursday, May 29, 2014

Attachment Default Save

Set the solution



Here's how to set the default location that Outlook will use to save attachments:

  1. Click Start, and then click Run.

  2. In the Open box, type regedit, and then press ENTER.

  3. In Registry Editor, locate the following subkey in the registry:
    HKEY_CURRENT USER\Software\Microsoft\Office\11.0\Outlook\Options 

  4. On the Edit menu, point to New, and then click String Value.
  5. Type DefaultPath, and then press ENTER.

  6. Double-click the DefaultPath value.
    In the Edit String dialog box, in the Value data box, type the path, including the drive letter, to the folder that you want to use for your Outlook saved items, and then click OK.

  7. Exit Registry Editor.
Office.Microsoft.com



See all Topics

Wednesday, May 28, 2014

New Excel Web Grabber

Web Toy



"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.
An example scenario: You wish to import and track data from MSN's weather page. Visit the site using the tool, enter Data Capture mode, and select a row or two of data from the table. Then click Select Similar, and the system will find similar data based on your previous selections.

You then can click Import and leverage Excel's rich data-editing capabilities, including the Refresh command, which will revisit the Web page and extract potentially new, updated data."

Web Data Add-In

(Webservices 2013)

From the Excel Blog team



See all Topics

Tuesday, May 27, 2014

Icon Title Opacity

See through


To make the background of desktop icons transparent, go to:

Control Panel > System > Advanced

Click Settings in the Performance section.



On the Visual Effects tab, check "Use drop shadows for icon labels on the desktop".



See all Topics

Monday, May 26, 2014

Secret Slide Numbers

PPT does not forget




"PowerPoint numbers slides in several ways and it pays to know the difference.

When you create a new slide, it gets a unique SlideID, a unique number that's read-only… you can't change it manually or programmatically. Reordering the slides won't cause it to change. Once a slide is created, it keeps the same SlideID forever.

SlideIndex is the ordinal number of the slide in the presentation as it's currently arranged. Move a slide around in slide sorter and its SlideIndex changes to reflect its new position in the show."

Slide number, SlideID, SlideIndex and all that jazz

From the MS Knowledgebase:
Sample Code to Print Slide Numbers for a Custom Show


"Microsoft PowerPoint has the ability to create custom slide shows, which are subsets of existing slides within your presentation. When you print a custom show, PowerPoint prints the page number defined for that slide. For example, if you print a custom show named My Show that consists of slides 2, 8, and 13 of your presentation, the numbers 2, 8, and 13 appear on the printed output.

This article provides a sample Microsoft Visual Basic for Applications macro that prints out a specified custom show and numbers the pages consecutively, beginning with the number 1."

Also:
Working with Slide Objects
and

Microsoft PowerPoint Objects



See all Topics

Sunday, May 25, 2014

Themes and Templates

Need a look?



Themes are a collection of design elements and color schemes that can be applied to your web site to give it a unified appearance.

Templates include themes and layout modules to aid in quickly creating a web site. Templates can be purchased through the web, but here is one of the locations that provide free design help.

FreeLayouts.Livejournal.com

"Want a great new look for your website? Free Layouts.com offers you just that - select from our huge database of complete "look and feel" designs. Professional, sports, technical and others - they are all here. Free Web Templates are available for you to download now.

Look around and download your favorite page layouts - for free. Also, submit templates of your own and increase traffic to your website greatly. Currently over 500 free HTML templates and 50 Flash templates for you to download!"




See all Topics

Saturday, May 24, 2014

Highlight the Current Control

Code vs. property


Many users have trouble knowing which text box on a form they're currently working with. One way to make it clear for users is to highlight the current one, for example, with a yellow background.
Access allows you to do this with conditional formatting, but you can also get a similar result using code.

To do so, create a new module and add the following code:

Function Highlight(Stat As String) As Integer
Dim ctrl As Control
On Error Resume Next
Set ctrl = Screen.ActiveControl
If Stat = "GotFocus" Then
ctrl.BackColor = 65535
ElseIf Stat = "LostFocus" Then
ctrl.BackColor = 16777215
End If
End Function

Save and close the module, then open the form you want to apply the highlighting to in Design view.
Click the Code button and insert

Highlight("GotFocus")

in each textbox control's GotFocus event procedure. Likewise, add
Highlight("LostFocus")
to each textbox's LostFocus event procedure.
When you've finished,save the changes, close the VBE, and switch to Form view.

When you tab to a field, it's shaded yellow. When you tab away from the field, its background is restored to white.



See all Topics

Friday, May 23, 2014

Wage is too Minimum

Low pay by state


Since 1997, the federal minimum wage has been stuck at $5.15. The new Congress plans to introduce legislation raising the minimum wage to $7.25-an increase that is long overdue.

This minimum wage increase would boost earnings for 13 million American workers-9.8 percent of the United States workforce.

Six million families with children-46 percent of the total low wage-earning families with children-currently receive all of their earnings from minimum wage jobs.

Raising the minimum wage will increase annual earnings to $15,000 from $10,700.

Without this increase, a family of three supported by one minimum wage earner will live roughly $5,400 below the federal poverty line.

At the 350 largest public companies, the average CEO total direct compensation was $11.6 million in 2005. At this rate of compensation, it takes the average CEO only one hour and 55 minutes to earn the annual pay of a minimum wage worker.

Here is an interactive map that will show how your state relates to the others.

Minimum wage map



See all Topics

Thursday, May 22, 2014

Calendars - Perpetual

It's that year again


One Month and One Year perpetual calendars are available.

These Excel file calendars do not use macros and can be used in OpenOffice or other Excel compatible software.


  • Perpetual calendars with Week starting on Sunday

  • Perpetual calendars with Week starting on Monday

  • A simple "universal" one month calendar that will update for any month and any year (after 1900) just by changing a date cell.

  • A "universal" one year calendar that will show 12 months starting with a user defined Month and Year.
Start dates can be at the beginning of any year and any month.

DotXLS.com: Perpetual calendars
 
Microsoft: How to make calendars



See all Topics

Wednesday, May 21, 2014

Custom Forms

Template collection



"At one time, Microsoft had a pretty nice collection of custom Outlook forms anyone could download. While a number of the forms are no longer available from Microsoft, a sizable collection remains. You can use these as-is or as a basis for your own custom forms."

See Slipstick.com - Sample Forms for the forms that are available.
  • Calendar Corporate Calendar
  • Expense Report
  • Help Desk
  • Holiday Card List
  • Job Candidates
  • Purchase Order Request
  • Real Estate Listings
  • Software Inventory Form
  • Student Attendance
  • Technical Repair Request
  • Time Card
  • Travel Request
  • Vacation Request
  • Web Site Listing
While they were all designed for Outlook in the Outlook 97/98 time frame, every one I've tried works with all versions of Outlook. However, the self-installers may not work due to security settings and you'll need to publish the form yourself. If you need step-by-step help to publish a form, see:
Outlook.net - Publish Form

OutlookCode.com - Send Form  

OutlookCode.com - Microsoft Outlook Custom Forms

Creating and distributing custom forms with Outlook



See all Topics

Tuesday, May 20, 2014

Equations = 2010+

Real text


Remember, back in the old days of pre-2007-10 Word. Equations were a pain. Messy to set up with the Equation Editor and difficult to edit and reformat.


Brace {yourself} there have been changes.



  • Equations are regular Word text (not objects), so they're integrated with regular Word formatting.

  • High-quality display and typography: we're using TeX standards and a brand-new Math Font to produce great-looking equations

  • Two input methods: UI and Linear Format (keyboard syntax)

  • MathML support: now you can write an equation in Word, paste it into a calculating or graphing application, and get results!

Equation Demo
 
Equations in Word 2007



See all Topics

Monday, May 19, 2014

Classroom Ideas

Ideas and tutorials



If you're looking for student projects and tutorials involving PowerPoint and more, look here:

PowerPoint - Creating Classroom Presentations

More information is located at:
EducationWorld.com

  • a search engine for educational Web sites only, a place where educators can find information without searching the entire Internet;
  • original content, including lesson plans, practical information for educators, information on how to integrate technology in the classroom, and articles written by education experts;
  • site reviews;
  • daily features and columns;
  • teacher and principal profiles;
  • Wire Side Chats with the important names in education;
  • employment listings.




See all Topics

Sunday, May 18, 2014

Drop Down Menu

Validation



You can create a dropdown list that gets its choices from entries located in another part of the spreadsheet.

  1. Type the entries in one column or row.

    You can name the list by selecting the entries and then clicking in the Name box on the Formula bar and entering a name, and then press Enter.

  2. Next, select the cell where you want the dropdown list.

  3. On the Menu bar, go to the Data menu, click Validation, and then click the Settings tab.
    In the Allow box, click List.

  4. Enter the name of the list or its location.

    Make sure the reference or name is preceded with an equal sign (=).

    Make sure the In-cell dropdown check box is selected.

    If your list is short, you can type the entries directly in the Source box, separated by commas.
Debra Dalgleish, Excel MVP has a complete discussion on her Contextures.com site. She covers resizing the dropdown box. The site also includes other information about data validation:
Excel — Data Validation —Tips  



See all Topics

Saturday, May 17, 2014

Soup is no Joke

A ladle humor


"Garçon, le mouche dans ma soupe!"

"Non, monsieur, la mouche"

"Mon Dieu, you Belgians have wonderful eyesight!"

Soup Jokes



See all Topics

Friday, May 16, 2014

Hiding Columns

In Datasheet view


When you're working in Datasheet View, you can easily hide columns containing data that you don't need to immediately work with.

To do so, select any field in the column and choose Format >Hide Columns from the menu bar.

As an alternative, right- click on the column's field name and select Hide Columns from the shortcut menu.

To redisplay hidden columns, select Format>Unhide Columns from the menu bar.
Then, select the check boxes next to the field names of any columns you want displayed and click OK.

You can select the Unhide Columns command even if no columns are hidden, allowing you to easily hide multiple columns by clearing the appropriate check boxes.



See all Topics

Thursday, May 15, 2014

Footnote Customization

Line it out


In Normal View:
  1. Go to View>Footnotes.

  2. Click the All Footnotes box arrow, and select Footnote Separator from the drop-down list.

  3. Click on the existing separator line and delete it.

  4. Go to Format>Borders And Shading.

  5. On the Borders tab, select the border you want.

  6. Select the color you want.

  7. Click OK.
You will see the new separator line for your footnote will appear in Print Layout or Print Preview.

Also:
Footnote FAQ



See all Topics

Wednesday, May 14, 2014

New Folder

Organize



If you are involved with a project, or you do a lot of work in a specific area, you may wish to create separate folders for e-mail related to that assignment.

You do not have to limit yourself to creating folders for e-mail; you can also create new Calendars or collections of Contacts.

One way to do this is to go to View>Folder list.

Select the "Root" of the directory tree, or choose a folder to create a sub-directory.

Right click the location and choose New Folder ...

Give it a name and then choose what information that folder should contain.

You can have a Contacts folder with names from a single company, or your personal list.

This way they will not be intermingled with your main collection.

You can do the same thing with personal Calendars.


New Folders

Managing Outlook Folders in Office 2003
Special Edition Using Microsoft Office Outlook 2003 from Que publishing

Microsoft Office Online:
Using Folders



See all Topics

Tuesday, May 13, 2014

Hide Dups

Format don't show



Duplicate entries can be formatted to "disappear", but still be available for computation.
  1. Select the range

  2. Goto Format>Conditional Formatting

  3. Select Formula Is

  4. Enter
    =A2=A1

  5. Click the Format button.

  6. Select a font color to match the cell background color.

  7. Click OK and OK
Dups can also stand out:
  1. Select the range

  2. Go to Format>Conditional Formatting

  3. Choose Formula Is

  4. Enter
    =COUNTIF($A$2:$A$100,A2)>1

  5. Click the Format button.

  6. Select a font or background color for highlighting.

  7. Click OK and OK
Hide Duplicate Values

Also:
Hide Records with Duplicate Cell Entries



See all Topics

Monday, May 12, 2014

STIFF

The Curious Lives of Human Cadavers


By Mary Roach
ISBN 0-393-05093-9
W.W. Norton 2003





About the Author
Has written for Salon, Discover, New York Times Magazine

Book Description
For two thousand years, cadavers -- some willingly, some unwittingly -- have been involved in science's boldest strides and weirdest undertakings. They've tested France's first guillotines, ridden the NASA Space Shuttle, been crucified in a Parisian laboratory to test the authenticity of the Shroud of Turin, and helped solve the mystery of TWA Flight 800. For every new surgical procedure, from heart transplants to gender reassignment surgery, cadavers have been there alongside surgeons, making history in their quiet way.

In this fascinating, ennobling account, Mary Roach visits the good deeds of cadavers over the centuries -- from the anatomy labs and human-sourced pharmacies of medieval and nineteenth-century Europe to a human decay research facility in Tennessee, to a plastic surgery practice lab, to a Scandinavian funeral directors' conference on human composting.

Quote
Besides a study about what happens to our remains, Roach has this comment:

"Anthropologists will tell you that the reason people never dined regularly on other people is economics. While there existed, I am told, cultures in Central America that actually ranched humans -- kept enemy soldiers captive for awhile to fatten them up -- it was not practical to do so, because you had to give up more food to feed them than you'd gain in the end by eating them. Carnivores and omnivores, in other words, make lousy livestock."





See all Topics

Sunday, May 11, 2014

Headline Animator

Up to date



Introducing the Headline Animator:

Unofficial Microsoft Office Stuff

FeedBurner.com
"We're happy to introduce our latest publisher service: the Headline Animator. When you burn your RSS or Atom feed with FeedBurner, you can take advantage of this cool, different way of looking at your feed.

Just by pasting some HTML code into, say, your email signature file or bulletin board profile, you'll get a nice little badge that always shows your latest five blog postings. No Javascript or Flash required -- we generate an animated GIF on-the-fly from your feed."




See all Topics

Saturday, May 10, 2014

Hue has the Color

Interactive Color Wheel


Richard Franzen has an interactive color wheel that you may want to play with.
You can experiment with saturation, intensity, hue, and luminosity.

SIH Wheel



See all Topics

Friday, May 09, 2014

Where in the World is it not

Trouble map


If it's not happening here, it's coming down over there.

Here's a Google map mashup of the world wide mashups.

Global Incident Map



See all Topics

Thursday, May 08, 2014

Email Fontcology

Comic vs. Arial


Does the font used in an email message color the perception of the reader?

"Summary: This study investigated the effect that a font has on the reader's perception of an email. Based on a previous study by Shaikh, Chaparro, and Fox (2006), a sample email message was presented in three fonts (Calibri, Comic Sans, and Gigi). The three chosen fonts represented a high, medium, and low level of congruency for email messages."


The Effect of Typeface on the Perception of Email

Also:

The Personality of Fonts



See all Topics

Wednesday, May 07, 2014

Downloadable 2013 Books

On the Internet shelf



  • Downloadable book: Getting started with Office 2013


  • Downloadable and printable content (available in .doc, .pdf, or .xps file formats) about how to get started with Office 2013.

  • Downloadable book: Planning guide for Office 2013


  • Downloadable and printable content (available in .doc, .pdf, or .xps file formats) about how to plan a deployment of Office 2013.

  • Downloadable book: Deployment guide for Office 2013


  • Downloadable and printable content (available in .doc, .pdf, or .xps file formats) about how to deploy Office 2013.

  • Downloadable book: Group Policy for Office 2013


  • Downloadable and printable content (available in .doc, .pdf, or .xps file formats) about how to deploy and configure an installation of Office 2013.

  • Downloadable book: Operations guide for Office 2013

and more.

Technet.Microsoft.com



See all Topics

Tuesday, May 06, 2014

Translate on the Fly


Translate Text



Ahora usted puede exhibir un grado de la sofisticación que excede tu conocimiento


On the Tools menu, click Research.

  1. In the Search for list, select Translation.
  2. To change the languages used for translation, in the Research task pane, under Translation, select the languages you want to translate from and to.
Do one of the following:
  • To translate a specific word, press ALT and click a word. The results appear under Translation in the Research task pane.
  • To translate a short sentence, select the words, and then press ALT and click the selection. The results appear in the Research task pane under Translation.
  • To translate a whole document, in the Research task pane, under Translation, click Translate whole document A translation of your document appears in your Web browser
  • To translate a word or phrase, type the word or phrase in the Search for box, and then click Start Searching .
Also see:
Speaking of translating a fly, here's another kind of translation: BzzzPeek A collection of 'onomatopoeia' from around the world using sound recordings from native speakers imitating the sounds of mainly animals and vehicles.



See all Topics

Monday, May 05, 2014

5 of 10 Commandments - Access

Writ on tables





"And it came to pass that the cries and lamentations of the Access newbies were heard on high by the gods of the Database, and their hearts were moved to pity for their followers. And they opened their mouths and spake, saying: "Nevermore shall the young and innocent wander witless on their journeys!


  1. Thou shalt design normalized tables and understand thy fields and relationships before thou dost begin.
  2. Thou shalt never allow thy users to see or edit tables directly, but only through forms and thou shalt abhor the use of "Lookup Fields" which art the creation of the Evil One.
  3. Thou shalt choose a naming convention and abide by its wisdom and never allow spaces in thy names.
  4. Thou shalt write comments in your procedures and explain each variable.
  5. Thou shalt understand error handling and use it faithfully in all thy procedures.
  6. . . .

Thus spake the gods of the Database, and blessed be their names!"

The full list can be found on:
The Access Web



See all Topics

Sunday, May 04, 2014

Browser Utensils

Tiny tools



Bookmarklets
Easy to use, free Java scripts.


"Bookmarklets are simple tools that extend the surf and search capabilities of Netscape and Explorer web browsers.

Bookmarklets are free.

Bookmarklets allow you to:
  • Modify the way you see someone else's webpage.
  • Extract data from a webpage.
  • Search more quickly, and in ways not possible with a search engine.
  • Navigate in new ways.
…and more. Over 150 bookmarklets are available."
Here's a list of available bookmarklets:

List of Offline Bookmarklets



See all Topics

Saturday, May 03, 2014

All Programs Sort

Alpha my Adobe


After a while, the list of programs on the All Programs list can get out of order.

Here's the super tech way to fix it:

Right click on the Programs menu and select Sort by Name.

Thank you very much.



See all Topics

Friday, May 02, 2014

Show Suggestions

10-20-30


A show should have 10 slides, last no more than 20 minutes and have at least 30 point font.
Guy Kawasaki is a venture capitalist with some piquant points about presentations.

The 10-20-30 Rule



See all Topics

Thursday, May 01, 2014

Resend Again

Send the same message


Here's how to resend a message. The intended recipient might have accidently deleted it or would just like to see it again.

Open the message. Now you'll see the correct menus:

In Outlook 2003 – look on the Actions menu.

In 2007+ it's under Other Actions




For 2010:

  1. In Mail, in the Navigation Pane (Navigation Pane: The column on the left side of the Outlook window that includes panes such as Shortcuts or Mail and the shortcuts or folders within each pane. Click a folder to show the items in the folder.), click Sent Items.
  2. Double-click the message that you want to resend.
  3. On the Message tab, in the Move group, click Actions, and then click Resend This Message.




See all Topics