Become a Teacher
Online Money Making
Menu
Introduction to Data Science 01 | දත්ත විද්‍යාව ගැන හැදින්වීම 01
Introduction to Data Science 02 | දත්ත විද්‍යාව ගැන හැදින්වීම 02
Introduction to Data Science 03 | දත්ත විද්‍යාව ගැන හැදින්වීම 03
Introduction to Data Science 04 | දත්ත විද්‍යාව ගැන හැදින්වීම 04
Introduction to Data Science 05 | දත්ත විද්‍යාව ගැන හැදින්වීම 05
For Additional Reading & Watching | අමතර කියවීම් සහ නැරඹීම් සඳහා
Solving Problems with Data 01 | ප්‍රශ්න විසදීමේ විද්‍යාත්මක ක්‍රමය 01
Solving Problems with Data 02 | ප්‍රශ්න විසදීමේ විද්‍යාත්මක ක්‍රමය 02
Artificial Intelligence & Machine Learning - Full Video | කෘතිම බුද්ධිය සහ යාන්ත්‍රික ඉගෙනීම - සම්පූර්ණ කොටස
Digitization vs Digitalization 01 | ඩිජිටල්කරණය සහ ඩිජිටල් පරිවර්තනය 01
Digitization vs Digitalization 02 | ඩිජිටල්කරණය සහ ඩිජිටල් පරිවර්තනය 02
Probability and Predictions 01 | සම්භාවිතාව සහ පුරෝකතන 01
Probability and Predictions 02 | සම්භාවිතාව සහ පුරෝකතන 02
Managing Data with Excel 01 | නිවැරදි දත්ත රැස් කිරීමේ ක්‍රම 01
Managing Data with Excel 02 | නිවැරදි දත්ත රැස් කිරීමේ ක්‍රම 02
Introduction to Power BI 01 | Power BI හදුන්වාදීම 01
Introduction to Power BI 02 | Power BI හදුන්වාදීම 02
Opportunity in Data Science 01 | දත්ත විද්‍යාව ආශ්‍රිත ක්ෂේත්‍ර 01
Opportunity in Data Science 02 | දත්ත විද්‍යාව ආශ්‍රිත ක්ෂේත්‍ර 02
Opportunity in Data Science 03 | දත්ත විද්‍යාව ආශ්‍රිත ක්ෂේත්‍ර 03

A PHP Error was encountered

Severity: Notice

Message: Trying to access array offset on value of type bool

Filename: courses/follow-course.php

Line Number: 871

Backtrace:

File: /var/www/v2/v2-elearning.lk/application/views/web/courses/follow-course.php
Line: 871
Function: _error_handler

File: /var/www/v2/v2-elearning.lk/application/controllers/Courses.php
Line: 330
Function: view

File: /var/www/v2/v2-elearning.lk/index.php
Line: 319
Function: require_once

