Description

3 Weeks Intensive Hands on training on Data Analysis using EXCEL and SPSS WITH A Special Class on using AI for Data Analysis

Here comes an opportunity you should never miss.
LEARNING DATA ANALYSIS FROM BEGINNERS TO ADVANCED LEVEL

Duration: 3 weeks

Excel DA Outline

 Advanced Formulas and Functions (IF, Text, Lookups, Date & Time, Financial, Medical, Statistical, etc)
 Pivot Tables and Pivot Charts
 Data Validation
 Sparklines
 Working with Charts and Slicers
 Conditional Formatting with formulas
 Managing large worksheets
 What If Analysis
 Flash Fill
 Quick Analysis
 Predictive Analysis
 Errors in Excel
 Printing Worksheets
 Solving different Excel problems

Special Class on using AI for Data Analysis

 Prompt Engineering for Data Analysis
 Microsoft Copilot
 Top AI tools for data analysis

SPSS Competency Course Outline:

1. Installing and Starting SPSS.
2. Components/Features of SPSS.
3. Variables (Dependent and Independent)
4. Entering Data and Variables.
5. Importing and Exporting of Data
6. Data Cleaning and manipulation.
7. Creating and Working with Unique IDs
8. Descriptive Analysis 1: Frequencies and Descriptives.
9. Understanding Analysis Output in SPSS.
10. Descriptive Analysis 2: Crosstabs and Charts.
11. Advanced data analysis using correlation and regression.
12. Statistical Tests (Means, T-test, One-way ANOVA).
13. Output in SPSS: Saving and Printing.