Easy Excel Analysis Guide

The Easy Excel Analysis Getting Started Guide

getting started
Explains how to import an Excel or CSV file into an analysis table.

formatting date and time values in CSV files
Explains how to import date and time values from CSV files when the format differs from the local machine regional settings.

importing from multiple Excel worksheets and/or files
Explains how you can import data from multiple worksheets and/or files.

importing from multiple CSV files
Explains how you can import data from multiple CSV files.

using data files
Explains data files, and how they can be used to share data with other users without having to grant them access to your databases.

using analysis tables
Explains how to create groups, summaries, and use charts with your data sets.

working with copies of the same data sets
Explains how you can create multiple analysis and pivot tables from the same data set without having to repeatedly run the same query.

working with analysis table columns
Explains how to hide and freeze columns, and create multi-row headers in your analysis tables.

working with charts
Explains how charts can be used to get a big picture analysis of your data set, and used as a navigation tool to support the analysis table.

Leave a Reply

Your email address will not be published. Required fields are marked *