Headlines from the best Excel weblogs

The most recent posts

asap utilities / excel blog

• 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
• How to: Check the spelling on multiple or all sheets 2010-01-13
• How to: Insert a blank row after every 3rd row 2009-12-31
• Excel 2010: Use the 32 or 64 bit edition? 32 Bit might be wiser? 2009-12-07
• Parlez-vous français? ? Pre-release version 4.5.6 2009-11-30

Daily Dose of Excel

• Importing text files in an Excel sheet 2010-03-11
• Using the MATCH Function for a Linear Search and a Binary Search 2010-03-10
• Keno Odds 2010-03-09
• Getting Array Data from a Filtered List in VBA 2010-03-08
• Plain and Pretty 2010-03-05
• Office Automation 2010-03-04
• PowerPivot - Part 3 of 4: Conditional Shape Colors 2010-03-03
• Web Query Lessons 2010-03-02
• IsHex Function 2010-03-01
• PowerPivot - Part 2 of 4: Prepping the census data 2010-02-27

Smurf on Spreadsheets

• Busy Boy 2010-03-10
• Pareto gave me whiplash 2010-03-01
• Microsoft operating profit by division 2010-02-22
• xlls With ExcelDNA 2010-02-18
• Excel xlls with tools 2010-02-17
• Xlls with Planatech XLL+ 2010-02-17
• Raw xlls 2010-02-16
• Managing Excel Extensions/Customisations 2010-02-16
• Excel Customisation/Extension summary 2010-02-15
• Spreadsheet Barbie 2011? 2010-02-14

Peltier Tech Blog

• Charting Utility Upgrades 2010-03-09
• Upcoming Excel Training Sessions 2010-03-04
• High-Low Line Alternatives in Excel Charts 2010-03-03
• Charting NBC Olympic Coverage 2010-03-02
• Reforming a Health Care Reform Chart 2010-03-01
• Contour and Surface Charts in Excel 2007 2010-02-23
• Main Effects and Interaction Plots 2010-02-17
• Monthly And Cumulative Spending Charts 2010-02-15
• Pareto Charts 2010-02-08
• Extra Distortion in a Pie Chart 2010-02-05

Learn Excel from MrExcel Video Podcast

• Offset Lookup - Podcast 1188 2010-03-12
• Fill Handle Regression - Podcast 1187 2010-03-11
• Row Height .18"? - Podcast 1186 2010-03-10
• Counting Mondays 2010-03-08
• Pivot SmartArt - 1184 2010-03-04
• Q1, Q2, H1 - Episode 1183 2010-03-04
• Plus / Minus - 1182 - Learn Excel from MrExcel 2010-02-26
• Dynamic Charting - 1181 - Learn Excel from MrExcel! 2010-02-25
• Check Marks in Excel - Podcast 1180 2010-02-24
• Pivot TagCloud - 1179 - Learn Excel from MrExcel Podcast 2010-02-23

Contextures -- Excel Tips

• Excel Pivot Table Report Filters 2010-02-26
• Excel VBA ComboBox Lists 2010-02-23
• Excel Quick Tips Videos 05 2010-01-07
• Excel Quick Tips Videos 04 2010-01-03
• Excel Quick Tips Videos 03 2009-12-30
• Excel Quick Tips Videos 02 2009-12-30
• Excel Quick Tips Videos 01 2009-12-23
• Colour Filter Headings 2009-12-07
• Excel Advent Calendar 2009-12-02
• Excel VBA Intro - Record and Run a Macro in Excel 2007 2009-11-26

Andrew's Excel Tips

• 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
• Excel 2010 2009-12-06
• Auto Cell Edit 2009-12-06
• DIY Slicers 2009-11-03

Spreadsheet Page Blog

