PKComments Off on Spotlight Visualization in Excel (Part-1)
This is the first part of Spotlight visualization in excel Here we have used RAG (Red, Amber and Green) color code to display metric performance like – Service Level, Quality Score
PKComments Off on VBA User form for Segregate data into multiple worksheets
Many times, we require to segregate our data into different worksheets. Here we have created a VBA User form which can segregate your data into worksheets. One user from will
PKComments Off on Login Form for Excel VBA based Application
Login Form is very important for any application. We have designed this Login form in VBA User form and connected with MS Access Database. We have used ADODB Connection to
PKComments Off on Custom Visual: Liquid Fill Gauge in Power BI
Liquid Fill Gauge is very beautiful Custom visual for Power BI. You can use this chart to display metrics like – Service Level, Quality Score, Sales conversion etc. You can
You can create very attracting info-graphics with the help of Auto shapes. Here we are giving an example of this. We have created stylish and beautiful Traffic lights in Excel.
PKComments Off on PDF to Word Converter Macro in Excel VBA
In this article we will tell how you can develop your own PDF to Word converter using Excel VBA. You can convert multiple files using this macro. Keep all your
Keyboard Shortcut Keys can improve your productivity. In this article we will tell you 33 useful VBA shortcut keys. If you are a VBA developer or work on VBA frequently
PKComments Off on Stylish Pivot Chart with Slicer in Excel
We are back with one more stylish chart but this time we have used a pivot chart and connected it with a slicer. We have displayed employee wise sales on
PKComments Off on Design, Publish and Share a Sales Dashboard in Power BI
Microsoft Power BI is very powerful tool to analyze and visualize data. It is very easy to access. We have developed the Sales Dashboard in Power BI with some dummy data points.
This website uses cookies to improve your user experience, analyze site traffic and serve targeted ads in accordance with our Privacy PolicyACCEPT
Privacy & Cookies Policy
Privacy Overview
This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.