Excel – tips & tricks

 


We have several better tools for data analysis than Excel, but we will probably never eradicate Excel from our life.

Excel has it’s onw beauty. And it was cool in the ’90s 😊



Thanks for the LinkedIn community, I want to share some useful documents of MS Excel.


Let’s see the shortcuts firstly.


Another one in pdf:

Excel_Shortcuts

 

Some tips and tricks:

Excel tipd and tricks


Some useful functions (XLOOKUP, INDEX&MATCH, SUMIF, IFERROR, etc…)

10_EXCEL_FUNCTION_IN_DATA_ANALYSIS

 

Advanced formulas

Advanced_Excel_Formulas_and_Calculations


A long story…:

EXCEL_NOTES

 

Anoter long one for mazochistics:

Excel_Formula_Bible

 

Some VBA notes:

Excel_VBA_notes_for_professionals

 

Have fun! 😊


Comments

Post a Comment

Popular posts from this blog

SQL – hints & tips

Image
  This time, I collected documents in the theme of SQL. Sources are marked, where avaliable. All the material are downloaded from linkedin professional groups.   First of all, a detailed SQL handbook from Hans-Petter Halvorsen, also avaliable on https://www.halvorsen.blog SQL in detail   Another useful document. Unfortunately the source is unknown: SQL_basics   Another one from the internet (unknown source): SQL_notes   SQL interview Q&A from www.algotutor.io site: SQL_Quick_Revision_Notes_For_Interview   Another 80 interview questions from Aspersh Upadhyay ( https://www.linkedin.com/in/aspersh-upadhyay/ ) 80_sql_interview_questions   An SQL tutorial from www.tutorialspoint.com SQL Tutorial   A useful one from www.w3schools.com SQL_tutorial_w3schools   A must save document from HIMANSHU KUMAR https://www.linkedin.com/in/himanshukumarmahuri SQL_Must_Save_And_Share  
Read more

What makes data analysts’ work difficult?

Image
Nowadays, data analysis is a rather recruited field. There is a huge need for well-qualified proffesionals. No concidence, that many people want to break into this labor market as part of career-hack. And this is not a problem. Currentrly we are lack of well-qualified professionals, who can use Power BI, Tableau or SQL on an advanced level. And you are able to learn these softwares. It’s not brain surgery… If you are interested in these tools, I encourage you to learn them. In my previos post I have wrote about it: Self-learning, self-developement Now I want to write a little about the difficulties we encounter as a data analyst at daily work. During learning of a software (Power BI, SQL, Access, whatever…), you are always in an almost ideal environment. You can practice on a well-structured database, and you can try all the features with them. In real life, this is usually not the case. Let's have a look what obstacles we have to face.   Data inputs are coming fr
Read more