Headlines from the best Excel weblogs

The most recent posts

asap utilities / excel blog

• Just released: ASAP Utilities 4.6.1 2010-09-01
• Now available: ASAP Utilities 4.6.0 2010-06-08
• ASAP Utilities 4.5.9 has been released! 2010-05-28
• Almost ready: ASAP Utilities 4.5.9 2010-05-25
• Just released: ASAP Utilities 4.5.8 2010-03-10
• How to: Set column width and row height in centimeters or inches? 2010-02-23
• How to: Quickly remove duplicated records 2010-02-18
• How to: Split data table into multiple worksheets (and save time) 2010-02-11
• How to: Remove or replace line breaks and carrage returns in cells 2010-01-18
• How to: Create a pipe delimited file 2010-01-15

Daily Dose of Excel

• Setting a Base Directory 2010-09-02
• Count Active Customers 2010-09-01
• Dymo LabelWriter Part II 2010-08-31
• Abbreviating Company Names 2010-08-30
• Bushy Trees 2010-08-28
• A Hundred Thousand Name Managers! 2010-08-19
• Showing Hidden Sheet and Workbooks Dialog in VBA 2010-08-12
• Printing to a DYMO LabelWriter 450 from VBA 2010-08-10
• Contextual PivotTable Userform 2010-08-09
• Regular chart version of a sparkline 2010-08-09

Smurf on Spreadsheets

• Soz for lack of posts 2010-08-20
• Overly intimate with the Excel OM 2010-08-06
• Wave Wave goodbye 2010-08-05
• European Spreadsheet Risk Group 2010 2010-07-23
• Oh the Irony 2010-07-20
• Hi, Remember me? 2010-07-19
• which add-ins? 2010-07-13
• One week to go 2010-07-03
• UK Excel Developer conf end of discount 2010-06-29
• Famous at last 2010-06-29

Peltier Tech Blog

• Fake Line Chart (Dummy XY Series for X Axis) 2010-08-31
• Custom Error Bars in Excel Charts 2010-08-30
• Box Plot of Values Against Limits 2010-08-25
• Plotting Values Against Limits 2010-08-24
• Peltier Tech Chart Add-Ins Have Been Updated 2010-07-21
• The Downside of Working in a Cubicle 2010-07-16
• Copy a Pivot Table and Pivot Chart and Link to New Data 2010-07-15
• Silent For Too Long 2010-07-12
• Two Ugly Real Economic Growth Charts 2010-05-17
• Excel Dashboard Training 2010-04-15

Learn Excel from MrExcel Video Podcast

• Excel in Depth - Applying Names to Formulas: Podcast #1236 2010-09-02
• Excel In Depth - Linking Workbooks: Podcast #1235 2010-09-01
• Excel In Depth - Convert Function: Podcast #1234 2010-08-31
• Excel In Depth - Calculate Loan Payments: Podcast #1233 2010-08-30
• Excel In Depth - Get the Cool DSUM: Podcast #1232 2010-08-27
• Excel In Depth - AGGREGATE Function: Podcast #1231 2010-08-26
• Excel In Depth - Joining Text: Podcast #1230 2010-08-25
• PowerPivot - Creating Relationships: Podcast #1229 2010-08-24
• Excel In Depth - Formula Entry: Podcast #1228 2010-08-23
• Excel In Depth - End Key Navigation: Podcast #1227 2010-08-20

Contextures -- Excel Tips

• Excel Pivot Table Summary Functions 2010-08-19
• Rick Rothstein - Excel VBA Samples - Text 2010-08-09
• Customize the Excel Quick Access Toolbar 2010-07-31
• Excel Template - Golf Scores 2010-04-25
• Excel Pivot Table Subtotals 2010-04-17
• Excel Data Validation Automatically Add Items to Drop Down Lists 2010-04-11
• Excel Conditional Formatting - Data Bars 2010-04-08
• Excel Pivot Table Filters - Top 10 2010-03-14
• Excel Pivot Table Report Filters 2010-02-26
• Excel VBA ComboBox Lists 2010-02-23

Andrew's Excel Tips

• A Dynamic Sorted List 2010-06-08
• From VBA to VB.NET 2010-05-02
• Sheet Tools 2010-03-21
• More Stuff For JMT Excel Utilities 2010-03-07
• Capturx For Excel 2010-02-07
• Right Click Menu Items for JMT Utilities 2010-01-31
• Those Battleships Are Back Again! 2010-01-10
• Word Search 2009-12-23
• Fun and Games 2009-12-19
• Classic Excel Colors Remade 2009-12-16

