Headlines from the best Excel weblogs

The most recent posts

asap utilities / excel blog

• Select cells easier and faster 2012-01-25
• How to: Protect multiple sheets at once 2012-01-13
• Pre-release new version & Happy new year! 2012-01-06
• Happy Holidays 2011-12-23
• User question: How to send this sheet to an e-mail in Excel 2010? 2011-11-21
• User question: How to delete cells based on content 2011-11-18
• User question: How to enter the same value on multiple sheets (or in multiple cells at once) 2011-11-16
• How to: Change the shortcuts used by ASAP Utilities 2011-11-03
• ASAP Utilities released its new version (4.8.0) today! 2011-10-26
• How to: Save several worksheets together in a single new workbook 2011-10-21

asap utilities / excel blog » how to with ASAP Utilities

• How to: Protect multiple sheets at once 2012-01-13
• User question: How to delete cells based on content 2011-11-18
• User question: How to enter the same value on multiple sheets (or in multiple cells at once) 2011-11-16
• How to: Change the shortcuts used by ASAP Utilities 2011-11-03
• How to: Select a number of worksheets and export each as a single workbook 2011-10-20
• How to use the extra functions you get with ASAP Utilities 2010-12-01
• Video: An easy way to split each group into a separate worksheet tab with ASAP Utilities 2010-10-25
• An easy way to split sheets 2010-10-25
• How to: Set column width and row height in centimeters or inches? 2010-02-23
• How to: Quickly remove duplicated records 2010-02-18

Daily Dose of Excel

• Tell Tale Signs 2012-02-03
• Excel Versions 2012-01-31
• Excel Mashup #2 2012-01-29
• Excel Dev Con Live Blogging 2012-01-25
• Excel Mashup #1 2012-01-25
• Using HTML5 Fractions in Exported Excel Tables 2012-01-24
• Messy Donut Junk 2012-01-24
• Does the location of a formula affect its accuracy? 2012-01-12
• No more Google Adsense ads on my website ? at least for now 2012-01-11
• Fixing Exported Dates 2012-01-05

Peltier Tech Blog

• Chart Busters: What Planned Parenthood Actually Does 2012-02-02
• Poor Man's Sparklines in Microsoft Excel 2012-01-30
• Select Meaningful Axis Scales 2012-01-26
• Getting Answers For Your Excel Questions 2012-01-23
• Excel Plotted My Bar Chart Upside-Down 2012-01-19
• You Have 1 New Notification On Klout! 2012-01-16
• Chart Busters: What Planned Parenthood Actually Does 2012-02-02
• Poor Man's Sparklines in Microsoft Excel 2012-01-30
• Select Meaningful Axis Scales 2012-01-26
• Getting Answers For Your Excel Questions 2012-01-23

Contextures Blog

• Excel SUMIFS Sum With Multiple Criteria 2012-02-02
• Use Excel COUNTIFS to Count With Multiple Criteria 2012-01-31
• Preparing for an Excel Expert Exam 2012-01-19
• Hide Pivot Table Detail Without Filtering 2012-01-17
• Excel UserForm Data Entry Update 2012-01-12
• Updated Excel Weight Loss Tracker 2012-01-10
• Excel Drop Down From List in Different Workbook 2012-01-05
• Change All Pivot Tables With One Selection 2012-01-03
• Excel Pivot Table from Multiple Sheets Update 2011-12-28
• Change Excel Comment Shape 2011-12-22

Chandoo.org - Learn Excel & Charting Online

• Formula Forensics No. 010 Count How Many Times a List of Values Occurs in a Range 2012-02-01
• Custom Number Formats (Multiply & Divide by any Power of 10) 2012-01-31
• Excel Links ? Live from Bangkok Edition 2012-01-30
• Cleaning Up Imported Data ? A Recent Case Study 2012-01-25
• Formula Forensics No. 008 ? Elkhan's MaxIf 2012-01-24
• Excel's Auditing Functions [Spreadsheet Risk Management - Part 3 of 4] 2012-01-18
• Formula Forensics. 009 ? Pradhishnair's Chainage Problem 2012-01-17
• Six Quick Updates 2012-01-16
• Finding Friday the 13th using Excel (and learning cool formulas along way) 2012-01-13
• Announcing Online VBA Classes from Chandoo.org, Please Join Today 2012-01-11

