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
What Is Data? & The Steps of Data Analytics - Full Video | දත්ත යනු මොනවාද? සහ දත්ත විශ්ලේශණයේ පියවර - සම්පූර්ණ කොටස
For Additional Reading & Watching | අමතර කියවීම් සහ නැරඹීම් සඳහා
Discussion & FAQ 01 | ප්‍රශ්න සාකච්ඡා කිරීම 01
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
Getting the Skills for Data Science 01 | දත්ත විද්‍යාව ප්‍රගුන කිරීමට අවශ්‍ය කුසලතා 01
Getting the Skills for Data Science 02 | දත්ත විද්‍යාව ප්‍රගුන කිරීමට අවශ්‍ය කුසලතා 02
Discussion & FAQ 02 | ප්‍රශ්න සාකච්ඡා කිරීම 02
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
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 මෙහෙයුම
Advanced Excel Mastery: Workshop Recording
Day 01 : 2021.07.05
Day 02 : 2021.07.12
Day 03 : 2021.07.19
Day 04 : 2021.07.26
Day 05 : 2021.08.02
Day 06 : 2021.08.09
Day 07 : 2021.08.16
Day 08 : 2021.08.23
Course | පාඨමාලාව
Job Roles | රැකියා කාර්යභාරය
Evolution of Websites | වෙබ් අඩවි වල විකාශනය
Timeline of Responsive Websites | Responsive වෙබ් අඩවි වල කාල රේඛාව
Web Browser | වෙබ් බ්‍රවුසරය
Browser Consoles | බ්‍රවුසරයේ හැසිරවීම් පුවරුව
IP Address & Local Servers | IP ලිපිනය සහ ස්ථානීය සර්වර
Chrome Remote Debugging
Custom Media Queries - Part 01 | 01 වන කොටස
Custom Media Queries - Part 02 | 02 වන කොටස
Exercise - Part 01 | අභ්‍යාසය - 01 වන කොටස (Media Queries)
Exercise - Part 02 | අභ්‍යාසය - 02 වන කොටස (Media Queries)
What is Bootstrap & How to Setup It? | Bootstrap යනු කුමක්ද සහ එය පිහිටුවන්නේ කොහොමද?
Boostrap Grid System - Part 01 | Bootstrap ජාල පද්ධතිය - 01 වන කොටස
Boostrap Grid System - Part 02 | Bootstrap ජාල පද්ධතිය - 02 වන කොටස
Other Bootstrap Classes & Components | වෙනත් Bootstrap Classes සහ උපාංග
Exercise - Part 01 | අභ්‍යාසය - 01 වන කොටස (Bootstrap)
Exercise - Part 02 | අභ්‍යාසය - 02 වන කොටස (BootStrap)
Webmaster Tools
Google Analytics
Wayback Machine
Special Instructions - Part 01 | විශේෂ උපදෙස් - 01 වන කොටස
Special Instructions - Part 02 | විශේෂ උපදෙස් - 02 වන කොටස
Special Instructions - Part 03 | විශේෂ උපදෙස් - 03 වන කොටස
Introduction to PHP
Setup PHP
Syntax - Part 01
Syntax - Part 02
Data Types
Variables - Part 01
Variables - Part 02
Variables - Part 03
Variables - Part 04
Echo and Print
Math Functions
PHP Constants
Introduction - Full Video
Use Cases - Full Video
Azure Machine Learning Platform - Full Video
Experiments & Data Sources - Full Video
Vehicle Price Predictions - Full Video
Data Cleaning - Full Video
Algorithms - Full Video
Completed Model - Full Video
Publishing Model - Full Video
Future Trends - Full Video
Introduction to the Java Course
1-Introduction_to_Programming
2-Java_Background
3-Run_First_Java_Program
1-Netbeans_IDE
2-Java_Variables_and_Datatypes
3-Java_Arithmetic_Operators
4-Java_Assignment_Operators
5-Java_Comparison_Operators
6-Java_Logical_Operators
7-Java_IF_ELSE
8-Java SWITCH_CASE
9-Java_WHILE_LOOP
10-Java_FOR_LOOP
1-Java_Class_and_Object_Introduction
2-Java_Class_and_Object_Implementation
3-Java_Methods
4-Java_Methods_Classes_Objects_1
5-Java_Methods_Classes_Objects_2
6-Java_Constructor
7-Java_this_Keyword
1-Java_Encapsulation
2-Java_Packages
3-Java_Package_Import
4-Java_Inheritance_1
5-Java_multilevel_Inheritance_hierachial_inheritance
6-Polymorphism_Method_Overloading
7-Polymorphism_Method_Overriding
8-Runtime_Polymorphism
9-Abstraction_with_Abstract_Class
10-Abstraction_with_Interfaces
11-Multiple_Inheritance_with_Interfaces
12-Private_Access_Modifier
13-Default_Access_Modifier
14-Protected_Access_Modifier
15-Public_Access_Modifier
1-Java_Exceptions_Intro
2-Java_Exceptions_Practical
3-Exception_Handling_TRY_CATCH
1-Java_User_Input
2-Java_Writing_to_File
3-Java_Reading_from_File
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
Blockchain : Brief Introduction
Blockchain : Introduction
Blockchain : Industry
Blockchain : How it Works?
Blockchain : Mining
Blockchain : Wallets
Blockchain : Meta Mask
Blockchain : Ethereum
Blockchain : Solidity
Blockchain : Coding - Part 01
Blockchain : Coding - Part 02
Blockchain : Coding - Part 03
Blockchain : Deploying Contracts
Blockchain : Q & A
AI Chatbot Development - Course Introduction
Introduction to Document AI & Chatbots - Part 01
Introduction to Document AI & Chatbots - Part 02
AI Chatbot Development - Downloads
Natural Language Processing Fundamentals
Designing the Document AI Chatbot
Developing the Chatbot
Introduction to Hugging Face
Let's Build a Chatbot - Part 01
Let's Build a Chatbot - Part 02
Let's Build a Chatbot - Part 03
Let's Build a Chatbot - Part 04
Let's Build a Chatbot - Part 05
AI Chatbot Development - Course Ending
Artificial Intelligence - Course Introduction
Introduction to Al - Part 01
Introduction to Al - Part 02
Python for Al - Part 01
Python for Al - Part 02
Python for Al - Part 03
Python for Al - Part 04
Python for Al - Part 05
Supervised Learning - Part 01
Supervised Learning - Part 02
Supervised Learning - Part 03
Unsupervised Learning - Part 01
Unsupervised Learning - Part 02
Deep Learning - Part 01
Deep Learning - Part 02
Deep Learning - Part 03
Natural Language Processing - Part 01
Natural Language Processing - Part 02
Natural Language Processing - Part 03
Al Model Development - Part 01
Al Model Development - Part 02
Al Model Development - Part 03
Model Optimization
Open AI API
Artificial Intelligence Course - Data Sets
Introduction to Unity - Full Video | Unity හඳුන්වාදීම - සම්පූර්ණ කොටස
Tools, UI and Workflow - Full Video | උපාංග හා මෙහෙයුම් හදුන්වාදීම - සම්පූර්ණ කොටස
Developing the First Game - Full Video | පළමු ක්‍රීඩාව නිර්මාණය කිරීම - සම්පූර්ණ කොටස
Programming 01 - Full Video | කේත කිරීම 01 - සම්පූර්ණ කොටස
Setup the Camera - Full Video | කැමරාව හැසිරවීම - සම්පූර්ණ කොටස
Gameplay Area - Full Video | ක්‍රීඩා අවකාශය - සම්පූර්ණ කොටස
Collectables - Full Video | එකතුවන් - සම්පූර්ණ කොටස
Programming 02 - Full Video | කේත කිරීම 02 - සම්පූර්ණ කොටස
Scores - Full Video | ලකුණු - සම්පූර්ණ කොටස
Publishing - Full Video | පල කිරීම - සම්පූර්ණ කොටස
Corporate Communication Soft Skills Training : Course Introduction
Communication Basics - Part 01
Communication Basics - Part 02
Communication Basics - Part 03
Communication Basics - Part 04
Communication Basics - Part 05
Better Communicator - Part 01
Better Communicator - Part 02
Better Communicator - Part 03
Better Communicator - Part 04
Why We Do? What We Do? - Part 01
Why We Do? What We Do? - Part 02
Why We Do? What We Do? - Part 03
Practical Knowledge - Part 01
Practical Knowledge - Part 02
Practical Knowledge - Part 03
Final Words
ඔබත් රැස්වීමකදි කතා කරන්න බයද?
Boss වැඩක් කියනකොට ඔයත් මෙහෙම කරනවද?
සෑම ආයතන සේවකයෙක්ම, ප්‍රධානියෙක්ම දැනගත යුතුයි
මේ Skill එක නැත්නම් Job Interviews ගිහින් වැඩක් නෑ
Introducing Yourself in Any Situation - Part 01
Introducing Yourself in Any Situation - Part 02
Casual Conversations - Getting to Know your Colleagues
Conversations at Workplace - Part 01
Conversations at Workplace - Part 02
Conversations at Workplace - Part 03
Daily Scrum Meetings
Design Meetings
Client Meetings - Part 01
Client Meetings - Part 02
Client Meetings - Part 03
General Email Etiquette
Introductory Emails - Part 01
Introductory Emails - Part 02
Emails Requesting Feedback
How to Use this Training?
How to Improve Your Pronunciation?
Getting Over Fear - Tips to Speak English Confidently
Grammar is Your Friend
AI Mantharaya - Course Introduction
Use AI in Sinhala Mode
AI Can Generate Excel Files?
Excel Macro Automation using AI?
AI Can Generate Your Word Document
AI Can Generate Images?
Making an AI ChatBot
How To Make A Video Silence Remover
How To Make A Hand Gesture Tool
Introduction of Python
Python Installation
Access Jupyter Notebook files with Jupyter Notebook
Jupyter Notebook - Walk through Tutorial
Getting Started with Python
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
Extra Tree - Theory
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
Course Introduction - Devops
Course Structure & Flow
What is DevOps & Why?
DevOps in Practice
Linux
Linux Demo Session
Version Controlling - Git
Git Demo Session
Build & Package Management Tools
Build & Build Artifacts Demo Session
Summary of Prerequisite Lessons
Build Artifact Repository Managers
Artifact Repositories Demo Session
Containers & Docker
Docker Demo Session
Cloud & IaaS
Connecting the Flow
CI CD
CI CD Integration with Cloud
Kubernetes
Managed Kubernetes
Infrastructure Automation(IaC)
Configuration Management
Scripting
Recap & Next Steps
DevOps 101 Bootcamp FAQ - Private WhatsApp Group
DevOps 101 Bootcamp - Assessment

