Thursday, July 31, 2014

Specifications for Excel 2007-2013

More flexibility


Lots of limits have been changed with 2007. The size of a worksheet is now 1,048,576 rows by 16,384 columns. The number of undo levels has gone up to 100.

Here are some more changes:

  • Worksheet and workbook specifications and limits

  • Calculation specifications and limits

  • Charting specifications and limits

  • PivotTable and PivotChart report specifications and limits

  • Shared workbook specifications and limits

Excel 2007 Specifications

Excel 2013 Specifications



See all Topics

Wednesday, July 30, 2014

Piggyback on GMail

An added tool


Google's Gmail is free and offers some features you can use in conjunction with your email program.


  • Send email to Gmail

  • Forwarding

  • Gmail spam control

  • Centralized Email

  • Additional email storage
"As well as a backup, it means you can easily access your messages via Internet terminal or mobile phone. Gmail is easily searched online or indexed offline using Google Desktop Search."
Here's the article from Office Watch:
Gmail as your spam filter

Here's GMail's Fetch gadget:
How to set up Mail Fetcher



See all Topics

Tuesday, July 29, 2014

Use the Ruler

Measure by Measure


Here is an article that explores the use of Word's Rulers.

About the only thing I don't see is that you can bring up the Page Setup dialog box by double clicking in the dark area of the ruler that indicates the margin.

Once again this tip comes from the Microsoft Word MVP site:

Ruler of all you survey:
How to make the best use of Word's rulers

Here's the spot to click to show rulers in Word 2007-13:





See all Topics

Monday, July 28, 2014

Clippy and Friends

Office Assistants


They were in the background, waiting to pounce.

Chris Pratley was there in the beginning:
Clippy and User Experiences


Stanford University:
Bob and the assistants
Social science research influences computer product design
..."They have found that to a very considerable extent people treat their computers and other computer-driven technology in the same ways that they treat people - as if the computer possessed reason, feelings, etc. People also treat pictures on screens as real objects, rather than as representations of real objects. This is relevant to anyone who wants to design technology or content that is as effective as it can be ..."


Also see:
Microsoft Bob

Clippy's Revenge



See all Topics

Sunday, July 27, 2014

Undo Excel

Level talk


In Excel 2007+. the number of levels of the "undo stack" was increased from 16 levels to 100.

Setting AutoFilters, showing/hiding detail in PivotTables, and grouping/ungrouping in PivotTables are now reversible.

And the undo stack is not cleared when Excel saves, be it an AutoSave or a Save by the user.

If you think the number of undos should be changed, here's how:


  1. Close any programs that are running.

  2. Click Start, click Run, type regedit in the Open box, and then click OK.

  3. In Registry Editor, expand one of the following registry subkeys, as appropriate for the version of Excel that you are running:

    Microsoft Office Excel 2010
    HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Options

    Microsoft Office Excel 2007 uses Office\12.0\
    Microsoft Office Excel 2003 uses Office\11.0\
    Microsoft Excel 2002 uses Office\10.0\
    Microsoft Excel 2000 uses Office\9.0\


  4. On the Edit menu, point to New, and then click DWORD Value. Select New Value #1, type UndoHistory, and then press ENTER.

  5. On the Edit menu, click Modify.

  6. In the Edit DWORD Value dialog box, click Decimal under Base. Type a value between 0 and 100 in the Value box, click OK, and then exit Registry Editor.

  7. Start Excel. Excel stores an undo history for the number of actions that you specified in step 6.


Modify the number of undo levels
 

If you want to clear the undo stack, just run a macro such as:


Sub ClearUndo()
Range("A1").Copy Range("A1")
End Sub

Allen Wyatt:
Clearing the Undo stack



See all Topics

Saturday, July 26, 2014

Leaf Automation

Animation tip


This tutorial will walk you through the steps you can use to display a leaf as it floats and swirls across the screen.

There is also a file that you can download to see how its done.

PowerPoint Heaven:

Leaf Motion



See all Topics

Friday, July 25, 2014

Startup Switches for Access

Your choice


"This article shows you how to customize the way that Microsoft Office Access 2007+ starts by adding switches and parameters to the startup command. For example, you can have Office Access 2007+ open a specific file or run a specific macro when it starts."


Office.Microsoft.com

Also:

Support.Microsoft.com

and

VB123.com



See all Topics

Thursday, July 24, 2014

Screen Capture Gear

Better than PrtScn


You can add graphics to instructions using the built in PrtScn button, but there's not much versatility.

WritersUA by WinWriters, Inc has a discussion on some available apps that can help.



"Almost all of us need to include screen captures in our user assistance from time to time.

Of course, it's possible to do almost all of this by pressing + to copy the active window to the clipboard, and then pasting it into your favorite image-editing application.
However, for each screen capture this requires you to go through the same set of actions in order to crop, set the color depth, add borders or edge effects, and finally save it.
If you only take the occasional screen capture, then this is fine. But it can become extremely tedious and time-consuming if you have a large number of screens to capture."


