Excel: data analysis

Objectives

To leverage the potential of Excel as a data analysis and decision-making tool.

Targeted audience

Professionals and technicians

Content

Sorting and Filtering

• Basic and multi-criteria sorting
• Logical operators AND, OR, and NOT
• Automatic and advanced filters using complex criteria
• Calculations based on criteria with DSUM, DAVERAGE, DMIN, DMAX, and DCOUNT

Data Tables and Highlighting

• "Table" formatting
• Conditional formatting with criteria and formulas

Decision-Making Tools

• Goal Seek
• One- and two-variable data tables

PivotTables

• Operating principles and configuration
• Summarizing a large amount of data
• Filters, sorting, page fields
• Data grouping
• PivotCharts
• Calculated items
• PivotTables connected to an external data source

Importing Data

• Importing data from a text file
• Importing data from a website

Array Formulas

• Calculating the number of occurrences with FREQUENCY
• Regression analysis with TREND and GROWTH
• Changing row/column orientation with TRANSPOSE
• Transposing a range

Control Tools

• Protecting a sheet and a workbook
• Data validation
• Creating a drop-down menu with list validation

Advanced Charts

• Choosing the right chart type
• Advanced configuration
• Combo charts with a secondary axis