Analyze Large Amounts of Data in Excel

How to analyze large amounts of data using power query and power pivot in Excel.

[@d20207]

This is so well explained. Finally I found a video that matches the title. There are other videos that start explaining the topic but then they beginning doing other shit that I dont need to learn. Thanks!

[@didzisstalidzans5232]

It's pretty impressive that excel can handle well so many rows. Interesting would be performance comparison between different connection types.

[@alexandreandrade7104]

Hi Sir, First, thanks for sharing. Is it works well with monthly refreshing? For example, adding data month by month... Thanks

[@tutsecret499]

Can we have the data file so we can practice. I need to know how I know I have low or sufficient memory in my computer and/or in my work computer.

[@nyc1bk1boy1]

Sir. You are a lifesaver !

[@Exceltrainingvideos]

Glad to hear that!

[@pacoriosports9182]

Very interesting...

[@Exceltrainingvideos]

Glad you think so!

[@deepakkumarsingh1381]

sir if I had done the Vlookup function and I got the yes and no value now I want only the yes value data and paste in new sheet with a single click of button for that can u give me Any reference video aur website Thank you

[@Exceltrainingvideos]

This link will help: kzbin.info/www/bejne/pJ6Yn5WYapdnqrc You can search this channel using 'vlookup' to find at least 10 videos on this topic.

[@deepakkumarsingh1381]

Thank you

[@TheLaopi]

Very interesting, where Can i fond thé csv files ?

[@Exceltrainingvideos]

You can find such files on the Net.

[@bezualemfisseha2119]

Thank you

[@Exceltrainingvideos]

You're welcome. Please share with your friends too.

[@danjarupath]

Cool

[@Exceltrainingvideos]

Thanks. Please share with your friends too.