Finance : With UPI Apps becoming mainstream nowadays, cash is garnering the status of a rare and exclusive commodity. Right from a small car...
CA, CS, CMA : Learn how to draft an accurate Balance Sheet in Excel within 2 minutes using formulas like VLOOKUP, HLOOKUP, and XLOOKUP for error...
Finance : Learn how to automate filling blank cells in Excel using VBA. Save time and reduce errors with our step-by-step guide for efficien...
Finance : Convert Excel data to PDF effortlessly for a polished look. Enhance presentation, maintain formatting, and ensure compatibility wi...
CA, CS, CMA : Discover essential Google Sheets keyboard shortcuts to boost productivity. Learn time-saving tips and tricks for efficient spreads...
Goods and Services Tax : Join Certification Course on GST Compliances, Excel For professionals, Income Tax and Customs, Import & Export by TaxGuru Edu at ...
Finance : Test anxiety can affect not just the result of your certification exam but also your wellbeing. It may lead to exam failure, or wo...
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.
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 […]
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 […]
We all have came across than one excel file which does not contain that much information but still taking up a space of several MBs and makes our PC standstill while opening or editing it. You might have wondered what is the extra data that is stored in that file. Here are few tips that […]
Pre requisites to help understand the file: 1. What is Timesaver Excel Shortcuts? 95 selected basic & advanced excel shortcuts which can simplify work 2. Is there any thing one should know in advance before reading the shortcuts? Yes. Below are the two points which you should know in advance before going through the shortcuts: […]
Microsoft Excel is undoubtedly most user friendly tool and being extensively used all over the world. We might be using it daily or maybe casually, but probably always wished that we knew more about this dynamic program. Most of us don’t use even 5% of its capabilities. While most of us know use of VLOOKUP, […]
Working as a Chartered Accountant or an Article in any company or firm, it is always expected from us that we are perfect in numbers as far as financial numbers are concerned. The one tool which is very common and useful in every industry and in every country, is MS-Excel. So, in this article we […]
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, […]
Another week has passed by and it’s time to get the hang of another feature in Excel. ‘It takes time to save time’ and When we invest time to learn Excel, we are actually saving our time. ♦ Background: You need to borrow some money – – You know how much you want (the amount […]
Excel’s ‘Consolidate’ feature helps in consolidating data in worksheets (located in one workbook or multiple workbooks) into one worksheet. Even though this is predominantly used at the managerial level (say, for aggregating various financial figures from multiple branches), it can come handy to the Chartered Accountants as well.
