Headlines from the best Excel weblogs

The most recent posts

ASAP Utilities for Excel ? Blog

• Tip: Quickly clean up your data in Excel 2019-01-10
• For developers; Application.Version returns 16.0 for both Excel 2019 and Excel 2016?!? 2018-10-05
• The importance of Microsoft Office Update | Fix random crashes 2017-10-30
• By request: non-admin setup edition ASAP Utilities 7.3 2016-12-13
• Tip: An easier way to fix the numbers that Excel doesn't recognize 2015-08-25
• Tip: Quickly remove spaces from the beginning and end of your data 2014-03-26
• Tip: Easily COUNT or SUM cells based on their Color 2014-03-21
• Tip: Quickly round the numbers in selected cells 2014-02-21
• Tip: Quickly reset the last cell and minimize the used range 2014-02-06
• New ASAP Utilities 5.1 just released! 2014-01-29

Daily Dose of Excel

• Keyboard Metrics III 2018-11-12
• Incrementing Months and Years 2018-11-09
• Free Table tools add-in 2018-11-09
• International Keyboard Shortcut Day 2018 2018-11-07
• Excel VBA Masterclass Ljubljana 2018-10-02
• Develop Excel Conference, London, October 18 2018-09-17
• Copying and Filling Table Totals 2018-07-06
• Hyperlink Formula Events 2018-07-02
• Office 365 Pro Plus meets Windows 10S, they don?t fall in love. 2018-06-03
• The Amsterdam Excel Summit 2018 2018-05-11

Peltier Tech Blog

• Remotely Trigger an Excel VBA Macro 2019-03-11
• Add Totals to Stacked Column Chart 2019-02-28
• Install an Excel Add-In 2019-02-26
• Send a Frown 2019-02-25
• Reference SeriesCollection Item by Name or Index 2019-02-18
• Trendline Calculator for Multiple Series 2019-02-12
• Repeated Gantt Chart to Track Players? Ice Time 2019-01-03
• Can You Answer This Quora Question? 2018-12-13
• Add One Trendline for Multiple Series 2018-12-05
• Revenue Chart Showing Year-Over-Year Variances 2018-11-15

Contextures Blog

• Compare Two Excel Tables with Simple Formula 2019-03-07
• Excel Button Text from Worksheet Cell 2019-02-28
• Excel Pivot Table Troubleshooting 2019-02-21
• Show Your Own Excel Error Values 2019-02-14
• How to Make an Order Form in Excel 2019-02-07
• Drop Down from Filtered Excel List 2019-01-31
• Add Data to Excel Table with Total Row 2019-01-24
• Highlight Top or Bottom Values in Excel List 2019-01-17
• Pivot Chart Title from Filter Selection 2019-01-10
• Excel Trackers for New Year Resolutions 2019-01-03

Office Blogs

• Stay connected wherever work takes you 2016-08-01
• Follow the Summer Games in Rio with the new Outlook Interesting calendar feature 2016-08-01
• Enhancing information rights management in Word, Excel and PowerPoint mobile apps 2016-07-29
• Learning Tools for OneNote supports more languages and themes and is now generally available 2016-07-28
• Episode 101 with Simon Jäeger on becoming an evangelist?Office 365 Developer Podcast 2016-07-28
• 7 simple calendar tricks that will level-up your team's productivity 2016-07-28
• Is your company's data secure? 2016-07-28
• Announcing monthly educator ?#OneNoteQ TweetMeets? in partnership with OneNote Central 2016-07-28
• Register for ?From Demo to Action: Tips from everyday users? on Modern Workplace 2016-07-27
• Kelly Services?putting nearly one million people to work every year, one great hire at a time 2016-07-27

Smurf on Spreadsheets

• most spreadsheets 2019-01-31
• Spreadsheet modelling competition 2018-11-15
• DevelopExcel conf almost sold out 2018-10-03
• Office 2019 released 2018-09-25
• Bluetooth mice 2018-09-21
• About Time 2018-08-31
• more perf figures 2018-08-22
• Excel 2016 performance ? even interestinger 2018-08-19
• Excel 2016 perf what the effing eff? 2018-08-17
• Excel 2016 Performance 2018-08-02

Excel ? The Excelguru Blog

• Become a Data Master with Power Query 2019-02-21
• Check the application version in Modern Office 2019-02-11
• Cache Shared Nodes Fix is Live 2019-01-30
• Building BI in Excel Course 2019-01-22
• One Solution to Challenge 4 2018-11-30
• Power Query Challenge 4 2018-11-29
• The Future of Power Query Challenges 2018-11-29
• Analyzing text with Power Query and Excel 2018-10-17
• Nuthin? ain?t nuthin? in Power Query 2018-10-04
• Power Query Recipes Now Available 2018-09-24

Bacon Bits

• Me vs Hungarian Notation 2017-06-27
• Create SQL Server Tables from Excel Data ? Free Tool 2017-06-19
• Excel Against Humanity 2017-03-31
• Best Practices for Organizing VBA Modules 2017-03-21
• Pulling SSRS Data Directly into Excel with PowerPivot 2017-03-07
• Me vs Hungarian Notation 2017-06-27
• Create SQL Server Tables from Excel Data ? Free Tool 2017-06-19
• Excel Against Humanity 2017-03-31
• Best Practices for Organizing VBA Modules 2017-03-21
• Pulling SSRS Data Directly into Excel with PowerPivot 2017-03-07

Excel and UDF Performance Stuff

• Formula Explorer Pro Beta 4.2 2019-01-08
• Develop Excel Conference 2018-07-30
• Formula Explorer Pro 2018-07-19
• Excel 2016 Performance Improvements 2018-01-29
• Strategies for getting the last row in Excel with VBA 2017-09-01
• Excel JavaScript API Part 5: The large numbers bug 2017-04-05
• Excel JavaScript API Part 4: The shallow copy problem 2017-04-05
• Excel JavaScript API Part 3: Benchmark of Processing Arrays Performance ? Loop vs Reduce vs COUNTIFS vs VBA 2017-03-16
• Excel JavaScript API Part 2: Benchmark of Read/Write Range Performance 2017-03-13
• Excel Range.Value(ValueType): What is this parameter? 2017-03-13