Banner Image

All Services

Programming & Development Programming & Software

Microsoft Excel Developer

$15/hr Starting at $25

I am Suraj Kumar Lohani, an expert in Excel and Google Sheets with a comprehensive understanding of their features, functions, and capabilities. Whether you need assistance with basic data entry or advanced formulae and macros, I can help you harness the full potential of these tools.

 

With my expertise in data analysis and visualization, I specialize in transforming raw data into meaningful insights. Utilizing techniques such as pivot tables, conditional formatting, and trend analysis, I provide valuable information and present it effectively using visually appealing charts, graphs, and dashboards.

 

I develop tailored templates that meet your specific requirements. By leveraging the power of macros and scripting with integration of Power BI/Looker, Forms,  I automate repetitive tasks, saving you valuable time and effort. Now I take help from Chat GPT & Bard to create more complex Scripting/Coding.

With a solid background in accounting and finance, I possess a deep understanding of financial data, budgets, and reporting requirements. This enables me to provide industry-specific solutions that align with your unique needs.

 

I have successfully completed 200+ projects. These include the development of Payroll Software in Excel, automated financial statements, an MIS structure for my previous company, a versatile software for stock market requirements (running successfully as an App and an API called Tradesimply - Link: https://app.tradesimply.io/), as well as OKR/KPI analysis and an ERP System in Google Sheets using Forms and Looker. Furthermore, I am proud to have authored the book "Excel for Finance and Accounting" published by BPB Publications.

 

About

$15/hr Ongoing

Download Resume

I am Suraj Kumar Lohani, an expert in Excel and Google Sheets with a comprehensive understanding of their features, functions, and capabilities. Whether you need assistance with basic data entry or advanced formulae and macros, I can help you harness the full potential of these tools.

 

With my expertise in data analysis and visualization, I specialize in transforming raw data into meaningful insights. Utilizing techniques such as pivot tables, conditional formatting, and trend analysis, I provide valuable information and present it effectively using visually appealing charts, graphs, and dashboards.

 

I develop tailored templates that meet your specific requirements. By leveraging the power of macros and scripting with integration of Power BI/Looker, Forms,  I automate repetitive tasks, saving you valuable time and effort. Now I take help from Chat GPT & Bard to create more complex Scripting/Coding.

With a solid background in accounting and finance, I possess a deep understanding of financial data, budgets, and reporting requirements. This enables me to provide industry-specific solutions that align with your unique needs.

 

I have successfully completed 200+ projects. These include the development of Payroll Software in Excel, automated financial statements, an MIS structure for my previous company, a versatile software for stock market requirements (running successfully as an App and an API called Tradesimply - Link: https://app.tradesimply.io/), as well as OKR/KPI analysis and an ERP System in Google Sheets using Forms and Looker. Furthermore, I am proud to have authored the book "Excel for Finance and Accounting" published by BPB Publications.

 

Skills & Expertise

AccountingBook WritingData EntryData ExtractionData ManagementFinancial ServicesMicrosoft

0 Reviews

This Freelancer has not received any feedback.