Pivot Table from Range vs Table – පරාසයක් මත පිවට් වගුව vs වගුවක් මත පිවට් වගුව

Microsoft Excel Master Course in Sinhala (සිංහල): From Basic to Pro - Step by Step Pivot Table from Range vs Table - පරාසයක් මත පිවට් වගුව vs වගුවක් මත පිවට් වගුව

Microsoft Excel Master Course in Sinhala (සිංහල): From Basic to Pro - Step by Step

0% Completed

Introduction

About the Instructor - පුහුණුකරු පිළිබඳව

Video - 00:3:30 mins

Requirements and How to get MS 365 - අවශ්‍යතා සහ MS 365 ලබාගන්නේ කෙසේද?

Video - 00:8:44 mins

Create New Excel File - නව Excel ගොනුවක් සාදන්න

Video - 00:6:21 mins

Download Resources - Resource folder Download කරන්නේ කෙසේද?

Reading

How to use the Resource Folder - Resource Folder භාවිතා කරන ආකාරය

Video - 00:4:24 mins

Getting to Know Excel

Introduction - හැඳින්වීම

Video - 00:1:1 mins

Understand Column - Row - Cell - Column තේරුම් ගැනීම

Video - 00:5:45 mins

Active Cells - Range - On Cell - In Cell

Video - 00:4:15 mins

Understand Basic Data Types - Create a Basic Table - මූලික දත්ත වර්ග තේරුම් ගන්න

Video - 00:6:8 mins

Changing Data in a Cell - සෙල් හි දත්ත වෙනස් කිරීම

Video - 00:2:9 mins

Move between the cells - සෛල අතර ගමන් කිරීම

Video - 00:10:8 mins

Practice - Move between the cells - සෛල අතර ගමන් කිරීම

Video - 00:2:18 mins

Data Selection - දත්ත තේරීම

Video - 00:10:22 mins

Data Selection - Goto - දත්ත තේරීම - Goto

Video - 00:5:37 mins

Undersand the Search Bar - සෙවීමේ තීරුව තේරුම් ගන්න

Video - 00:2:40 mins

Understand the Name Box and Name Manager

Video - 00:9:49 mins

Understanding the Formula Bar

Video - 00:5:39 mins

Tabs - Groups - Sliders - Zoom - Quick Access

Video - 00:8:27 mins

Dealing with Cell Values and Data

Introduction - හැඳින්වීම

Video - 00:1:8 mins

Simple Copy, Cut and Drag - සරල පිටපත් කිරීම, කැපීම සහ ඇදගෙන යෑම

Video - 00:11:58 mins

Copy Cut and Drag - Range - සරල පිටපත් කිරීම, කැපීම සහ ඇදගෙන යෑම - සෛල පරාසය

Video - 00:6:7 mins

Drag and Drop - Detailed with Shortcuts - ඇදගෙන යාම සහ හැර දැමීම සවිස්තරාත්මකව

Video - 00:5:48 mins

Fill Handle

Video - 00:8:48 mins

Insert and Delete Rows and Columns - Rows සහ Columns ඇතුළත් කිරීම සහ මකා දැමීම

Video - 00:9:43 mins

Adjusting the size of the Rows and Column - Rows සහ Columns ප්‍රමාණය සැකසීම

Video - 00:4:19 mins

Hide and Unhide Rows - Columns - Sheets - සැඟවීම සහ නැවත දිස්වීම

Video - 00:11:43 mins

Up - Down - Right - Left Fill Options

Video - 00:5:51 mins

Let's Start with a Simple Formula

Video - 00:4:48 mins

Mathematical and Statistical Functions

Introduction - හැඳින්වීම

Video - 00:1:2 mins

Clipboard in Detail - Clipboad විස්තරාත්මකව

Video - 00:9:48 mins

Understand the Font Group - තේරුම් ගන්න

Video - 00:7:43 mins

Calculations vs Formulas vs Functions

Video - 00:10:32 mins

Sum Function

Video - 00:12:45 mins

Min - Max - Average - Small - Large Functions

Video - 00:015:20 mins

Number format in Detail - අංක ආකෘතිය විස්තරාත්මකව

Video - 00:11:13 mins

Sparkline and Column

Video - 00:02:40 mins

Round - Roundup, Rounddown, Int, Abs Functions

Video - 00:13:42 mins

Subtotal - Filter - Introduction to Conditional Formatting

Video - 00:15:28 mins

Table, Filter and Slicer

Video - 00:12:48 mins

Quotient and Mod Functions

Video - 00:4:29 mins

Absolute vs Relative Cell References

Text Functions

Introduction - හැඳින්වීම

Video - 00:1:12 mins

Right Function - Flash Fill - Text to Col

Video - 00:09:31 mins

Left Function

Video - 00:03:7 mins

Mid Function

Video - 00:06:20 mins

Len Function

Video - 00:01:29 mins

Len + Left and Right Functions

Video - 00:07:2 mins

Text to Column Option in Detail

