pivotronics

Tag: trick

• Spreadsheets

  

  A magical Excel trick for flattening data copied from a PivotTable report in tabular layout into usable format

  Here is a scenario that I come across sometime ago when I received an Excel file with some apparently messy data for further processing to generate another report. The data in the file appear similar to below screenshot. This data is self-explanatory. It’s the sales in units and dollars of…

  January 5, 2017
• Spreadsheets

  A quick trick to create in-cell charts in Excel

  Here I share a tricky way to create in-cell charts in Excel with an example. Below is the data of a few employees and the respective volume of requests completed by them. Now enter the below formula in cell C2 and copy it till C8. =REPT(“n”, B2/50)      …

  July 29, 2013