Headlines from the best Excel weblogs

The most recent posts

ASAP Utilities Blog

• Tip: Easily move and resize your range selection(s) in Excel (Video Tutorial) 2021-02-08
• Small update to website and blog: responsive/mobile friendly 2021-01-22
• Tip: Quickly save just your selection or sheet as a new file 2020-11-23
• The importance of Microsoft Office Update | Fix random crashes and performance issues 2020-04-23
• 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
• 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

Daily Dose of Excel

• Name Manager updated 2020-12-14
• RefTreeAnalyser: Two updates 2020-12-04
• Opening a File from a Userform Disables Ribbon 2020-09-09
• Excel Virtually Global 2020-07-17
• Excel VBA Masterclass 2020-04-27
• International Keyboard Shortcut Day 2019 2019-11-04
• Combinations, Combinations. And the winner is? 2019-09-19
• Putting Statistics 2019-08-19
• Combinations, Combinations. A challenge 2019-08-06
• Where's my ?Edit Measure? option from the Values pane? 2019-08-05

Peltier Tech Blog

• Dynamic Charts Using Dynamic Arrays 2021-03-25
• Install an Excel Add-In in Excel for Mac 2021-03-16
• Dynamic Array Histogram 2021-03-08
• VBA Test for New Excel Functions 2021-02-10
• Convert Line Chart to Step Chart with VBA 2020-12-21
• Calculate Nice Axis Scales with LET and LAMBDA 2020-12-08
• Charts for Excel Upgrade 2020-11-30
• Conditional Donut Chart 2020-10-21
• Prepare Your Data in a Chart Staging Area 2020-10-19
• Precision Positioning of XY Data Points 2020-10-14

Contextures Blog

• Excel Error Cannot Shift Objects Can?t Push Objects 2021-04-01
• PowerPoint Slides From Excel List 2021-03-18
• Excel Nested IF Formula Horror Stories 2021-03-04
• Quick Tip: Find and Replace Line Breaks in Cells 2021-02-18
• Count Duplicates in Excel List With Pivot Table 2021-02-04
• Add Letter Headings in Excel Drop Down List 2021-01-21
• Quick Tip: Divide Excel Numbers Without Formulas 2021-01-07
• Excel Roundup 2020-12-31 2020-12-31
• How to Count Specific Words in Excel Text String 2020-12-10
• Excel Threaded Comments Macros 2020-11-26

Chandoo.org ? Learn Excel, Power BI & Charting Online

• 10 Advanced IF formula tricks you must know 2021-03-31
• Advanced Data Viz with Excel ? Live Event on 26 March 2021-03-17
• What is XLOOKUP? 13 formula examples to really understand it 2021-03-17
• Write a formula to get Department Budget for a Month [Homework] 2021-03-12
• How to embed Excel files, calculators on your website? ? Step by step instructions 2021-03-03
• Dynamic Arrays Live Masterclass ? Replay 2021-02-23
• 5 Simple & Useful Conditional Formatting Tricks 2021-02-15
• 10 Advanced IF formula tricks you must know 2021-03-31
• Advanced Data Viz with Excel ? Live Event on 26 March 2021-03-17
• What is XLOOKUP? 13 formula examples to really understand it 2021-03-17

Featured Blog

• Unhide multiple worksheets 2021-03-25
• Financial Modeling World Cup 2021-03-22
• Resizable Conditional Formatting dialogs 2021-03-03
• What's New in Excel for the web 2021-03-02
• Excel Reddit AMA on March 10 at 10 AM PT 2021-02-16
• Announcing first-ever Office Scripts AMA on February 16th! 2021-01-28
• Performance Improvements in Excel for the Web 2021-01-25
• Discover Data Types templates 2021-01-11
• Simplified Ribbon is now available in Excel for the web 2020-12-16
• Open multiple documents in Excel on iPadOS 2020-12-09

Smurf on Spreadsheets

• Gods Own County 2019-07-31
• Self Spreadsheet Saboteur risks 10 years porridge 2019-07-23
• Eusprig 2019 2019-06-17
• Old VB6 books 2019-05-02
• 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

Excel ? The Excelguru Blog

• Major redesign at Skillwave.Training 2021-03-09
• New Monkey Tools Features 2021-01-12
• More free features in Monkey Tools 2020-12-02
• Use Excel Tables to Filter a Power Query 2020-09-23
• Update to Monkey Tools QuerySleuth 2020-09-10
• Creating Power Query Based Calendars 2020-07-08
• Name Worksheets After Queries 2020-05-15
• Change Multiple Load Destinations at Once 2020-04-30
• Monkey Tools Update Now Available 2020-04-24
• Appending Columns with Different Names 2020-04-07

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

• Finding VBA Bottlenecks with VBA Profiler 2020-10-29
• Excel Virtually Global 2020-07-17
• FastExcel Version 4 ? with Introductory Offer 2020-02-05
• Backward Compatibility of Office 365 Dynamic Arrays (Updated 23 Sep 2020) 2019-05-20
• Excel Summit South 2019 2019-05-13
• 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