Saturday, December 31, 2016

Autofit Table

Fit to page

Select the table and right-click.
Scroll to Autofit and then select AutoFit to Window.

Word will automatically adjust the table width to any margin or page orientation changes.

Here are some more table fit suggestions:

TechRepublic.com



See all Topics

Friday, December 30, 2016

Resize Alt-Tab

Registry hack

Here are the instructions about how to size the thumbnails in Vista/Win7 to fit your screens resolution.

Windows 7



See all Topics

Thursday, December 29, 2016

Wednesday, December 28, 2016

Who's to Blame

The hammer or the carpenter?

Farhad Manjoo places the blame where it belongs, the show's producer, not the software.

No More Bullet Points



See all Topics

Tuesday, December 27, 2016

Excel to Outlook

Concatenate Excel Outlook

A common task is to bring a contact list into Outlook from Excel. Usually Excel will have names separated into columns. Other information, such as addresses may also be divided.
Here’s how to format the Excel file for a seamless import.

Howto-Outlook.com



See all Topics

Monday, December 26, 2016

Ribon Guide

FluidUserInterface


”These interactive guides show you where your favorite menu and toolbar commands are located in Office 2010-13. Just click the command or button that you want to find, and the guide will show you its location in the 2010-13 version of the program.”
Office.Microsoft.com



See all Topics

Sunday, December 25, 2016

Versionista

Web monitor


Versionista monitors web sites and alerts you by email of any changes. It also displays the changes visually on the page.
Here's one mention from the news:

Rachel Maddow

Versionista.com



See all Topics

Saturday, December 24, 2016

Windows Split

Easy trick

Here's how to split the open window and/or create new windows.

SaraFord



See all Topics

Friday, December 23, 2016

Office 2010-2013

Preview review


Ed Bott has been writing about Office since 1996. Here is his take on the latest version.

Ed Bott Office 2010

Office 2013

Office 2010: Product Guides

Office 2013



See all Topics

Thursday, December 22, 2016

Runtime is Free

No need for Access


"If no end-user customization is required (including report modifications), you may choose to distribute these Access solutions so that they run without requiring a full installation of Access."

Access 2007 Runtime

Access 2010 Runtime

Access 2013 Runtime



See all Topics

Wednesday, December 21, 2016

Set Your Kindle Free

Jailbreak

You can program your Kindle to accept screensavers, and other aps.

How to Geek.com



See all Topics

Tuesday, December 20, 2016

Monday, December 19, 2016

Last Doc Shortcut

Back Quick

"A separate shortcut with a special switch that will open the last document that was open in Word."

Last Document



See all Topics

Sunday, December 18, 2016

Undelete Deletes

Get it back


"It’s happened to most of us. You delete a file and realize you need it back. This guide will explain when you can get that file back and how to go about it."


 How to Recover a Deleted File



See all Topics

Saturday, December 17, 2016

Move Up the Page

The old fingers walking trick

If you want to move words, paragraphs, bullets, up or down the keyboard shortcut is Shift+Alt + Up/Down/ arrow.


HowtoGeek.com



See all Topics

Friday, December 16, 2016

UAC-Administrator

Full control

If you are overly confident about your skills, you might want to look at Greg Schultz's discussion on Administrator power.
”You should use the real Administrator account very sparingly - never make it your default modus operandi! Please note that you use this technique at your own risk.”
TechRepublic



See all Topics

Thursday, December 15, 2016

Pause a Sound

And then I said

How to insert a sound file, and set it to play automatically, but also pause the narration at will during the slide show.

Andrew May



See all Topics

Wednesday, December 14, 2016

Hotmail Gmail

Harmony

Instructions on how to import your old Hotmail account into Gmail:

GoogleSystem Blog



See all Topics

Tuesday, December 13, 2016

How Google Works

Backstage

Here's what's going on behind the scenes.
  • Googlebot, a web crawler that finds and fetches web pages.
  • The indexer that sorts every word on every page and stores the resulting index of words in a huge database.
  • The query processor, which compares your search query to the index and recommends the documents that it considers most relevant.
GoogleGuide.com



See all Topics

Monday, December 12, 2016

Dates with Bill G

What it was like

February and March are incorrect in Excel.
Joel Spolsky talks about dates with Bill G.

Bill G



See all Topics

Sunday, December 11, 2016

How to spot a gun

using a graph

Edward Tufte has this discussion about a graphic that shows how to spot a hidden firearm.
"Color is used to highlight how the gun moves and how the gun reveals itself, short visual noun-verb sentences that indicate the key signs that help detectives to spot someone carrying a hidden handgun. Thus the color usually has a distinct substantive point and is not just used to depict surfaces or to decorate the news."


(Scroll down on web page)

Hidden hand gun



