Excel Function : Excel is very rich tool for MIS and Data Analysis, and Excel Functions are most useful topic in Excel learning. In this tutorial, i am trying to cover most useful function in Excel category wise. Everyone can learn excel formula like text function, logical function date function, time function, statistics function, lookup function.
In this shortcut keys in excel tutorial, we will learn popular keyboard shortcuts used with the excel. Using a keyboard shortcut helps the user to work in excel more efficiently. Keyboard shortcut keys speed up our work. Microsoft Excel has a rich library of shortcut keys, Here, we will discuss some popular shortcut keys used […]
Useful Shortcut Keys in Excel Read More »
IFERROR Function in Excel: We will learn about syntax and how to use iferror function in Excel with examples. Description: The Function returns a custom value when a function generates an error, otherwise, it returns the result of the value part. The most useful function of Excel to manage errors in a formula in Excel.
IFERROR Function in Excel Read More »
Text Function in Excel : Here, we will discuss about syntax and usage of TEXT function. Description: The TEXT Function in Excel is used to convert number into given text format. It returns text value, so it may not perform mathematical task on given result. We can use this formula to covert numeric or date value
TEXT Function in Excel Read More »