Headlines from the best Excel weblogs

The most recent posts

asap utilities / excel blog

• Pre-release ASAP Utilities version 4.2.5 RC3 2008-04-28
• Pre-release ASAP Utilities version 4.2.3 RC1 2008-01-31
• New ASAP Utilities version 4.2.2 released! 2008-01-22
• Pre-release ASAP Utilities version 4.2.2 RC5 2008-01-09
• Google Desktop Search slows down Excel 2007-12-20
• Office 2007 Service Pack 1 coming on December 11th 2007-12-06
• Pre-release ASAP Utilities version 4.2.2 RC1 2007-11-28
• Review: ASAP Utilities - You Sexy Thing 2007-11-20
• Video: How to fix trailing minus signs in Excel with ASAP Utilities 2007-11-09
• Video: How to delete all empty rows in Excel with ASAP Utilities 2007-11-05

Daily Dose of Excel

• Simple Gantt Chart 2008-05-11
• Using a Class Property to do more than just Assign or Query a Value 2008-05-09
• Double Clicking Through a List 2008-05-07
• Efficient Looping 2008-04-29
• Testing Strings Using Left 2008-04-28
• Printing First Page of Email in Outlook 2008-04-23
• VBE Bookmark add-in for Office 2000-2007 2008-04-21
• I?ve Arrived 2008-04-14
• Mike Won! 2008-04-14
• Tab Groups 2008-04-08

Smurf on Spreadsheets

• Data types 2 2008-05-08
• Do you know the data type? 2008-05-06
• Microhoo 2008-05-04
• End User Development 2008-05-01
• Asus Eee 1.0 impressions 2008-04-29
• Is Excel Services a trap? 2008-04-29
• Microsoft Q1 results out 2008-04-25
• State of the profession 2 2008-04-24
• State of the profession 2008-04-23
• Access queries 2008-04-22

Learn Excel from MrExcel Video Podcast

• Episode 755 - Sort Largest 2008-05-09
• Episode 754 - Create Workbooks 2008-05-08
• Episode 753 - Text Date/Time 2008-05-07
• Episode 752 - Truncating to Date 2008-05-06
• Episode 751 - Grouping Dates 2008-05-05
• Episode 750 - Save Settings 2008-05-02
• Episode 749 - Sum Overdue 2008-05-01
• Episode 748 - Pivoting Text 2008-04-30
• Episode 747 - Who is Largest 2008-04-29
• Episode 746 - Obscuring Excel 2008-04-28

Contextures -- Excel Tips

• Change All Page Fields 2008-05-04
• Excel Newsgroup Postings -- Selected Statistics 2008-05-01

Andrew's Excel Tips

• New Tools for JMT Excel Utilities 2008-04-25
• I'm Back! 2008-04-19
• Excel Thunder Down Under 2008-03-16
• File History 2008-03-01
• JMT Excel Utilities Updated 2008-02-24
• Removing Duplicates and Non-matching Items 2 2008-02-17
• Removing Duplicates and Non-matching Items 2008-02-09
• Excel User Conference in Sydney 2008-01-20
• Save Settings to a Text File 2008-01-09
• 'Twas the day before Christmas 2007-12-24

Unofficial Microsoft Office Stuff

• Leroy, the Big Pup [Flickr]
• Tacoma Art Museum [Flickr]
• Tables
• Happy Mother's Day
• First Presbyterian Roof [Flickr]
• First Presbyterian Light [Flickr]
• First Presbyterian Glass [Flickr]
• Population: 485
• Change Case

Tips & Tricks for MS Excel © 1989 - 2008 XL-Dennis

• Online resources for VSTO 2008-05-04
• Export SQL Server data to a worksheet 2008-02-11
• Export Access-data to a worksheet 2008-02-11
• .NET Co Library 2008-02-07
• Export MySQL-data to a worksheet 2008-02-07
• A Collection of useful Excel articles 2008-02-05
• Books on VBA / VB / VB.NET & ADO / ADO.NET & VSTO 2008-01-21
• MS Excel sites 2008-01-15
• Retrieve e-mailaddresses from a Notes database 2008-01-01
• Create connection strings to databases with .NET Connection 2007-12-01

About Spreadsheets

• Excel 2007 SMALL Function 2008-05-09
• Excel 2007 RANK Function 2008-05-07
• Hide Information in Microsoft Excel 2008-05-05
• Excel 2007 NETWORKDAYS Function 2008-05-02
• Excel 2007 NOW Function 2008-04-30
• Excel 2007 TODAY Function 2008-04-28
• Excel Timeline Template 2008-04-26
• Excel 2007 ROUNDUP Function 2008-04-24
• Excel 2007 COUNTIF 2008-04-21
• Excel 2007 AVERAGEIF 2008-04-18

Microsoft Excel

• PivotTables: Calculated Items 2008-05-09
• Append Multiple Text Files into a Worksheet without Code 2008-04-30
• Improving Sheet Selection 2008-04-23
• Building the Excel Media Player ? Part 3 2008-04-18
• Building the Excel Media Player ? Part 2 2008-04-17
• Building the Excel Media Player ? Part 1 2008-04-15
• Understanding Floating Point Precision, aka ?Why does Excel Give Me Seemingly Wrong Answers?? 2008-04-11
• Statistics and Business Data: Detecting Unexpected Values 2008-04-02
• Office Open XML, a.k.a. IS 29500 2008-04-02
• Shadows on Charts and Cells in Excel 2007 2008-03-28

Other interesting blogs

Juice Analytics: Agile Analytics

• A Dashboard Alerts Checklist
• Tufte-Style Comparison Chart Generator
• Real-World Tufte Graphics in 11 Lines of Code
• Keyword Trends in Google Analytics With Greasemonkey
• Enhancing Google Analytics Using Greasemonkey
• S. Few Renounces Dual-Axis Graphs; Juice Ups Ante
• Franken-measures...or How to Construct a Useful Composite Measure
• How to Feel Better About Your Data Warehouse Fiasco
• The Colbert Bump is Real, Colbert’s Nation Not What He Thinks it is
• Analytics Roundup: Gladwell drops and Tokyo pops