Learn Advanced Excel Formulas Power Query and Data Transformation Financial Modelling & Valuation Power Pivot and Data Modelling Excel VBA Automation Power BI Reporting for Finance Advanced Excel Charts Accounting Reporting
Advanced Excel Training
Skilled based and Focused Excel & Data Analytics Training
Latest in Excel Blogs
Blog posts covering Most useful Excel features
Unprotect Specific Worksheet while opening Workbook
This macro is an best way to protect users from accidentally closing their file before saving You can Force excel to save workbook before closing
Top Selling products
Excel or Google Sheets templates to increase productivity
What People Say about our Services and Products...
I have worked with Prashant with my crazy employee data report. I work in Payroll department and I had a unique problem with monthly payroll report. I found one of Prashant's product online and consulted him, he offered perfect solution using Power Query which is now saving me tons of time! Easy to with, thank you!
Prashant's Excel based products are amazing and saves tons of time. Prashant provides excellent support for any issue in using problem, he also solves specific issues with your data and using product! Highly recommended professional.
Compare Data Workbook product is real life saver for me. I had issue of comparing complex structured data every week and Prashant's product solved the problem and saved me hundreds of hours weekly, he provides excellent custom support!
I work in telecom industry and I am incharge of sales. I always had to compare complex data by row and then by cell each week to know exactly movements and track KPIs accurately. I bought Prashant's Compare Data workbook which saved me many hours of work and brought 100% accuracy in my analysis. Thank you!