Spreadsheet Page Blog

• DataPig's Book Is #1 At Amazon 2010-09-01
• More Ribbon-Based Apps 2010-09-01
• A Break From Excel 2010-07-07
• Excel 2010 Book List Updated 2010-04-23
• Excel Hero 2010-04-20
• Problems With Euro Currency Tools Add-In 2010-04-19
• Hiding & Unhiding With Shortcut Keys 2010-04-11
• Mini Books 2010-04-07
• Adventures In Book Marketing 2010-04-02
• 35 Years Of Microsoft 2010-03-30

The Ken Puls Blog » Excel

• Enabling Outlining Commands on a Protected Worksheet 2010-09-02
• Macro to wrap an existing formula with IFERROR 2010-08-27
• Built in Ribbon Customizations in Office 2010 2010-05-25
• New article on the site 2009-10-15
• A reader's question on Application.Run 2009-09-03
• Lie Back and Think of England 2009-08-08
• Using getSize with RibbonX buttons 2009-08-05
• Find and Replace Dreams 2009-08-01
• Excel 2010 Finally Fixes SpecialCells 8192 Limit 2009-07-24
• Re-Active vs Pro-Active Data Validation 2009-07-23

About Spreadsheets

• Count Days Between Two Dates in Excel 2010-09-01
• Excel's Print Options 2010-08-30
• Excel 2007 DAYS360 Function 2010-08-27
• Calculate the Number of Days Between Dates in Excel 2010-08-25
• Excel Nested IF Function Step by Step Tutorial 2010-08-23
• Create a Template in Excel 2007 2010-08-20
• Biweekly Time Sheet Template 2010-08-18
• Excel Timeline Template 2010-08-16
• Excel 2007 VALUE Function 2010-08-14
• Excel 2007 TRIM Function 2010-08-12

Microsoft Excel 2010

• =VLOOKUP (uhh?now what?) 2010-08-31
• You Asked: What the heck is Scroll Lock 2010-08-25
• Excel Web App leads to healthier snacks for kids 2010-08-19
• Got lots of text in a cell? Make it readable 2010-08-11
• Use SUMPRODUCT to find the last item in an Excel list 2010-08-04
• How it's Made: Tower Defense - a Game in Excel 2010 2010-07-27
• Announcing Excel 2010 Developer Challenge Winners 2010-07-20
• Vote for the prototype you like for the Open XML SDK 2010-07-14
• How it's Made: Missile Command - a Game in Excel 2010 2010-07-07
• The analytics of the World Cup in Excel with PowerPivot 2010-06-28

Chandoo.org - Learn Excel & Charting Online

• Modeling & Building Cash-flow Projections for Project Valuation [Part 4,5 of 6] 2010-09-02
• How to cook a delicious dynamic chart that will have your boss drool 2010-08-31
• We have updates!!! 2010-08-30
• How many hours did Johnny work? [Excel Homework] 2010-08-27
• Excel Everest ? Recommended Excel Training Program 2010-08-25
• Building Inputs & Assumptions Sheets ? Excel Financial Modeling [Part 3 of 6] 2010-08-23
• How do you make charts when you have lots of small values but few extremely large values? [Debate] 2010-08-20
• Excel Wedding Planner is here, Get your copy today! 2010-08-18
• Jump to Any Cell / Worksheet using Name Box [Quick Tip] 2010-08-16
• What is the most unusual thing you have used Excel for? [Quick Poll] 2010-08-13

Excel Hero

• Excel Optical Illusions Week #28
• Excel High Precision Engineering Chart #1
• Excel Optical Illusions Week #27
• Excel Optical Illusions Week #26
• Excel Optical Illusions Week #25
• Excel Optical Illusions Week #24
• Excel Optical Illusions Week #23
• Animated Business Chart #2
• Excel Optical Illusions Week #22
• Excel Partial Match Database Lookup

Other interesting blogs

Juice Analytics: Agile Analytics

• Juice Takes Message to the Capital City
• Chart Makeovers, Fed IT Dashboard edition
• Dashboard Design - Flow
• Juice Boston Tea Party
• Tableau and Juice together with You
• Designing a Better 'Federal IT Dashboard'
• 30 Great Visualization Resources in 30 Days
• Come Have Breakfast with Juice on July 15th
• Measures and Averages and Indexes, Oh My!
• Can familiarity trump usability?