Banner Image

All Services

Programming & Development

Excel and Data Visualisation Expert

$13/hr Starting at $25

I have around 16 years of experience in software development and management. I have worked extensively on Microsoft Excel, automating processes using VBA, and performing data analysis/management for various organizations. I have experience in Google spreadsheets and data visualization. I am currently doing freelance as part-time. I have specialization in the following areas: • Building Advanced Excel Spreadsheets & Dashboard Reports. • Data Cleansing, Analysis, Reconciliation of Complex & Large Data Sets • Management & Performance Reporting • Graph, Charts, Tables, Pivot Tables And Pivot Charts Generation • Automation Of Spreadsheet Reports Using Advanced Functions • Expert In Vlookup, Hlookup, If, And, Or, Index/Match, Sumif(S), • Countif(S), Trim, Len, Concatenate, Mid Etc • Data Validation,Conditional Formatting,Consolidation • Vba (Excel Macros) • Financial Reporting In Excel • Google Spreadsheet Reporting • Data Extraction From Website To Excel • VBA based Excel Applications • Data Visualization • Visio - Diagrams • Microsoft Project Plan - Handling multiple projects in one MPP • Centralized resource pool management - MPP

About

$13/hr Ongoing

Download Resume

I have around 16 years of experience in software development and management. I have worked extensively on Microsoft Excel, automating processes using VBA, and performing data analysis/management for various organizations. I have experience in Google spreadsheets and data visualization. I am currently doing freelance as part-time. I have specialization in the following areas: • Building Advanced Excel Spreadsheets & Dashboard Reports. • Data Cleansing, Analysis, Reconciliation of Complex & Large Data Sets • Management & Performance Reporting • Graph, Charts, Tables, Pivot Tables And Pivot Charts Generation • Automation Of Spreadsheet Reports Using Advanced Functions • Expert In Vlookup, Hlookup, If, And, Or, Index/Match, Sumif(S), • Countif(S), Trim, Len, Concatenate, Mid Etc • Data Validation,Conditional Formatting,Consolidation • Vba (Excel Macros) • Financial Reporting In Excel • Google Spreadsheet Reporting • Data Extraction From Website To Excel • VBA based Excel Applications • Data Visualization • Visio - Diagrams • Microsoft Project Plan - Handling multiple projects in one MPP • Centralized resource pool management - MPP

Skills & Expertise

Account ReconciliationDashboard DesignData ManagementData VisualizationFinancial AnalysisGoogleGraphsManagementMicrosoftMicrosoft ExcelMicrosoft Excel Pivot TablesMicrosoft VisioPerformance EngineeringPlanningProcess DesignReport WritingReportsSoftware DevelopmentSpreadsheetsTable DesignVBAVisualisationWeb Design

Related Work Collections

0 Reviews

This Freelancer has not received any feedback.