• New Shortcut Key Discovered 2010-02-22
• Greg Likes The Book 2010-02-19
• Excel 2010 VBA Enhancements 2010-02-17
• 14 Years Old 2010-02-16
• Joe's A Fan 2010-02-14
• Chess Game Viewer 2010-02-14
• Your Most Recent Excel Task? 2010-02-12
• Spreadsheet Cartoon 2010-02-03
• Annoying Window Behavior 2010-02-03
• 44 Excel Blogs 2010-01-30

The Ken Puls Blog » Excel

• 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
• PED 2nd Edition â?? Hello World! 2009-07-08
• Quick Tip â?? Set RefEdit boxes to Edit mode 2009-07-03
• VBA IDE vs VS2008 IDE 2009-06-29

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

• MS Excel sites 2010-03-03
• Excel Loader 2009-08-09
• Online resources for VSTO 2009-07-02
• Professional Excel Development (PED) Second Edition 2009-06-07
• SQL Tester 2009-04-20
• Books on VBA / VB / VB.NET & ADO / ADO.NET & VSTO 2009-04-07
• A Collection of useful Excel articles 2009-01-27
• AddInSpy 2008-10-02
• Export SQL Server data to a worksheet 2008-02-11
• Export Access-data to a worksheet 2008-02-11

About Spreadsheets

• Excel 2007 RIGHT Function 2010-03-10
• Excel 2007 CONCATENATE Function 2010-03-08
• Excel 2007 LEFT Function 2010-03-05
• Excel MAX Function 2010-03-03
• Excel 2007 AVERAGE Function 2010-03-01
• Excel MODE Function 2010-02-26
• Excel 2007 MEDIAN Function 2010-02-24
• Excel 2007 EDATE Function 2010-02-22
• Excel 2007 NETWORKDAYS Function 2010-02-19
• Excel TODAY Function 2010-02-17

Microsoft Excel 2010

• Hover Charts 2010-03-11
• PowerPivot Alpha Geek Challenge 2010-03-03
• Scatter charts with PowerPivot 2010-02-24
• Windows Touch & Excel 2010 2010-02-18
• Migrating Excel 4 Macros to VBA 2010-02-17
• Where to Find the Form Controls 2010-02-13
• Offloading UDF's to a Windows HPC Cluster 2010-02-12
• Calculating Excel Models on an HPC Cluster 2010-02-09
• Excel 2010 and High Performance Computing 2010-02-04
• Management Features of PowerPivot for SharePoint 2010-02-01

Pointy Haired Dilbert: Learn Excel Online - Chandoo.org

• 31 Excel Tutorials ? Learn and Be Awesome in Excel 2010-03-11
• Introducing Flag Project ? A fun way to Learn Excel Charting 2010-03-08
• Get a Copy of Excel Project Management Templates Today! 2010-03-04
• Exploring Profit & Loss Reports [Part 4 of 6] 2010-03-03
• Writing ?Either Or? formula in Excel [Formula Howtos] 2010-03-02
• Annual Goals Tracker Sheet [awesome ways to use excel] 2010-03-01
• Sachin Tendulkar ODI Stats ? an Excel Info-graphic Poster 2010-02-26
• Adding Calculated Fields to Pivot Table P&L [part 3 of 6] 2010-02-25
• Use Paste Special to Speed up Chart Formatting [Quick Tip] 2010-02-24
• Find and Remove Blank Items from a Range of Cells [personal experience] 2010-02-23

Other interesting blogs

Juice Analytics: Agile Analytics

• Survey Results: Are the Viz-Pundits Really Helping?
• Chart Selection, Art and Science
• Are you using information effectively?
• Predictive Analytics: Interview with Eric Siegel, Ph.D.
• Important Dialogue
• Automated PowerPoint Generation, or Making a "Slide Factory"
• Depth and Discovery: Powering Visualizations with the Google Analytics API
• Juice's Simple Font Framework
• Designing Great Dashboards - Part 3
• Airline and Airport Traffic and Delays: A JuiceKit Visualization Demo