Most Valuable Professional


View Jan Karel Pieterse's profile on LinkedIn subscribe to rss feed
Subscribe in a reader

Subscribe to our mailing list

* indicates required

Audit !!!

Check out our RefTreeAnalyser
the ultimate Excel formula auditing tool.

Trainings

Excel VBA Masterclass (English)
Excel VBA for Financials (Dutch)

Third party tools

Speed up your file

FastExcel
The best tool to optimise your Excel model!

Repair your file

Stellar Phoenix Excel Repair
Best tool to repair corrupt Excel sheets and objects
Home > English site > Links
Deze pagina in het Nederlands

 

Links

This page contains a couple of links to mostly Excel related sites I find useful.

If you have suggestions for additions or find defective links, please let me know.

Newsgroups and fora

Let me start with the most important ones, Newsgroups and fora.

Compuserve's Office Forum: Ask your questions about any Microsoft Office product here. Moderated newsgroup.

Microsoft MSDN Forums: The MSDN forums (aimed at developers and VBA programming) operated by Microsoft.

Microsoft's Excel user forums: The user forums operated by Microsoft.

Eileen's Lounge: Very lively forum on lots of Microsoft software, including Office.

Excel related links

English sites

Decision Models - Advanced Microsoft Excel Consultancy and Solution Development: A wealth of information on Excel's calculation engine. Also the co-author of the Name Manager. Decision models sells a very useful add-in called :

FastExcel V3: An excellent product to optimise your Excel model!

There are 3 major products in the FastExcel V3 family which are targeted at different types of useage, and allow you to only buy the tools you need:

My Online training hub; Courses by Excel MVP Mynda Treacy

Peltier Tech Chart Utility for Excel; The best charting tool ever!

Peltier Tech Chart Utility

Peltier Tech (Jon Peltier): Excellent pages on how to create charts you thought were impossible with Excel.

Peltier Tech Blog: Jon's blog on Charting in Excel.

ModelOff: ModelOff is a fun, innovative and professional competition for students and professionals to develop and test their financial modeling skills against their friends, colleagues and top modelers from around the world. Participants from over 100 countries progress through two Online Qualification Rounds with a Live Finals Event held in New York.

Infotron: Dealing well with Excel yourself, but want to understand, validate and improve your spreadsheets?

Infotron

MZTools The best VBA programming productivity tool on the planet!

MZ tools

Andrew's Excel Utilities: Excel productivity tools you'll love!

Andrew's Excel Utilities

AET VBE tools

The Excel Blog By Microsoft: news and tips on the latest and greatest from Microsoft.

Office Automation (Stephen Bullen): An excellent site that hosts many good examples of how to do the impossible with Excel.

Bill Manville Associates (Bill Manville): Site of one of my closest Excel friends. and the home of one of the most popular Excel downloads I know of: FindLink

Nick Hodge's site: Various informative pages, especially on VBA.

Pearson Software Consulting Services (Chip Pearson): An excellent site with a wealth of information about Excel, including many advanced topics.

Ron de Bruin's Excel Page: If you want to send mail using lists in Excel, this is your starting point. Also the home of the Google search utility for Excel.

Daily Dose of Excel (By Dick Kusleika): One of the web's best Excel Blogs with daily tips.

Jwalk (John Walkenbach): Excellent site with a lot of information on Excel. Also hosts one of the most complete Excel blog lists I know of.

Application Professionals (Rob Bovey): Host of one of the utilities I use most frequently, the Code cleaner.

AJP Excel Information (by Andy Pope): Some very nice charting examples, VBA examples and utilities.

xlDynamic.com (By Bob Philips): Very interesting Excel VBA and formula examples.

Excel user (By Charley Kyd): Has interesting articles, about OLAP and Excel, about dashboard reporting and runs a monthly newsletter.

XL-Dennis: Very nice blog about Excel and .NET.

TrumpExcel (By Sumit Bansal): Tutorials (blog posts and videos) covering various topics such as Excel Tips, VBA Tips, Charting Tips, Dashboard Tips, Pivot Table, and Templates. Site hasmore than 350+ tutorials!

The road of the cell masters: Nice interviews with Excel specialists, including me.

Excel hero (Daniel Ferry): Great Excel blog; intriguing downloads.

Infotron (Felienne Hermans) The very first website I know of which enables you to upload your spreadsheet models after which you receive a free analysis of how well you designed your formulas and such. Highly recommended for anyone building spreadsheets.

Expert Excel and Access Consultants and Trainers: If you need an Access or Excel expert, this site has a list of many of them (including myself).

Excel Tutorial: Free online Excel courses. Learn at your own speed.

Best Excel Resources on the Web: An ever growing list of Excel resources on the web maintained by Rick Grantham.

Excel Training: Quick and easy to follow Excel tutorials. By Tomasz Decker.

