You may have come across this problem while you were trying to align everything centrally, but numbers don’t go to center. All other formats like date, text and account can be centrally aligned but once you change them to numbers with comma style, the format goes out of toss. I remember one conversation between one of my colleagues and his manager about formatting. The manager wanted everything in the table centrally aligned and my colleague was trying to explain, it was impossible. Both tried all tricks and finally, the manager had to agree with him. Today, I found one hack which helps to overcome this challenge. Continue reading How to align or format numbers centrally in Microsoft Excel table– TopBullets.com
You may have come across this problem while you were trying to align everything centrally, but numbers don’t go to center. All other formats like date, text and account can be centrally aligned but once you change them to numbers with comma style, the format goes out of toss. I remember one conversation between one of my colleagues and his manager about formatting. The manager wanted everything in the table centrally aligned and my colleague was trying to explain, it was impossible. Both tried all tricks and finally, the manager had to agree with him. Today, I found one hack which helps to overcome this challenge. Continue reading 
I have never understood why Microsoft office is so costly. It hardly provides 8-10 software in the package while the entire operating system is much cheaper which hosts the entire set of the system. Typically, Microsoft office costs around 300-400 INR (5-6 USD) monthly to 4500 INR yearly which is a hell lot of money. As being a cost-sensitive person, I always prefer to go with trial or open source software. But as being a professional you need to depend on Microsoft Excel and PowerPoint a lot if not other software and for that, I was looking for a solution from last few months. I tried a lot to find suitable open source and ways to crack the office but it didn’t work. Once trying to get keygen I unknowingly installed a malware and had to format my PC. So, I didn’t want to take any further risk and finally found a way to install licensed and genuine MS office. 
In Data Science visualization is a powerful tool. You can’t sell a concept but a product. Data analytics is science but presenting them through different graphs and charts is an art. We have many ways to present the numbers and a lot of software which make our life easy. Few of them which I have tried are Tableau, R Shiny, D3, QlikView and VBA Dashboard. Every tool has its own advantages and properties. Currently, I am working on R Shiny dashboard which is so beautiful and easy to learn. I would really encourage you to learn R Shiny if you do coding in R. It has a lot of in-built packages which can easily be deployed. Today let’s work on cascading filters one of the most important kinds of filters. Every other filter is connected to the predecessor filter. 
Today I got a challenge to provide a new function in Excel dashboard. I am not an expert in VBA and have very less experience but it’s fun doing coding in VBA. It makes excel function so simpler that I really loved it. My few lines of code helped me to reduce 3 hours manual work to only 5 minutes. Thanks to Microsoft for providing such a powerful tool. 
Topbullets - A Digital Notebook 