Finance - Benford's law describes the relative frequency distribution for leading digits of numbers in datasets. In this article we are discussing the possible ways to implement this theorem with understanding our needs and business practices of record keeping....
Read MoreFinance - Microsoft Excel is extensively used across the globe to store and analyze. Despite various new data analytics tools in the market, Excel remains the go-to product for working with data. It has numerous in-built features, which makes it easier for you to organize your data. In this article, we’ll be discussing the various Excel shortcuts...
Read MoreFinance - Following the previous post, we are here with some unknown yet useful features of Pivot that can enhance our work quality on a day-to-day basis. In this post we will be looking into the Pivot Charts, Filters and Slicers, Timelines and the feature of Calculated Fields in Pivot....
Read MoreFinance - What is a Pivot table? Table in Excel is a conventional form where we have the rows and columns of the data as in raw form with a little scope such as filter, sort ,etc. There is no scope for turning down the data into meaningful insights and summary. ‘Pivot’ means to turn or change […]...
Read MoreFinance - We often know so many tools. The big question is when and how do I use the tool? Sharing small snippets on using Excel flash fill along with a few use cases. What is Flash Fill in Excel? Excel Flash Fill is a special tool that analyses the information you are entering and automatically fills […]...
Read MoreFinance - Join Certification Course on GST Compliances, Excel For professionals, Income Tax and Customs, Import & Export by TaxGuru Edu at 60% discount...
Read MoreFinance - Test anxiety can affect not just the result of your certification exam but also your wellbeing. It may lead to exam failure, or worst, mental breakdown! And if you don’t want to pull a stressful all-nighter, there’s no better way than to have a game plan. For those who plan to take Microsoft exam 70-741, […]...
Read More