Headlines from the best Excel weblogs

The most recent posts

ASAP Utilities for Excel ? Blog

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

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

• 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
• Welcome to the Day of Data! 2020-10-13
• Use Power Query to Manipulate Your Data 2020-05-07
• Dynamic Arrays, XLOOKUP, LET ? New Excel Features 2020-05-05
• Watching my Weight with SPC (Statistical Process Control) 2020-04-28

Contextures Blog

• 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
• Combine Text and Formatted Numbers in Excel 2020-11-12
• Excel Spill Formula Examples 2020-10-29
• Happy Spreadsheet Day 2020 2020-10-17
• Spreadsheet Day 2020 Online Celebration 2020-10-13
• Excel Looks Strange on Second Monitor 2020-10-01
• Excel Check Box Fills in Billing Address 2020-09-17
• Excel TEXTJOIN Function Examples 2020-09-03

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

• Merry Christmas & Happy New Year 2021 2020-12-24
• Image Lookup ? How-to show dynamic picture in a cell [Excel Trick] 2020-12-16
• 9 Box grid for talent mapping ? HR for Excel ? Template & Explanation 2020-11-17
• 6 Must Know Line Chart variations for Data Analysis 2020-10-01
• Two-level Data Validation [Excel Trick] 2020-09-23
• Excel formula to convert calendar format to table 2020-09-03
• Power Query Tutorial ? What is it, How to use, Full examples, Tips & Tricks 2020-08-26
• Merry Christmas & Happy New Year 2021 2020-12-24
• Image Lookup ? How-to show dynamic picture in a cell [Excel Trick] 2020-12-16
• 9 Box grid for talent mapping ? HR for Excel ? Template & Explanation 2020-11-17

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

• 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

• 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
• PivotSleuth and Measure Tables 2020-03-31
• Monkey Tools is Here 2020-03-23

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