ExcelUser Blog

• How to End Jaggies in Large Excel Headlines 2011-12-18
• How to Create Two-Dimensional Lookups in Excel Formulas 2011-11-17
• How One Excel User Is Making a Great Living From Excel Reports 2011-11-13
• Still Another Excel 2010 Camera-Tool Bug, and How to Fix It 2011-11-13
• Compare Performance to Yes-No Conditions in Excel Charts 2011-11-10
• How to Chart Recessions in Excel, Part 2 of 2 2011-11-09
• How to Chart Recessions in Excel, Part 1 of 2 2011-11-08
• How to Reference Gasoline Price History in Excel Formulas 2011-10-29
• Here's One Excel Chart That Shows the Protesters Shouldn?t Blame Business 2011-10-22
• Track Public Confidence Daily 2011-10-22

Excel Blog

• Excel: The Basics (Video) 2012-02-01
• Five most popular posts on the Excel blog in 2011 2012-01-26
• Yes, it is possible to create nice looking spreadsheets 2012-01-19
• Guy Kawasaki's guide to creating a financial forecast in Excel 2012-01-18
• Generate invoice numbers in Excel 2012-01-12
• Beyond spreadsheets: Spiffy Excel calendars for 2012 2012-01-06
• VBA tip: Limit the number of times a file can be opened 2012-01-04
• Excel mashup tutorial 2011-12-22
• Last-minute budget tips for those last-minute gifts 2011-12-20
• Create smashing mashups with Excel 2011-12-15

Smurf on Spreadsheets

• Excel developer conference thanks 2012-01-30
• Facebook spam fest 2012-01-29
• Dev conf social 2012-01-19
• Extreme Spreadsheeting 2012-01-17
• Excel Dev Conf Presenter Bob Phillips 2012-01-12
• Stratfor RickRolled 2012-01-10
• More conf presenters. 2012-01-09
• One Down 2012-01-07
• 5 years 2012-01-07
• Last few hours of conference discount 2012-01-06

Learn Excel from MrExcel Video Podcast

• Learn Excel 2010 - "Stop Speak On Enter!": Podcast #1514 2012-01-30
• Dueling Excel - "Total All Lookups": Podcast #1513 2012-01-27
• Learn Excel 2010 - " Move Entire Rows ": Podcast #1512 2012-01-26
• Learn Excel 2010 - "Count Between Ranges-With A Pivot Table": Podcast #1511 2012-01-26
• Learn Excel 2010 - "Chart An Extra Series": Podcast #1510 2012-01-23
• Dueling Excel - "Conditional Format +/- 15%": Podcast #1509 2012-01-20
• Learn Excel 2010 - "Count Between A Range": Podcast #1508 2012-01-19
• Learn Excel 2010 - "Random Around Media and Standard Deviation": Podcast #1507 2012-01-12
• Learn Excel 2010 - "GL Codes Imported as Dates": Podcast #1506 2012-01-11
• Learn Excel 2010 - "Next Invoice Number": Podcast #1505 2012-01-10

About Spreadsheets

• Excel AVERAGEIFS Function 2012-02-02
• Excel COUNTIF Function 2012-01-28
• Excel SUMIFS Function 2012-01-24
• Excel SUMIF Function 2012-01-19
• Excel TRUNC Function 2012-01-16
• Excel IF Function Step by Step Tutorial 2012-01-12
• Rounding Numbers with the CEILING Function 2012-01-06
• Keeping Headings and Titles on Screen in Excel 2012-01-02
• Round Numbers Up in Excel 2011-12-30
• Rounding Numbers in Excel 2011-12-22