See all Topics

Saturday, December 10, 2016

Bracket Characters

Solutions

Certain special characters must be surrounded with brackets:
"Microsoft Access does not restrict the use of special characters such as a number sign (#), a period (.), or a quotation mark (") in the database object names or in the database field names. However, if you do use the special characters, you may experience unexpected errors.
" To work around this problem, do not use special characters. If you must use special characters in query expressions, enclose the special characters in brackets ([]). For example, if you want to use the greater than sign (>), use [>]."
Special Characters



See all Topics

Friday, December 09, 2016

Multiple-Choice Template

A, B, or C

A template for creating a test paper.
Multiple-choice test or survey kit:

MSDN.com



See all Topics

Thursday, December 08, 2016

Tipsy Windows

More suggestions

A lot of XP stuff, but many suggestions that are still useful.

Marvs Windows Tips



See all Topics

Wednesday, December 07, 2016

No Seeum Buttons

Invisible clicks

How to place spots on your slide that initiate actions when clicked, but are otherwise invisible.

Create invisible buttons



See all Topics

Tuesday, December 06, 2016

Basic Outlook

Good tutorial

  • Basic principles of good time management
  • Folders
  • Rules
  • Notifications
  • Categories
  • Daily review: Managing your time and your tasks
  • Find that message: Searching effectively
  • Calendars and meetings
  • Contacts
Best Practices for Microsoft Outlook



See all Topics

Monday, December 05, 2016

Flight Status

Where da plane?

An easy way to find out whether Aunt Mable's plane is on time is to type the airline name and number into Google (or Bing).





See all Topics

Sunday, December 04, 2016

Timelines

Process and sample

The need to create a graphic view of a timeline can occur often.



Here are the instructions:
Vertex42.com



See all Topics

Saturday, December 03, 2016

More Controls

Proximity Functions

"Proximity Functions" is a set of MS Access modules, forms and controls that you can use to easily add professional functionality to your MS Access application without programming. By simply importing a few modules, then copying and pasting one control next to a text control on your form you can add Windows-standard file open/save dialogs, folder browse dialogs, color selection dialogs, a fantastic calendar date picker dialog, and more.

PetersSoftware.com



See all Topics

Friday, December 02, 2016

Ribbon Reasoning

What it's all about

Users opened Office 2007-10 and were shocked by the
transformation that was the Ribbon User Interface.
Here's a collection of how to's and why's by Patrick Schmid.
The Office UI Bible



See all Topics

Thursday, December 01, 2016

PPT Suggestions

Many how tos


  • Sound Solution: Playing Music on HTML Presentations
  • Creating Depth within a Slide Presentation
  • Creating & Running an Opening Loop
  • Using PowerPoint in Dual Monitor/Projector
  • Boom - Blowing things up
  • Black and White Printing Solution
  • PowerPoint Animations: Starting Things Going
  • Making and Preserving a Second Master
  • Find fabulous fonts to dress up your deck
  • Ten PowerPoint FAQ Entries You Don't Know You Need to Read

PPTfaq.com



See all Topics

Wednesday, November 30, 2016

No Friend

Spam


Here's a suspected social network SPAM email you might have received.




Don't click Yes, don't click No.
Just ignore.
Ask-Leo.com

Snopes.com

Labnol.Blogspot.com

eWeek.com



See all Topics

Tuesday, November 29, 2016

Search Google

Top 10


Tip #1 Fine-Tune Your Query with More Keywords
Tip #2 Search for Either One Word or Another
Tip #3 Include Stop Words
Tip #4 Exclude Irrelevant Words
Tip #5 Search for Similar Words
Tip #6 Search for Similar Pages
Tip #7 Search for exact Phrase
Tip #8 Use Google's Advanced Search Page
Tip #9 Search within Your Search Results
Tip #10 Search Google's Other Sites

Informit.com



See all Topics

Monday, November 28, 2016

Is it Christmas Yet?

Ideas to consider


All right, when this was posted, November was just put to bed. Still if you are going to do something for the holidays, you might want to start now.

37signals.com has a good selection of suggestions, tutorials, and links the will help you decorate your site. Elves are extra.


37signals is here to help. In these pages you'll find dozens of ideas for improving the holiday customer experience at your site. Each idea is accompanied by examples taken from top retail sites (we've visited hundreds of sites over the past two holiday seasons seeking smart techniques).


Is your Site Ready?



See all Topics

Sunday, November 27, 2016

Spreadsheets for Schools

Classroom samples

"The purpose of LT Technologies, Inc. is to link technology with teaching in order to maximize student achievement in the classroom."
Spreadsheets



See all Topics

Saturday, November 26, 2016

Picture Contols

How to

