Becoming a Master of Excel

Excel has 6 Major skill components including VBA and DAX. For a data analyst, having ideas at all the mentioned levels would be beneficial. I have linked the free tutorials for mastering excel here.

 

Basic Excel:

Intermediate Funct: https://www.youtube.com/watch?v=KkTaQ5OjAGc&list=PLmHVyfmcRKyxYcARtENIf6zFf5OlsrEQN

Dynamic Arrays: https://www.youtube.com/watch?v=2USJsIyIzvo&list=PLmHVyfmcRKyyPFY31LldHWcJdLzGUPTSP

Advanced Funct: https://www.youtube.com/watch?v=F264FpBDX28&list=PLmHVyfmcRKyxvxehq3fiGjKDsEyy6d4Tz

Lookup Formulas: https://www.youtube.com/watch?v=E7gQ-PgYkMc&list=PLmHVyfmcRKyxpMnh_KKfAgp5DF9ydawmi

Excel Charts: https://www.youtube.com/watch?v=DAU0qqh_I-A&list=PLmHVyfmcRKyyEj7oQkCf7TL9yQQWXbGOQ

Chandoo Advanced Formulae: https://www.youtube.com/watch?v=Y3DEt7P62G8&list=PLmejDGrsgFyDUK8Q_CfZEtQvmRqV0UMm_ 

Chandoo Advanced Pivot Tables: https://www.youtube.com/watch?v=0HU8Hej6ong&list=PLmejDGrsgFyBH0zkiwAXsDLMMyGEO2hsx

Chandoo Smart Charts: https://www.youtube.com/watch?v=vK_PsW-RE-g&list=PLmejDGrsgFyBi4uTM0yTHZdw97cgg5Vnq

Excel Dashboarding:

1) https://www.youtube.com/watch?v=NZJXNw_rzTQ&list=PLmHVyfmcRKyz_4TwSfxzN_gsRtg3ODzyx

 2) Awesome Excel Dashboard by Chandoo: https://www.youtube.com/watch?v=pPpkYB9uG9A&list=PLmejDGrsgFyDN-HoP5wlkvq9zKbWM9KtT

3) The Office Lab: https://www.youtube.com/watch?v=20zDV9MNE0s&t=29s

4) Pk An excel expert: https://www.youtube.com/watch?v=qPJMrwtYSDc

5) Other levels: https://youtube.com/playlist?list=PLxuBYEpUjhDsVA2O1FTayFiYrDfoErdbx

6) https://www.youtube.com/watch?v=33Gsy9mmYOA

7) Chando: Easy Call center dashboard: https://www.youtube.com/watch?v=pPpkYB9uG9A

8) Data with decision: https://www.youtube.com/watch?v=xC3-lka89f8&list=PLwIcJx1aSL1S0208H1BQXmV0_O6HbuB2S&index=3

9) Datas with decision sales vs target: https://www.youtube.com/watch?v=tzR9XQCRnxw&list=PLwIcJx1aSL1S0208H1BQXmV0_O6HbuB2S

10)Week by Week Dashboard by Data with Decision: 

            https://www.youtube.com/watch?v=W8a218fMMQg&list=PLwIcJx1aSL1RPZOWpo_CGGWr-OA7SXnLH

            https://www.youtube.com/watch?v=qEPQgJ-8Qts&list=PLwIcJx1aSL1TURYqe6609iTbllD7h4DRT

            https://www.youtube.com/watch?v=NTyf3aG9Iu0&list=PLwIcJx1aSL1ShNoAl3c2XFdSdZN-Zggb9

Excel Power Pivot:

Excelisfun: https://www.youtube.com/watch?v=eIaKC6zLmb0&list=PLrRPvpgDmw0k_aIFiiIgRufZ8nmB6iyr-

Excel Power Query:

excelisfun: https://www.youtube.com/watch?v=FLzKnNmE4Ms&list=PLrRPvpgDmw0m3ohSvgwoHvd0KO8QsQdiK

Chandoo Power Query Tips and Tricks: https://www.youtube.com/watch?v=PiFAa_jjaEI&list=PLmejDGrsgFyBqyHBq4jqdUzobCo5BDKY2

Excel PowerBI:

Chandoo: https://www.youtube.com/watch?v=uwe8C7K8fXY&list=PLmejDGrsgFyClheDmsfikqOt0no-TKArs

Dax by Chandoo: https://www.youtube.com/watch?v=uwe8C7K8fXY&list=PLmejDGrsgFyClheDmsfikqOt0no-TKArs 

How to use powerbi DAX by Kavin Cookies: https://www.youtube.com/watch?v=waG_JhBgUpM

Excel VBA:  

VBA Leila Gharani: https://www.youtube.com/watch?v=8IreWUk1Al4&list=PLmHVyfmcRKyzmbDy6QoBuUDrU5D-jD-Se

Chando VBA examples and projects: https://www.youtube.com/watch?v=nerIcLV7a2s&list=PLmejDGrsgFyCcACC_FRUFc03XYf1Mxf9k

All in one courses:

Full Advanced Excel course: https://www.youtube.com/watch?v=5Qn3Ddvy9Uo&list=PLrRPvpgDmw0lcTfXZV1AYEkeslJJcWNKw

Excel is fun full advanced data analytics course: https://www.youtube.com/watch?v=iRuazQke6SY&list=PLrRPvpgDmw0ks5W7U5NmDCU2ydSnNZA_1

Data Analytics full course by Data with Decision: https://www.youtube.com/watch?v=mXHyNVaTaVo&list=PLwIcJx1aSL1QnQrYSmpra8jZbmhizfWkY

use the proxy site if any downloads are not loading: https://hide.me/en/proxy

 

DAX Formula incase you want to become a pro: 

https://www.youtube.com/watch?v=Rbkbr89cuHo&list=PLrRPvpgDmw0nglJ9yX2XT5-K1A_AKHpvW