# Category: Excel Functions

#### How to use Excel LOWER Function

Quick view of Excel LOWER Function Explanation: In the above table, the LOWER function is applied to the data and the results are from D7 to D10. The formula can…

#### How to use Excel UPPER function

Quick view of Excel UPPER Function How to use Excel Upper Function Explanation: In the above table, Excel UPPER function is applied to the data and the results are from…

#### How to use Excel PROPER function

Quick view of Excel PROPER Function How to use Excel Proper Function Explanation: In the above table, the PROPER function is applied to the data and the results are from…

#### How to use Excel RIGHT function

Quick view of Excel RIGHT Function Explanation: In the above table, the RIGHT function is applied to the data and the results are from D25 to D32. The formula can…

#### How to use Excel MID function

Download the Excel File with examples Download Quick view of Excel MID Function Explanation: In the above table, MID function is applied to the data and the results are from…

#### How to use Excel LEFT Function

Quick view of Excel LEFT Function Excel LEFT function Explanation: In the above table, LEFT function is applied to the data and the results are from D7 to D15. The…

#### How to use Excel Filter Function

Quick view of Excel Filter Function Explanation: We have filtered Sales man name, Sales Amount, Department (entire data) based on the condition that department is equal to textiles. You can…

#### How to use the SEQUENCE function in Excel

What are the uses of SEQUENCE function in Excel What are the uses of Excel SEQUENCE Function Definition of SEQUENCE Function SEQUENCE Function: The SEQUENCE function allows you to generate…

#### Excel How to use OFFSET function

Click here to download the Excel workbook which contains the below examples. Description OFFSET Function: Returns a reference to a range that is a specified number of rows and columns…

#### Excel WEEKNUM

Click here to download the excel workbook which contains below examples. WEEKNUM: WEEKNUM is a date and Time function in Excel. Using WEEKNUM function, if we input any date we…