Video - 00:06:34 mins

Flash Fill in Detail

Video - 00:09:9 mins

Concat and TextJojn Functions

Video - 00:05:51 mins

Trim Function

Video - 00:01:45 mins

Choose Function

Video - 00:06:58 mins

Case Functions - Upper - Lower - Proper

Video - 00:01:46 mins

Find and Search Functions

Video - 00:03:40 mins

Substitute Function

Video - 00:02:55 mins

Replace Function

Video - 00:04:20 mins

Rept Function

Video - 00:04:55 mins

Text Function

Video - 00:07:26 mins

Date and Time Functions

Introduction - හැඳින්වීම

Video - 00:00:47 mins

Understanding Date and Time in Excel - Excel හි දිනය සහ වේලාව තේරුම් ගැනීම

Video - 00:19:27 mins

Date Formatting - දිනයේ ආකෘතිකරණය

Video - 00:04:21 mins

Current Date and Time - Function and Shortcuts - වත්මන් දිනය සහ වේලාව

Video - 00:03:17 mins

Construct Date and Time using Functions - දිනය සහ වේලාව නිර්මාණය කිරීම

Video - 00:02:44 mins

DeConstruct Date and Time using Functions - දිනය සහ වේලාව විවරණය කිරීම

Video - 00:06:38 mins

Datedif Function in detail

Video - 00:09:6 mins

Other Date Functions

Video - 00:12:51 mins

Financial and Other Functions

Introduction - හැඳින්වීම

Video - 00:01:10 mins

Loan Amortization Calculation - ණය කප්පාදු ගණනය

Video - 00:09:43 mins

PV and FV Functions

Video - 00:06:49 mins

NPV, IRR and RATE Functions

Video - 00:08:7 mins

Information Functions - තොරතුරු Functions

Video - 00:9:57 mins

Unique Fuction in Detail

Video - 00:9:58 mins

Sort and Sortby Functions

Video - 00:10:23 mins

Sequence Function

Video - 00:8:3 mins

Random Functions

Video - 00:17:22 mins

Logical Functions

Introduction - හැඳින්වීම

Video - 00:50:00 mins

Simple IF Function

Video - 00:9:59 mins

Absolute Cell Reference in Detail

Video - 00:12:24 mins

IF Function - Next Step

Video - 00:7:38 mins

IFS Function

Video - 00:17:28 mins

AND and OR Functions

Video - 00:10:6 mins

IF with AND and OR Functions

Video - 00:14:27 mins

SumIF - SumIFS - AverageIF - AverageIFS Functions

Video - 00:13:39 mins

Count - Counta - CountBlank Functions

Video - 00:5:58 mins

Countif - Countifs Functions

Lookup Functions

Introduction - හැඳින්වීම

V-Lookup Exercise Solution

X-Lookup Exercise Solution

Video - 00:2:51 mins

X-Lookup vs V-Lookup and Grouping

Video - 00:7:54 mins

Index - Match Functions

Video - 00:9:37 mins

Offset Function

Video - 00:17:33 mins

Transpose Paste and Transpose Function

Video - 00:5:46 mins

Row - Column - Rows - Columns Functions

Video - 00:13:23 mins

Address Function

Video - 00:6:23 mins

Indirect Function

Video - 00:10:48 mins

Hyperlink Feature and Hyperlink Function

Video - 00:8:22 mins

Other Features and Areas

Introduction - හැඳින්වීම

Video - 00:51:00 mins

Conditional Formatting Ultimate Lesson

Video - 00:26:19 mins

Conditional Formatting - Automatic Bordering

Video - 00:4:17 mins

Column - Pie - Line Charts

Video - 00:19:13 mins

Introduction to Simple Pivot Table - සරල පිවට් වගුවකට හැඳින්වීම

Video - 00:7:44 mins

Pivot Table from Range vs Table - පරාසයක් මත පිවට් වගුව vs වගුවක් මත පිවට් වගුව

Video - 00:3:16 mins

Dashboard from Pivot Table - පිවට් වගුවෙන් ඩෑෂ්බෝඩ් එකක්

Video - 00:25:57 mins

Insert Shape - Picture and Icons - හැඩසවිය, පින්තූර සහ අයිකන් ඇතුළත් කරන්න

Video - 00:6:32 mins

SmartArt - Process - Hyrarchy - Cycle

Video - 00:9:12 mins

Insert Sparklines - Win or Loss

Get Data from Different Sources - වෙනස් මූලාශ්‍රවලින් දත්ත ලබාගන්න

Video - 00:7:3 mins

Remove Duplicates - අනුනාමික දත්ත ඉවත් කරන්න

Video - 00:3:39 mins

Data Validation

Video - 00:21:23 mins

Data Validation - Dropdown and Dependent Drop Down list

Video - 00:20:51 mins

Consolidate Data

Video - 00:6:41 mins

What-If Analysis - Goal Seek

Video - 00:17:22 mins

What-If Analysis - Data Table

Video - 00:16:26 mins

