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

• Macros with 32-bit API Calls 2021-05-31
• 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

Peltier Tech

• Prevent Overlapping Data Labels in Excel Charts 2021-05-24
• Slope Chart with Data Labels 2021-05-06
• 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

Contextures Blog

• Excel Workbook for Golf Tee Off Times Update 2021-09-02
• Hide Used Items in Drop Down List With Excel 365 Formula 2021-08-26
• Excel Queries & Connections Pane Stuck at Top of Screen 2021-08-05
• Find MAX and MIN With Criteria in Excel Formulas 2021-07-22
• Excel Roundup 2021-06-24 2021-06-24
• Excel Workbook Formulas Not Calculating: How to Fix Them 2021-06-10
• Excel Formatted Named Tables: Love Them or Hate Them? 2021-05-27
• Excel Drop Down List with Latest Items at Top 2021-05-13
• Excel MATCH Function Error Troubleshooting Examples 2021-04-29
• Reverse First Last Names with Excel Formula 2021-04-15

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

• Sorting values in Olympic Medal Table style [Quick Tip] 2021-08-02
• How to use Date & Time values in Excel ? 10 + 3 tips 2021-07-28
• Getting Started with Power BI ? Sales Dashboard in one hour 2021-06-17
• 6 Essential TEXT functions in Excel with 6 Everyday Examples 2021-06-14
• How to create a fully interactive Project Dashboard with Excel ? Tutorial 2021-06-10
• Getting Started with Power Pivot & DAX ? FREE Live Masterclass 2021-05-21
• Extract data from PDF to Excel ? Step by Step Tutorial 2021-04-14
• Sorting values in Olympic Medal Table style [Quick Tip] 2021-08-02
• How to use Date & Time values in Excel ? 10 + 3 tips 2021-07-28
• Getting Started with Power BI ? Sales Dashboard in one hour 2021-06-17

Microsoft Tech Community - Latest Blogs - Excel Blog

• Excel and Power BI: connected features coming soon for users with Power BI free licenses 2021-08-31
• Help us shape the future of automation in Excel 2021-08-17
• Inspiration for inclusive features comes from customers 2021-07-29
• Announcing LAMBDA Helper Functions: Lambdas as arguments and more 2021-07-26
• Restrict usage of Excel 4.0 (XLM) macros with new macro settings control 2021-07-22
• Celebrate World Orca Day with Microsoft Excel 2021-07-14
• What's New in Excel for the web 2021-06-15
• Come join our Office Scripts and Power Automate AMA! 2021-06-03
• Office Scripts is now generally available in Excel for the web 2021-05-27
• Import data from local files using Power Query in Excel for Mac 2021-05-19

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

• Fireside Chat With a Data Monkey 2021-09-01
• Label Duplicates with Power Query 2021-08-04
• Building a SelectQuery Function 2021-04-14
• 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

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