HTC 8525 - Best mobile ever

Best mobile ever

Social Media Revolution

This video is good to explain the social media revolution.

Best Video on User Experience Design - Google

This is the best video that i feel on user experience design. Enjoy!

Essential Tabs in excel Reports

In my job, there are multiple calls weekly with the stakeholders. The most common agenda in the con calls are report discussion and various tasks progress. I have been looking at different excel reports, and i can sense the reports are extracted from huge bigger excel sheets with a lot of raw data.

The whole idea of this blog, it to make you aware that in any report you send to the customer there should be these 3 tabs in the excel, without which you will make the report less impactful. One more important thing it to include the name of the parameters in X & Y axis. The report should be easy to understand by its audience.

hyenalabs_excel_tab



The key tabs, that are essential are

Tab 1. Methodology - this tab should have the assumption/hypothesis along with the step by step description of the steps that were taken to generate the report.

Tab 2. Findings -this excel tab should have the Findings and Inference of the report. A good suggestive graphs should be there to make the audience understand the reports.

Tab 3. Comparison - this tab should show the actual numbers that were used to generate the graphs.

I hope that these 3 tabs you will always include in your reports.

Manager's please learn PIVOT in excel

Some days back, i got a huge excel sheet with many columns and rows of data. The program manager in US requested analysis of the excel sheet and come up with a methodology. I went to the SDM(Service delivery manager) and had a word with him. I learned some cool tricks in excel that i am eager to share with you all. I feel that all mangers should give a try to learn PIVOT in excel.

pivot 3

 

I will highlight how to work with pivot.

Step 1: Open the excel sheet on which you want to work on.

Step 2: Select all the data from the excel.

Step 3: Open INSERT tab, and click on PIVOT.Click on “insert” tab and select “Pivot table”. The path will be

Insert >> Pivot Table >> Pivot Table.Create PivotTable pop up screen will be displayed as shown in the screen capture below. Click on the OK button.pivot

Step 4: Another sheet will be displayed, as shown below. Pivot table field list will be also present on the right hand side of the window. Select the column that you want to sort out. 

pivot 3 

Step 5:Similarly select other two parameters. We can adjust the placement of these parameters in the 4 boxes that is present in the top screen. Drag and drop the parameters to generate the report.

I think this is a small step towards PIVOT in excel. Move on with PIVOT, it is really helpful to prepare and analyze data.