My General Assistance include :
- Data Preparation
- Excel Graphs
- Excel Formulas & Functions
- Conditional Formatting
- Data Validation
- Pivot Tables & Charts
- Excel Dashboard
- VLOOKUP & HLOOKUP
- Financial reporting
- Financial management
My expertise related with advanced Excel features and topics include :
1. PivotTables and PivotCharts
2. Macros and VBA programming
3. Conditional Formatting and Data Validation
4. Advanced Formula and Function techniques (e.g. INDEX/MATCH, XLOOKUP)
5. Data Analysis and Visualization tools (e.g. Power BI, Power Query)
6. Advanced Charting and Graphing techniques
7. Data Modeling and Dashboard creation (including Excel dashboards)
8. Advanced Data Manipulation and Transformation techniques
9. Using Excel's advanced statistical and engineering functions
10. Automation and Integration with other tools and systems
11. Power Query and Power Pivot
12. DAX formulas and measures
13. Data Visualization and Storytelling techniques
14. Advanced Data Filtering and Grouping techniques
15. Excel Add-ins and Plug-ins (e.g. Solver, Analysis ToolPak)