Capture Tools



See all Topics

Wednesday, July 23, 2014

Non Stop Show

Stop the breakout


If a PowerPoint show is running, it can be stopped by using the escape key. Here's a way to prevent that from happening.

A User can exit out of a show accidentally/intentionally by pressing the ESC key. This add-in disables the functionality of the ESC key.

Note: If the show is set to run in Kiosk mode, disabling the ESC key will provide no way of getting out of a slide show, hence please ensure that you have provided an escape route (e.g an invisible shape set to End show) to exit the show.


No ESCape Add-in
by Shyam Pillai



See all Topics

Tuesday, July 22, 2014

Continued

More to come



You can place the word "More" or "Continued" at the bottom of every page except the last one.
The field, for those of you who know how to use them is:

{ IF { PAGE } = { NUMPAGES } "" "more" }

You can't just type in the brackets, you must use Insert>Field or Ctrl+F9.

Here is a more sophisticated formula:

{ IF { PAGE } < { NUMPAGES } "Continued on page {={PAGE} + 1}" "Last Page"}

Also see the Word MVP site
How to control the page numbering in a Word document



See all Topics

Monday, July 21, 2014

Cmabrigde

Crorcet Sllipneg



"Aoccdrnig to a rscheearch at Cmabrigde Uinervtisy, it deosn't mttaer in waht oredr the ltteers in a wrod are, the olny iprmoetnt tihng is taht the frist and lsat ltteer be at the rghit pclae. The rset can be a toatl mses and you can sitll raed it wouthit porbelm. Tihs is bcuseae the huamn mnid deos not raed ervey lteter by istlef, but the wrod as a wlohe."


Spanish:
"Sgeun un etsduio de una uivenrsdiad ignlsea, no ipmotra el odren en el que las ltears etsan ersciats, la uicna csoa ipormtnate es que la pmrirea y la utlima ltera esten ecsritas en la psiocion cocrrtea. El rsteo peuden estar ttaolmntee mal y aun pordas lerelo sin pobrleams. Etso es pquore no lemeos cada ltera por si msima preo la paalbra es un tdoo."

Russian:



See: Matt Davis - Cmabrigde, for a full discussion.

True or fsale?

TheSpellingBlog



See all Topics

Sunday, July 20, 2014

Use a Table Alias

to change names in a query


When you need to change the table name referenced in an existing Access query, it can be a pain. This is especially true if the query contains a large number of fields.

You typically might use an alias when you need to relate a table to itself or tables have long or unwieldy names.

If you make a practice of always using aliases in your queries, you can easily change which table is used by changing the one occurrence of the original table name in the query's FROM clause.
  1. To set a table alias in the query's Design view,
  2. Right-click on the table field list and choose Properties.
  3. Then, enter the alias name you want to use in the Alias text box.





See all Topics

Saturday, July 19, 2014

Make PowerPoint HTML Sing

Web sounds



"The situation usually is that someone has spent the time to create a wonderful slide show with music set to start on the first slide and run throughout the entire presentation.
Unfortunately, when the presentation is saved as HTML, and it is tested, the music plays only on the first slide.

This article will not only explain what to do, it will also give you exact HTML code and tell you where to put it in the file. "

A Sound Solution: Playing Music on HTML Presentations



See all Topics

Friday, July 18, 2014

And then there was Word

Remember the past



As one writer put it:
"Before the development of personal computers and word processing software, documents were produced on typewriters."

Chris Pratley, a Microsoft Program Manager, started with the Excel team in 1994 and then worked with the Word team. He has written about the early days:
Let's talk about Word


Also see:
WordStar Resource Site
(Includes a WordStar emulator for Word)


And:
In Search of Stupidity



See all Topics

Thursday, July 17, 2014

How to Start a Blog

Step-by-step tutorials

"If you’re like most people, you may not know where to get started. Starting a blog can be intimidating if you don’t have the required technological skills. Not to mention that the number of options available for starting a blog can be just plain confusing. The good news is that the free step-by-step guide on this site removes any confusion from the process, and requires only the most basic computer skills. So whether you’re 8 or 88, you can have your blog ready to go in less than 20 minutes."

Theblogstarter.com

See all Topics

See all Topics

Wednesday, July 16, 2014

Horrific Stories

What did your Grandparents do?


"Unsuspecting visitors in crime-infested Port Townsend, victims of shanghaiing, are sold to the highest bidder
Bunco Kelly, Spider Johnson and fourteen dead men on the deck of the Flying Price.
Urban East Hicks surrounded by Indians in 1886.
Earthquakes, riots, robberies, murders and a host of other terrifying events which created panic in the streets of communities throughout the Pacific Northwest.
Selected from the Clippings File of the Tacoma Public Library's Northwest Room /Special Collections, these true-life tales chillingly capture the dark side of our state's history."

Unsettling Events!



See all Topics

Tuesday, July 15, 2014

IE Spells

Missing feature found



For years, I've filled out forms on the net and then had to copy and paste into Word to check doubtful spelling.

