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
Blogs
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
Stylish Traffic Lights in Excel
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.
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
33 Useful VBA Shortcut Keys
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
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
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.
RAG (Red, Amber and Green) Analysis Chart in Excel
RAG (Red, Amber and Green) Analysis Chart in Excel is very useful to analyze the performance. We have designed this chart using Stacked column chart and Line chart. You can
Protect Excel Worksheet as UserInterFaceOnly
Just assume you a worksheet wherein you have few groups for column or rows and then you Protect Excel Worksheet that worksheet. Now will you be able to expand or
3D Container Pivot Chart with Slicer and Timeline
This time I am back with a beautiful 3D container Pivot Chart with the slicers and Timeline. We have displayed the sales conversion by Zone on the chart. We have