Excel Course on linkedin

 Have you ever tried this course on linkedin?

https://www.linkedin.com/learning/paths/master-microsoft-excel

Things to avoid in Data Visualisation

I have been preparing tons of visualizations, asking investigative question looking at billions of data every week, I believe following are the common data visualization mistakes:

Pies & donuts with too many segments:

Comparing angles are not something humans are excellent in. If you got too many segments, in that case, it is better to use bar or column charts instead.
 

Line charts for categorical comparisons:

Line charts should be used to show trends. Using them for categorical data (vs. time-series) is misleading, and can suggest relationships or patterns that don't exist.
 

Treemaps for non-hierarchical data:

Treemaps are designed to show hierarchies (like subcategories within categories). For simple categorical comparisons, use a bar or column chart instead.
 

Unsorted data:

Don't expect viewers to make their own visual comparisons. Use intuitive sorting rules to organize your data and tell a clear story.

Too much noise, too little focus:

Dashboards should clearly communicate the most important information, and often the best way to do this is by eliminating noise. While it's tempting to add that cool ribbon chart or 3-D effect, remember that CLARITY and INSIGHT are far more important than variety or visual appeal.

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