Insert Alternate Blank Rows In Excel
Inserting Rows & Columns in an Excel spreadsheet is a common thing but in few cases, we need to insert alternative blank rows. We may think Macro is the only…
How To Use IF Function Instead Of VLOOKUP
Lookup function is an important part of any Spreadsheet program, especially in Excel. Normally, whenever a Lookup requirement comes in Excel we think about VLOOKUP, INDEX- MATCH & XLOOKUP function…
How To Resolve Date Issues In MS Excel?
Date format is always a big issue, especially when you are extracting or receiving raw data from different sources(software). It becomes more challenging especially when we get raw data from…
Create a Pivot Table with an external Data Source without opening file
The idea behind building your pivot table using an external data source is that you can create and use a pivot table from a database that is not stored in…
How To Calculate Difference Between Two Dates in Excel (DATEDIF)???
MS Excel DATEDIF function returns the difference between two date values, based on the given interval. The DATEDIF function is a hidden built-in function in Excel that is categorized as…
Performance Issues Of Excel Workbooks And Their Solution
Performance issues are always a big challenge. Users get frustrated with Excel when they upgrade to later versions. Performance issues often boil down to spreadsheets that have been around a…