Best Excel Tutorial
  • Home
  • Basic Tutorial
  • Advanced Tutorial
  • Charts
  • Tips and Tricks
  • VBA
  • Functions
  • Business Intelligence

How to Prepare Workbook Analysis Report from Inquire Add-in?

Details

In this Article we will learn how to prepare the workbook Analysis report in Excel using the Inquire Add-in:

Go to the Excel ribbon and click Inquire tab.

ribbon inquire

From the tab click Workbook Analysis button.

Workbook Analysis

We will see these options:

Workbook Analysis Report options

Let us run the results and check:

run the results

This is how the example result of workbook analysis looks like.

Further reading: 
How To Activate and Use The Inquire Tab?
How to compare Excel Files using Inquire?

Recommended lessons

  • Getting started with Excel
  • Sheet Formatting
  • Pivot table
  • Solver
  • What-If Analysis
  • Data Validation
  • Drop-down list
  • Multiple Linked Drop-Down List
  • VLOOKUP
  • HLOOKUP
  • Future Value
  • Present Value
  • Index function
  • Sumproduct
  • Charts 101
  • Column Chart
  • 3 axis Chart
  • Bullet Chart
  • Chart from right to left
  • Chart with a break Y axis
  • Funnel Chart
  • Panel Chart
  • Pareto Chart
  • Budget Template
  • ROI Calculator
  • Ratio Calculation
  • Interactive Map Dashboard
  • 11 best add-ins
  • Recording macros
  • How to create own add-in?
  • What are the most common bugs in VBA code?
  • Excel's FAQ

New lessons

  • Formula to get the number of days in the month
  • If Function with multiple conditions
  • How to Quickly Concatenate Multiple Cells?
  • How to find circular references?
  • How to get rid of circular references?
  • Regular Expressions (Regex)
  • Chart with Checkboxes
  • Budget Calculator
  • COUNTIF for non-empty cells
  • Data Entry Form
  • Stiff Diagram
  • How to calculate Slope?
  • How to Prepare Workbook Analysis Report from Inquire Add-in?

Most popular lessons

  • How to calculate the variance in Excel?
  • How to open .VCF files?
  • How to remove green triangles?
  • How to calculate logarithms and inverse logarithms in Excel?
  • How to calculate CAGR?
  • 3 axis Chart
  • How to use the integral function?
  • How to calculate ROI?
  • COUNTIF
  • Toggle button
  • BCG Matrix
  • How to apply formula to entire column?
  • How to Calculate z-score?

Our favourite lessons

  • Butterfly Chart
  • Chart with combo box
  • Cause and Effect Diagram
  • Dynamic Chart
  • Multiple Overlay Charts
  • Waffle Chart
  • How to Create Your Own VBA Function?
  • How to sort data in columns with VBA instead of Excel sorting?
  • How to create own add-in?
  • How to create a folder and sub folder in Excel VBA?
  • How to use trig functions?
  • How to zoom in graph?
  • Interactive Charts

Best Excel Tutorial - the largest Excel knowledge base. Best place to learn Excel online. Privacy policy About Follow us: Facebook Twitter Github

Copyright © 2012-2021 Luke K