Excel User Group

Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Sign in | Join | Help

Daily Dose of Excel » All Tags » Formulas (RSS)

Browse by Tags

Daily Dose of Excel

Home

Syndication

Recent Posts

Tags

News

This site is published here by kind permission of Daily Dose of Excel's owner Dick Kusleika

Archives

Variable Hyperlinks

Excel provides an easy way to create a table of hyperlinks and even save the workbook as a web page. The built-in method for creating a hyperlink is Insert > Hyperlink (Ctrl+K). The problem with this method is mass changes, like renaming your server. Editing each one (if you have a lot) [...] Read More...

Published Wed, Jun 06 2008 2:53 PM by Daily Dose of Excel

Filed under: Formulas, List and Table Functions, User Defined Functions, Hyperlinks
Steady vs. Volatile

I read my retirement account statement today. It wasn’t pretty. A lot of low, single digit returns lately. I know people who complain when the market tanks, but I’m not one of them. When it comes to my retirement, I want the market to keep going down until I’m 59 1/2, [...] Read More...

Published Sun, Feb 02 2008 8:50 PM by Daily Dose of Excel

Filed under: Formulas
ExcelRefTool; A New Formula Auditing Tool

Hi, A while ago I requested beta testers for a new utility, now called "ExcelRefTool". Thanks to my beta testers, the tool is now mature enough to be exposed to the general public. Have a look here, download the demo if you like and give it a spin. And thanks again, to everyone who took the trouble of beta [...]

Published Mon, Dec 12 2007 8:53 AM by Daily Dose of Excel

Filed under: General, MVP, Downloads, Formulas, COM Addins, Add-ins

Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.