Here is the latest news about Microsoft Excel, and updates on the Contextures website and blogs.
Spreadsheet Day: This year's Spreadsheet Day is Sunday Oct 17th - are you ready to celebrate?
Cluster Stack Pivot Chart: See how to create a Cluster Stack Pivot Chart from a pivot table. Use named Excel table or see how to unpivot data with Power Query. Sept 27, 2021
Remove Duplicates: Simple steps to remove duplicate items from Excel list. Fix problem when duplicates numbers not all removed. Sept 16, 2021
To see the latest features and fixes in Excel, go to these pages on the Microsoft site and YouTube.
Microsoft 365 Apps: For the Monthly Enterprise Channel, go to this page for a list of new features and fixes in the latest versions.
Microsoft 365: To see new features demonstrated, go to the Microsoft 365 YouTube Channel. Look for the monthly videos on "What's New".
Excel Improvements: Excel users are encouraged to post improvement suggestions on Microsoft's Excel UserVoice website. To see the completed items from that list, go to this filtered list. There's also a list in this Excel Tech Community article, which is frequently updated.
Office Updates: For a list of all Office updates, going back to 2010, and other Microsoft resources, visit the Office Updates page. There is a Download PDF link, at the bottom left corner on that page.
Watch this short video to see how to hide used items in an Excel 365 drop down list, to prevent duplicate entries.
See the details, and get the sample workbook on the Hide Used Items in Drop Down page.
Contextures Blog: Three ways to create a clustered stacked chart in Excel. Sept 16, 2021
Conditional Formatting: Fix Excel conditional formatting problems when extra rules are automatically created. Manual or macro clean up. Sept 9, 2021
Contextures Blog: Choose golf tee off time and assign players in Excel. Partially filled time slots can be completed later. Sept 2, 2021
Spreadsheet Day Blog: Charts, orcas, pivot tables and more, in the latest spreadsheet roundup. Aug 31, 2021
Contextures Blog: Hide used items in Excel 365 drop down list, to prevent duplicate entries. Aug 26, 2021
Contextures Blog: Diving into the new Power Query book, and Excel Query pane problems. Aug 5, 2021
Pivot Table Blog: Save time-stamped backup copies of Excel files while you work with free add-in. August 4, 2021
Don't miss my latest Excel tips and videos! Click OK, to get my weekly newsletter with Excel tips, and links to other Excel news and resources.
Last updated: October 23, 2021 11:51 AM
Contextures RSS Feed