Microsoft Excel / Excel Modelling
Experience: 8 years
I am an experienced professional in the financial sector.
I can explain you the most important excel functionalities.
I can also design spreadsheets / dashboards / templates excel models
I have experience in the development of analytical tools with Excel and VBA and I use excel daily.
Feel free to contact me for any further query
Some of the topics usually requested:
- functions: SUMIF, COUNTIF, MAX, MIN, AVERAGE, CONCATENATE, LEFT, VLOOKUP, HLOOKUP, INDEX, MATCH, CHOOSE, OFFSET, LEFT, TODAY,
- import data from external source, WEB, txt, other files
- formula auditing, name manager,
- data validation, conditional formatting
- pivot tables
- basic VBA
- excel modelling