What is inQuire?

inQuire is a multifaceted platform that encompasses a user-friendly Customer Relationship Management (CRM) tool, a professional AI writing assistant, and a Python data type. The inQuire CRM is known for its comprehensive integration capabilities, actionable analytics, and accessibility across browsers and mobile devices. It streamlines communication through its conversation module and enhances productivity with features like speech-to-text, one-click communication, and automated workflows.

As a service, inQuire offers an AI writing assistant that is part of the Flowrite ecosystem. This assistant aids users in crafting emails and messages quickly and effectively, promoting professional and polite communication. It is designed to improve writing efficiency and authenticity, especially for business inquiries. inQuire service is conveniently available for free and operates directly within your browser.

From a technical standpoint, the inQuire data type refers to a Python data type and stands distinct from traditional C/C++ data types. It caters to Python's dynamic nature, where explicit concern over data types like unsigned or signed integers is generally unnecessary. When dealing with data types in Python, tools such as the type() function and the isinstance() function help in determining variable types, while the struct and ctypes libraries provide additional functionalities for those who need to work with system-specific types.

Inquire Plugins for Excel

Activating Inquire Add-in

To utilize the Inquire add-in features in Excel, the add-in must first be activated. Users can turn on the Inquire add-in through the Excel Options menu or by accessing the COM Add-ins dialog box and selecting the Inquire Add-in. The Inquire tab will appear in Excel after the add-in is enabled, indicating that the add-in is ready for use.

Workbook Analysis and Reporting

The Inquire add-in provides a Workbook Analysis command that offers a comprehensive analysis of a workbook's logic structure and error status. The analysis includes details such as formulas, cells, ranges, and warnings. It also provides general statistics about the workbook, and can detail external data connections, such as when a workbook is connected to a text file.

Exporting Analysis Report

Once the Workbook Analysis is complete, users can export the data to a report for documentation purposes. This report is generated in a new Excel workbook and contains categories like Summary, Workbook, Formulas, Cells, Ranges, and Warnings, documenting the workbook's details comprehensively. This feature is particularly useful for assessing the risk and impact of a workbook within an organization.

Limitations and Availability

It is important to note that the Inquire add-in is only available in Office Professional Plus and Microsoft 365 Apps for enterprise editions. Additionally, the add-in may not be available if not included in an edition of Office or Excel or if it has been disabled by a system administrator. A workbook with over 100 million cells in the used range cannot be processed by Inquire, and the add-in is not available in Office on a Windows RT PC.

Common Use Cases

• I

  
  Use case 1: Assessing the risk and impact of an Excel workbook within an organization to ensure data integrity and reliability.
• I

  
  Use case 2: Activating the Spreadsheet Inquire add-in to analyze workbook logic, error status, and identify hidden sheets and linked workbooks.
• I

  
  Use case 3: Exporting the Workbook Analysis data to an Excel report format for documentation and auditing purposes.
• I

  
  Use case 4: Analyzing the data connections in a workbook to understand and manage external file dependencies.
• I

  
  Use case 5: Identifying and resolving errors and inconsistencies in formulas and array formulas to improve workbook functionality.

Frequently Asked Questions

What editions of Office include the Excel inQuire plugin?

Excel inQuire plugin is only available in Office Professional Plus and Microsoft 365 Apps for enterprise editions.

How do I activate the Excel inQuire plugin?

You can activate the plugin by going to the Excel options menu, selecting Add-Ins, and then activating the Spreadsheet Inquire add-in. After activation, the Inquire tab will appear in Excel.

What features does the Workbook Analysis provide?

The Workbook Analysis feature can report on workbook statistics, formulas, cells, ranges, and warnings. It categorizes information into Summary, Workbook, Formulas, Cells, Ranges, and Warnings sections, providing details such as linked workbooks, external data connections, hidden sheets, and array formulas.

Can the reports generated by Workbook Analysis be exported?

Yes, reports generated by Workbook Analysis can be exported to Excel.

What are the benefits of using the Excel inQuire plugin?

The inQuire plugin helps in providing a comprehensive analysis of a workbook's logic structure and error status, assessing the risk and impact of a workbook in an organization, and examining data connections through detailed reports.