Contents
|
Index
|
Search
Introduction
About Easy Excel Analysis
Version history
Supported database engines
Direct connections without client libraries
Connecting to an Oracle database without OCI
Contact us
Using Easy Excel Analysis
The workspace
Importing data
Importing data from an Excel spreadsheet
Worksheet and settings
Set up columns
Set up additional date elements
Importing from multiple files/worksheets
Progress
Importing data from a CSV file
Set import settings for CSV file
Select settings
Set up columns
Set up additional date elements
Importing from multiple files
Progress
Opening a data file
Using the analysis table
Appearance
Summaries
Advanced summaries
Groups
Highlighting cells
Highlighting options
Data bars
Icon set
Three color scale
Two color scale
Range of values
Duplicate values
Ranking
Unique values
Above or below average
Using formulas
Formulas
Sorting
Filtering
Analysis chart
Chart elements
Chart synchronization
Printing and exporting
Using the pivot table
Creating a pivot table
Pivot table areas
Summaries
Custom grouping
Filtering
Sorting
Analysis chart
Printing and exporting
Creating additional analysis tables or pivot tables
Frequent tasks
Adding more analysis or pivot tables
Importing data
Importing date values
Analysis table
Creating a summary
Sort using a summary value
Grouping columns
Stop a column from scrolling
Stacking columns
Hiding a column
Displaying a chart
Pivot table
Hiding a column
Displaying a chart
Hiding a chart series