Pictures can add interest and understanding to Forms and Reports.
This article covers the pertinent details you'll need to know.

Use images in your Access forms, reports, and controls



See all Topics

Friday, November 25, 2016

Long Bar

So far to go

Here's how to inset an overbar or macron, Ā, in Word.

Overbar



See all Topics

Thursday, November 24, 2016

Cap on

A note

Here's how to have Windows notify you if the Cap Lock key is struck.
HowtoGeek.com



See all Topics

Wednesday, November 23, 2016

PPT Blog

Neat site


Tony Ramos has a neat presentation, PowerPoint blog.
He recently featured this PPT clip:

It's Hard to Believe This is PowerPoint

TonyRamos.com



See all Topics

Tuesday, November 22, 2016

Stuck Attachment

When it has to go through

What to do when attachments won't get through.
By David Gewirtz

OutlookPower



See all Topics

Monday, November 21, 2016

Wireless Security Myths

How to

A bit techy, but it may come in handy

The six dumbest ways to secure a wireless LAN:
George Ou



See all Topics

Sunday, November 20, 2016

Free Stuff

Sound bites and more

This is a collection of historical material including Edward R Murrow’s response to Joseph McCarthy.

Edward R Murrow

FreeInfoSociety



See all Topics

Saturday, November 19, 2016

Friday, November 18, 2016

Deletion Warning

Reinforce

After a while, the warning that a record will be deleted becomes routine.
Here’s the code to create your own notice:

  1. Open the database, and click Macros under Objects.
  2. Click New.
  3. Right-click the macro title bar and select Conditions. (In Access 2002+, click the Conditions button in the Macro toolbar.)
  4. Click in the first Conditions cell and enter the following:
    MsgBox("Do you really want to delete the record?"273,"Delete")<>1
  5. Click in the Action cell and enter CancelEvent.
  6. Click in the next Condition cell.
  7. Enter an ellipsis (...).
  8. Press [Tab].
  9. Enter StopMacro.
  10. Click in the next Action cell.
  11. Enter Keystrokes.
  12. Under Action Arguments, click in the Keystrokes box and click [Enter].
  13. Close and save the macro as ConfirmDelete.
  14. Open the form in design view, then right-click the form and select Properties.
  15. On the Event tab, click in the On Delete property box and select ConfirmDelete
Create a new warning for Access record deletion



See all Topics

Thursday, November 17, 2016

Auto Backup

Beep, beep


Automatically creates backups on every save.


AutoHistory: Every time you save your document (and something has changed), a backup (of the history) is created.

AutoHistory



See all Topics

Wednesday, November 16, 2016

Stop Logging In

Just stop

If you work in a secure environment, you can stop Windows from asking for your password.

Stop Asking



See all Topics

Tuesday, November 15, 2016

Launch Apps on Slide Click

Simple VBA

". . . did you know that when you set a shape's action setting to launch a program, you can pass command line switches to that program?"

Launching Other Applications with Command Line Switches



See all Topics

Monday, November 14, 2016

Direct Replies To

Someone else

Instructions about how to send out a message, but have the responses go to somebody else to answer.

HowtoGeek.com



See all Topics

Sunday, November 13, 2016

Head Blog

How to

Some instructions about how to make a header for a Blog or web page.
It talks about Photoshop, but other editors can do the same thing.

PaulStamatiou.com



See all Topics

Saturday, November 12, 2016

Short Menu Change

In context

Right clicking an object can display a shortcut menu.
Here are some instructions about how to write a macro that will edit that menu.

Right Click



See all Topics

Friday, November 11, 2016

Thursday, November 10, 2016

Database Phobia

Fear of the unknown

What's a database? What's Access? What's what.
A basic description and explanation.
Access Basics



See all Topics

Wednesday, November 09, 2016

Sources

Citations, Bibliographies, Equations, References

When putting together a research paper, one is expected to quote authorities.
Word can make it possible:

Final Paper Time



See all Topics

Tuesday, November 08, 2016

Type Design

Basic ideas

Sketches explaining some basic issues in type design.



TypeWorkshop.com



See all Topics

Monday, November 07, 2016

Crop in PowerPoint

Do it in house

"Sometimes, you want to crop around an image with a complex shape. Most people do this in Adobe Photoshop or another image-editing program, but you can do it in PowerPoint if you don't have or know another program"
Read more:
EllenFinkelstein.com



See all Topics

Sunday, November 06, 2016

Command Outlook

From the Run line

Create custom shortcuts as desktop icons or run line commands.
(updated through 2016)

HowtoOutlook



See all Topics

Saturday, November 05, 2016

Ticker Tracker

Free Code

Create your own tracker graphic. It updates automatically.



TickerFactory



See all Topics

Friday, November 04, 2016

Conditional Formatting II

If, then

