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…
MS OFFICE 365
Microsoft 365 is a cloud based office suite designed to help you to run your business in a very cost-effective manner. More than just apps like Word, Excel, PowerPoint, Microsoft…
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…
MS WORD (BASIC TO ADVANCE)
Microsoft Word is a most powerful word processor program. It allows user to create, edit and format the document for a professional look. With MS Word we can modify the images…
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…
POWER PIVOT
Power Pivot is a powerful Add-Ins of Microsoft Excel. This Add-Ins need to be installed separately in Excel 2010 but it's a part of Excel 2013 onwards. Power Pivot is…
MIS EXCEL DASHBOARD
An Excel dashboard is very informative interface that helps professionals in tracking their MIS related information in less time in various ways. It contains charts, tables, slicer, views that are…