Stephan
Member
Excel 2010, looks promising, at a glance Interactive/Dynamic Data Validation to display Dynamic Tables/Charts, looks like a simply solution to bespoke/custom Formula/VB edits.
How on use of Pivot Tables & Slicers, they are incoherent and useless, intentionally, not just to waste your time, to waste the rest of time, and get a newer version of Excel & see if it's any better!
Excel is for collating & summarising data, if Data Validation (Categories) and Dynamic Tables/Charts (Results) worked as intended via Pivot/Slicers then Office/XL2010 would have satisfactory. Because if PivotTableSlicers are what you do to get what you want in Results, then the concept id good, but the approach is obviously to appear uncoordinated, chaotic & clumsy, obvious rouses for more Mcse courses, add-ins, outsourced alternatives, and newer versions of Office, all of which wud be un-necessary if Data Validation was as simple & uncomplicated as it can be, perhaps it's better in Excel2013/16, if not will Excel 2020 be any better? Or does the annual subscription Office365 Data Validation does that even work? Of course all the Office Packages @ 1st glance appear Glossy, Professional & packed with features, but if you can't 'Summarise' concisely with it, then it's not worth upgrading from XL 2003, hence what use is it, not alot, but it does make a great converter from 2010 > 2003!
How on use of Pivot Tables & Slicers, they are incoherent and useless, intentionally, not just to waste your time, to waste the rest of time, and get a newer version of Excel & see if it's any better!
Excel is for collating & summarising data, if Data Validation (Categories) and Dynamic Tables/Charts (Results) worked as intended via Pivot/Slicers then Office/XL2010 would have satisfactory. Because if PivotTableSlicers are what you do to get what you want in Results, then the concept id good, but the approach is obviously to appear uncoordinated, chaotic & clumsy, obvious rouses for more Mcse courses, add-ins, outsourced alternatives, and newer versions of Office, all of which wud be un-necessary if Data Validation was as simple & uncomplicated as it can be, perhaps it's better in Excel2013/16, if not will Excel 2020 be any better? Or does the annual subscription Office365 Data Validation does that even work? Of course all the Office Packages @ 1st glance appear Glossy, Professional & packed with features, but if you can't 'Summarise' concisely with it, then it's not worth upgrading from XL 2003, hence what use is it, not alot, but it does make a great converter from 2010 > 2003!
Last edited: