Office Links

Excel VBA
Excel Formulas
User-defined Functions
Office Links
Access VBA
Access SQL
Alan’s Excel FAQ
Main Excel Page
Alan’s Home
  • Unicode Characters - From time to time, I am creating a web page and next a special character. Here is a little cheat sheet I wrote for myself. - 11/16/2009
  • Cool iPhone app - Need a cool iPhone app to look at your Excel data while you are on the go? They have templates to help you build the look you want and you just upload the data. - 8/2/2009
  • Training - BIN95 Free online university courses include free computer training, free IT training, free Microsoft Office 2007 training, free OSHA training, and free Management training. Also includes bonus downloads like our CISSP Certification Training and many more free software application training courses. - 7/8/2009
  • Excel VBA Site (in German) - I wish I could tell you what the site is all about -- his English is much better than my German -- the translator program garbled it badly - 5/17/2009
  • Access 2003 to 2007 Cross Ref - Wondering where your favorite Access 2003 commands are located in the new Access 2007 interface? - 11/28/2008
  • Alex’s Excel Gold for Engineering - Occasionally we find tremendously useful resources on the internet, such was the case when I came upon Alex Tomanovich's spreadsheets. I had not spoken to Alex in over 20 years and ran across the Excel work he has been doing. Way out of my league but cool stuff. - 11/28/2008
  • Excel 2007 Tutorial Videos - This is a free website for learning and self practicing all the basics of Excel. It includes many tutorial videos and easy step by step manual instructions. - 11/23/2008
  • How can you become an Office Genius? - Broad list of recommended Office 2007 resources and has been updated for more recent additions\changes to Office 2007 resources - 11/23/2008
  • OfficeZealot - Have you experienced the warm glow of satisfaction that is possible when you combine your technical know-how with the functionality of Office to solve problems or eliminate a manual process? At Office Zealot, we have been avid fans of Microsoft Office for many years now. We have been promoting Office as an important platform for developers and working with users to squeeze more productivity out of Office. For that reason, we are happy to be your hosts here at OfficeZealot.com. OfficeZealot.com is your source for relevant, focused and practical developer information pertaining to everything Microsoft Office. - 11/23/2008
  • Ribbon Customizer Tool - RibbonCustomizer™ is an add-in for Microsoft® Access™, Excel®, Outlook®, PowerPoint® and Word 2007. It allows you to customize the Ribbon (Office Fluent™) User Interface with only a few mouse clicks! Microsoft did not include that ability in Office 2007, but with this add-in you are no longer stuck with a static User Interface! - 11/23/2008
  • Tek-Tips Forums - This is one of the first places I go when I am bogged down - 11/23/2008
  • The Code Project - The Code Project was formed to provide developers with a place to meet and exchange ideas. We hope to provide developers with all the resources they need to help them in their day to day programming, as well as helping them keep up to date with the latest technologies. - 11/23/2008
  • Widget Genie - Widgenie empowers everyone, from bloggers to business people, to quickly visualize data and share it in many different ways. Now you can publish data in the places you already know and love, places like iGoogle, Facebook, WordPress, and even your own website. We combine all the power of an enterprise-level business intelligence platform and provide it in a convenient Web 2.0 widget. - 7/2/2008
  • Best Stock Price Retriever - XLQ -- connects automatically to excel allowing you to work with data in a layout and format that you want, allowing for complex in-depth analysis to simple portfolio management. If you know how to use excel, you already know how to use xlq. (an example xlqDemo.xls is provided with the install) I got rid of all my crazy MSN stock quote stuff to use this exclusively - 6/6/2008
  • ODBC DB Free Add-In - Simplify data retrieval from SQL Server, Oracle, Sybase, MySQL, DB2, Firebird and any other ODBC compliant database - 6/6/2008
  • Figure Distance with Excel - This page describes various methods for working with Latitude and Longitude data in Excel. - 1/21/2008
  • Spreadsheet World - SpreadsheetWorldSM is designed to be a gateway to engineering knowledge bases and function libraries from the Microsoft Excel platform. Passing through the gate leads to a world of Excel and VBA based software products and services and to membership in the SpreadsheetWorldSM gateway. - 1/21/2008
  • Martin Green’s Excel VBA - VBA (Visual Basic for Applications) is the magic that allows you to get your Office programs doing whatever you want. - 4/26/2005
  • StrikeIron OnDemand Web Services™ for Microsoft® Excel - Build real-time, on-demand access to data utilizing Web services without any programming knowledge. Now anyone can take advantage of on-demand Web services for accessing real-time data using Excel! OnDemand Web Services for Excel accesses any Web service and you can search internal and external UDDI directories. - 3/8/2005
  • John Walkenbach - The man that wrote the book on Excel - 8/3/2004
  • Best Excel Books - Books by the dean of Excel programming, John Walkenbach - 2/13/2004
  • Chip Pearson - This web site is brought to you as a public service by Pearson Software Consulting, LLC and Chip Pearson. PSC provides complete Excel, Office, and Visual Basic solutions for your business. - 2/13/2004
  • DevelopersDex - Empowering Developers Worldwide -- found this to be particularly useful when my program blows up for no reason - 2/13/2004
  • Excel Forum Tips - This is one of the first places I go when I am stumped. - 10/17/2003
  • Woody's Lounge - A super place to ask your tough questions. In addition to the Excel Lounge, there are areas for VBA, VB, Word, Access and others. - 10/17/2003
  • David McRitchie, Excel MVP - Lots of cool Excel information and links. - 1/12/2003

© 1994-2010

Updated:  05/27/2010 19:26