Excel BitsHow to use UNIQUE Function in Excel — Best way to Remove DuplicatesUNIQUE function is a recent addition to the list of functions in excel. This function identifies the unique values from a range or an arrayApr 16, 2022Apr 16, 2022
Excel BitsHow to use Excel ROW FunctionWhat is Excel Row Function The purpose of Excel Row function is to know or get the row number for a given cell or range. This function…Apr 2, 2022Apr 2, 2022
Excel BitsHow to use Excel COLUMN FunctionIn this article let us understand about the Excel COLUMN Function. The Formula Syntax of Column Function in Excel.Apr 2, 2022Apr 2, 2022
Excel BitsMust know Excel Double Click Tricks — Work Faster with ExcelDo you mouse while using excel. Do you know that in few scenarios using mouse is better than using keyboard. Surprised !!!. Let us see the…Feb 24, 2022Feb 24, 2022
Excel BitsQuick way to Select Multiple Cells or Ranges at once in Excel- Excel BitsWhen working on excel, there will be instances where you need to select multiple cells or ranges at once. We do that by selecting the area…Jan 19, 2022Jan 19, 2022
Excel BitsHow to Change Column Name from Alphabets to Numbers in ExcelIn this post let’s see how to Change Column Name from Alphabets to Numbers in Excel.Jan 7, 2022Jan 7, 2022
Excel BitsFilter Data with a Single Click — Excel Efficiency TipCan we select and filter data with a single click in excel.Jan 4, 2022Jan 4, 2022
Excel BitsHow to use Cell References in Excel — Relative, Absolute and MixedUnderstanding Cell References in Excel is one of the important things to master excel and make the most out of spreadsheets. Cell…Dec 30, 2021Dec 30, 2021
Excel BitsHow to use OFFSET function in excelIn this post let’s know about the OFFSET Function in excel. Also, the Syntax, how to use along with limitations and alternatives to OFFSET…Dec 27, 2021Dec 27, 2021
Excel BitsHow to Create and Use Named Ranges in ExcelWe know that every cell in the spreadsheet has a unique name by default. This name is nothing but the combination of the row number and the…Dec 27, 2021Dec 27, 2021