MENTOR ME CAREERS

# Category Microsoft Excel Resources

Tutorials, tricks and shortcuts in excel can be found here

## How to make powerfull Charts using excel charts?

निम्नलिखित हिंदी में दिए गए पाठ को कनवर्ट करने का प्रयास किया गया है। कृपया ध्यान दें कि यह एक अक्सर प्रोग्राम द्वारा किया गया रूपांतरण है और इसमें कुछ त्रुटियाँ हो सकती है। दो ऐसे लोग कैसे हो सकते…

## MOD Function in excel and how does it work?

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.…

## LEN Function In excel and how to use it?

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 Function in excel and how to use it?

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…

## MIN Function in excel and how to use ?

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 in excel and how to use?

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…

## How to use the rank formula in excel?

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…

## Mastering Date Calculations in Excel: Adding Months to Date

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…

## HLOOKUP Function in Excel and how to use it?

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,…

## LOOKUP Function in Excel and how to use?

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…

## Unleashing the Power of the Date Function in Excel: A Comprehensive Guide

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…

## Compressing Excel Files- Quick Guide

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…