Hi there,
Formulas make Excel smart. Without them, Excel is just a data keeping tool. But by using formulas, you can crunch data, analyze it and get answers to most complex questions.
While anyone can use a simple SUM or IF formula, an advanced user of it would be able to seamlessly write & combine formulas like SUMIFS, SUMPRODUCT, INDEX, MATCH, LOOKUP formulas. Apart from knowing the formulas, advanced Excel users know how to debug them, audit them and how to use which formula for which occasion
I know how to gather, structure & present their data so that it looks impressive. I have good understanding of Excel features like Power Query (Get & Transform Data), Tables, cell styles, formatting options is necessary to make awesome Excel workbooks.
I have following skills in Excel
- Data, Power Query, Tables & Formatting
- Conditional Formatting
- Advanced Charting
- Pivot Tables & Pivot Reporting
- VBA & Macros
- Using Excel Productively
- Data Tables, Simulations & Solver
- Integrating Excel with other tools & Optimizing Excel
Looking forward to talk with you.
Thank You
Muhammad Asfaqul Islam