Advanced data analysis using pivot tables, Power Query, and advanced Excel functions.
Use of complex formulas (INDEX, MATCH, XLOOKUP, logical and text functions).
Automation of reports and recurring processes.
Design of executive dashboards with key performance indicators (KPIs).
Optimization and control of large datasets.... Lee más