
Abhishek Konda
290 posts

Abhishek Konda
@AddictAnalytics
No Offence to Oxygen, but I live bcoz of Data.









stop wasting months learning excel you just need to know these highly important 16 excel topics because these are the only topics that legit helps to move the needle and you'll definitely use them in your real life just focus on these 16 topics: → power query: (most important topic to focus or be ready to regret) → text to columns: super helpful in cleaning the real world messy data → conditional formatting: use it when you have 100 data points but only need to highlight the imp ones → data visualization: the most interesting part for the stakeholder to see the trends of business → slicer: data viz without slicer is of no use → pivot tables: summarize the entire dataset & take out the insights in just a few clicks → descriptive statistics formulas: understand your data before even deep diving into it → data validation: best way to avoid the errors entering into the data by assigning the limits → text based formulas: real world data is always very dirty & this where they'll help you a lot → logic based formulas: to fulfill the stakeholder's requirements, you'll definitely require some logic → aggregation formulas: they'll help you to play with numbers and easily summarize them → date & time formulas: very helpful for creating weekly, monthly or other time based reports → remove duplicates: real world data always has the same looking like data → tables: to keep everything dynamic → types of errors & handling: one should know the reason behind every error & how to handle them → macros: to automate all your manual tasks so you can chill at your work without letting them know this might sound a lot but to be honest, in just 2 weeks you can learn all these topics easily below i'm dropping all the formulas name as well so you better know where to focus












