Are you making the same mistake for information management in your practice?

Hello Professional Colleagues, Hope you had a good start to the year 2017 and today is important day for us Chartered Accountant being the Budget Day! However, today I am going to share with you one important Professional Productivity/Practice Management Tool – Evernote. Visit https://evernote.com/ Evernote is a cross-platform, freemium app designed for note taking, organizing, […]

Share

PDF to Excel – A Quick Free Online Helper for Professionals

Hello Excel enthusiasts, I spoke about the limitations of free online tools for conversion of Portable Document Files in the past, but I recently stumbled across a great free tool for transforming your PDFs back to Excel. For the unacquainted, PDFs are used for sharing documents between different computers/devices, because they can be viewed on […]

Share

Replace a long formula of Nested IF with a simple VLOOKUP formula

Hello Formula Experts, I am sure you all have a good grasp on the formulas in Excel. But sometimes it happens that we write unnecessary too long formula when a simple solution giving the same result is possible. Today I am giving a example of the same and a Quiz for you. Doesn’t it sound […]

Share

How a $5 Formula fix Project – ended up in a $33/hour contract.

Hello Mates, I am demonstrating (in great detail) one of my experiment recently couple of days back (on Friday) with applying few of my golden tricks and techniques shared in the Online courses. First let us walkthrough what all events has gone into achieving above, then we will see what rules (Strategy) one need to […]

Share

Multiple Criterial Lookup

Hello Advance Formula Users, Although its very simple if you know the trick, it can save HOURS of your time if applied regularly in practice. The trick is basically MULTIPLE CRITERIA lookup with the help of two different methods 1. CONCATENATE and VLOOKUP and 2. INDEX and MATCH. View below video for Detail Recording of the […]

Share

All about that 2-letter abbreviation: CA

Chartered Accountant (C.A) is one of the many popular career options for a Commerce subject student. It is a distinguished and an internationally recognized career which involves work in fields of business, finance and management. The CA entrance exam is the one of the most prominent entrance exams in Indiaand here’s all you need to know […]

Share

Subscribe for Newsletter