Find everything that which you would need to become an Excel Maverick, here on this Blog. Learn by reading the blogs and articles, follow the official YouTube Blog channel – watching and executing workbook lessons step-by-step. We’ve got something for all excel enthusiasts.
About
Excel Maverick is an endeavor for putting together resources of learning for people who are enthusiastic about Excel. Premal who has a background in accounting and auditing, with experience working for Information Technology organizations for more than 20 years, has been passionate about data analysis and loves working with Excel. Throughout his career, he has continued to build upon his knowledge of Excel, and his love for excel has only grown.
Premal is also a youtuber, and has created a YouTube Channel again with the objective of creating and sharing Learning resources via videos.
https://www.youtube.com/channel/UCpI34FLekxxq8P-0J7qEehw?view_as=public
Don’t forget to visit the Youtube Channel as well.
Happy Learning !!
Blog
Data Table What-If Analysis in Excel
Using What-if analysis is performing Sensitivity analysis using excel on a set of data, where we want to see a range of possible outcomes based on certain changing parameter values. This analysis allows a decision maker to take more informed decisions. There are three different tools available in Excel to perform what-if analysis: Scenarios, Data …
Passing parameters to queries in Power Query
Wouldn’t it be nice to have a complex Power Query accept values from users as arguments, and wouldn’t it be more usable if we could provide a way to give these users a dropdown list for each of the argument in the Power query, where they can choose the allowed parameter values which they are …
Continue reading “Passing parameters to queries in Power Query”
Pivot with Text
Gone are the days when you could pivot only with numbers!! Yes, with newer functionalities in Excel you can do pivoting with text as well. In this article, we will ponder upon how to make use of Pivot table to display text values. Pivot tables have been excellent, mainly for summarizing numbers. But, when it …
Contact
Just use the form below to get in touch with regarding any questions, templates and custom services.