Banner Image

Skills

  • Power Query
  • VBA
  • VBA Programming
  • Advance Excel
  • Cartography
  • Dashboard
  • Dashboard Design
  • DAX
  • Microsoft Excel Pivot Tables
  • Power BI
  • Power Pivot
  • Query Optimization
  • VBA Macros

Services

  • Power Map, DAX, Power Pivot, Power Query

    $8/hr Starting at $30 Ongoing

    Dedicated Resource

    • Power MAP, Power Query, Power Pivot, DAX Measures, Power BI, Tableau, jQuery, MySQL • VBA & Macro, API/JSON/XML, User Form, Login Form • Combined Multiple Excel Sheet, Data Cleaning, Advance Filter,...

    Advance ExcelCartographyDashboardDashboard DesignDAX

About

Hello,
I'm Md. Aquib Javed, Chartered Accountants (CA) from Bangladesh. Also Completed BSS in Economics, MSS in Economics, EMBA in Finance.
My Computer Experience is 14 Year's more with a good English background.

✅ Web Research & Web Scrap
• Python, Selenium, Pandas, BeautifulSoup, JavaScript, Anaconda, Conda, Web Scrap, PyCharm, Subline, Jupytar, Visual Studio (Web Scrap, Email Scrap, Data Mining, Product Scrap, Contact Scrap, Web Re-search etc.)

✅ Access Database
• VBA, Macro, MySQL, SQL, Queries, Table, User Form, Login Form, Relation, Report, Formulas, Database Development etc.

✅ Advanced Excel
• Power MAP, Power Query, Power Pivot, DAX Measures, Power BI, Tableau, jQuery, MySQL
• VBA & Macro, API/JSON/XML, User Form, Login Form
• Combined Multiple Excel Sheet, Data Cleaning, Advance Filter, Advanced Sort, Excel Invoice, Drop down, Conditional Formatting, Data Validation
• Forecast, VLOOKUP, HLOOKUP, LOOKUP, MATCH, INDEX, COUNTIFS, AVERAGEIFS, SUMIFS, IFERROR, NOT, AND, OR, Nested IF, Datedif, Find, Concatinate, Substitute, Left, Right, Mid, Array, PROPER, D COUNTA, ROUND, TRANSPOSE, DEV, ST DEV, IS REF, IS BLANK, UPPER, LOWER, MID, MIN, MAX, MEDIAN, COUNT with 150+ Nested Formula

✅ Dashboard, Graph & Chart
• Gantt Chart
• PERT Chart
• Column Chart
• Line Chart
• Pie Chart
• Doughnut Chart
• Bar Chart
• Area Chart
• XY (Scatter) Chart
• Bubble Chart
• Stock Chart
• Surface Chart
• Radar Chart
• Combo Chart

✅ Editable PDF & Design
• MS Visio Diagram Design
• PDF Editing (Same Font, Color)
• Text Fields
• Check Boxes (Tick, Circle, Cross, Diamond, Square, Star)
• Radio Buttons
• List of Choices (Drop-down Button)
• Print, Clear, Submit
• Save Buttons
• Image Fields
• Date Fields
• Digital Signatures
• Text Signatures (cursive font style)
• Barcode Field
• Encrypt forms with Password
• Calculations (Sum, Product, Minus, Average, Minimum, Maximum and others)
• Formatting and validations (Number, Percentage, Date, Time, Currency, Character limit and others)

Attachments (Click to Preview)