Jon Peltier offers a number of ways to format conditional charts.
PeltierTech.com



See all Topics

Thursday, November 03, 2016

Better Text

How we read

BookofJoe discusses a better way to read text on a computer screen.
A Better Way



See all Topics

Wednesday, November 02, 2016

Certification

Get your paper


"Discover the only worldwide, performance-based certification program that validates the skills needed to get the most out of Microsoft Office and Windows Vista. Whether you want to stand out in the job market, improve your performance, or better prepare your students to enter the workforce, the Microsoft Certification program can help you attain the valuable expertise you need—and businesses rely on—to succeed."
Microsoft Certification



See all Topics

Tuesday, November 01, 2016

Hidden Data

Secrets revealed

Ed Bott has a discussion on Metadata. That information, such as names and notes, which is hidden in Word documents.

MrBLaw



See all Topics

Monday, October 31, 2016

Free Design Tools

Simple and free

Mauricio Duque has collected a list of 45 no cost design programs.
"Some of them are pretty decent alternatives, not only for those who are not willing to spend the big bucks, but also for those who need some specific tasks done, like resizing a batch of picture without needing to run the almighty Photoshop."

Snap2Objects.com



See all Topics

Sunday, October 30, 2016

Layout Contol

Unique designs

How a slide is laid out can be captured as a custom template.
You are not restricted to the schemes that come out of the box.

Custom Layout



See all Topics

Saturday, October 29, 2016

Mail Excel

VBA + sample

Excel Guru Ron de Bruin has put together the VBA code needed to send Excel via email.
He has also included the sample workbooks for those that are not VBA literate.

Also:
". . . a new add-in named RDBMail for Excel/Outlook 2007-2016
RDBMail

The add-in create a new tab on the Ribbon named RDBMail with a lot of mail options.
You have the option to send as workbook or PDF for every mail option."
Code to send mail from Excel



See all Topics

Friday, October 28, 2016

Hosting Info

Who dat provider?

Find out which provider a site is using.
Find out which internet providers are most reliable.
Find out which operating system is being used by which provider.
Find out . . .

Netcraft.com



See all Topics

Thursday, October 27, 2016

Video Tutorials Too

What you see

"MIStupid.com is The Online Knowledge Magazine that publishes information that everyone should know, wants to know, or forgot.
MIStupid.com was created in 2001 by Greg Renza with the desire to eradicate the world's stupidity."
A few of the lessons include:
  • Concatenating Cells
  • Conditional Formatting
  • Subtotals
  • Data Sorting
  • Formulas and Named Cells
  • Create Graphs and Charts
MIStupid.com



See all Topics

Wednesday, October 26, 2016

Productivity Guides

Free suggestions


Microsoft provides 22+ guides to productivity in the office.

"Microsoft IT created Work Smart productivity guides (previously Everyday Productivity Education (EPE) guides) to bridge the gap between technology and users. Work Smart guides provide employees with scenario-based, best-use productivity aids on Microsoft products and technologies. As more Work Smart guides are published, Microsoft IT expects to see more consistent, productive, and cost-effective use of products and technologies across the company."

IT Showcase



See all Topics

Tuesday, October 25, 2016

Database Genisis

Gotta start somewhere


Microsoft has a tutorial on how to create a database.

Office.Microsoft.com



See all Topics

Monday, October 24, 2016

Word Feature

New or reacquaint

2007 came up with a number of new and improved features. Most are the same in 2010-13.
Here's a description of some built in tools.

Beyond the Ribbon



See all Topics

Sunday, October 23, 2016

Convert Graphic Styles

Straight forward

Often you will have pictures in one format and want to explore using it in a different manner.
Built into Office 2003/7/10 is a mini app called Microsoft Office Picture Manager.

1. Go to Start > All Programs > Microsoft Office > Microsoft Office Tools > Microsoft Office Picture Manager
2. Browse to the images you want to convert and select them
3. Go to File > Export
4. Under Export with this file format, click the dropdown and select one of the formats (TIFF, PNG, JPG, BMP. . .)


Converting WMF's



See all Topics

Saturday, October 22, 2016

Friday, October 21, 2016

Stuck in the Outbox

Steps to try

Some suggestions about how to empty your outbox and speed your greatest thoughts on their way.

How to troubleshoot messages stuck in your Outbox


Outlook Troubleshooting Tips



See all Topics

Thursday, October 20, 2016

Google Searches II

Tips


Here's a link to a PDF file that shows how to maximize Google searches.

Parameters Cheat Sheet



See all Topics

Wednesday, October 19, 2016

Selection Address

What's the count

". . . know what range is selected at any given time. You can look at the Name Box, but that only show the active cell."

Display number of Rows and Columns



See all Topics

