DATA ANALYTICS WITH SPSS AND EXCEL

data analytics
data analysis with Excel and SPSS

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

Date : July 17th, 2024

Duration: 3 weeks

BOTH SPSS AND EXCEL : N20,000 .

EXCEL ALONE: N15,000

SPSS ALONE: N15000

Interested participants should click the link below to join the Mobilization group

๐Ÿ‘‡๐Ÿ‘‡๐Ÿ‘‡๐Ÿ‘‡๐Ÿ‘‡๐Ÿ‘‡๐Ÿ‘‡๐Ÿ‘‡๐Ÿ‘‡๐Ÿ‘‡๐Ÿ‘‡๐Ÿ‘‡๐Ÿ‘‡๐Ÿ‘‡๐Ÿ‘‡๐Ÿ‘‡

CLICK HERE

ย 

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.