|
Host your Web site with PureHost! |
 Thursday, June 30, 2011 – Permalink – IE Temp filesStorage areaEvery once in awhile when the Berners-Lee pipeline clogs up, you are instructed to delete the temporary files that IE saves. You can do it with the Click of an IE Options button. Here's where those files are stored:  As you see, you could move that location if you wanted to. Ed Bott mentioned this in his Blog: Finding the Temporary Internet Files folder See all Topics <Doug Klippert@ 3:55 AM
Comments:
Post a Comment
Wednesday, June 29, 2011 – Permalink – Spreadsheet Boo-BoosDesign suggestionsA few links to sites with advice on spreadsheet design and error detection. European Spreadsheet Risks Interest Group: Spreadsheet mistakes - news stories John F. Raffensperger: (oldies but . . .) Spreadsheet Style Microsoft Assistance: Worksheet design strategy Raymond R. Panko, PhD University of Hawaii What We Know About Spreadsheet Errors See all Topics Labels: Excel <Doug Klippert@ 3:24 AM
Comments:
Post a Comment
Tuesday, June 28, 2011 – Permalink – Splash ScreenBrand your appYou can replace the Access splash screen with your own logo. Access displays a quick splash screen when you launch it. You can replace that splash screen with a graphic of your own. Save a bitmap graphic in the same folder as the database. Give the graphic the same name as your database and make sure it has a BMP extension. (MyDatabase.BMP) Now when you launch Access by double-clicking on the database icon or its shortcut, you will see your logo instead of Access's default screen. You can also make the graphic 1x1 pixels, so it won't be seen. MS Knowledge Base: How to Create a Custom Startup "Splash" Screen See all Topics Labels: Access <Doug Klippert@ 3:40 AM
Comments:
Post a Comment
Monday, June 27, 2011 – Permalink – YouTube in PowerPointImbedded videosShyam Pillai has provided a free wizard to imbed YouTube clips into a PowerPoint Presentation "Use this to insert YouTube videos into a PowerPoint slide. All you need to do is to provide the YouTube video URL that appears in the browser address bar, the rest is taken care of by the YTV Wizard. YouTube Video Wizard See all Topics Labels: PowerPoint <Doug Klippert@ 3:20 AM
Comments:
Post a Comment
Sunday, June 26, 2011 – Permalink – Gmail FeaturesThe top 10Bill Kee, Associate Product Marketing Manager for Gmail, has a blog and has listed 10 major features of the free web based email system. Including: "When you get an email that references an address, look to the right and you'll probably see a link from Gmail pointing you to a map of the address on Google Maps. Gmail features Part 1 Gmail features Part 2 See all Topics Labels: Internet <Doug Klippert@ 3:48 AM
Comments:
Post a Comment
Saturday, June 25, 2011 – Permalink – Web DataNumbers from the etherExcel has had a feature called web query. Here's an add-in that makes it a little easier. "The Excel 2007 Web Data Add-In makes it easy to use a Web page as a data source in Excel.  Web Data Getting data from the Web in Excel See all Topics Labels: Excel <Doug Klippert@ 3:44 AM
Comments:
Post a Comment
Friday, June 24, 2011 – Permalink – Charity or ScamIRS worthy or notDid someone call asking for money for the Global Relief Foundation, Inc. or some other charitable organization? You can look them up with the IRS. BTW, you might think again about these groups:
Revoked by IRS Here's the site for Washington state: Secretary of State See all Topics Labels: Addendum <Doug Klippert@ 3:16 AM
Comments:
Post a Comment
Thursday, June 23, 2011 – Permalink – Outlook Keyboard ShortcutsGood StrokesCheck names--------------------------------------Ctrl + K or Alt + K Check spelling-----------------------------------F7 Choose the account from which to send a message(with focus on the To line) and then TAB to the Accounts button------------Ctrl + TAB Convert an HTML or RTF message to plain text-----Ctrl + Shift +O Delete a mail message----------------------------Delete or Ctrl + D Display the Address Book-------------------------Ctrl + Shift + B Find a message ----------------------------------Ctrl + Shift + F Find text----------------------------------------F3 Forward a message--------------------------------Ctrl + F Go to folder-------------------------------------Ctrl + Y Go to next mail message--------------------------Down or Up arrow Insert signature---------------------------------Ctrl + Shift + S Mark a message as read---------------------------Ctrl + Enter or Ctrl + Q Move between the Folders list and message list---Tab Open or post a new message-----------------------Ctrl + N Open the Address Book----------------------------Ctrl + Shift + B Open the Inbox-----------------------------------Ctrl + I Open the Outbox----------------------------------Ctrl + O Open the selected message------------------------Ctrl + O or Enter Post to a folder---------------------------------Ctrl + Shift + S Print the selected message-----------------------Ctrl + P Reply to a message-------------------------------Ctrl + R Reply to all-------------------------------------Ctrl + Shift + R Send (post) a message----------------------------Ctrl + Enter or Alt + S Send and receive mail----------------------------Ctrl + M or F5 Switch among Edit, Source, and Preview tabs------Ctrl + Tab Switch to Inbox----------------------------------Ctrl + Shift + I Switch to Outbox---------------------------------Ctrl + Shift + O Royal National Institute of the Blind: Outlook Keyboard Shortcuts - Doc See all Topics Labels: Outlook <Doug Klippert@ 3:42 AM
Comments:
Post a Comment
Tuesday, June 21, 2011 – Permalink – MHTMLOne file web pagesWhen a web page is created using HTML, the coding is normally contained in one file and the graphics in separate folders. The Mime HTML or MHT/MHTML format changed that. Starting with Office 2000 as an add-in and carried through XP as a "Web Archive" option, the format emerged in Office 2003 as a "Single file web page" selection in the File Save As dialog box. Features in Internet Explorer Here are the Save As choices available in an application such as Word:
Short Summary of the MHTML Standard See all Topics Labels: Windows <Doug Klippert@ 3:08 AM
Comments:
Post a Comment
Product KeyfinderSearch machineYou have a legal copy. You installed it and activated the application. Now your machine blew up and you have to install it again. Where's the Product key? Probably gone sometime in the past 10 years. "The Magical Jelly Bean Keyfinder is a freeware utility that retrieves your Product Key (cd key) used to install windows from your registry. Keyfinder See all Topics Labels: Windows <Doug Klippert@ 3:05 AM
Comments:
Post a Comment
Monday, June 20, 2011 – Permalink – New Tables in TownBigger and better (?)Pre '07 versions of PowerPoint limited tables to a maximum of 25 rows and columns. You were able to ungroup the table cells before, but that has been taken away. "In this release, we have increased that maximum to 75x75 within the UI. PowerPoint Tables It can still be done: Workaround for animating a table:
See all Topics Labels: PowerPoint <Doug Klippert@ 3:33 AM
Comments:
Post a Comment
Sunday, June 19, 2011 – Permalink – Mailbox DietPrune the fatMicrosoft provides a tutorial on the mechanics of Outlook 2007 mailboxes. Learning how to manage your Microsoft Outlook 2007 Mailbox and keep it within a specific size limitation.Battle mailbox size Performance problems with a large .pst file Manage with Mailbox Cleanup See all Topics Labels: Outlook <Doug Klippert@ 3:03 AM
Comments:
Post a Comment
Saturday, June 18, 2011 – Permalink – Smart TagsDon't hideIn Excel, if you type a stock ticker symbol, the options offered on the Smart Tag are:
 How to turn on smart tags. Smart tag functionality is turned off by default. Before you can use smart tag functionality, you must turn on smart tag recognition. To do this, follow these steps, as appropriate for the version of Excel that you are running. Microsoft Office Excel 2007
 Microsoft Office Excel 2003 and earlier versions of Excel