Tuesday, October 18, 2016

Navigate Navigation Pane

Ahoy


Here's the Microsoft tutorial:

Meet the Navigation Pane

Also:
"We have heard a few of you have missed the ALT D shortcut to open an object in design. As you know, ALT in ribbon apps now allows you to access ribbon shortcuts. Next time you want to open an object in design view, try Control Enter."
Navigation pane tip



See all Topics

Monday, October 17, 2016

Custom QAT

Access additions


Applications put most of the most-used commands on the Home tab's Ribbon, not everything is there. You may want to add Close, Close All, or Print commands, for example.

In the upper Left corner is the Quick Access Tool bar.

To update the QAT:
Click the down-pointing arrow to the right of the QAT.
Choose any common commands (New, Close, Print, etc.) by checking the option.



See all Topics

Sunday, October 16, 2016

Temp Files

Where they live and breathe


Ed Bott discusses temp files; care, feeding, and cleaning.


Ed Bott



See all Topics

Saturday, October 15, 2016

Flip Text

This text is right side up


uʍop ǝpısdn sı sıɥʇ

This site accepts your perfect prose and turns it around.
(with Unicode)

RevFad.com



See all Topics

Friday, October 14, 2016

Display Order

What’s on top

Outlook allows you to rearrange how information is displayed in your email list.



(Outlook 2010)

HowToGeek.com



See all Topics

Thursday, October 13, 2016

Historical Documents

Remember good old paper?


"Fold3 helps you find and share historic documents. We are able to bring you many never-before-seen historic documents through our unique partnerships with The National Archives, the Library of Congress and other institutions.

Our patented digitization process is helping bring other collections to life on the web everyday.

But Fold3 is more than just a dusty, digital archive online. We provide you the tools to share your historical passions and connect with others."


Fold3.com



See all Topics

Wednesday, October 12, 2016

Access Communities

It takes a village


Here are some links the Access groups. Someone has probably asked your question before.
Access Communities



See all Topics

Tuesday, October 11, 2016

Merge Formatting Extended

Manipulation

When you merge data into Word, it takes on the formatting of the target document.
This tip allows you the dictate the appearance of merged data.


WordRibbon.Tips.Net



See all Topics

Monday, October 10, 2016

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

Sunday, October 09, 2016

Schlub

a stupid, worthless, or unattractive person

"(Jerry is) an all-American schlub . . . He has turned these degradations into an animated Web site appropriately named ItsJerryTime.com, on which he battles a cast of tormentors that includes the Meal Moth, his landlord and an alleged telephone conspiracy perpetrated by a duo of old ladies" Wall Street Journal

ItsJerryTime.com



See all Topics

Saturday, October 08, 2016

Home for PPT Ideas

A covey of notions

"PowerPoint Heaven is a PowerPoint entertainment portal for PowerPoint animations, games, artworks, showcases, animation templates and tutorials. The focus of this site is to maximize the use of Microsoft PowerPoint and go beyond its capability. Our goal is to show users that PowerPoint is not simply a presentation tool, but is also capable on leveraging into other areas such as creating games, artworks and animations."

PPTHeaven



See all Topics

Friday, October 07, 2016

Order on the Right

Context Menu

Eric Leauglt shares the VBA code that can be used when "Organizing Your E-mail Using Custom Item Context Menus in Outlook 2007".

May appear to be daunting, but if you have had some exposure to VBA, it's not that bad.

Eric Leauglt



See all Topics

Thursday, October 06, 2016

Command Reference

2003-2007-2010-2016

Those of you that are just now making the switch to the Ribbon world, will find this valuable.

ComputerWorld.com



See all Topics

Wednesday, October 05, 2016

My One and Only Thrill

Melody Gardot


Gentle. Almost from another time.
"The story of vocalist Melody Gardot is as remarkable as any who perseveres against abject adversity. Born in New Jersey in 1985, she took up piano and played as a youngster on the nightclub scene of Philadelphia, influenced by jazz, folk, rock and pop musics. At age 19 she was a fashion student at the Community College of Philadelphia. But, on a fateful day, while riding her bicycle, the driver of a Jeep made an illegal turn, hurdling into Gardot and leaving her in the street for dead. Hospitalized for months with multiple head injuries and pelvic fractures, her love for music was the best therapy she could receive.
Her music could be described as a cross between Laura Nyro, Joni Mitchell, Eva Cassidy, and Shania Twain, but goes deeper than mere pop convention. ~ Michael G. Nastos, All Music Guide"





See all Topics

Tuesday, October 04, 2016

Tips for Office

Suggestions

TechRepublic lists a number of areas that you might explore when training is needed for a new Office version.

