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! 
Tuesday, December 22, 2009 – Permalink – Link WorkbooksTie them togetherExcel 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).
See all Topics excel <Doug Klippert@ 3:10 AM
Comments:
Post a Comment
Sunday, December 06, 2009 – Permalink – Curvesand More
"Students of analytic geometry, (the kind that combines algebra and geometry), often work in one of two coordinate systems: Cartesian or Polar  and frequently must convert from one to the other. See all Topics excel <Doug Klippert@ 3:02 AM
Comments:
Post a Comment
Sunday, June 14, 2009 – Permalink – Julian DatesGregorian to/from JulianJulian dates refer to the number of days from the first of the year and the number of days until the end of the year. The year 45 has been called the "year of confusion," because in that year Julius Caesar inserted 90 days to bring the months of the Roman calendar back to their traditional place with respect to the seasons. This was Caesar's first step in replacing a calendar that had gone badly awry. Caesar created a solar calendar with twelve months of fixed lengths and a provision for an intercalary day to be added every fourth year. As a result, the average length of the Julian calendar year was 365.25 days. Calendars by L. E. Doggett From Chip Pearson's site CPearson.com: "Many applications (especially mainframe systems) store dates in the Julian format, which is a 5digit number, consisting of a 2digit year and a 3digit dayofyear number. For example, 24August1999 is stored as 99236, since 24August is the 236th day of the year. Excel does not support Julian dates directly, but you can use them with only a few fairly simple formulas. US Naval Observatory has this definition (and a calculator): Julian dates (abbreviated JD) are simply a continuous count of days and fractions since noon Universal Time on January 1, 4713 BCE (on the Julian calendar). Almost 2.5 million days have transpired since this date. April 29, 2004 at 6:00 AM would be 2453854.75 See all Topics excel <Doug Klippert@ 3:43 AM
Comments:
Post a Comment
Tuesday, February 10, 2009 – Permalink – Dynamic AutoShape LinkShow the starHere's a hint that I had forgotten about.You can tie the result of a cell to an AutoShape. This displays the value in a more dramatic manner.
See all Topics excel <Doug Klippert@ 3:21 AM
Comments:
Post a Comment
Tuesday, May 13, 2008 – Permalink – Embed a ShowStick it in WordYou might like to distribute a short PowerPoint slide show, and include some extra material. Open Word and PowerPoint. Arrange the windows so that both applications can be seen. <Doug Klippert@ 6:23 AM
Comments:
Post a Comment
Sunday, March 09, 2008 – Permalink – Camera ToolSmile!(This is the per2007 routine. For 2007 see the bottom of this tip. ) To create a linked picture of part of a spreadsheet for use elsewhere:
The process is a little different in 2007. Either add the Camera tool to the Quick access toolbar, or just select the range and drop down the Paste options. <Doug Klippert@ 8:15 AM
Comments:
Post a Comment
Thursday, October 18, 2007 – Permalink – Links to ExcelSpokes of the webThere's a lot of information out there. The problem is how to find it. Here is a site that contains links to Excel information arranged in topics:
Excel Links See all Topics excel <Doug Klippert@ 8:03 AM
Comments:
Post a Comment
Thursday, May 31, 2007 – Permalink – Link to WordExcel to Word connectionThe Insert Hyperlink dialog will allow you to link to any file. To link to a particular bookmark in a Word document, you can specify the bookmark by adding it yourself, adding a # (pound sign) plus the bookmark name to the path and file name. C:\My Documents\MyDocument.doc#MyBookmark To link to a page in a Word document, add a pound sign and the page number after the document path and file name: C:\My Documents\MyDocument.doc#4 See Jon Peltier's hyperlink collection: Hyperlinks See all Topics excel Labels: Link <Doug Klippert@ 7:22 AM
Comments:
Post a Comment
