Posts

Showing posts with the label Deadly-VBA.Programmer

Our Team Blogs

LIST OF BLOGS MAINTAINED BY VIKRAM SHANKAR MATHUR SRNO BLOG URL GMAIL_ID 01 https://vsmathurcoin.blogspot.com vsmathurco@gmail.com 02 https://vsmathurcoinshop.blogspot.com vsmathurco@gmail.com 03 https://exceltrainerahmedabad.blogspot.com vsmathurco@gmail.com 04 https://vbabeginner.blogspot.com vsmathurco@gmail.com 05 https://ktvayedaco.blogspot.com ktvayedaco@gmail.com 06 https://ahmedabadfca.blogspot.com ahmedabadfca@gmail.com O7 https://vikramsmathur.blogspot.com vikramsmathur@gmail.com 08 https://cavsmathurin.blogspot.com cavs.mathur@gmail.com 09 https://cavsmathur.blogspot.com cavs.mathur@gmail.com 10 https://vsmathur380052.blogspot.com vsmathur380052@gmail.com 11 https:/’/vsmathur380054.blogspot.com vsmathur380054@gmail.com 12 https://vbacoder1962.blogspot.com vbacoder.1962@gmail.com 13 https://vsmathuricai.blogspot.com vsmathuricai@gmail.com 14 https://deadlyvbaprogrammer.blogspot.com deadlyvbaprogrammer@gmail.com   CA Vikram Shankar Mathur aka the DeadlyVBAProgrammer deadly...

How to Connect Python to Ms Excel Read and Write Data

Image
DISCUSSION SOURCE URL FOR CODING - USE THIS, WILL OPEN IN NEW WINDOW: https://www.kindsonthegenius.com/blog/2018/01/how-to-connect-python-to-excel-read-and-write-data-try-it.html Copyright @ 2019 - CA Vikram Shankar Mathur ( deadlyvba.programmer@gmail.com ) DeadlyVbaProgrammer.com

20191129-Use-Of-Excel-And-VBA-For-MIS-Development-Slides

Image
20191129-Use-Of-Excel-And-VBA-For-MIS-Development-Slides GALLERY OF SLIDES

20191117-Running-Total-Formula-MSExcel

Image
20191117-Running Total Formula in Microsoft Excel Worksheet for Computation of Total Income of an Assessee I have already made a similar post in my Wordpress Blog as VBA Beginners Guide - ( November 2019 ), but here is a more refined version of the same with detailed explanations about the need to create such a running formula. What is a "Running Total" and when is it significant in an Excel Worksheet? The above image is the last part of the image that was added to the final image right at the top of this page, replicated here to ease the explanation of why a " running total " can be required in an excel worksheet. Suppose you had a worksheet, as in my case it is a worksheet that computes the Total Income of an Income-Tax Assessee for the Financial Year ended 31-March-2019 , wherein the various allowed heads under Section 80C, namely, " Public Provident Fund Contribution ", " Life Insurance Premium ", " Children's Educatio...

Deadly-VBA.Programmer

DeadlyVBAProgrammer - hmm.. I created this account and this blog so much time before and am re-discovering it again today. Oh, by the way, for those who did not know this already, we are on facebook as DeadlyVBAProgrammer , so do visit us there. If you wish to send us an email, please send it to deadlyvba.programmer@gmail.com . CIAO !!