I will automate excel spreadsheets using vba, and formulas

5+ Years Professional Veteran in Microsoft Excel, Power Bi, and Google Sheets.

I am here to resolve the problems which pertain to Microsoft Excel and VBA.

This portfolio includes:

Customized Excel Spreadsheet

Dynamic Reports containing (Advanced Formulas, Functions, Power Pivot, DAX,

and graphical Visualization.

ETL and Custom Formatting, Data Modelling, Data Validations, and Controls.

Excel Auto Macros, Power Query Functions, Split and Merge Data.

Big Data Spreadsheet and Gantt Chart.

Visual basic code (VBA) expertise. 

Import Data (CSV, XLS, TEXT) - Export Reports (PDF)

EXCEL Formulas & Functions:

️Functions (Queries & Connections, Data Transformation, and Formatting & Fixing)

Power Pivot & DAX

Visualizations (Charts, Mapping, KPI, and Metrics)

️Selection Panel and Bookmarks

(XLOOKUP, INDEX, INDIRECT, MAP, LOGICS, SUMPRODUCT)

(JOINT, CONVERT, CALENDAR, COUNTS, SUMS, IFS, LEN)

(MATCH, SEARCH, CHOOSE, OFFSET, and More).

My service relies on the following:

Accuracy & fast delivery

Client satisfaction & projects training

Support after project completion.

Note: Every project is peculiar and unrevealed. 

Don't hesitate, contact me. Available 24/7

Thanks & Regards

Shan Y