In order to re-create the Live Calendar displayed above in the graphics, carry out the following steps after inserting a new workbook in your excel space: (1) Just download the graphics and select B2:H2 and merge the cells choosing Home->Alignment->Merge & Center. (2) Enter a date into the merged range (for e.g. 01-01-2025). The day of the month is not important, so change the format of the cell to a custom format that doesn't display the day: mmmm, yyyy. (3) Enter the abbreviated day names in the cells B3:H3. (4) Select B4:H9, and then enter the array formula to the one in the blue square in the graphic above. (Note: To enter an array formula, press Ctrl+SWhift+Enter. CA Vikram Shankar Mathur 12-Dec-2024 | 03:42 Hours IST | #VSM

In my #ExcelTrainerAhmedabad identity (GST recognized) I wanted to impart Advanced Excel Training which would enable you to produce formats like this screenshot, as an Excel Worksheet / Workbook (macro-enabled). But I have given up the idea of training anyone ever,  because now I have no time to do this, see? Cheers!! In my opinion, I have gained a lot of free time by giving up and the loss is obviously to those who ought to have availed that opportunity!!

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

https://youtu.be/q6Mc_sAPZ2Y 20191209 - Learn to automate Excel using Python, well, I always have been using Visual Basic for Applications (VBA)!! This video will tell you a lot more that can be done using Python,  a modern Programming language.

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...