Tutorials, tricks and shortcuts in excel can be found here
What is the Mod Function? The MOD Function is categorized under Excel Math and Trigonometry functions. This function helps find a remainder after a number(dividend) is divided by another number(divisor). It can be used as a worksheet function in Excel.…
Are you confused about the Len Function in Excel? The Len function helps you find the number of characters in a excel cell. Just type = LEN ( select any cell with characters), it will show you the number of…
PMT Full form in excel stands for payment. A very useful tool to calculate, equated payments either in investments or financing scenarios. In this article, you will get the full understanding of how to use it flawlessly. PMT Full Form…
What is the MIN function? The main function is categorised under Excel statistical functions. This function will return the minimum value in a given list of arguments or arrays. The main function is very useful in financial modelling to calculate…
Max function excel, is a inbuilt formula in microsoft spreasheet to calculate or return the largest value in the set of numbers What is the Max Function Excel? The Max function is categorized under Excel Statistical function. MAX will return…
The rank formula in excel is a very useful and handy tool to get a rank either in descending or ascending order. What is the Rank Formula in Excel? The RANK function is categorized as an Excel Statistical Function. The…
In Excel, adding months to date is a common task for various data analysis and financial modeling scenarios. Understanding how to perform this calculation accurately and efficiently can greatly enhance your Excel skills. In this comprehensive guide, we will delve…
In this blog, I will make this function a powerful tool, hlookup in excel, under your ammo of other parts you may or may not know. Now, I will clarify to you first that ‘H’ in hookup means horizontal. Similarly,…
The lookup function in Excel is a powerful tool that enables users to search for specific values within a dataset, providing a convenient way to retrieve related information. With the lookup function, you can effortlessly locate data based on a…
Welcome to our comprehensive guide on the data function in Excel! In this article, we will explore the power and versatility of the data function, empowering you to excel at handling data calculations and formatting in Excel. From understanding its…
In this short tutorial page, you will learn how to compress excel file from MB to kbs without using any plugins or online converters. So read along. Why reducing the Excel File is Important? The Excel spreadsheets file size might…
Gridlines in Excel Author: Sarthak Bhalerao Table of Contents What are gridlines? Gridlines in Microsoft Excel are the horizontal and vertical grey coloured lines that differentiate between all the cells in a worksheet. These grid lines help in reading the…