Headlines from the best Excel weblogs

The most recent posts

asap utilities / excel blog

• List of keyboard shortcuts for Word 2002, Word 2003, and Word 2007 2008-11-19
• Soon to be released: version 4.2.9 2008-11-18
• When Excel doesn?t recognize empty cells correctly 2008-11-13
• How to insert blank rows where the value changes 2008-10-30
• Prepare a document before sending it to others 2008-10-27
• Weird looping through cells in a range object 2008-10-23
• Unhide all columns and rows 2008-10-21
• Now available: ASAP Utilities 4.2.8 2008-09-24
• Keep leading and remove only the trailing spaces 2008-09-18
• Add trailing zeros 2008-09-17

Daily Dose of Excel

• Add-ins in Excel 2007 2008-11-21
• XML and Excel 2008-11-20
• Creating Classes from Access Tables 2008-11-16
• Lessons in SQL 2008-11-14
• Table Tools in Excel 2007 2008-11-14
• Ribbon, You?re Nothing to Me Now 2008-11-06
• www.jkp-ads.com Anniversary and Website Update 2008-11-05
• My First Ribbon 2008-10-28
• Disable Excel 2003 Menu Accelerators keys in Excel 2007 2008-10-26
• Free Financial Advice 2008-10-24

Smurf on Spreadsheets

• Spreadsheet modes 2008-11-21
• They?re closing in on us? 2008-11-19
• Weathering the recession 2008-11-18
• Pimp my app? 2008-11-17
• Lucky dev 2008-11-16
• Migrationware built on Abandonware 2008-11-14
• .chm WTF? 2008-11-13
• The case FOR on-line collaboration 2008-11-11
• Free Crapware 2008-11-11
• Google drops StarOffice 2008-11-10

Learn Excel from MrExcel Video Podcast

• Episode 895 - Fill Handle Double 2008-11-21
• Episode 894 - Export Each Worksheet 2008-11-20
• Episode 893 - WIIW Customizing Icons 2008-11-19
• Episode 892 - Validation Formula 2008-11-18
• Episode 891 - AC DC Video 2008-11-17
• Episode 890 - Offset as TableArray 2008-11-14
• Episode 889 - Concatenated Key 2008-11-13
• Episode 888 - WIIW - 2 Axes Chart 2008-11-12
• Episode 887 - Keeping Pivot Formats 2008-11-11
• Episode 886 - SumIf 2 Conditions 2008-11-10

Contextures -- Excel Tips

• Advanced Filter Video Tutorial 2008-11-06
• Excel Newsgroup Postings -- Selected Statistics 2008-11-01
• FilterClick 2008-10-19
• Excel Data Validation -- Combo box -- Click 2008-10-18
• Excel Newsgroup Postings -- Selected Statistics 2008-10-01
• Excel Comments -- Programming -- Insert a Colour Formatted Comment 2008-09-30
• Excel Pivot Tables -- Creating a Running Total 2008-09-13
• Video Tutorial Clips 07 2008-09-01
• Excel Tables -- Creating an Excel Table in Excel 2007 2008-08-22
• Video Tutorial Clips 08 2008-08-16

Andrew's Excel Tips

• Bring Back Those Old Style Menus 2008-10-25
• Checklist Maker 2008-09-28
• Quick Filter Updated 2008-09-06
• File History 2 2008-08-24
• Do The Numbers Shuffle 2008-08-05
• Replace Text Tools 2008-07-20
• New Site Address 2008-07-12
• Classic Colors for Excel 3 2008-07-09
• Classic Colors for Excel 2 2008-07-06
• Classic Colors for Excel 2008-06-21

Spreadsheet Page Blog

• The End Of PC Magazine 2008-11-20
• Excel And AV Software 2008-11-18
• Excel 2007 Help Updated 2008-11-17
• Microsoft Has A Download Store 2008-11-17
• Free PUP Source Code 2008-11-13
• Small Basic 2008-11-09
• Excel In A Browser 2008-10-29
• AC/DC Video In Excel 2008-10-25
• 29 Years Of Spreadsheets 2008-10-25
• Hyperlink Misinformation 2008-10-22