See all Topics Labels: Excel <Doug Klippert@ 3:38 AM
Comments:
Post a Comment
Friday, June 17, 2011 – Permalink – DOS were the daysTake CMDHere's an introduction to the Command Prompt: Command Line Microsoft has provided product documentation on the use of the Command line in Windows. Hopefully this won't be something you need in an emergency. Use it in good health. Details for Command line
See all Topics Labels: Windows <Doug Klippert@ 3:40 AM
Comments:
Post a Comment
Thursday, June 16, 2011 – Permalink – Move the ShowPortable hintsA speaker can be called upon to present programs almost anywhere. Every site is unique and has its own problems. Your show may, also, have to be sent out on its own. Here are some suggestions that may help on the road: Distributing PPTs - Pitfalls, Panics & Pleasures By Steve Rindsberg There are several potential problem areas:
See all Topics Labels: PowerPoint <Doug Klippert@ 3:15 AM
Comments:
Post a Comment
Wednesday, June 15, 2011 – Permalink – Hi-Res WallpaperDetails apparentChoose from a broad selection of free pictures to use for wallpaper. Download sizes from 1920x1200 to 320x240.  Free High-Resolution Widescreen Wallpaper See all Topics Labels: Windows <Doug Klippert@ 3:26 AM
Comments:
Post a Comment
Tuesday, June 14, 2011 – Permalink – Word to PPSend outline to PowerPointThat old 2003 version allowed you to send a Word file to PowerPoint and have it create a slide show. After styling with Heading 1, 2, etc, go toFile > Send To > Microsoft Office PowerPoint. 2007 is a little different (duh!)
Word to PowerPoint See all Topics Labels: PowerPoint <Doug Klippert@ 3:19 AM
Comments:
Post a Comment
Monday, June 13, 2011 – Permalink – Last Name FirstPhonebook styleSort the Contacts list by the File as field. To do this, use one of the following methods depending on the version of Outlook that you are using. In Outlook 2007, follow these steps: 1. Start Outlook 2007. a. On the Tools menu, click Account Settings. b. Click the Address Books tab, and click Change. c. Under Microsoft Office Outlook Address Books, click the address book that you want to change the contact display format for.  For example, Contacts: Mailbox - Personal Folders, and then click File As (Smith, John). In Outlook 2003, follow these steps: 1 Start Outlook 2003. a. On the Tools menu, click E-mail accounts. b. Click View or change directories or address books, and then click Next. c. Click Outlook Address Book, and then click Change. d. Under Outlook Address Books, click the address book that you want to change the contact display format for. For example, Contacts: Personal Folders, and then click File As (Smith, John). e Click Close, and then click Finish. 2. Quit and restart Outlook. 3. Verify that the newly created contacts are sorted in the LastName, FirstName format. To do this: a. On the Tools menu, click Options. b. Click the Preferences tab, and then click Contact Options. c. In the Contacts Options box, click Last, First in the Default File As order list. d. Click OK two times. 4. Edit the properties of any contacts that have the File as option configured individually. This setting overrides the setting that you made in step 1. a. Double-click any contact that does not appear in the LastName, FirstName format in your Contacts list. b. Click the General tab, click the down arrow next to File as, and then click Lastname, Firstname, where Lastname, Firstname is the name of the contact. Lastname first Outlook 2010 See all Topics Labels: Outlook <Doug Klippert@ 3:38 AM
Comments:
Post a Comment
Sunday, June 12, 2011 – Permalink – All the BasicsAll(most) all you need to knowOffice.Microsoft.com has a short demo that shows you the main things anyone needs to know about Excel. There are many thousands of users who find that this is all they ever need.
See all Topics Labels: Excel <Doug Klippert@ 3:35 AM
Comments:
Post a Comment
Saturday, June 11, 2011 – Permalink – New WindowPick your targetExpression Web/FrontPage/HTML provides the opportunity to choose how a page opens when you click on a hyperlink. Create a hyperlink as you usually would by selecting the text (or graphic) you want to use for the link. Choose Insert > Hyperlink... (or use Ctrl-K or the toolbar icon  as a shortcut), and locate the page in the current web or enter an address in the URL field.On the right side of the Create Hyperlink window you'll see a button named "Target frame"; click the button. You'll get the Target Frame dialog box. In the "Common targets" field, select New Window. Click OK, then click OK to close the Create Hyperlink dialog box. Your hyperlink will now open a new browser window when clicked.  The code would appear like this: <a target="_blank" href="TCC/Blog/blogger.html">Blog</a> To make it the page default, place the following code in the "head" section: <base target="_blank"> See all Topics Labels: Expression Web, FrontPage, HTML, Internet <Doug Klippert@ 3:46 AM
Comments:
Post a Comment
Friday, June 10, 2011 – Permalink – Night SkyThe real stars
In 1826, the astronomer Heinrich Olbers asked, "Why is the sky dark at night?" By his time, physicists had learned enough to realize that, in a stable, infinite universe with an even distribution of stars, the entire universe should gradually heat up.
Labels: Addendum <Doug Klippert@ 3:28 AM
Comments:
Post a Comment
Thursday, June 09, 2011 – Permalink – Null ParameterShow somethingIf a user doesn't specify a parameter value, you can use a wildcard with the parameter in the format Like [Enter Name] & "*" The problem with this is that the query will return records that partially match the criteria. For instance, if users searching for records based on last name enter a parameter value of "Smith" they'll also get the records for Smithers, Smithfield and Smithson. Another problem is that the parameter query will ignore any records where the field being searched contains a Null value when you try to return the entire recordset with a blank parameter. To fix this, set up a query to limit responses to explicit parameter entries, but still allow users to return all records by leaving the parameter blank. If you're searching for LastName, open the query design grid and add LastName to it. In the Criteria row for the field, enter the parameter prompt [Enter Name] Then, in the next blank column of the design grid, enter the same parameter (everything between and including the square brackets) in the Field text box. Finally, in the Or row, enter the criteria Is Null . If you're using any additional criteria for other fields, make sure to copy that criteria to the Or line as well. See all Topics Labels: Access <Doug Klippert@ 3:19 AM
Comments:
Post a Comment
Wednesday, June 08, 2011 – Permalink – Auto Text - Building BlocksNew old feature
Labels: Word <Doug Klippert@ 3:14 AM
Comments:
Post a Comment
Tuesday, June 07, 2011 – Permalink – Custom ShortcutsHands on keysEd Bott reminds us how to set up custom keyboard shortcuts to start applications.  Create custom keyboard shortcuts See all Topics Labels: Windows <Doug Klippert@ 3:16 AM
Comments:
Post a Comment
Monday, June 06, 2011 – Permalink – Google ShowsPresentation alternativeGoogle Docs now has a presentation element. You can create documents, spreadsheets and presentations online. They're a bit restricted and simplexat this point, but you can also import files and convert them for sharing or publication. Google Docs Review of Google presentation See all Topics Labels: PowerPoint <Doug Klippert@ 3:13 AM
Comments:
Post a Comment
Sunday, June 05, 2011 – Permalink – Desktop CalendarStare at the dayOutlook on the Desktop places your Microsoft Outlook Calendar on your desktop. You can adjust its appearance. You can switch to Inbox, Tasks, Contacts, or Notes as well. Double-click any item on the calendar to open in Outlook. It works with all versions of Outlook from 2000 SR-1 forward; it also works with Vista and it's free. Outlook on your desktop See all Topics Labels: Outlook <Doug Klippert@ 3:36 AM
Comments:
Post a Comment
Saturday, June 04, 2011 – Permalink – Chart ArtApple π
Labels: Excel <Doug Klippert@ 3:10 AM
Comments:
Post a Comment
Friday, June 03, 2011 – Permalink – Who's smarter?My barista can take your electricianI.Q. is not really a guarantee of vocational/financial success. There are about as many college professors with scores below 100 as there are Kindergarten teachers who register above 120. Here's a link to how the testing breaks down: IQ Distribution of Various Jobs See all Topics Labels: Addendum <Doug Klippert@ 3:29 AM
Comments:
Post a Comment
Thursday, June 02, 2011 – Permalink – Loan PaymentBasic tutorialMicrosoft provides a number of learning activities related to fundamental tasks. Here's one that walks the student through a worksheet designed to calculate interest and total payment for a purchase, based on different loan terms. "This practical spreadsheet lesson offers easy answers to life's perplexing math problems like How much will my dream car really cost after financing? Also: Labels: Excel <Doug Klippert@ 3:24 AM
Comments:
Post a Comment
Wednesday, June 01, 2011 – Permalink – Single Spaced +2007 gives you more than you ask forThis quote from The Microsoft Office Word Team's Blog explains their thinking behind making line spacing "looser" in 2007 than it was earlier.
What does single spacing really mean anyway?  How to fix it: Default line spacing in Word 2007 differ from earlier versions of Word See all Topics Labels: Word <Doug Klippert@ 3:11 AM
Comments:
Post a Comment
|
