|
Book Home Page Bloglines 1906 CelebrateStadium 2006 OfficeZealot Scobleizer TechRepublic AskWoody SpyJournal Computers Software Microsoft Windows Excel FrontPage PowerPoint Outlook Word 
Host your Web site with PureHost! 
|
 
Thursday, April 30, 2009 – Permalink – Google from the Help MenuSearch with Excel, Word, PowerPointWhere better to search the Internet for support on an Excel, PowerPoint, or Word problem than through the Help menu? Would you like to add Google to that menu? Ron de Bruin at rondebruin.nl has developed free add-ins that does just that. "Google Search 6.0/7.0 places a new sub-menu item under the Help menu of whatever program you call it from. When that item is selected, up pops a user-friendly interface. This allows a largely intuitive completion and execution of a Google Search.See all Topics excel Labels: Addins <Doug Klippert@ 3:46 AM
Comments:
Post a Comment
Thursday, April 23, 2009 – Permalink – Lookup, Down, and SidewaysA very useful Excel featureExcel does not have "relational" tables like database applications such as Access. You, however, can make use of database functions including the ability to look up values in a table based on a value. You could, for instance look up a salesperson's records based on an employee ID. All 'Bout Computers has an article describing "Lookups". Using VLOOKUP, HLOOKUP, INDEX, and MATCH in Excel to interrogate data tables John Walkenbach has a book "Excel 2003 Formulas" with a 24-page chapter on Lookup functions and other database/list tricks. Chip Pearson talks about lookups on his site as well. Aaron Blood's site offers download files explaining lookup. See numbers 36, 37, and 44. One of the zipped Workbooks (number 35) Lookup.zip, is a study in lookup methodology. Daily Dose of Excel: VLookup on Two Comumns See all Topics excel Labels: Formulas <Doug Klippert@ 3:01 AM
Comments:
Post a Comment
Thursday, April 16, 2009 – Permalink – SpWebSheetNo Excel neededHere's a site that lets you design and post spreadsheets on the web. "Keep your records, lists and spreadsheets in one place online. Easily slice, dice and share with others. NumSum.com See all Topics excel <Doug Klippert@ 3:17 AM
Comments:
Post a Comment
Wednesday, April 15, 2009 – Permalink – Date an OctothorpeDate an OctothorpeSome more of those things I'm sure I used to know The keyboard combination of Alt+Shift+D inserts the current date in MS Word and PowerPoint. Ctrl+; (semicolon) does it in Excel and Access. If you do not like the date's format, select a different one with Insert>Date and Time and, if you would like to make that permanent, click on the Default button in the lower left corner of the dialog box (in PowerPoint it's in the lower right corner). In Excel, Ctrl+Shift +# formats the entry as day-month-year. Ctrl+1 will display the "Format cells" dialog box. BTW, the "hash, pound or number" sign # is also called an "octothorpe". The person who named it combined Octo for the eight points and Thorpe for James Thorpe. "Bell Labs engineer, Don Macpherson, went to instruct their first client, the Mayo Clinic, in the use of the new (touch tone phone system). He felt the need for a fresh and unambiguous name for the # symbol. His reasoning that led to the new word was roughly that it had eight points, so ought to start with octo-. He was apparently at that time active in a group that was trying to get the Olympic medals of the athlete Jim Thorpe returned from Sweden, so he decided to add thorpe to the end." While we're at it, the "backwards P, Enter mark" ΒΆ is actually named a "pilcrow". The pilcrow was used in medieval times to mark a new train of thought, before the convention of using paragraphs was commonplace. Also see: Geek-speak names for punctuation marks Wikipedia: Punctuation See all Topics excel <Doug Klippert@ 3:36 AM
Comments:
Post a Comment
Thursday, April 09, 2009 – Permalink – Excel-lent E-MailOutlook, Excel, and VBARon de Bruin, Microsoft MVP - Excel, has put together a collection of VBA routines to make Excel e-mail friendly. See if these topics tempt you: Example Code for sending mail from Excel
Also see: <Doug Klippert@ 3:27 AM
Comments:
Post a Comment
Friday, April 03, 2009 – Permalink – Where Have All the Bytes Gone?Folder size listYou can create a list in Excel of all the folders on a drive and their sizes. (The credit goes to Peter Beach, an Excel MVP.) Get Folder Size code
<Doug Klippert@ 3:56 AM
Comments:
Post a Comment
|
