With over 10 years experience in investment banking, specialising in leverage finance and data analytics, i am well versed in financial reporting and, as certified as an excel "specialist", I can perform a broad range of activities in Excel (Windows and Mac). Such activities include the re-formatting, formulation, analysis and presentation of data using the below techniques to name a few: Dashboards Advanced formulation of data (INDEX, MATCH, VLOOKUP, CONCATENATION, nested IF formulas etc) Save and export Excel into different formats Protect workbooks and worksheets Import and export XML and CSV files Work with Vlookup and Hlookup functions Filter and subtotal lists Work with named cells and ranges Use validation in a spreadsheet Perform data analysis Look up prices or products based on IDs or dates Create advanced charts Create advanced Pivot Table Create charts with trend lines Understand more complex spreadsheets Use conditional formatting to highlight key data Share workbooks with other users