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