Re: $$Excel-Macros$$ Power BI

2017-11-29 Thread joseph abi
Power BI is a paid is a graphical tool for dash board graphical presentation etc. It is paid services from Microsoft. It work like pivot table and chart. Pivot table is far better than Power B . If you coud establish connection to the file in server and user pivot table in excel that is best than

Re: $$Excel-Macros$$ Values are not calculating in number format

2017-10-12 Thread joseph abi
Dear Mr. praveen In your file some unwanted character which is invisible in the front of each numbers are hidden. That is the reason the number is considered as text by excel and you are unable to calculate. This is very small data I have manually removed the character in each cell. to remove coma

Re: $$Excel-Macros$$ Formula for Month wise calculation

2017-09-30 Thread joseph abi
Dear Mr. Paul, It great to formulate such a amazing formula to calculate such difficult scenario. Abi Joseph On Fri, Sep 29, 2017 at 5:48 PM, Paul Schreiner wrote: > This is pretty "convoluted" logic. > I tried several approaches that soon became extremely complex (as if this > isn't?) > > Th

Re: $$Excel-Macros$$ Re: 10 Microsoft Excel Formulas For All Kinds Of Work

2016-04-26 Thread joseph abi
Thanks Abi Joseph On Sat, Apr 23, 2016 at 6:08 PM, sleek wrote: > I dont usually use networkdays much, & your site props up ads and offers, > too. > > > On Monday, 18 April 2016 11:40:43 UTC+3, Melissa James wrote: >> >> Hello Guys, >> >> Hello Guys, >> >> I would like to share an article about

$$Excel-Macros$$ Excel template for Management of Finance for the FY 2016-17.

2016-03-07 Thread joseph abi
Dear Group members I have created an excel template for the management of Finance for the FY 2016-17. This can be used for a company as well as for personal accounts. If the entries are right the day wise and month wise trail balance can be monitored. This is a trail version as it is designe