Introduction to Data Analysis using Excel
Learn Excel for data analysis from basic to expert level and be able to apply this practical skill in any field. It explores spreadsheet software’s most relevant features which will help you become an expert as beginner, achieve proficiency as basic user or polish skills and finish learning curve as an intermediate one. All of this while using real-world data together with practical exercises done step-by-step.
2 Days
MS Excel Data Analysis
7 PDUs
Personal Development Unit
MS Excel Data Analysis
PREPARING DATA & CREATING PIVOTTABLES
- Prepare Data
- Create a PivotTable from a Local Data Source
- Create a PivotTable from Multiple Local Data Sources
- Create a PivotTable from an External Data Source
ANALYZING DATA USING PIVOTTABLES
- Summarize PivotTable Data
- Organize PivotTable Data
- filter PivotTable Data
- Format a PivotTable
- Refresh and Change PivotTable Data
WORKING WITH PIVOTCHARTS
- Create a PivotChart
- Manipulate PivotChart Data
- Format a PivotChart
Advanced Tools
- Using the Database Functions
- Using the Statistics Functions
- Descriptive Statistics Functions
- Inferential Statistics
- Optimization Modeling with Solver
Workshop Wrap-Up
At the end of the course, students will have an opportunity to ask questions.
