Home > Skills > FAQs > What's New What's New in Microsoft ExcelOn 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. For many more tutorials, go to the Excel Tips page. You'll find an Excel topic list there, with links to the tutorial pages. |
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
Pivot Table Blog: Do you love Excel GetPivotData function or do you turn it off? . Mar 29, 2023
Unpivot with Power Query: Unpivot Excel data using Power Query, to create normalized column layout. Step-by-step guide, sample file. Mar 8, 2023
Contextures Blog: How to turn off the grey "Page 1" on your Excel worksheet. Mar 9, 2023
Debra D's Blog: Enter start and end dates on a Microsoft Access form, to use as date range criteria for a query. Mar 13, 2023
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.
Pivot Table Blog: Instead of complex Excel formulas, use a pivot table to show MIN IF or MAX IF numbers. Mar 15, 2023
Pivot Table Blog: How to fix Excel pivot table subtotal date format to match other dates. Mar 8, 2023
Contextures Blog: Calculate ratios in Excel with this 3-step formula, and don't trust the bots! Mar 2, 2023
Pivot Table Blog: Move Excel pivot table values for better printing, with a vertical layout. Mar 1, 2023
Filtered Rows: Count or sum filtered rows in Excel list. How many rows are visible in Excel table? What the total for numbers in filtered table. Feb 24, 2023
Contextures Blog: Use an Excel macro to quickly increase amounts in multiple cells. Feb 23, 2023
Pivot Table Blog: Select specific pivot table section, such as subtotals, so you can apply formatting. Video shows the steps. Feb 22, 2023
Contextures Blog: Macros list all threaded comments on an Excel worksheet. You can show all replies for each comment too! Feb 16, 2023
Pivot Table Blog: Add fake clickable hyperlinks to Excel pivot tables. Video shows the steps. Feb 15, 2023
Debra D Blog: Are you ready to pivot? Yes, Bing Search Chat will change things, but if four people can turn a train, you can pivot your blog, to keep it growing!. Feb 13, 2023
Pivot Table Blog: Troubleshoot the problem for an Excel pivot table not showing all data. Feb 8, 2023
Contextures Blog:Repeat text with Excel REPT function for in-cell charts, table row height & more. Feb 2, 2023
Pivot Table Blog: Show extra subtotals in pivot table, without adding columns. Watch for limitations though!. Jan 25, 2023
Debra D Blog: This Ode to Microsoft Excel, for Robert Burns Day, gives humorous "burns" to other spreadsheets. Jan 25, 2023
Contextures Blog: Can ChatGPT write Excel TEXTJOIN formulas? See my test results. Jan 19, 2023
Combine Text: Combine text and numbers from multiple cells with Excel TEXTJOIN function. 7 examples, basic to advanced Jan 18, 2023
Pivot Table Blog: Pivot table troubleshooting - see quick pop-up message with details. Jan 10, 2023
Play Games in Excel: When your work is done, enjoy playing games in Excel! Do you remember the old hidden games in Excel? Dec 14, 2022
XLOOKUP Function: Basic examples show how to get started with Excel XLOOKUP function, in Excel 365 and Excel 2021. Dec 7, 2022
Pivot Table Blog: How to fix pivot table headings with "(blank)" or remove "Sum of" in headings Dec 7, 2022
Contextures Blog: Use Excel macros to quickly create 12 monthly workbooks, with daily sheets, for the upcoming year. Dec 1, 2022
Contextures Blog: Excel for the holidays - planners, Advent calendars, Christmas trees, personalized messages. Nov 17, 2022
Skip Blanks: Avoid pasting blank cells over existing data with Excel Skip Blanks feature. Nov 9, 2022
Pivot Table Blog: Is it hotter than usual this November? Compare years with pivot table conditional formatting colour scale Nov 9, 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
Add Sheets Macro: Macro adds new worksheet automatically when file opens at start of month. Nov 1, 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
Last updated: March 29, 2023 11:44 AM