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 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
• 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

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

• Getting Started with Power Pivot & DAX ? FREE Live Masterclass 2021-05-21
• How to create a fully interactive Project Dashboard with Excel ? Tutorial 2021-05-19
• Extract data from PDF to Excel ? Step by Step Tutorial 2021-04-14
• 10 Advanced IF formula tricks you must know 2021-03-31
• 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
• Getting Started with Power Pivot & DAX ? FREE Live Masterclass 2021-05-21
• How to create a fully interactive Project Dashboard with Excel ? Tutorial 2021-05-19
• Extract data from PDF to Excel ? Step by Step Tutorial 2021-04-14

Microsoft Tech Community - Latest Blogs - Excel Blog

• Office Scripts is now generally available 2021-05-27
• Import data from local files using Power Query in Excel for Mac 2021-05-19
• New data types and smart templates powered by Wolfram are now generally available 2021-05-17
• Our journey to make Excel work well for everyone 2021-05-05
• Power BI connected PivotTables in Excel for the web 2021-05-04
• Collaborate with confidence: Introducing Show Changes for Excel on the Web 2021-04-29
• Ready Player Zero 2021-04-28
• What's New in Excel for the web 2021-04-26
• Unhide multiple worksheets 2021-03-25
• Financial Modeling World Cup 2021-03-22

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

• 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
• Change Multiple Load Destinations at Once 2020-04-30
• Monkey Tools Update Now Available 2020-04-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

• 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