Introduction

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

Getting to Know Excel

2-0 - Getting to Know Excel
2-1 - Understand Column - Row - Cell
2-2 - Active Cells - Range - On Cell - In 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

Dealing with Cell Values and Data

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

Mathematical and Statistical Functions

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

Text Functions

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

Date and Time Functions

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

Financial and Other 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

Logical 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

Lookup Functions

9-0 - Introduction to Lookup Functions
9-1 - V-Lookup Simple
9-2 - V-Lookup Detailed
9-3 - V-Lookup Exercise Solution
9-4 - Simple X-Lookup
9-5 - X-Lookup in Detail
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

Other Features and Areas

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

New Functions

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
11-26 - Scan Function
11-27 - ByCol and ByRow Functions

Ai Developments in MS Excel

12-0 - Introduction to Ai and Excel

Ai Developments in MS 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

Excel - Get help from Ai - LLMs (ChatGPT)

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

Ai and Excel - ChatGPT for Excel Add-in

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

The Bricks - Fully Ai Magical Spreadsheet Tool

15-1 - TheBricks - Magical AI Excel Tool

Exercise - Commission Calculation

16-1 - Commission Calculation - Excercise Overview
16-2 - Commission Calculation - Solution Simple Example
16-3 - Commission Calculation - Solution to Complex Example

Final Exercise

17-1 - Final Exercise Overview
17-2 - Final Exercise Solution

Comments

There are no comments yet