An Excel Expert and Data Transformation Enthusiast
And Chartered Accountant
Hey, I am Prashant Panchal. I like helping fellow Accountants, Auditors and Analysts to become PRO at using Microsoft Excel.
I have been using Excel mainly for Accounting and Analytics for more than 15 years, and I am enthusiastic about sharing my knowledge with fellow Accountants, Analysts, or Excel users.
I have encountered many reporting and analytics challenges during my career, and I resolved the same using a good old Microsoft Excel Spreadsheet application.
You will find Basic to Advanced Excel formulas and Functions, Tips and Tricks, and Excel VBA ready-to-use codes with me.
I am most excited to share Modern Excel Tools training and its basics to make your life easier as an Accountant or Analyst for Data cleaning and Report Automation.
With the Techniques I have acquired using Excel for so many years, I am pretty sure I can reduce your routine workflow (time and effort) to half or even more.
While I love traditional formulas and functions, Pivot tables and Excel VBA, I feel it’s time to go beyond and discover Microsoft’s amazing Power Tools.
These tools include Power Query for Excel (Get and Transform) and DAX Formulas Engine with Excel Power Pivot.
Don’t worry if you have not heard about these tools; you will learn about them in detail (basics to advanced) with me without any pain!
My Speciality lies in Data Analytics and ETL (Extract, Transform and Load)
While formulas, Functions, and Excel VBA can automate reporting and calculations for your projects, there is nothing better than Power Query when dealing with repetitive tasks.
So I am a big proponent of Automation of Data and reporting: Source data to Reporting with minimum manual steps involved with 100% Accuracy of Output reports.
By the way, I am a Chartered Accountant by Qualification and well-versed in hands-on Corporate Financial Accounting and Reporting for diversified industries.
So don’t worry. You are in good hands and a trusted source for your Excel problems and have become an Excel superuser.