Getting the Skills for Data Science 01 | දත්ත විද්‍යාව ප්‍රගුන කිරීමට අවශ්‍ය කුසලතා 01
Getting the Skills for Data Science 02 | දත්ත විද්‍යාව ප්‍රගුන කිරීමට අවශ්‍ය කුසලතා 02
1-1 - About the Instructor
1-2 - How to get MS 365
1-3 - Create New Excel File
1-4 - How to use the Resource Folder
2-0 - Getting to Know Excel
2-1 - Understand Column - Row - Cell
2-3 - Data Type - Create a Basic Table
2-4 - Changing Data in a Cell
2-5 - Move between the cells
2-6 - Move between the cells Practice
2-7 - Data Selection
2-8 - Data Selection - Go To
2-9 - Undersand the Search Bar
2-10 - Understand the Name Box and Name Manager
2-11 - Understanding the Formula Bar
2-12 - Tabs - Groups - Sliders - Zoom - Quick Access
3-0 - Dealing with Cell Values - Introduction
3-1 - Simple Copy, Cut and Drag
3-2 - Copy Cut and Drag - Range
3-3 - Drag ad Drop - Detailed shortcut
3-4 - Fill Handle
3-5 - Insert and Delete Rows and Columns
3-6 - Adjusting the size of the Rows and Column
3-7 - Hide and Unhide Rows - Columns - Sheet
3-8 - Up - Down - Right - Left
3-9 - Simple Formulas
4-0 - Math and Statitical Functions - Introduction
4-1 - Clipboad in Detail
4-2 - Understand the Font Group
4-3 - Calculation vs Formulas vs Functions
4-4 - Sum Function
4-5 - Min - Max - Average - Small - Large
4-6 - Number format in Detail
4-7 - Sparkline and Column
4-8 - Round - Roundup, Rounddown, Int, Abs Functions
4-9 - Product Function
4-10 - SumProduct Fuction
4-11 - Suntotal - Filter - Introduction to Conditional Formatting
4-12 - Filter In Detail
4-13 - Filter Function
4-14 - Table, Filter and Slicer
4-15 - Quotient and Mod Functions
4-16 - Absolute vs Relative Cell References
4-17 - Rank Functions
4-18 - Absolute Function
5-0 - Introduction to Text Functions - Introduction
5-1 - Right Function - Flash Fill - Text to Column
5-2 - Left Function - Flash Fill - Text to Column
5-3 - Mid Function - Flah Fill - Text to Column
5-4 - Len Function
5-5 - Len + Left and Right Functions
5-6 - Text to Column in Detail
5-7 - Flash Fill in Detail
5-8 - Concat and TextJojn Function
5-9 - Trim Function
5-10 - Choose Function
5-11 - Case Functions
5-12 - Find and Search Functions
5-13 - Substitute Function
5-14 - Replace Function
5-15 - Rept Function
5-16 - Text Function
6-0 - Introduction to Date and Time Functions
6-1 - Understanding Date and Time in Excel
6-2 - Date Formatting
6-3 - Current Date and Time - Function and Shortcuts
6-4 - Construct Date and Time using Functions
6-5 - DeConstruct Date and Time
6-6 - Datedif Function in detail
6-7 - Other Date Functions
7-0 - Introduction to Financial and Other Functions
7-1 - Loan Amortization Calculation
7-2 - PV and FV
7-3 - NPV - IRR and RATE Functions
7-4 - Information Functions
7-5 - Unique Fuction in Detail
7-6 - Sort and Sortby Functions
7-7 - Sequence Function
7-8 - Random Functions
8-0 - Introduction to Logical Functions
8-1 - Simple If Function
8-2 - Absolute Cell Reference in Detail
8-3 - If Function Next Step
8-4 - Ifs Function
8-5 - AND & OR
8-6 - If + AND & OR
8-7 - Sumif - SumIfs - AverageIf - AverageIFS
8-8 - Count - Counta - CountBlank Functions
8-9 - Countif - Countifs Functions
8-10 - IfError
8-11 - NOT Function
9-0 - Introduction to Lookup Functions
9-1 - V-Lookup Simple
9-2 - V-Lookup Detailed

A PHP Error was encountered

Severity: Notice

Message: Trying to access array offset on value of type bool

Filename: courses/follow-course.php

Line Number: 871

Backtrace:

File: /var/www/v2/v2-elearning.lk/application/views/web/courses/follow-course.php
Line: 871
Function: _error_handler

File: /var/www/v2/v2-elearning.lk/application/controllers/Courses.php
Line: 330
Function: view

File: /var/www/v2/v2-elearning.lk/index.php
Line: 319
Function: require_once

