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
Blogs
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
3D Filled Pyramids Chart in Excel
3D Filled Pyramids chart have been designed to display the KPI metrics like Sales Conversion, Service Level or any other KPI in percentage. You can display multiple categories on horizontal
Dynamic Sales Funnel Chart with Slicers
In this article you will learn how to create dynamic Sales Funnel Chart with Slicers. This Chart can be used in your business dashboard or presentations. Below are the data
Arrows Symbols (➷➹) with Custom Formatting in Excel
Custom formatting is very useful in Excel. You can display some Icon with colors with the numbers. Here we have taken an example wherein we have displayed designer up/down Arrows
Drill through in Power BI
In this article you will learn how use Drill through in Power BI. You can create a page in your report that focuses on a specific entity such as Supervisor