Importing Data from Excel into QlikView

In this video I've discussed about how can we import the data in QlikView. I've shown different types of setting to import the data correctly. Why and how to change the column names is discussed and after that in the end we've discussed how to open the Table Viewer window to view the imported table. List of other QlikView tutorials How to calculate average value in QlikView - https://www.youtube.com/watch?v=arERnJrEob0 Hot to calculate standard deviation in QlikView - https://www.youtube.com/watch?v=2MJWaFxBF7o Empirical rule in QlikView - https://www.youtube.com/watch?v=PAPtnugnAv4 Case study of average and variation of data in QlikView - https://www.youtube.com/watch?v=LithVdvaGvw How to calculate skewness in QlikView - https://www.youtube.com/watch?v=aIV_oGAN_vQ How to create box and whisker plot in QlikView - https://www.youtube.com/watch?v=euy7YSDIr48 How to calculate correlation and covariance in QlikView - https://www.youtube.com/watch?v=gPahztV2URw Correlation case study in QlikView - https://www.youtube.com/watch?v=lI2Uh9W4VJA How to learn a business intelligence tool - https://www.youtube.com/watch?v=uwDRqBbB4jQ&t=1s 7 Habits of highly effective qlikview developers - https://www.youtube.com/watch?v=6KVsTKMBc94&t=2s What are the QlikView advance features and functions - https://www.youtube.com/watch?v=rN3PMePHvaE How to use only function in QlikView - https://www.youtube.com/watch?v=vPBSYklRi6Q How to use interval match function in QlikView - https://www.youtube.com/watch?v=tKN99DdwoQE How to tackle slowly changing dimensions in QlikView - https://www.youtube.com/watch?v=mgHUWdrwR7M&t=25s How to do resident load in Qlikview - https://www.youtube.com/watch?v=oWFWUL69elI&t=138s How to do incremental load in QlikView - https://www.youtube.com/watch?v=veMG0eFcy3k How to create hierarchies in QlikView - https://www.youtube.com/watch?v=dTQo0qWwpH8 How to do text to columns in QlikView - https://www.youtube.com/watch?v=m5h70rj629g How to conditionally show and hide objects in QlikView - https://www.youtube.com/watch?v=7mrZQvbN0_U How to calculate rolling total for n period in qlikview - https://www.youtube.com/watch?v=6FQ9-8RTuWs How to auto minimize in QlikView - https://www.youtube.com/watch?v=wAuz535H1DQ&t=95s How to use hierarchy belongs to function in QlikView - https://www.youtube.com/watch?v=A_YlO2RkBA0 What are information density and subset ratio in QlikView - https://www.youtube.com/watch?v=d6QVv5X1TqA How to do sorting in QlikView - https://www.youtube.com/watch?v=gAclWckkS_Y How to do custom sorting in QlikView - https://www.youtube.com/watch?v=nbsIZPcHVUo&t=73s How to import Microsoft Access Data in QlikView - https://youtu.be/Pf9lbejrBQQ How to create polynomial trend lines in QlikView - https://www.youtube.com/watch?v=SMJpJSgOPak How to use mixmatch function in QlikView - https://www.youtube.com/watch?v=FsqcQ7mw-yc How to use wildmatch function in QlikView - https://www.youtube.com/watch?v=FsqcQ7mw-yc How to calculate efficiently in QlikView using Pick and Match function - https://www.youtube.com/watch?v=HIBNf0YY0jY What is hypothesis testing in QlikView - https://www.youtube.com/watch?v=mcso_xivnv0 How to open a URL from QlikView application - https://www.youtube.com/watch?v=I1LZa4cZojA How to change currency symbols in QlikView - https://www.youtube.com/watch?v=tgF5cMjZbFg How to use HRank or Vrank function in QlikView - https://www.youtube.com/watch?v=DGGuAQfI-yc&t=2s How to do chi square test in QlikView - https://www.youtube.com/watch?v=YDLmjP9ZjUw How to do one sample T test in QlikView - https://www.youtube.com/watch?v=Ps5aoplXqvM How to do paired samples T Test in QlikView - https://www.youtube.com/watch?v=MBFeMOLK1I0&t=4s How to do independent samples T Test in QlikView - https://www.youtube.com/watch?v=PXEAXkinbhU How to create comma separate list values from QlikView field value - https://www.youtube.com/watch?v=WfpNEfetLl0