9-3 - V-Lookup Exercise Solution
9-4 - Simple X-Lookup
9-5 - X-Lookup in Detail
9-6 - X-Lookup Exercise
9-7 - X-Lookup vs V-Lookup & Grouping
9-8 - Index - Match Functions
9-9 - Offset Function
9-10 - Transpose Paste and Function
9-11 - Row - Column - Rows - Columns Functions
9-12 - Address Function
9-13 - Indirect Function
9-14 - Hyperlink Feature and Hyperlink Function
10-0 - Introduction to Other Features and Areas
10-1 - Conditional Formatting Ultimate Lesson
10-2 - Conditional Formatting - Automatic Bordering
10-3 - Charts - Column - Pie - Line Charts
10-4 - Introduction to Simple Pivot Table
10-5 - Pivot Table from Range vs Table
10-6 - Pivot Table with Dashboard
10-7 - Insert Shape - Picture and Icon
10-8 - SmartArt - Process - Hyrarchy - Cycle
10-9 - Insert Sparklines - Win or Loss
10-10 - Slicer in Detail
10-11 - Print Title
10-12 - Get Data from Different Sources
10-13 - Remove Duplicates
10-14 - Data Validation
10-15 - Dropdown and Dependent Drop Down list
10-16 - Consolidate Data
10-17 - Goal Seek Option
10-18 - Data Table
10-19 - Group and Ungroup
10-20 - Freeze Pane
10-21 - Formula Auditing
11-0 - Introduction to Newer Functions
11-1 - Image Function
11-2 - Let Function
11-3 - TextSplit Function
11-4 - TextBefore - TextAfter Functions
11-5 - ArrayToText Function
11-6 - Regular Expressions RegExTest - RegExExtract and RegExReplace
11-7 - Regular Expressions RegExExtract - Date
11-8 - Regular Expressions RegExExtract - EmailE
11-9 - Regular Expressions RegExExtract - Multiple Data
11-10 - ChooseCols - ChooseRows Functions
11-11 - Understanding ChooseCols and Choose
11-12 - ChooseCols and ChooseRows Advanced
11-13 - Understanding the Take Function
11-14 - Take Function Advanced Examples
11-15 - Drop Function
11-16 - Understanding Vstack Function
11-17 - VStack Function in Details
11-18 - ToCol and ToRow Functions
11-19 - WrapRows Function
11-20 - WrapCols Function
11-21 - Xmatch Function
11-22 - Understanding Lambda Function
11-23 - Lambda Function Paye Tax Calculation
11-24 - Lambda Function Advanced Usage
11-25 - Map Function with LAMBDA

A PHP Error was encountered

Severity: Notice

Message: Trying to access array offset on value of type bool

Filename: courses/follow-course.php

Line Number: 871

Backtrace:

File: /var/www/v2/v2-elearning.lk/application/views/web/courses/follow-course.php
Line: 871
Function: _error_handler

File: /var/www/v2/v2-elearning.lk/application/controllers/Courses.php
Line: 330
Function: view

File: /var/www/v2/v2-elearning.lk/index.php
Line: 319
Function: require_once

