Dear sir,
I’m very very specialized in excel formulas and teaching. I have made hard exercises for people that need advanced understanding of
- Complex multi-condition Index/match formulas
- Formulas in pivot tables, in number formats, in graph axis colors, in conditional formatting, and in dropdown menus.
- Array-like formulas, that are equivalent to VBA loops. Like “sum of squares of values in a range”, or “min in column A for values when the text in column B is present in text column C”.
- Size reduction for big data files
- Time reduction for files with too many calculations
- efficiency shortcuts (98% of times, I don’t even touch the mouse in Excel)
1- Experience Excel : since 2004 both VBA and Formulas. I can make very complex formulas with multi conditions and text search applied on big ranges of data.
2- Experience in Word : I can make macros in Word that are executed from Excel inputs, create models with pre-existing zones so that Excel can paste data, export visuals to emails etc.
3- Academics : I graduated a Master in computer science and mechanical engineering from the top French Engineering school and this can be publicly verified.