To make your experience with MS-Excel more complete and more precise, here are some of the advanced settings in excel …
Excel Advance Settings, Customize Ribbon and Quick Access Toolbar Read More »
To extend the functionality of MS-Excel you can install extra add-ins in Excel. By default, you’ll not see any additional …
Microsoft Excel is the GOTO tool for data management and data processing. MS-Excel provides powerful tools to filter large data …
Microsoft Excel Options: General Settings & Formula Settings Read More »
Test Yourself MATCH function is helpful when you want to know the relative position of any text/value in a range …
Lookup Functions in Excel: In today’s blog let’s talk about Lookup Functions in Excel. VLOOKUP If you need to find …
Today, let’s have a look at logical functions: If and Nested IF IF Function in Excel One of the most …
We have discussed about VLOOKUP in our previous posts and talked about how it could help us in extracting data …
Introduction To DAX: Data Analysis Expressions Formulas What is DAX? Functional language of Power Pivot in Excel, the Tabular Model …
Let us know about importance of pivot tables. But before we get to know about pivot, what is pivot table? …
In today’s let us look at how to Import data into pivot tables This feature is one of the most …
Import Data from External Sources to build a Pivot Table Read More »