Here are a few:
  • LINKS TO TIP SHEETS AND ARTICLES
    "Instead of telling your users to go out to Microsoft.com and do a search, put hyperlinks to the printer-friendly version of tip sheets and articles on your company's main portal page. Providing links to information you know they need will help you cover the training bases. And presenting the links on an internal web site they already use will show your users that it's okay to go outside of their four firewalls to learn something new. Include your favorite hyperlink in your signature line so it goes out in every e-mail you send."
  • ONLINE TRAINING
  • E-LEARNING
  • WEBCASTS
  • VIRTUAL TRAINING
  • MULTILINGUAL SCREENTIPS AND TRANSLATIONS
  • COMMAND REFERENCE GUIDES
  • OFFICE ONLINE AT WORK
10 ways to train your users on Office for free



See all Topics

Monday, October 03, 2016

Context Clutter

Registry mop


When you Right-click the desktop, a “Context” menu appears. Some programs like to sneak in and add shortcuts to their very important applications.
If your context menu has been cluttered up, here are some instructions and tips to clean it up.


HowToGeek.com



See all Topics

Sunday, October 02, 2016

Classroom PP

A few tips


Here is a tutorial on ways to use PowerPoint in the classroom.
They also talk about how to use the 2007-2010 ribbon.

Actden.com



See all Topics

Saturday, October 01, 2016

Stop Reply To All

Macro magic

Scott Hanselman (who is ". . . an old fat guy with a Black Belt that used to fit") has a tutorial on how to disable "Reply to All".

How To Easily Disable Reply To All And Forward In Outlook



See all Topics

Friday, September 30, 2016

Fast Interchange

7 day URL


Go to http://cl1p.net and then:

Enter a URL that starts with http://cl1p.net.
example:http://cl1p.net/assuming/

Paste in anything you want.
Some text, links, etc. Click 'Save' when done.

On any other computer open a browser to the same URL.
You will find the information you entered in step 2.


Do more with CL1P.net. Just open any URL that starts with http://cl1p.net and you can...
  • Create a notebook
  • Have a conversation
  • Create a community
Cl1p.net



See all Topics

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

Monday, August 29, 2016

Garden Cities of To-Morrow

Lullaby Baxter's Back


The quirky star of Capable Egg returns.




Rattled Little Clam

Montreal, 1997. Lullaby Baxter is waiting tables at Jello Bar. Coaxed on stage for an impromptu number, she sings Billie Holiday's signature song "Lover Man (Oh, Where Can You Be?)". This, her first public performance since grade school, brings down the house.

She buys a green guitar and learns "Leaving On A Jet Plane". Someone at the Laundromat says, "Anyway, try writing songs."

Little Song
Also see:
Capable Egg



See all Topics

Sunday, August 28, 2016

Copyright Fair Use

When can you use it?


The copyright law is a little vague when it comes to fair use.


" Fair use is a copyright principle based on the belief that the public is entitled to freely use portions of copyrighted materials for purposes of commentary and criticism. For example, if you wish to criticize a novelist, you should have the freedom to quote a portion of the novelist's work without asking permission. Absent this freedom, copyright owners could stifle any negative comments about their work.
Unfortunately, if the copyright owner disagrees with your fair use interpretation, the dispute will have to be resolved by courts or arbitration. If it's not a fair use, then you are infringing upon the rights of the copyright owner and may be liable for damages."




U S Copyright Office
Ohio State University
CopyrightLaw.com



See all Topics

Saturday, August 27, 2016

List Field in Access Tables

Bit o' code


When viewing a table that has many fields in Design view, you have to scroll up and down to review the field names.

This can be tiresome when you're referring to them constantly, and particularly when you're working with several tables.

The following code produces a field listing for a given table. This can then be copied to Notepad and printed for easy reference.

Enter the code into a module, substituting your table's name where appropriate.

Open the Debug/Immediate window, type ListFields,

Press Enter to produce the listing.
Sub ListFields()
Dim dbs As DATABASE
Dim dbfield As Field
Dim tdf As TableDef

Set dbs = CurrentDb
Set tdf = dbs.TableDefs!NAMEOFYOURTABLE

Debug.Print ""
Debug.Print "Name of table: "; tdf.Name
Debug.Print ""

For Each dbfield In tdf.Fields
Debug.Print dbfield.Name
Next dbfield
End Sub




See all Topics

Friday, August 26, 2016

Moving PST

Instructions



It is sometimes necessary to move Outlook .PST files to a different drive on your local computer.

Here are Microsoft's instructions:

How to Move your Personal folders

You may be tempted to move the file to a network drive, but Microsoft advises against it:

Why Outlook .PST files are unsupported over a LAN or WAN link

How to manage .pst files in Outlook

 
Slipstick.com has this to say about how
 To move a Personal Folders .PST file

and

