I will make excel graphs charts pivot tables and complex dashboard

Do you need to import data from the Web, or multiple sources and clean, merge, combine and transform it into usage format in Excel or Pivot Table or Power Query?

You are in the right place with a PhD, certified accountant, data analyst and financial expert with over 18 years of experience. I will provide you with Excel Spreadsheets to help you transform your data in the required shape, ready for analytics.

I have a vast knowledge of Excel functions such as statistical, mathematical, date and time, logical, string, and dynamic array.

• Financial modelling
• Seasonality models.  
• Transform CSV into Excel files
• Analyze clicks and impressions from the website
• Transform your data.
• Removal of duplicate.
• Arranging raw data in Excel using pivot tables and graphs.
• Create Sales Tracker Sheets & Monthly Reports.
• Arrange customer's Emails for a usable format.
• Visualization of Report using Slice
• VLOOKUP and HLOOKUP to solve complex issues
• Combining or merging multiple files
• Conditional Formatting
• Formulas/Advance Filter
• Vlookup / Hlookup
• Countif / Countifs
• Sumif / Sumifs
• Data Validation

Please contact me before placing an order. 100% client satisfaction is my priority.