Skip to main content

Posts

Showing posts from November, 2015

New Article

How to SUM by matching partial text in Excel

Unable to load msmdlocal.dll for PowerPivot add-ins

Image 1: DLL file First time I've installed PowerPivot add-ins on Excel 2013. But the problem is while going to run it it shows a message on Windows 8.1 that, "Unable to load msmdlocal.dll". I'm afraid how to solve it. One thing I got in my mind that, if Restart can solve many problems of PC, then why not reinstalling? Then I've uninstall it completely and reinstall it after re-starting the PC and it works perfectly. I don't know what was the matter for showing the message. Still trying to know that.

Want to survive in a company in Bangladesh, then learn these survival techniques in Excel

As an MIS Executive, you need to prepare various types of report in MS Excel. That is why you need to take care about 2 important things in my opinion. a) Analytical Ability: This will help you tho design the report table based on requirements. You must think simply. Remember your information is important not the colorful design. If you have an order to prepare a report with some criteria, then first draw a sketch table in your notebook and design the table matrix (Row header and Column Header). This will help you to get the data fast. b) Know MS Excel properly so that you can use it very quickly: Learn your MS Excel properly so that you can use it to collect data very quickly. You don't need to go to training school. You can do it by yourself if you wish without free of cost. Now a day huge tutorials are found over online. Just search and learn. After learning apply the learning things into your real data, which is related to your company. If you found the result corr