menus, which are explained below.
We will explain the shortcut menus for the left pane, Space of structures of consolidation, first.
All shortcut menus are displayed by right-clicking on the appropriate item.
Some items do not have shortcut menus, so do not worry about that.
Open: This option is enabled when this book is in the folder indicated; point to it to open the book and see its contents.
Consolidate: This option is enabled when there are books to be consolidated.
Save Changes: Point to it to save changes made.
Open Template: Select it to create a Template associated to the model. A Template is a book from which copies will be made for all other books.
Import Structure: Use it to insert all the structure and logic of an existing model into the model we are creating, i.e. the template, consolidation tree
and any other configurations. It will be enabled only if there are prior models saved.
New Consolidation: Select it to create consolidation levels. Each level is also a book that will consolidate the books grouped in it.
New Spreadsheet: Click here to create new books that are copies of the Template.xls book associated to the model, and save them in the Files
folder, as shown in the example.
Expanded All: Select it to expand the consolidation tree and see its structure in full.
Collapsed All: Point to it to collapse the consolidation tree; only its name will be visible.
Properties: Click here to see the basic properties of the book, such as path and creation and modification dates.
Right-click on any other consolidation-type or consolidation-level item 
to open shortcut menus, which have some additional options to those
explained above, including:
Rename: Click here to change the name of a consolidation level or any other book, except for the first book that has the model name.
Re-Create: This option will be enabled when the add-in finds that a book is missing in the folder so we may be able to create it again.
See Creating a new model
data, first get copies manually before deleting them.
to display a shortcut a menu with fewer options, all of which have already bee explained and have the same functions.
Now we are going to explain the shortcut menus for the right pane, Space of analysis of data.
Right-click on the appropriate item to display the shortcut menus.
Right-click on Data Analysis to see a short cut menu with the following options:
Configure Data Analysis: Select it to define what type of cross section report you want to create.
Execute Data Analysis: Click here to run the type of report chosen in the previous option.
Save: Point to it to save the selection of items to be included in the data analysis.
Right click on the item with the same of the model, Test2008, to see another shortcut menu with options
to create advanced pivot tables.
Exploit Data: Select it to generate pivot tables with the items selected, including books, rows and columns.
Select All: Click here to select all items in the consolidation tree of the model.
Unselect All: This option does exactly the opposite as the previous one.
Expanded All: Click here to show all elements.
Collapsed All: Point here to hide all elements.
select and unselect all items grouped here.
Right-click on an empty area in the right pane to see yet another shortcut menu, with the following options:
Create Data Analysis: Select it to create all the whole structure in "Space of analysis of data". The
add-in will create it automatically when it finds the required information.
All items contained in the selected models will be loaded automatically.