Now there is a tool that should have been included in the first place.


"ieSpell is a free Internet Explorer browser extension that spell checks text input boxes on a webpage. It should come in particularly handy for users who do a lot of web-based text entry (e.g. web mails, forums, blogs, diaries).

Even if your web application already includes spell checking functionality, you might still want to install this utility because it is definitely much faster than a server-side solution. Plus you get to store and use your personal word list across all your applications, instead of maintaining separate ones on each application."


ieSpell



See all Topics

Monday, July 14, 2014

Access Tutorials

Learning Sites



Microsoft has created a web site for Office. Part of the site is devoted to tutorials touching on:

Word, Access, Publisher , Outlook, PowerPoint, InfoPath , Excel, Visio, OneNote, Expression, and Project.

The Access lessons are located here:

2013 Access Tutorials

2010 Access Tutorials
2003 Access Tutorials
2007 Access Tutorials

Here's another site:

FunctionX Access tutorials




See all Topics

Sunday, July 13, 2014

Put IE Back on the Desktop

Regedit ahead


  1. Click Start, Run.

  2. Type "regedit.exe" (Without quotes).

  3. Navigate to the following registry key
    HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\HideDesktopIcons\NewStartPanel

  4. In the right hand pane, double-click {871C5380-42A0-1069-A2EA-08002B30309D} key.

  5. Enter dword value as 0 to enable the Internet Explorer icon on the Desktop.





Internet Explorer Desktop icon missing



See all Topics

Saturday, July 12, 2014

Wrist Time

Ding dong bling


Face it, you're never going to wear these watches. Some of them are just concepts, others are just too.

They are fun to look at.


Wrist Fashion is a Weblog that publishes the latest news, trends and products from the Wristwatch Industry in bite size morsels.


Brand: Venexx
Movement: Swiss Ronda Calibre 1063.1.90 quartz movement
Perfume: Approximately 60 sprays
Water Resistant: 30 metres


Perfume Watch

WristFashion.com



See all Topics

Friday, July 11, 2014

Flag Access Controls

Tag Property


The TAG property allows you to associate up to 2,084 characters of text with any form, report, section, or control. This is especially helpful when you want to single out a specific subset of controls.

For instance, say that you want to hide certain controls on a form when a user clicks a button.
You can flag which controls will be hidden by entering the word "Hide" (or any other consistent word) in each control's Tag property. Then, attach the following code to the command button's Click event procedure:

Dim ctl As Control
For Each ctl In Me.Controls
If ctl.Tag = "Hide" Then
ctl.Visible = False
End If
Next





See all Topics

Thursday, July 10, 2014

More Icons Deal

Forgotten tricks


Here's a simple way to display different icons on your desktop.
Right-click on a desktop folder and choose Properties.
Click the change Icon button. You'll see a few icons. For more icons look at:
C:\WINNT\system32\moricons.dll

PC magazine has this article:
Assign Custom Icons to Windows Explorer Folders.

Softpedia:
Change Icon v1.2.1

Creating Icons


Also see:
The Iconarchive, the art of virtual (desktop) litter.



See all Topics

Tesla's Birthday

July 10, 1856


There has been an attempt to make July 10, the birth date of Nikola Tesla,
Global Energy Independence Day.

The purpose is to promote emerging energy technologies that move us away from oil dependence.




Happy Birthday Tesla

Tesla - The Lost Wizard

Tesla Coil

Tesla cage of death




See all Topics

Wednesday, July 09, 2014

Convert Anything

Four pecks to a bushel



Convert
"Convert is an easy to use unit conversion program that will convert the most popular units of distance, temperature, volume, time, speed, mass, power, density, pressure, energy and many others, including the ability to create custom conversions!"

Convert



OnlineConversion.com does more conversions online.
(A Hogshead is 63 Gallons)


Also:
Convert between bits/bytes/kilobits/kilobytes/megabits/megabytes/gigabits/gigabytes



See all Topics

Tuesday, July 08, 2014

Viddler Video Storage

Player and free video storage

"You can upload many videos at once, and in various formats, too.(mov .avi .wmv .mpeg).

You also won't have to worry about file size - just keep any video you upload under 500 Mb.

Timed Tags
Moments on the timeline of your video are taggable, so you can classify and share instances in time. Timed tags are searchable, too - a great way to explore the content on viddler.com

Timed Comments
Your position in the timeline of a video determines where your comment will be posted to, which brings the discussion to a whole new level!

Use Your Webcam
Got a web camera? You can use Viddler to record footage directly from the camera to the website. There's no third-party software



"Viddler is very different from other video-delivery based websites, because we stream our videos instead of having the user download it.

That means you get to watch videos without having to wait for the entire video to load.

This is especially useful when you want to view the last few minutes of a very long video.

It's a secure system and prevents other people from watching the video (in ways they're not supposed to) or ripping the video off the site.

Video that you host with Viddler cannot be stolen, or used in any fashion, unless you set your sharing options to allow it."


Vidler.com



See all Topics