A very frustrating aspect of PivotTables is where you receive a message that Pivot Table group dates by month cannot group that selection. This also happens when you try other groupings.
The reason for this seems to be how Microsoft Excel sees the data.
For example if you have 999 cells that contain a valid Excel date, and only 1 cell that is a blank or a date that excel doesn’t recognise you will get the message that ‘Pivot Table group dates by month cannot group that selection’.
To get the PivotTable to perform the grouping you will need to change the problem cells to more acceptable entries. Change blanks to a zero or dates into Excel acceptable dates.
Dates are often a problem in PivotTables so we often recommend that clients create a new column in the underlying data that does any of the grouping they need and then pull through these grouped columns into the Pivot Table.
Ctrl END arrow versus CTRL arrow As a rule we prefer to navigate through a big spreadsheet using the CTRL and arrow buttons. If you are not aware of it, if you click on the first cell in a range, … Continue reading
Changing number labels in Pivot Tables When using Pivot Tables you may have a situation where you pull through numbers into the rows or columns i.e. changing number labels in Pivot Tables. For example you have a 5%, 10% and 15% … Continue reading
....As an example, the training in VLOOKUP had applicability in differing ways for each employee and they learned then and there how to use it in their own work. They left the training with clear expectations on improvement in their areas of responsibility...– Benefits of inhouse training- Health and Accident Underwriting Managers