Excel Tutorial with GIFs from Udemy: This tutorial helps you learn excel by using text and GIFs, and covers beginner and intermediate concepts.

Acuity Training: Acuity Training offers high quality classroom based Excel courses in the UK.

PDF Converter Blog: Learn Excel online with these resources for self-study learners.

Vena is an Enterprise Solution, that automates any 'mission-critical' finance, accounting or business process while allowing users to remain completely inside MS Excel. Here is a quick visual: Vena in 90 Seconds

Vena Solutions

ExcelChamps A nice Excel blog run by Puneet Gogia

spreadsheeto.com Blog run by two Danish friends

Excel & VBA Tutorial Comprehensive and detailed tutorials covering a variety of Excel topics, including formulas and functions, and VBA/development.

Excelusive.com Great material on Charting and dashboards in Excel by David Hoppe.

excelunplugged.com Great Excel site and Blog by Gašper Kamenšek from Slovenia

www.wallstreetmojo.com Offers a free course on financial modelling in Excel

Excel University Excel University shows how to use Excel to maximize efficiency, automate recurring processes, and get your work done in less time.

Acuity Training is a leading Excel training provider in the UK, running training centres in London and Guildford. For more details of its Excel courses click here

yodalearning.com The people at yodalearning provide video tutorials on MS Office tools like Excel, VBA Macros, Outlook, PowerPoint etc

Microsoft Excel training manuals available for free download from London UK based training company STL. They've taken their experience from thousands of hours of classroom training delivery and distilled it into these course manuals.

Dutch sites

Luc Heyndrickx's site: Interesting downloads and valuable lessons on Excel, all in Dutch.

www.excelexperts.nl: Blog of Excel experts Nederland

Spanish sites

excellentias.com, a blog written in spanish, full of articles, tutorials, tips, courses and great resources to learn how to get the best out of Microsoft Excel.

Excel MVP sites

This is a list maintained by fellow MVP teylyn. Note that you can filter and sort this list directly on this page!

Commercial links and freeware

VBADiff by Technicana: VBADiff reads your VBA Projects and compares their contents, to show you the differences in the VBA code. Just drag-and-drop two documents into VBADiff - any modules with different code appear in red. Any new or renamed modules appear in blue. Double-click on a module to see a comparison of the code using your favourite code Diff tool.

Convert PDF to Excel Online: A free tool to convert pdf files to Excel files. Very easy to use!

Able2Extract offers you the capability to extract data from pdf files so you can easily incorporate the information into Office documents: Able2Extract Professional

Add-ins.com: has over 50 Excel add-ins that make Excel easier to use and save you time, plus downloadable books (full of examples) on how to write Excel macros. The add-ins range from the Spreadsheet Assistant, which adds many time saving features to Excel, to specialized add-ins like the Risk Analyzer and Duplicate Finder.

Synkronizer: Commercial Add-in to track differences between Excel files.

DuplicatesRemover: The DuplicatesRemover finds and removes duplicates from Microsoft Excel spreadsheets.

Computergaga Excel Training: Excel guides and quizzes aimed at the Excel beginner through to an advanced level.

Quick-XL simplifies data entry in Excel: Quick-XL is an Excel add-in for entering data into Excel spreadsheets. It is designed to provide a highly ergonomic way to get data entered as quickly as possible. Quick-XL works in businesses of all sizes. Best news, the cost is under $10/yr.

MTools Ultimate Excel Add-In: The Excel Add-in MTools Ultimate is the essential software, that significantly enhances the capabilities of Excel. It provides the users with a broad and carefully selected collection of time-saving tools. Even Excel novices will make spreadsheets significantly faster and more reliable than many Excel experts. Use MTools and impress your boss with the speed and the reliability of your work or enjoy your newly gained free time by finishing your job faster than expected. 

MVP related links

The MVPs.org home page: A site hosted and maintained by MVP's, containing many links to MVP's and a wealth of information, including the Word FAQ.

Microsoft Most Valuable Professional: The official Microsoft site about the MVP program.

Website design links

Pat Geary
Genealogy Web Creations and Web Design: Website Design, Tips, Tutorials, and Templates by Genealogy Web Creations.
Expression Web Tips, Tutorials, and Templates

Tina Clarke
Expression Blog
Expression Web Help
Expression Web Ezine
Migrating from FrontPage to Expression
Web

 I followed Tina and Pat's course on migrating Frontpage sites to Expression web and I must say the course was worth every penny. Excellent material, very helpful and knowledgable instructors.

Access links

OpenGate Software - Microsoft Access Tools: Great tools for Access Developers

Statistics

Online Math degrees: A blog article with one hundred links to statistical sites. Highly recommended!

Statsoft Electronic Statistics Textbook: The most comrehensive statistics guide I know of.