Moving Outlook .PST files to a new machine



See all Topics

Thursday, August 25, 2016

Link Workbooks

Tie them together


Excel is a flatfile database, but you can do some Access kinds of relationships.


"A link is a formula that gets data from a cell in another workbook. When you open a workbook that contains links (a linking workbook), Microsoft Excel reads in the latest data from the source workbook or workbooks (updates the links).

Use links when you want to maintain information in a single workbook, but also use the information in other workbooks. For example, if your product prices change frequently, you might keep a master price list.
Other workbooks that use the price data in calculations, such as purchase orders, inventory valuations, or sales estimates, can create links to the price list workbook so calculations always use current prices. When prices change, you only have to enter the new prices in one place."


  1. Open both workbooks.

  2. In the source workbook, select the cells you want to link to and click the Copy button.

  3. Switch to the destination workbook and click the upper left cell of the range where you want the links.

  4. On the Edit menu, click Paste Special, and then click Paste Link.
Create and Manage Links



See all Topics

Wednesday, August 24, 2016

No Home in IE

Blanked out


You can open Internet Explorer to a blank page.

Sometimes your normal home page may be too busy, or slow to load when you just want to pop out to a different location.

This trick will give you a blank slate to paste in a new URL.

  1. Create a new Desktop shortcut
    (Right click an empty spot on the desktop and choose New>Shortcut)

  2. Copy the following, and paste it as the target for the shortcut:


    "C:\Program Files\Internet Explorer\iexplore.exe" nohome

  3. Name the shortcut something like Blank IE




See all Topics

Tuesday, August 23, 2016

Give Yourself a Tip

Take your own advise


If you still have Windows set up so that it shows a tip when you first sign in, you can add your own message, or change the ones the developers created.
  1. Go to start>Run and type in Regedit

  2. Find:
    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\Tips]
    

  3. Create a new string value named by incrementing the existing value names and set it to the required tip text.

  4. The Data Type is REG_SZ (String Value)

  5. The Value Data: Your tip




See all Topics

Monday, August 22, 2016

Notes from Word

Import it all


One technique that can be used when preparing a PowerPoint show, is to import material from an existing Word Outline.

If the Word document is formatted with Heading styles, Heading 1 will become a new slide and the subsequent headings, 1 through 6 will become bullet points on the slide.

It may be desirable to prepare notes for each slide while developing the Word outline. Notes don't appear on the slide, they are placed on a separate page that can be printed out for the speaker or handed out to the audience.

Bill Dilworth has written a macro that moves information that has been formatted, say at Heading 6, and places it on the notes page:

"This macro outline allows the user to use Word's "Send To PowerPoint" feature, then run this macro to get notes from MS Word to PowerPoint as notes. The macro allows you to set the text level you want to become the notes."


Word Outline to Notes Page in PowerPoint



See all Topics

Sunday, August 21, 2016

Burn Wrapping Paper?

Holiday info


If you want to find out the real background story on any number of water cooler questions, try:
StraightDope.com

For instance:

Why is it dangerous to burn wrapping paper?


The fire is the wrong place for other holiday detritus as well - der Tannenbaum, for example.

My assistant Una had an Uncle Bob, a manly man who felt throwing the Christmas tree away was a waste of good firewood. So he tossed it in the fireplace - gave him a nice warm glow.
Unfortunately
what was glowing was the roof, presumably ignited by embers.
Fortunately
the fire was small and anybody with a hose could have put it out.
Unfortunately
the hose was frozen solid and the fire department had trouble getting the nearest hydrant to work.
Fortunately
the firefighters were able to throw a ladder up against the house and put out the fire with a chemical extinguisher. They then hacked off a small hunk of charred roof with axes, peered into the crawl space, and declared the fire out.
Unfortunately,
having by now found an operational hydrant, the firemen declared they needed to hose down the roof "as policy," sending a torrent of water through the hole and collapsing the living room ceiling.
Really unfortunately,
the house that all this happened in belonged not to Uncle Bob but his in-laws. Bob bought them an RV and matters were pronounced square, but it was a lesson he won't soon forget, and neither should you.




See all Topics

Saturday, August 20, 2016

Combo Box Queries

How to



Parameter queries add flexibility to filtering records in a database. To make it easy, take a look at this approach from Martin Green's Office Tips site:

Drop down box in a Parameter Query

  1. Build a dialog box with as many combo boxes as you need.
  2. Design a query to read its criteria from the information on the dialog box.
  3. Create a macro or visual basic procedure to tell them both what to do.
Also:
Base Combo Box on Parameter Query to Filter Values



See all Topics

Friday, August 19, 2016

It's Policy

Set your own


It's best to make your email rules available and well known:


