How to Create a Searchable Drop Down List in Excel (very Simple)

How to Create a Searchable Drop Down List in Excel (very Simple)

Insert Blank Row After Every Data Row In Excel

How To Enter Values Starting With Zero In Excel

       How To Enter Values Starting With Zero In Excel ?        Application for Excel 2007, Excel 2010, Excel 2013 and Excel 2016       ...

How To Transpose Data From Rows To Columns In Excel

      How To Transpose Data From Rows To Columns In Excel ?      You would use this feature if you want to transpose data to get a better...

How To Add More Than One New Row or Column

       How To Add More Than One New Row or Column ?        You may know the way to add one new row or column, but it really wastes a lot ...

How To Add A Diagonal Line To A Cell In Excel

      How To Add A Diagonal Line To A Cell In Excel (Insert Diagonal Line In A Cell) ?      When creating a classmate address list, for e...

How to use if function in Excel with multiple criteria [Part 2]

      Read more post "How to use if function in Excel with multiple criteria [Part 1]" at here       If you need to create more...

Using if function in excel with multiple conditions [Part 1]

     How to use if function in excel with multiple conditions (multiple criteria).In summary, there can be 2 basic types of multiple condit...

Remove errors in Excel with IFERROR and IFNA functions

     How to remove  #VALUE!, #N/A, #NAME?, #REF!, #NUM!, #DIV/0!, and #NULL! errors in Excel with IFERROR and IFNA functions       Both o...

Using Vlookup with multiple criteria in Excel

      How to use Vlookup with multiple criteria in Excel, this post will guide you Vlookup on Two or More Criteria Columns.      The gene...

Counting the number of Saturdays/Sundays between two dates

    How to count the number of Saturdays/Sundays between two dates (you can count the number of weekdays between two dates like Monday, Tue...

How to rank with multiple criteria in Excel

    How to rank in Excel with multiple criteria: This post will guide you ranking by multiple criteria in Excel.     For example, I need ...