{"id":1740,"date":"2013-04-25T10:52:53","date_gmt":"2013-04-25T10:52:53","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/exceltraining\/?p=1740"},"modified":"2023-12-31T00:17:01","modified_gmt":"2023-12-31T00:17:01","slug":"excel-2013-audit-your-spreadsheet-with-the-inquire-add-in","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/excel-2013-audit-your-spreadsheet-with-the-inquire-add-in\/","title":{"rendered":"Excel : Audit your Spreadsheet with the Inquire Add-In"},"content":{"rendered":"

\"new<\/a>For users with the Office Professional Plus package, the Inquire add-in comes pre-installed on Excel 2013. Helping you to analyse, audit and review workbooks, this great new feature also has the potential to highlight errors and security concerns.<\/p>\n

We recently discussed, how to take back control of your spreadsheets <\/a>by reducing \u201cfat finger mistakes\u201d and auditing errors, which can have huge cost implications to businesses. The Inquire add-in is another great tool for preventing these issues from arising and escalating in Excel.<\/p>\n

The new tool can be accessed via the Inquire Tab in the ribbon and includes a number of useful functions:<\/p>\n

\"Worksheet<\/p>\n

    \n
  1. Workbook analysis<\/span><\/li>\n
  2. Workbook relationship<\/span><\/li>\n
  3. Worksheet relationship<\/span><\/li>\n
  4. Cell relationship<\/span><\/li>\n
  5. Compare files<\/span><\/li>\n
  6. Clean Excess Cell formatting<\/span><\/li>\n
  7. Workbook passwords<\/span><\/li>\n<\/ol>\n

    These seven functions are simple to use, many providing visualisations to help better understand the information.<\/p>\n

    We all know Excel for being data driven, however, visualising things often makes this mass data easier to understand, take for example\u00a0recommended charts & graphs<\/a>\u00a0or all new quick analysis techniques<\/a>.<\/p>\n

    A few of our favourite Inquire features include:<\/p>\n

    \"Cell<\/a><\/p>\n