Here is the latest news about Microsoft Excel, and updates on the Contextures website and blogs.
Pivot Table Blog: Analyze sales data with Pivot Table Top 10 filters. Change settings on worksheet, macro changes multiple pivot table filters automatically. Apr 7, 2021
Contextures Blog: How to fix Excel error, Cannot Shift Objects Off Sheet or Can't push objects off sheet. Simple shortcut, or make small change to comments. Apr 1, 2021
Conditional Formatting: Use Excel conditional formatting to automatically change currency symbol in worksheet numbers, based on country name selected. Mar 31, 2021
Data Validation: Use simple data validation rules to limit budget entry amounts that can be entered in Excel budget plan. Video, written steps, free Excel workbook Mar 23, 2921
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 change the number format in a pivot chart, either on its own, or with the pivot table's number format.
See the details, and get the sample workbook on the Pivot Chart Format page.
Contextures Blog: Quickly create PowerPoint slides from data in Excel list, using these macros. Mar 18, 2021
Excel Error: See how to fix the Excel Errors, Cannot Shift Objects Off Sheet or Can't push objects off sheet. Use a simple keyboard shortcut, or make a small change to the comment settings. Video, written steps. Mar 16, 2021
Pivot Table Blog: Show differences between pivot table amounts without formulas. Use this built-in Excel feature. Mar 10, 2021
Contextures Blog: Keep Excel IF formulas short & simple! Do you have IF formula horror stories? Mar 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: April 7, 2021 11:30 AM
Contextures RSS Feed