11-26 - Scan Function
11-27 - ByCol and ByRow Functions
12-0 - Introduction to Ai and Excel
12-1 - Ai in Excel - Flash Fill
12-2 - Ai in Excel - Forecast
12-3 - Ai in Excel - Recommended PivotTables
12-4 - Ai in Excel Recommended Charts
12-5 - Ai in Excel - Analyze Data
12-6 - Ai in Excel - Data from images
13-1 - ChatGPT - Simple Function help
13-2 - ChatGPT - Error Handling
13-3 - ChatGPT - Step-by-Step Guide to break the Formula
13-4 - ChatGPT - Find Shortcuts
13-5 - ChatGPT - Split Text
13-6 - ChatGPT - Help wth Complex Formulas
14-1 - ChatGPT for Excel - Ai.ASK
14-2 - ChatGPT for Excel - Ai.LIST
14-3 - ChatGPT for Excel - Ai.TABLE
14-4 - ChatGPT for Excel - Ai.TRANSLATE
14-5 - ChatGPT for Excel - Ai.FILL
14-6 - ChatGPT for Excel - Ai.EXTRACT
14-7 - ChatGPT for Excel - Ai.CHOICE
15-1 - TheBricks - Magical AI Excel Tool
16-1 - Commission Calculation - Excercise Overview
16-2 - Commission Calculation - Solution Simple Example
16-3 - Commission Calculation - Solution to Complex Example
17-1 - Final Exercise Overview
17-2 - Final Exercise Solution
Microsoft Excel හැදින්වීම
Excel පරිගණකයේ Install කරගන්නා ආකාරය
Excel පරිගණකයේ Open කරගන්නා ආකාරය
Open කරපු Excel File එකක් පරිගණකයේ Save කරගන්නා ආකාරය
Excel workbook සහ worksheet
Excel Worksheet එකක නම වෙනස් කරන ආකාරය
Excel Worksheet එකක් Zoom කරගන්නා ආකාරය
Excel Worksheet එකක් Copy කරගන්නා ආකාරය
Excel Menu අයිතම
Excel Menu අයිතමවල අන්තර්ගතය
Excel Worksheet එකක Columns සහ Rows
Excel Worksheet එකක Cells
Excel වෙත දත්ත ඇතුළත් කරන ආකාරය
Text Formatting සිදු කරන ආකාරය
Border Function එක භාවිත කරන ආකාරය
Freeze Panes භාවිත කරන ආකාරය
Excel වලට පින්තූර ඇතුළත් කරන ආකාරය
Excel මගින් ගණිතමය මෙහෙයුම් සිදු කරන ආකාරය
Excel තුළ Charts භාවිත කරන ආකාරය
Excel තුළ Filter Function එක භාවිත කරන ආකාරය
Excel වල Sort මෙහෙයුම
Excel වල Pivot Table
Excel වල Vlookup මෙහෙයුම සිදු කරන ආකාරය
Excel දත්ත Print කරන ආකාරය
Paste Function එක භාවිත කරන ආකාරය හා වෙනත් Excel Tips
Text File, Excel වල Open කරන ආකාරය
Excel වල Text to Column මෙහෙයුම
Power BI in English : Lesson 01
Power BI in English : Lesson 02
Power BI in English : Lesson 03
Power BI in English : Lesson 04
Introduction to Power BI
What is Data Science & Why Data Analytics?
Power BI Interface
Import & Display Data
Unstructured Data
Power Query
Creating measurements
How to Get Data from the Web?
Multiple Tables
Power BI service
Introduction to Python Programming
Working with Variables
Python Date Time, Calendar, If conditions
Python for Loops Advanced
Python While Loops
Working with Python Dictionaries
Working with Python List
Python Input Methods
Python Functions
Python String Methods
Python Try Catch
Python Object-Oriented Programming i
Python Object-Oriented Programming ii
Python Object-Oriented Programming iii
Python Object-Oriented Programming iv
Working with Files
Python Modules
Introduction to Data Science i
Introduction to Data Science ii
Python Numpy
Python Pandas
Python Visualization i
Python Visualization ii
Q & A Session i
Q & A Session ii
Q & A Session iii
Q & A Session iv
Q & A Session v
Q & A Session vi
Q & A Session vii
Data Science Introductory - Session 01
Data Science Introductory - Session 02
Data Science Introductory - Session 03
Data Science Introductory - Session 04
Data Science for Business - Session 01
Business Analytics with Microsoft Power BI - Session 01
Business Analytics with Microsoft Power BI - Session 02
Business Analytics with Microsoft Power BI - Session 03
Business Analytics with Microsoft Power BI - Session 04
Business Analytics with Microsoft Power BI - Session 05
Business Analytics with Microsoft Power BI - Session 06
Basic Microsoft Excel - Session 01
Advanced Microsoft Excel - Session 01
Advanced Microsoft Excel - Session 02
Advanced Microsoft Excel - Session 03
Advanced Microsoft Excel - Session 04
Advanced Microsoft Excel - Session 05
Advanced Microsoft Excel - Session 06
Advanced Microsoft Excel - Session 07
Advanced Microsoft Excel - Session 08
Advanced Microsoft Excel - Session 09
Advanced Microsoft Excel - Session 10
Advanced Microsoft Excel - Session 11
Data Science for Business - Session 02
Business Analytics with Microsoft Power BI - Session 07
Business Analytics with Microsoft Power BI - Session 08
දත්ත ඉංජිනේරුවෙක් වන හැටි - අලුත්ම data related jobs සහ දත්ත විශ්ලේෂණය
Excel වල මළගම? Co-pilot එක්ක මොනවද කරන්න පුළුවන්
Data Science යනු කුමක්ද? අනාගතයේ grow වෙන ක්ෂේස්ත්‍ර
Advanced Excel Mastery: Workshop Recording
Introduction to Data Science and Analytics
Basic Mathematical Functions
Loss Function
Linear Regression
Supervised Learning Workflow
Classification, Entropy and Information Gain
Getting Started with the Environment
Defining Variables
Linear Regression Line by Line Implementation
Converting Picture to a Numpy Array
Introduction of Python
Python Installation
Access Jupyter Notebook files with Jupyter Notebook
Jupyter Notebook - Walk through Tutorial
Variables - Types
Variables - Usage
Variable - Strings
Variable - Integers, Floats and Boolean
Lists
Tuples
Sets and Dictionaries
If Statements
for loop
While loop
Python Custom Functions
List Comprehensions
Lambda Functions
Built-in Functions
External Libraries
Python Exercise Overview
Python Exercise Solution - part1
Python Exercise Solution - part2
Introduction to Supervised Learning
Machine learning life cycle
Introduction to Performance Evaluation - Classification
Confusion Matrix
Main Classification Metrics
Performance Evaluation - Regression
Introduction to Sklearn
One Hot Encoding
Split the data
What is Fit
Linear Regression - Theory
Linear Regression Salary Prediction - Practical - Part 1
Linear Regression Salary Prediction - Practical - Part 2
Linear Regression House Price Prediction - Practical - Part 1
Linear Regression House Price Prediction - Practical - Part 2
Logistic Regression - Theory
Logistic Regression - Practical - Iris Flower
Logistic Regression - Gender Classification - Exercise Overview
Logistic Regression - Gender Classification - Exercise Solution - Part 1
Logistic Regression - Gender Classification - - Exercise Solution - Part 2
Lasso and Ridge Regression - Theory
Lasso and Ridge Melbourne Housing - Practical - Part 1
Lasso and Ridge Melbourne Housing - Practical - Part 2
Lasso and Ridge Melbourne Housing - Practical - Part 3
Lasso and Ridge - Insurance - Exercise Overview
Lasso and Ridge - Insurance - Exercise Overview - Solution
Bias Variance Trade-off
Dealing with Imbalanced Data
Dealing with Missing Values
Dealing with Outliers - Theory
Dealing with Outliers - Practical
Feature Scaling - Theory
Feature Scaling - Practical
Gaussian Naive Bayes Classifier - Theory
Gaussian Naive Bayes Titanic - Practical - Part1
Gaussian Naive Bayes Titanic - Practical - Part2
Decision Tree - Theory
Decision Tree - Practical - Penguin
Decision Tree - Wine Quality - Exercise Overview
Decision Tree - Wine Quality - Exercise Solutions
Random Forest - Theory
Random Forest - Practical - Bike sharing - Part1
Random Forest - Practical - Bike sharing - Part2
Random Forest - Weather Australia - Exercise Overview
Random Forest - Weather Australia - Solution Part 1
Random Forest - Weather Australia - Solution Part 2
Introduction to Boosting Techniques
Boosting techniques - Theory - Adaboost
Boosting techniques - Theory - Gradient Boosting
Boosting Techniques - Practical - Adult Dataset
Support Vector Machines - Theory
SVM - Practical - Heart Disease Classification
SVM - Water Potability - Exercise Overview
SVM - Water Potability - Exercise Solution
K-Nearest Neighbor - Theory
K-Nearest Neighbor - Practical - Classified Data
K Means Clustering - Theory
K Means Clustering - Practical - Iris
DBSCAN Clustering - Theory
DBSCAN Clustering - Practical
PCA - Principal Component Analysis - Theory
PCA - Practical - Airline Passenger part1
PCA - Practical - Airline Passenger part2
Natural Language Processing - Theory - Introduction
NLP - Naive Bayes Multinomial Classification - Theory
NLP - Practical - Amazon Reviewer Classification - Part 1
NLP - Practical - Amazon Reviewer Classification - Part 2
NLP - Practical - Amazon Reviewer Classification - Part 3
Resources / Downloads: Python for Mastering Machine Learning and Data Science
Looking to build your future?

Comments

There are no comments yet