Andrew's Excel Tips

• Charts and Excel Services 2 2011-12-11
• AET Chart Tools Update 2011-12-11
• Charts and Excel Services 2011-10-23
• Random Data Generator 2011-10-02
• Named Ranges and Excel Services 2011-09-22
• Financial Date Formulas 2011-09-11
• Macro Comments v2 2011-09-04
• When should I use a chart? 2011-08-28
• What's wrong with this chart? 2011-08-23
• AET Chart Tools 2011-08-15

Spreadsheet Page Blog

• Excel 15 2012-01-14
• How To Be Employable 2011-11-15
• Elevens 2011-11-11
• How Many Books? 2011-10-17
• Today Is Spreadsheet Day 2011-10-17
• Do You Hate Mailing Stuff? 2011-10-11
• Excel And Scotch 2011-10-08
• Excel Champ 2011-08-04
• Google Plus 2011-07-20
• Bad Charts On Wikipedia 2011-06-29

Excel Unusual

• An Animated Linear Feedback Shift Register (LFSR) as a Pseudo Random Pattern Generator in Excel 2003 ? Part#3 2011-10-16
• An Animated Linear Feedback Shift Register (LFSR) as a Pseudo Random Pattern Generator in Excel 2003 ? Part#2 2011-10-12
• An Animated Linear Feedback Shift Register (LFSR) as a Pseudo Random Pattern Generator in Excel 2003 ? Part#1 2011-10-10
• An Animated Ray Tracing Model for Spherical Mirrors ? video preview 2011-07-19
• A 3D Flight Simulator ? video preview 2011-07-18
• Anaglyph Stereoscopy in Excel ? video preview 2011-07-17
• A Fast Pong Game with Special Effects in Excel 2003 ? video preview 2011-07-15
• Random Walk and Brownian Motion Diffusion Model ? video preview 2011-07-15
• The Melting Snow Castle ? video preview 2011-07-14
• A 2D Animated Heat Transfer Model ? video preview 2011-07-13

Excel Hero

• Time to Learn!
• Excel VBA Class 2012
• Excel Universal Calendar Template
• VBA vs Macros
• Awesome Formula Challenge!
• Chandoo's VBA Class
• Excel Hero Academy is Closing Registration for 2011
• Excel Corality Challenge Winner Announced
• Excel Hero Logo Contest!
• Excel Hero Academy Is Reopening!

Other interesting blogs

The Microsoft Office Blog

• Excel: The Basics (Video) 2012-02-01
• PST Capture: New tool to manage those ever multiplying inboxes 2012-02-01
• Office 365 Helps Small Businesses Imagine the Possible 2012-01-31
• "Office 15" Begins Technical Preview 2012-01-30
• Update on BlackBerry Business Cloud Services for Microsoft Office 365 2012-01-30
• Quick! Recall that email message 2012-01-28
• Five most popular posts on the Excel blog in 2011 2012-01-26
• How to save your Access SharePoint password 2012-01-26
• Helping You Get Started 2012-01-25
• Working with Nothing but a Windows Phone, Part 2 (Office Mobile) 2012-01-24

Juice Analytics

• People Love Beauty. A Dashboard Design Truth. 2011-12-17
• Dashboard Gauges: Indulgence with Restraint 2011-12-01
• Dashboard Designs People Love ? A Refresher 2011-11-18
• What's on Your Wall? 2011-11-01
• Cheers! Juice is Headed to Boston. 2011-10-14
• Can A Map Move a City? 2011-09-22
• Announcing the Strata Vizathlon Winners! 2011-09-15
• Visualizations as vocabulary?or know the big words, use the small ones 2011-09-09
• More Time to Visualize Big Apples. Strata Vizathlon Deadline Extended. 2011-08-29
• ?Powering the Kitchen? 2011-08-22