This set of Oral questions on Excel Pivot Table will help both the Interviewer and the Interviewee (You). As I had already mentioned in 3 things to remember before you go for an Interview, always remember technical attitude matters more than the technical knowledge. Please do not take it as the only guide to crack the interviews, instead treat this as refresher before you go for interview. Inspite of a few shortcomings this is an excellent book to learn data analysis.Going with the belief that you are aware of or have working knowledge on Pivot Tables, I've prepared a set of questions which might help you in your upcoming Excel Interviews. The raw data was taken from Microsoft® Office Excel® 2007: Data Analysis and Business Modeling (Bpg - Other).
The complete journey to the solution and the result is described in the training video below (about 31 MB). He then uses the pivot table and pivot chart feature in Microsoft Excel step by step to find a solution. Based on the data that he has he is not able to decide. He realizes that he should sent the brochures only to travelers who really have a good travel budget. To be effective he wishes to target the right prospects. He has created lovely and quite expensive brochures which he wishes to mail to a target audience. Our example is about a manager working in a travel agency. The following training video demonstrates the creation of pivot tables to extract meaningful information from your Excel data. However, the good news is that the creation and destruction of the pivot tables takes seconds and therefore if you are not happy with the extracted information you can quickly create another view. Once this is decided you have a good chance of creating an excellent pivot table. The first question you must ask yourself is what would you like to display in your pivot table. Pivot tables help to analyze and summarize data.
0 kommentar(er)
