On this page, you can see what's new, here on the Contextures website, and on each of my blogs.
There's one of my recent videos too, showing the steps for an Excel feature. Also, there are links that take you to the Microsoft site, so you can find out what's new in Microsoft Excel, and the other Microsoft Office apps.
These are the latest articles that I've posted here on my Contextures site, as well as each of my blogs. There is a longer list of articles, further down on this page - it shows articles from previous months
Contextures Blog: Use Excel macros to quickly create 12 monthly workbooks, with daily sheets, for the upcoming year. Dec 1, 2022
Pivot Table Blog: Is it hotter than usual this November? Compare years with pivot table conditional formatting colour scale Nov 9, 2022
Skip Blanks: Avoid pasting blank cells over existing data with Excel Skip Blanks feature. Nov 9, 2022
Add Sheets Macro: Macro adds new worksheet automatically when file opens at start of month. Nov 1, 2022
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 compare two Excel lists, to find new items in the second list, and add them to the first list
See the details, and get the sample workbook on the Excel Compare Two Lists page.
This list shows previous articles that I've posted here on my Contextures site, as well as each of my blogs. These articles are from the past year or so.
Contextures Blog: Excel for the holidays - planners, Advent calendars, Christmas trees, personalized messages. Nov 17, 2022
Contextures Blog: Have you ever sent Microsoft a smile or frown in Excel? Go to the Help tab, and click Feedback. Nov 3, 2022
UserForm Search: Use this Excel UserForm to search transaction records in a worksheet table. Add new records, or find existing records, and view, edit or delete them. Sept 28, 2022
Contextures Blog: Before you click Remove All button for Excel Subtotal feature, be prepared -- there's no Undo! Sept 22, 2022
Count Blanks: In a pivot table, see how to count blanks in source data cells. Fix problem, get correct count of empty cells. Video, written steps, Excel workbook. Sept 13, 2022
Contextures Blog: How I fixed an Excel error message -- ⚠️ Reference isn't valid. Sept 8, 2022
Contextures Blog: Problems pasting into filtered Excel list? This shortcut might help, or try a workaround. Aug 25, 2022
Contextures Blog: It's football season! New Excel sample data for testing/training - NFL player rosters - 2 teams, 2 years . Aug 11, 2022
Pivot Table Blog: Date filters in Excel pivot tables - try these 3 different types. Aug 3, 2022
Contextures Blog: Video shows how to use wildcards with criteria for a flexible AVERAGEIF formula in Excel . July 28, 2022
Date Grouping: See how to turn off automatic date grouping for Excel Pivot Tables and AutoFilters. July 18, 2022
Contextures Blog: Track your golf scores in Excel, for multiple players & courses . July 14, 2022
Line Breaks: How to add line breaks in Excel cells and formulas. Find and remove line breaks. July 13, 2022
Pivot Table Blog: Quickly check sales progress with % Running Total feature in Excel pivot table - 2 videos show the steps. July 6, 2022
Contextures Blog: How to make country flags in Excel 365, with 1 formula instead of 48672! June 30, 2022
Compare Lists: Compare two Excel lists, to find new items in second list, and add them to first list. June 20, 2022
Pivot Table Blog: Quick and easy steps to make a clustered stacked pivot chart in #Excel. Video and sample file. June 8, 2022
Contextures Blog: How to find product price with Excel VLOOKUP and MATCH, for quantity ordered. June 16, 2022
Status Bar Tips: Use Excel Status Bar info to troubleshoot problems, and get key information. For macros, show custom messages with macro progress updates. June 8, 2022
Debra D Blog: Use bookmarks and shortcut keys for quick navigation in Notepad++ file. June 6, 2022
Contextures Blog: How to count duplicate number sets with Excel formulas, using Excel 365 spill functions. June 2, 2022
Debra D Blog: How to fix mouse double click problem in Microsoft Access, get it working again. May 30, 2022
Contextures Blog: How to show hidden data in Excel chart or Excel sparklines. Change chart setting manually or with macro. May 19, 2022
Basic UserForm - Videos: Step-by-step videos show how to make basic Excel UserForm with text boxes for data entry. May 16, 2022
Pivot Table Blog: Why does pivot table show duplicate numbers? How to fix the problem. May 11, 2022
FILTER Function Reports: See how to create multi-column summary reports, using Excel FILTER Function (Excel 365). May 7, 2022
Contextures Blog: Take a break from your work, and use Excel to stream web radio. May 5, 2022
Debra D Blog: How to fix avi format videos that have audio and black screen, with Video Editor in Microsoft Photos program. Apr 24, 2022
Contextures Blog: See warning if Excel worksheet sheet has hidden rows or columns, and steps show how to fix them. Apr 21, 2022
Compare Cells: How to compare cell values in Excel. Find exact match, or partial match and percentage. Apr 12, 2022
Pivot Table Blog: Help Excel pivot table macros run faster by preventing automatic updates. Apr 6, 2022
Excel Charts: How to show hidden data in Excel chart or Excel sparklines. Change chart setting manually or with macro. Mar 15, 2022
Highlight Weekends: How to highlight weekend data in Excel pivot table with conditional formatting. Fix rule settings to avoid problems. Mar 2, 2022
Excel Printing: How to create an Excel report diagnostic display to check filter settings before printing. Jan 27, 2022
Working Days: How to calculate project dates or upcoming workdays in Excel with WORKDAY function and WORKDAY.INTL function. Jan 17, 2022
Copy & Paste Problems: How to fix Excel copy & paste problems for multiple selections error, or formulas changed to values. Dec 27, 2021
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
Conditional Formatting: Fix Excel conditional formatting problems when extra rules are automatically created. Manual or macro clean up. Sept 9, 2021
Last updated: December 1, 2022 10:15 AM