TechnoTip 4 by CA Ravindra Patil - Unit of Measurement of Computer Storage Space


Comments

Post a Comment

Popular posts from this blog

Techno-Tip #8 - How to open New version Tally data in Old version of Tally

Techno-Tip #8 by CA Ravindra Patil (92093-00789)                         (16-09-2018) How to open New version Tally data in Old version of Tally Paste data into data directory Open tally If any company automatically opened close it by pressing Alt+F1 Now you will be at “Company Info.” Window Press Alt + Ctrl + R – it will navigate to Rewrite Company Select the company to rewrite It will as “Rewrite?” select Yes It will ask “Backup before rewriting?” select Yes Select the destination folder to backup if not already selected or simply type C:\ or D:\ or E:\ Your company is not rewritten. Open the company and enjoy your work.
Read more

Techno-Tip #9 - How to remove tally vault password?

Techno-Tip #9 by CA Ravindra Patil (92093-00789)                         (21-01-2019) How to remove tally vault password? 1.        Open company with tally vault password. 2.        Press Alt+F3 for Company Info Menu. 3.        Select Change Tally Vault option. 4.        Type Current Password. 5.        Keep Blank at rest of the fields. 6.        Select yes at "Change?" Window. 7.        It will create new Company with new number without vault password. 8.        Now you can delete old company with vault password. 9.        Open the company without vault and enjoy your work.
Read more

Techno-Tip #6 - Cell Reference in Excel

_Techno-Tip #6 by CA Ravindra Patil (92093-00789)                        (10-03-2018)_ *Cell Reference in Excel* 1. Excel has a cell reference style C1R1     Where C1=Column 1 & R1=Row 1 2. When we drag/copy and paste the formula cell reference also change automatically.      e.g. C1=A1+B1, if we copy cell C1 & paste in cell F5 formula will change to D5+E5 it’s called              relative reference 3.  If you want to make the cell reference as absolute reference (means reference will not change             with drag/ copy & paste) we have to assign $ sign to column & row label      e.g. C1=$A$1+$B$1, here if you copy formula of cell C1 & paste in F5, formula in cell F5 will             ...
Read more