Where data analysis in Excel?
tech-support Where data analysis in Excel?

People who know how to use a spreadsheet or  Excel have one important skill to start building a professional path as a Data Analyst. Excel as SpreadSheet are a really powerful tools for data research but, where data analysis is in excel or Google SpreadSheet? For this answer we have to dive deeper on the math concept world: Notation. 

Notation is a common language used to communicate mathematical ideas. Think of notation as a universal language used by academic and industry professionals to convey mathematical ideas. 

You likely already know some notation. Plus, minus, multiply, division, and equal signs all have mathematical symbols that you are likely familiar with. Each of these symbols replaces an idea for how numbers interact with one another and have the following properties:

So, Hightly recommend to understand notation before learning Excel languages, and for sure Excel Languages are based on notation and has been in development for a very long time, and it supports a surprising amount of languages on its own as you can see: 

Excel Formula Language: While we don't think about it this way, excel formulas are a language.

Excel 4.0 Macro Language: Yes, it still works. Software companies don't remove old features due to backwards compatibility.

VBA: This is the language that Excel records your macros in. But its much more powerful than that. (There is a reason you will get a warning when a workbook contains macros! VBA can be used for much more than dialog boxes.)

M Language: This is the one the came in Excel 2016, under Get & Transform. It is used the language for data transformation. (You can look up “M is For Data Monkey” for a start.)