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.