" Email is a quick, cheap and easy means of communication. This makes email a great business tool, but at the same time a potential threat for employers. Email threats such as confidentiality breaches, legal liability, lost productivity and damage to reputation cost companies millions of dollars each year.
How can a company protect itself from these threats? The first step in securing your company is to create an email usage policy. After you have created your email policy you must make sure it is actually implemented. This can be done by giving regular trainings and by monitoring employees' email using email security software. "

You may find it useful when trying to develop your own E-mail policy.

Nolo.com: Create an Email Policy



See all Topics

Thursday, August 18, 2016

Change Insert Picture Target

File location


If you would like to specify the folder Word will default to when you go to Inset>Picture:
  1. From the Tools menu, click Options.

  2. Select the File Locations tab.

  3. Select ClipArt Pictures from the File Types list.

  4. Click the Modify button.

  5. Navigate to the folder you want Word to default to.

  6. Click OK. OK.


In 2007-10, you'll find the entry by
  1. Click on the Office logo

  2. Go to Word Options>Advanced

  3. Scroll down to General

  4. Click the File Locations button




See all Topics

Wednesday, August 17, 2016

Have a Geeky Gift

And a Functional New Year


It is rather late in the season, but this is a gift that gives all year long:
This hilarious clock is the perfect accessory for any Excel power user. Each numeral has been replaced with a suitable Excel function that will evaluate to that numeral.

We've used one function from as many function categories as possible to really provide a broad range of functions.


For instance:
=FACT(3) - The FACT() function returns the Factorial of a number. The Factorial of 10 is 10x9x8x7x6x5x4x3x2x1. This function is great for statisticians calculating combinations and permutations. In our case, the Factorial of 3 is 3x2x1 or 6

MrExcel.com:

Excel Function Clock



See all Topics

Tuesday, August 16, 2016

Files DO have Extensions

Smarten your machine


For some reason, the powers that be thought that the general public was going to be confused by those suffixes at the end of file names.

To help us all out, they hid extensions by default.

I like to see .Doc (or .Docx). Here's how to get that information back
  1. Open Windows Explorer

  2. Go to Tools>Folder Options.

  3. In the Folder Options dialog box, click the View tab

  4. Clear the checkbox to the left of the Hide extensions for known file types option

  5. Click OK to close the dialog box and return to Windows Explorer


Also see EdBott.com:
 Show or hide file name extensions

and
Configure Windows



See all Topics

Monday, August 15, 2016

Display Row, Column Headings

User Function



Here's an odd little use of functions.

If you want to display the Row number on a spreadsheet, the formula
=Row()
works just fine.
You could then hide the Row and Column headings and format the Row numbers any way you want. If a Row is deleted the numbers will automatically update.

Column headings are a little harder. The formula =Column() will show the number of the Column, not the letter, i.e. "2" instead of "B".

The following formula extracts the Column letter:

=SUBSTITUTE(ADDRESS(1,COLUMN(),4),"1","")


To break it down:

=ADDRESS(row_num,column_num,abs_num)

This finds the address at Row number "1" and current Column number. The abs_num of "4 " says make the result a relative address.

The formula will produce a result such as "AA1".

SUBSTITUTE(text,old_text,new_text)

This function looks at the address, i.e. "AA1".
It replaces the Row number character ("1") with a null or empty value ("").
The formula will produce a result such as "AA".

Also see Daily Dose of Excel by Dick Kusleika.

Dick mused:'

"Sometime before the year 3,000, Microsoft will hopefully increase the number of columns in Excel (Hey, I can dream can't I). The challenge before you is to write a function that converts a column number to its letter equivalent assuming columns go to ZZZZ. That’s about 450,000 columns - maybe more than I need."


Of course Office 2007+ has taken it up to 16,284 columns.



See all Topics

Sunday, August 14, 2016

Hungarian Notation

Belépés



This tip is useful in a number of applications.

When you name an object, include a prefix that identifies the type of object.

When naming a table for Customers, use "tblCustomers" .
You could also have a form for customers. It would be "frmCustomers" .


It's called Hungarian notation because with the prefix, it does not look like an English word.

Dr. Charles Simonyi developed the convention at Microsoft, and he is from Hungary.

He wrote an article on Hungarian notation for MSDN, the Microsoft Developer's Network.

Hungarian notation


Here are some prefixes:
  • tbl- Table
  • qry- Query
  • frm- Form
  • rpt- Report




See all Topics

Saturday, August 13, 2016

Templates are Digital Stencils

Make your own


If you have a document; such as a report or reoccurring newsletter, one way to reduce the production time is to create a template.

These preformatted, boiler plated documents can then be fleshed out without having to reinvent the sardine.

Here are some tutorials to help you along:

AddBalance.com
Template Basics

About.com
Word Templates



See all Topics