For example, a single excel for all teachers in a school could include sheets with schedules for each day of the week, responsibilities/guidelines/priorities, student directories by grade, etc. If I could group the sheets for schedules together, or student directories of all grades, that would help organize the space.

For example, a single excel for all teachers in a school could include sheets with schedules for each day of the week, responsibilities/guidelines/priorities, student directories by grade, etc. If I could group the sheets for schedules together, or student directories of all grades, that would help organize the space.

An underlay behind the fliter menu to show the count of each value in the filter menu for that column.
This will give users a good indication of the impact of that value. In a second phase, hovering over the value could give a tool tip with the count or make the count show up on the right hand side of the filter menu.

Create step by step user tutorial for pivot tables.

The Autofilter shortcut is an available button in the Windows version that you can bring into the Quick Access Toolbar or ribbon. Select a cell and click the Autofilter button -> the selection is then automatically filtered by the selected cell. Currently, we have to navigate a long-winded context menu path. This would be a real time saver for all those working with reams of data in tables.

Wfhen applying a filter, it is currently not possible to copy and paste information without getting an error message

When setting a table The “Forms” option is no longer available. Strangely enough that was one of the reasons I purchased 360.

It is annoying to have to unprotect a worksheet each time you need to open or close a group.

When protecting a worksheet, have a tick option to permit this or not.

Allow Mac users to create tables, graphs, and charts as easy as on Windows.

Mac and Windows applicable.
Remember the size of the filter menu that drops down from the filter twisty with filters on.
Thanks.

Create a one-click option to sort tabs/sheets within one workbook the same way you can sort data within your worksheet cells.

I would like the ability to drag-and-drop rows and columns to re-order them. Google Sheets has this ability and I use it all the time. In excel if I want to move a row or column to re-order it, I need to use copy/paste and insert. It's a pain. If I'm viewing a list of items which I want to put into priority order, it is very difficult to do this in Excel. Whereas in Google Sheets, I can just drag and drop the rows to re-order them very easily.

When filtering the pivot tables or excel tables, we the Mac users aren't allowed to use custom filter and that can be frustrating when we need to filter out names from A to N, but as the row is categorised as "Texts", we do not get to use filters like "Greater than or equals to" which is only for "Numbers" category. Need this to be included soon.

This is the behavior which is not in Mac or does not have an alternative, the only way is using the mouse click.
Working with filters, when the filter is applied to a column and the drop down menu is active,
When an item is selected, pressing the space bar will check/uncheck the check box.  Then press Enter to apply the filter.

Allow a table that has a filtered range to be expanded.

On a table that's filtered, when you hit the little filter drop down arrow the cursor should immediately go to the search box in the drop down, rather than having to click it again. As you've just hit the dropdown you obviously want to filter and as that's the only field you can type in while filtering it should go there automatically

Please provide the Find all button on the Mac version