Here is the latest news about Microsoft Excel, and updates on the Contextures website and blogs.
Contextures Blog: In an Excel Order Form, click the check box and a macro fills in the billing address. Clear the check box to clear address info.
FILTER Function: Simple Excel FILTER function examples - how to create lists that update automatically. Set rules, format list items. Sept 15, 2020
Pivot Table Blog: Quickly refresh all pivot caches in workbook with #Excel macro. Message shows cache and failure counts. Sept 9, 2020
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.
In Excel for Office 365, you can use the FILTER function to create dynamic lists, based on your criteria. These lists will update automatically, if you change the source data or the criteria. In this video, see 3 FILTER function examples:
See the details, and get the sample workbook on the FILTER Function Examples page.
Contextures Blog: Use the new Excel TEXTJOIN function to combine several text items, quickly and easily. See simple and complex examples. Sept 3, 2020
Workbook Macro: At end of work day, use this macro to list and close all open Excel files. Next day, click button to open those files again. Like Excel's old Workspace feature. August 27, 2020
Criteria List: Filter an Excel table based on criteria lists on different sheet. Click buttons to quickly run macros that apply AutoFilter, or clear all filters. Get the free workbook. August 24, 2020
Contextures Blog: Click a Slicer to quickly show value groups in Excel pivot table. Great for source data with lots of value fields. August 20, 2020
Drop Down Lists: Limit choices with dependent drop down lists, based on choice in other drop downs. Select region, then sales rep, then customer for region and rep. Free Excel workbook. August 14, 2020
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: September 23, 2020 10:27 AM
Contextures RSS Feed