The Ken Puls Blog

• Disabling the Excel Compatibility Checker 2008-09-25
• Converting External Links to Values 2008-08-20
• Excel inter-version styles quirk 2008-08-15
• Office Mobile 2008-06-28
• Marking cells without dependents 2008-06-21
• Using Named Range to Refer to Cell Above 2008-06-08
• Excel Videos 2008-05-22
• PDF Creator - Multiple worksheets to multiple files in two folders 2008-05-21
• The best line of VBA ever 2008-05-06
• Making MZTools for VBA work on Vista 2008-02-01

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

• MS Excel sites 2008-11-15
• AddInSpy 2008-10-02
• A Collection of useful Excel articles 2008-08-01
• SQL Tester 2008-07-31
• Online resources for VSTO 2008-06-21
• 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
• Books on VBA / VB / VB.NET & ADO / ADO.NET & VSTO 2008-01-21

About Spreadsheets

• Excel 2007 ROUND Function 2008-11-19
• Basic Excel 2003 Spreadsheet Tutorial 2008-11-17
• Basic Excel 2007 Spreadsheet Tutorial 2008-11-14
• Excel Dice Roller Tutorial 2008-11-11
• Excel 2007 COUNTBLANK 2008-11-09
• Excel 2007 COUNTIF 2008-11-05
• Excel 2007 COUNT Function 2008-11-03
• Excel 2007 Freeze Panes 2008-11-01
• Excel 2007 MID Function 2008-10-30
• Excel 2007 RIGHT Function 2008-10-28

Microsoft Excel

• Using PivotTables to Analyze Data From a SharePoint List 2008-11-06
• Excel Web Application Announced at PDC 2008-10-29
• Creating a Master-Detail View in Excel 2008-10-24
• Don't forget about the "A" in "VBA"! 2008-10-17
• Using Office Data Connection files (.odc) and the DataConnections Web Part in SharePoint to Specify External Data Connections in Newly Created Excel Workbooks. 2008-10-16
• What is the fastest way to scan a large range in Excel? 2008-10-03
• Building a Basic, Understandable Sudoku Solver Using Excel Iterative Calculation - Part 2/2 2008-10-02
• Building a Basic, Understandable Sudoku Solver Using Excel Iterative Calculation - Part 1/2 2008-09-30
• Chart Advisor 2008-09-25
• New Online Training Courses for Excel Services 2008-09-10

Pointy Haired Dilbert - Chandoo.org

• 5 visualizations to inspire you [Nov 21] 2008-11-22
• Generating Random Phone Numbers 2008-11-20
• vlookup(), match() and offset() - explained in plain english [spreadcheats] 2008-11-19
• The new Mac vs. PC web ad by Apple is really cool 2008-11-19
• What would you like to ask Charley Kyd of Exceluser.com in an interview? 2008-11-18
• Make your VBA macros work anywhere: Enable Relative References 2008-11-18
• Excel Links of the Week - Do you want to run 10k with me edition 2008-11-17
• Ads that are also Infographics - 10 Dazzling Examples 2008-11-17
• 5 Visualizations for Your Inspiration [Nov 14] 2008-11-15
• Seperating digits from a number [excel formulas] 2008-11-14

Other interesting blogs

Juice Analytics: Agile Analytics

• #1 Barrier to BI Success
• The Purpose Driven Design
• Information Experiences™...or, Whaa what would you say...yah do here?
• Billions and Billions of Reports (a la Carl Sagan)
• 11 Parallels Between Architecture and Interface Design
• Analyticstime!
• Thrown to the Ad-Wolves... or, Learn from My AdWords Mistakes
• Review: 5 Options for Embedding Charts in a Web Page
• Godin Dumps on Bar Charts; Data Visualization Record Falls to 1 and 1
• Why Analytical Applications Fail