Grouping and Ungrouping

New Functions (Modern)

Introduction - හැඳින්වීම

Video - 00:1:46 mins

Image Function

Video - 00:13:57 mins

Let Function

Video - 00:15:18 mins

TextSplit Function

Video - 00:11:4 mins

TextBefore and TextAfter Functions

Video - 00:13:48 mins

ArrayToText Function

Video - 00:10:47 mins

Regular Expressions RegExTest - RegExReplace - RegExExtract

Video - 00:12:37 mins

Regular Expressions RegExExtract - Extract Date

Video - 00:4:6 mins

Regular Expressions RegExExtract - Extract Email

Video - 00:6:24 mins

Regular Expressions RegExExtract - Multiple Data

Video - 00:2:45 mins

ChooseCols and ChooseRows Functions

Video - 00:12:54 mins

Understanding ChooseCols vs Choose

Video - 00:7:6 mins

ChooseCols and ChooseRows Advanced

Video - 00:9:5 mins

Understanding the Take Function

Video - 00:4:34 mins

Take Function Advanced Examples

Video - 00:14:59 mins

Drop Function

Video - 00:5:38 mins

Understanding VStack Function

Video - 00:3:49 mins

VStack Function in Detail

Video - 00:13:16 mins

ToCol and ToRow Functions

Understanding Lambda Function

Video - 00:11:57 mins

Lambda Function - Paye Tax Calculation

Video - 00:6:23 mins

Lambda Function Advanced Usage

Video - 00:9:33 mins

Map Function with LAMBDA

Video - 00:5:50 mins

Scan Function

Video - 00:9:26 mins

ByCol and ByRow Functions

Video - 00:12:31 mins

Ai Developments in Excel

Introduction - හැඳින්වීම

Video - 00:1:43 mins

Ai in Excel - Flash Fill

Video - 00:3:6 mins

Ai in Excel - Forecast

Video - 00:6:11 mins

Ai in Excel - Recommended PivotTables

Video - 00:2:34 mins

Ai in Excel - Recommended Charts

Video - 00:2:6 mins

Ai in Excel - Analyze Data

Video - 00:5:30 mins

Ai in Excel - Data from Screenshot

Video - 00:6:23 mins

Excel – Get help from Ai – LLMs (ChatGPT)

ChatGPT - Simple Function help - සරල ක්‍රියාවලිය සඳහා උදව්

Video - 00:6:40 mins

ChatGPT - Error Handling - දෝෂ හසුරුවීම

Video - 00:2:56 mins

ChatGPT - Step-by-Step Guide - පියවරෙන් පියවර මාර්ගෝපදේශය

Video - 00:3:00 mins

ChatGPT - Find Shortcuts - කෙටි මාර්ග සොයන්න

Video - 00:3:14 mins

ChatGPT - Extract Text - පෙළ උපුටා ගැනීම

Video - 00:2:28 mins

ChatGPT - Help wth Complex Formulas - සංකීර්ණ සූත්‍ර සඳහා උදව්

Video - 00:4:8 mins

Ai and Excel – ChatGPT for Excel Add-in

ChatGPT for Excel - Ai.ASK

Video - 00:9:43 mins

ChatGPT for Excel - Ai.LIST

Video - 00:3:49 mins

ChatGPT for Excel - Ai.TABLE

Video - 00:3:8 mins

ChatGPT for Excel - Ai.TRANSLATE

Video - 00:1:52 mins

ChatGPT for Excel - Ai.FILL

Video - 00:2:7 mins

ChatGPT for Excel - Ai.EXTRACT

Video - 00:2:4 mins

ChatGPT for Excel - Ai.CHOICE

Video - 00:2:23 mins

The Bricks – Fully Ai Excel like Tool

The Bricks

Video - 00:17:34 mins

Exercise – Commission Calculation

Commission Calculation - Excercise Overview - කොමිෂන් ගණනය - අභ්‍යාස සාරාංශය

Video - 00:3:5 mins

Commission - Solution Exercise 1 - කොමිෂන් ගණනය - සරල අභ්‍යාසය සඳහා විසඳුම

Video - 00:5:1 mins

Commission - Solution to Exercise 2 - කොමිෂන් ගණනය - අභ්‍යාසය 2 සඳහා විසඳුම

Video - 00:12:29 mins

Final Exercise

Final Exercise Overview - අවසන් අභ්‍යාසය පිළිබඳ සාරාංශය

Video - 00:6:6 mins

Final Exercise Solution - විසඳුම

Video - 00:20:42 mins

Announcements Reviews Live Classes Gradebook Certificate Course Info

Previous Next

Complete the course to unlock the certificate

Microsoft Excel Master Course in Sinhala (සිංහල): From Basic to Pro - Step by Step Pivot Table from Range vs Table - පරාසයක් මත පිවට් වගුව vs වගුවක් මත පිවට් වගුව

Microsoft Excel Master Course in Sinhala (සිංහල): From Basic to Pro - Step by Step