Greetings. I am a U.S. based Finance and Accounting Consultant and former Director of Finance and Strategy, I am a Certified Microsoft Excel Expert with over 15 years experience creating financial models.
I have held multiple leadership roles in the corporate and divisional levels in varied areas of financial planning and analysis (FP&A), including preparation of annual operating plans, daily/weekly/monthly reporting, forecasts, strategic planning, CAPEX planning, labor planning, operations improvement, and ad hoc analyses.
As a Microsoft Excel Expert I am well versed in macro creation/modification, graphing presentations (charts, trend lines, axis scales, multiple charts), formula building (SUMIF, SUMIFS, SUMPRODUCT, V-Lookup, H-Lookup, Arrays, Dynamic Named Ranges, etc.), conditional formatting, name definition and creation, hyperlink creation, data validation (dropdown list, and warning error message), filter (auto filter, advanced filter), data consolidation, subtotal, pivot tables, analytical tools such as Goal Seeker, tracing dependents, financial functions (PMT, FV, PV, NPV, RATE, and IRR), logical and nested functions (IF, AND, OR, and NOT functions in formulas), string, date, and time functions, statistical functions (MIN, MAX, MEDIAN, STDEV), worksheet sharing and protection, and customization of toolbars.
I look forward to discussing this project with you.