Special Offer and Next Steps - Codanics

Course Content

Introduction (Day-1)

0/1

What will you learn and Registration Process

How to enroll in this course?

0/1

Enrolment Process

Important Information (only for enrolled students)

0/1

Important Announcements for Enrolled Students

Zoom Meeting – 1

0/4

Where can you get everything about this course?

Microsoft Excel and Installation (Course Plan)

Data is Everywhere

Complete Course Plan

Special Offer

0/1

Special Offer and Next Steps

Data is Everywhere

0/1

Data is Everywhere and Data Analyst Demand is Increasing

Data Analyst Jobs and Profiles

0/3

Data Analyst Job Roles and Profile

Important Skills, tools and Qualifications to be a Data Analyst

Data Analysts Roles in Railways

Zoom Meeting – 2

0/1

Zoom Meeting Link and Time

Scales/Levels of Measurements

0/2

Nominal vs. Ordinal Scales (Categorical Data)

Interval vs. Ratio Scales (Numerical Data)

Data Collection

0/2

Data Collection Methods

Data Collection Measurement Errors

Data Types

0/1

Primary Data vs. Secondary Data

How to ask Questions in this course?

0/1

Discord Server for this course

Data Types in Detail

0/9

Primary vs. Secondary Data

Qualitative vs. Quantitative Data | Discreet and Continuous Numeric Data

Categorical Data | Nominal and Ordinal Data Types

Time Series Data for Data Analysts

Cross-sectional and Longitudinal Data

Spatial data or GIS Data

Multidimensional Data and its importance for Data Analysts

Structured vs. Un-structured vs. Semi-structured data

Next ZooM Meeting Details and Time

0/1

Zoom Meeting of enrolled students 30.06.2024

MS Excel (Part-1)

0/3

Introduction and Basics of MS Excel

Task and Assignment

How to submit the task and Assignment

MS Excel (Part-2)

0/15

Master Microsoft Excel for Data Analysis in 10 steps

Auto Fitting Rows and Columns in Microsoft Excel

Pasting and Formatting Dates in Excel

Data Tables in Excel

Serial Numbers in Excel

Add current date and time in Microsoft Excel

Hyperlinks in Microsoft Excel

Dynamic Interactive chart in Microsoft Excel

Mean, standard Deviation and Standard Error Calculation in MS EXCEL

Descriptive Statistics in MS Excel |Hindi/Urdu

Percent Calculation in MS Excel

Correlation and Linear Regression in MS Excel

IQR (Interquartile range) in Microsoft Excel

CV (Coefficient of Variation) in Microsoft Excel

t-test in Microsoft Excel

MS Excel (Part-3)

0/68

Introduction to MS EXCEL

Excel Basics Knowledge

Change alphabets in upper & lower case in excel

Add rows and columns in excel

Select entire row & entire column in excel

Group & ungroup data in excel

Delete blank rows in excel

Convert numbers into words using excel

Combine Data in one column using excel

Add date in excel

Calculate age in excel

Calculation with Dates

Compare data in Excel

Change date format in excel

Calculate time difference in excel

DAX in MS Excel

Checkbox in MS Excel

Insert Excel in PPT

Insert image in excel

Insert PPT/PDF in excel

Convert PDF to Excel

Insert tickmarks in MS Excel

Insert watermark in excel

Set cell size in excel

Create barcodes in excel

Excel flash Fill

Add hyperlink in excel

Round off formula in excel

Calculate standard deviation in excel

Sort by date in excel

Sort data set in Excel

Slicers and Filters in Excel

Add filters in Excel

Goal Seek in Excel

Add drop down list in Excel

Data Validation in Excel

Lock (Protect) cells in MS Excel

Excel print page setup

Conditional Formatting in Excel

Remove duplicates in excel

Calculate percentage in excel

Autofill in Excel

Highlight duplicates in excel

Charts In excel

Progress tracker in Excel

Gantt Chart in Excel

Mail Merge in Excel

vLookup Function (A complete Basic Guide)

Vstack Function In Excel

Indirect Function in Excel

Web query in Excel

User form in Excel

Recover unsaved files in excel

Project planning and Gantt chart in Excel

MIS (Management Information System) Reports in Excel

Time series analysis (Complete Basic Guide)

Dashboard in Excel (Part-1)

Power Query in Excel

Dashboard in Excel (Part-2)

Shortcut Keys in MS Excel

Logical Test in MS Excel

IF Function in MS Excel

NESTED IF Function in MS Excel

NOT Function & IF ERROR Function in MS Excel

AND Function in MS Excel

Auditing Tools in MS Excel

Maths & Trigonometric Functions in MS Excel

Announcement about Zoom meeting 07.07.2024

0/1

No Zoom meeting on 07.07.2024

What we have learned so far?

0/1

Master MS Excel

Zoom Meeting-3

0/1

Next Zoom Meeting

Advance Excel Tips

0/2

Questions and Answers about lectures

Advances tips in MS Excel about functions and formula

Excel Tips for Formula Sheet

0/2

MS Excel Tips in Formula Basics to Intermediate

MS Excel Tips Joining Text and Numbers

Zoom Meeting-4 (21 July 2024)

0/1

Zoom Meeting will be at 17:00 on 21.07.2024

Lecture Day 21 07 2024

0/3

Mastering Excel’s Data Analysis ToolPak: Essential Skills for Data Analysts

Question Answer Session 21 07 2024

Assignment before next session

Statistics for Data Analysis (Part-1)

0/13

Introduction to Statistics

But what is statistics?

Content of the course

Why Statistics is Important for Data Scientists/Analysts?

Scales/Levels of Measurement in statistics

Qualitative vs. quantitative Data

Discrete vs. Continuous vs. Binary Data types

Time Series Data

Categorical vs. Ordinal Categorical Data

Multivariate Data

Structured vs. Unstructured Data

Boolean Data type or Binary Data

Statistics for Data Analysis (Part-2)

0/9

Operationalization and proxy measurements

Surrogate Endpoints in statistics

True and Error Score

Types of Errors in Data Collection

Type-I and Type-II errors

Reliability and validity

Measurement and Data Bias

How to remove bias?

Statistics for Data Analysis (Part-3)

0/4

Types of Statistics or Statistical Analysis

Why is statistics important to learn?

Data Analysis and Types of Data Analysis

Central Tendency: Mean, Median, and Mode

Data Analyst Summer Bootcamp 2024

Join the conversation

Umar Mehmood 1 month ago

Thank You Sir

Reply

0% Complete