Now, let’s take a walk through the ribbon.

At this point I should also mention that PowerPivot is also already included, as you can see in the picture below. File/Options/Add-ins, select COM Add-ins and tick the Inquire. The answers to all these questions, and many others are hidden in the INQUIRE tab, which can only be added to Excel by enabling the Inquire Add-In. How many differences are there between the two workbooks. How many blank sheets, how many hidden sheets… How many connections between the sheets. How many cells with formulas are in this workbook. This is in fact an analytical tool, which does not deal with numbers and tables, but rather with the data. We then helped ourselves with some kind of a VBA solution, but never got even close to the elegance and simplicity of the Inquire Add-Inn. This Add-Inn hides tools that we have looked for in all previous versions of Excel but never found them. Today I'm going to talk about a great add-in for Excel 2013, which is part of Excel itself and is called Inquire.

Microsoft office excel 2013 expert