How to start Tally?

Can you imagine how many ways you know to start Accounting Package Software Tally? Following methods tell you about it...

There are many ways to start Tally.

Please comment if you like it, or have any
suggestions.

Finally Tally remove the Directory Field Bug ……………

Finally Tally remove the Directory Field Bug ……………

In company creation screen there is a Directory Field. The Directory Field specify where you want to create the company in computer or other computer on the network. Here we type the path where we want to create the company. By default it takes default path which mention in Tally.ini file. At the time of company creation If this field remain empty Tally will create the company. Now question is “in which path Tally will create the company?”.

??????????????is this a bug………….????????????????

The path where Tally will create the company is the root folder of the drive where the Tally installed.

Now Tally resolve the problem from Tally.ERP9 series A release 5.0 version. In this version we can not move to next field if Directory Field is empty.

When we create a Company in Tally with empty directory field

Tally will create the company.

In this case the company will create in the root folder  of the drive where Tally installed.

Now Tally resolve the problem from Tally.ERP9 series A release 5.0 version. In this version we can not move to next field if Directory Field is empty.

 For video link: Finally Tally remove the Directory Field Bug........

What is Pivot Table..........

There are two words in Pivot Table

  

1.Pivot and

2.Table

Pivot

Literal meaning of Pivot is as follows:

The central point, pin, axis or shaft on which a mechanism turns or oscillates.

Table

Literal meaning of Table is as follows:

A set of facts or figures systematically displayed, especially in rows and columns.

Pivot Table

Pivot Table is a mechanism, a tool or an interactive table by which we can rotate rows and columns quickly and easily to organize, summarize, analyse, and compare large amounts of data without having to build complex formulas.

How to Break Full Name...............?

How to extract Title from Full Name ?

=LEFT(“Title Firstname Middlename Lastname”,find(“ “,“Title Firstname Middlename Lastname”)-1)

How to extract First Name from Full Name?

Find first space position(FSP)

FSP= FIND(“ “,“Title Firstname Middlename Lastname”)

Find second space position(SSP)

SSP= FIND(“ “,“Title Firstname Middlename Lastname”,FSP+1)

Find first name length(FNL)

FNL=SSP-FSP-1

Extract First Name

=MID(“Title Firstname Middlename Lastname”,FSP+1,FNL)

                OR

=MID(“Title Firstname Middlename Lastname”, FIND(“ “,“Title Firstname Middlename Lastname”)+1, FIND(“ “,“Title Firstname Middlename Lastname”, FIND(“ “,“Title Firstname Middlename Lastname”)+1)- FIND(“ “,“Title Firstname Middlename Lastname”)-1)

Show formula in Excel in specific cells without activating show formula option:

Show formula in Excel in specific cells without activating show formula option:

Someone asked me about following table. How the Expression column in this table shows formula without activating Show formula option in Formula Tab à Formula Editing? In this column he access any cell in edit mode after lock the entry in the cell Excel shows the result instead of underlying value in that cell.

I solve above mention problem in following steps:

If you want to show formula in excel cell first select the cells

Then convert its category General to Text

 

After that type the formula: this formula extract Title from the Name of the Student

Now you are able to view the formula. If you want to convert it into formula to calculate by Excel you select the cells again

And convert its category text to general

Active any cell in expression column and press F2 key

and press Enter key Excel now calculate it.

 

Or if there are already formulas in cells and you want to view it without using the show formula option/ (Ctrl+`) (`acute accent key) or you want to view only specific cells not all in the sheet:

Step1: select the cells

Step2: change their category into Text

Step3: make it active and press F2 and lock the entry

Now it will show the formula……….

Tell us what we can do to improve this article

Please comment if you like it, or have any
suggestions.