Excel 2024: How to Provide Usable Feedback to the Excel Team

September 19, 2024 - by Bill Jelen

If you encounter a bug in Excel, here is the best way to get it fixed quickly. On the Help tab in the Ribbon, choose the Feedback icon. This opens a Feedback pane on the right side. Follow all of these steps:

1. Choose "Report a Problem". No one reads the "Send a Compliment" submissions.

2. Type a description of the problem.

3. Choose "Include Screenshot"

4. Choose "You can contact me about this feedback" and provide an e-mail address.

More Reading

Excel 2024: Many Task Panes Now Collapse into a Tab Strip »

September 16, 2024 - by Bill Jelen

There are several features in Excel that open a task pane on the right side of Excel. Sometimes, you would end up with 2, 3, or even 4 task panes open and it would cover your entire screen.

Excel 2024: Number the Visible Rows in a Filtered Data Set »

September 10, 2024 - by Bill Jelen

You've applied a filter to a data set and would like to number the visible rows. Two functions that can ignore rows hidden by a filter are SUBTOTAL and AGGREGATE. The key to this solution is to use the COUNTA version of SUBTOTAL for every cell from the Heading row to the current row.

Excel 2024: Use A2:INDEX() as a Non-Volatile OFFSET »

September 6, 2024 - by Bill Jelen

There is a flexible function called OFFSET. It can point to a different-sized range that is calculated on-the-fly.

MrExcel 2024 Igniting Excel

February 2024

This is the 7th edition of MrExcel XL. Updates for 2024 include: Remove Filter Items Using Search Box, The Consolas Font Makes it Easy to Tell Zero from the Letter O, Display Online Pictures In a Cell Using a Formula, Place Pictures In Cell From Local Computer, Using Artificial Intelligence with Copilot for Excel, and more...

Cool Excel Sh*t

March 2021

Cool Excel Sh*t is designed with the Excel guru in mind, introducing advanced, creative solutions and hacks for the software's most challenging problems.

MrExcel 2021 - Unmasking Excel

February 2021

This is a 5th edition of MrExcel XL. Updates for 2021 include: LAMBDA, LET, Power Query Fuzzy Match, Sort & Filter in Sheet View, Cut-out people, Save object as image, STOCKHISTORY, Wolfram Alpha Data Types, Custom Data Types from Power Query, Weather data types, bilingual spreadsheets, Performance improvements, Unhide multiple worksheets, Action pen, Collapsible task panes, LET function to re-use calculations, store formulas using LAMBDA, Recursive LAMBDA, Branching LAMBDA, Lambda to return a picture, Excel function quick reference.

Financial Modelling in Power BI

September 2022

The only book to produce all three financial statements in Power BI.

see more products »

Excel 2024: How to Provide Usable Feedback to the Excel Team

More Reading

Featured Products