- 95
- 14 609
IT Plus
Sri Lanka
เข้าร่วมเมื่อ 21 มี.ค. 2021
Discover the pinnacle of ICT education with the 'IT Plus' TH-cam channel, acclaimed as the best destination for comprehensive and cutting-edge information technology (ICT) education. Immerse yourself in a world of insightful tutorials, expert-led courses, and in-depth explorations of the latest trends in the IT industry. Whether you're a novice seeking to build a solid foundation or a seasoned professional aiming to stay ahead, IT Plus is your go-to source for top-notch educational content, offering a dynamic learning experience that empowers individuals to thrive in the ever-evolving field of information technology.
"ICT" stands for Information and Communication Technology, a term that encompasses a broad range of technologies used to manage and communicate information.
The field of ICT encompasses hardware and software components, networks, and the applications that enable the creation, storage, processing, transmission, and retrieval of information.
"ICT" stands for Information and Communication Technology, a term that encompasses a broad range of technologies used to manage and communicate information.
The field of ICT encompasses hardware and software components, networks, and the applications that enable the creation, storage, processing, transmission, and retrieval of information.
21- Microsoft Excel Advanced Tutorials |Find Function | IT Plus (SINHALA)
ඔයාට මෙම වීඩියෝව තුලින් Microsoft Excel වල තියන Len කියන Function එක ගැන දැනුමක් ලබා ගන්න හැකි වෙනවා. ඒ වගේම ඒ Function එක පාවිච්චි කරලා කරන පුංචි උදාහරනයකුත් කතා කරනවා. ඒ තුලින් මේ Function එක යොදාගන්නේ කොයි වගේ අවස්තා වල දී ද කියලත් ඔයාට දැනුමක් ලැබේවි. ඉතින් මම හිතනවා මේ වීඩියෝවත් ඔයාලාට ගොඩක් වැදගත් වෙයි කියලා. එහෙම නම් මේ වීඩියෝ එකත් බලලා ඔයාගේ දැනුමට තවත් අලුත් දෙයක් එකතු කර ගන්න.
Discover how to use the **Find function in Microsoft Excel** to locate specific text or characters within a cell. This versatile tool is essential for data analysis, allowing users to quickly search for and extract precise information from large datasets. Ideal for both beginners and advanced Excel users.
Microsoft Excel - Functions video Link :-
th-cam.com/video/-RRqIMJJPt4/w-d-xo.html
Discover how to use the **Find function in Microsoft Excel** to locate specific text or characters within a cell. This versatile tool is essential for data analysis, allowing users to quickly search for and extract precise information from large datasets. Ideal for both beginners and advanced Excel users.
Microsoft Excel - Functions video Link :-
th-cam.com/video/-RRqIMJJPt4/w-d-xo.html
มุมมอง: 40
วีดีโอ
20- Microsoft Excel Advanced Tutorials |Index & Match Function Examples | IT Plus (SINHALA)
มุมมอง 5321 วันที่ผ่านมา
Learn how to use the "Index and Match functions in Microsoft Excel" to efficiently search, match, and retrieve data. This powerful combination offers greater flexibility than VLOOKUP, enabling advanced data lookups across rows and columns. Perfect for beginners and advanced Excel users looking to enhance their spreadsheet skills. Index & Match Function viedo link: - th-cam.com/video/My_S2zcV5jA...
29 - Adobe Photoshop || Camera Raw Filter || Sinhala (සිංහල) || IT Plus
มุมมอง 39หลายเดือนก่อน
The Camera Raw Filter in Adobe Photoshop is a powerful tool for enhancing and adjusting images. It provides advanced photo editing capabilities, including exposure correction, color grading, noise reduction, and sharpening, directly within Photoshop. Ideal for photographers and designers, the filter replicates the functionality of Adobe Camera Raw, enabling non-destructive edits and fine-tuning...
19- Microsoft Excel Advanced Tutorials | Index & Match Function | IT Plus (SINHALA)
มุมมอง 52หลายเดือนก่อน
Learn how to use the Index and Match functions in Microsoft Excel to efficiently search, match, and retrieve data. This powerful combination offers greater flexibility than VLOOKUP, enabling advanced data lookups across rows and columns. Perfect for beginners and advanced Excel users looking to enhance their spreadsheet skills.
18- Microsoft Excel Advanced Tutorials |What-if-Analysis Data Table | IT Plus (SINHALA)
มุมมอง 1092 หลายเดือนก่อน
data table Discover how to use data tables within What-If Analysis in Microsoft Excel to explore different scenarios and outcomes. This guide explains the steps to create one-variable and two-variable data tables, helping you to analyze how changes in your data impact your results. Ideal for financial modeling, budgeting, and forecasting. t Excel Advanced Tutorials |What-if-Analysis Scenario Ma...
17- Microsoft Excel Advanced Tutorials |What-if-Analysis Goal Seek | IT Plus
มุมมอง 1902 หลายเดือนก่อน
Goal Seek in Microsoft Excel is a built-in tool used to perform what-if analysis by determining the necessary input value needed to achieve a specific goal or target outcome. Instead of manually adjusting variables, Goal Seek allows users to define the desired result (goal) and identify the input value required to reach it. This feature is especially helpful in financial modeling , budgeting , ...
16- Microsoft Excel Advanced Tutorials |What-if-Analysis Scenario Manager | IT Plus
มุมมอง 3202 หลายเดือนก่อน
A Scenario Manager in Microsoft Excel is a powerful feature that allows users to create and manage multiple sets of data or "scenarios" within the same worksheet. It is particularly useful for what-if analysis where different variables are adjusted to see potential outcomes without altering the original data. Users can easily compare different scenarios such as best-case, worst-case, and most-l...
15- Microsoft Excel Advanced Tutorials |Subtotal | IT Plus
มุมมอง 1653 หลายเดือนก่อน
"Learn how to efficiently use the Subtotal function in Microsoft Excel to summarize data and perform quick calculations. This guide covers the step-by-step process to apply subtotals, filter data, and analyze results within large datasets. Whether you're working with sales figures, inventory lists, or any data requiring grouped totals, mastering subtotals can significantly boost your productivi...
13- Microsoft Excel |Forms | IT Plus
มุมมอง 1203 หลายเดือนก่อน
Microsoft Excel Forms is a powerful feature within Microsoft Excel that allows users to easily create, manage, and analyze data using customizable forms. With Excel Forms, you can streamline data entry, automate surveys, and efficiently organize information within your spreadsheets. Whether for business, education, or personal use, Excel Forms simplifies data collection and enhances productivit...
14- Microsoft Excel Advanced Tutorials | Pivot Table - Part - 3 | IT Plus
มุมมอง 493 หลายเดือนก่อน
Pivot Table Learn how to create, customize, and effectively use Pivot Tables in Microsoft Excel. This comprehensive guide covers everything from basic setup to advanced data analysis techniques, empowering you to summarize and analyze your data with ease. Whether you're a beginner or an experienced Excel user, this tutorial will help you make the most of Pivot Tables to visualize trends, patter...
28 - Adobe Photoshop || guides (Guidelines) || Sinhala || IT Plus
มุมมอง 293 หลายเดือนก่อน
Discover comprehensive guides (Guidelines) in Adobe Photoshop that cover essential tools, techniques, and tips to help you master photo editing, graphic design, and digital art. Whether you're a beginner or a seasoned professional, these guides will help you unlock the full potential of Adobe Photoshop's powerful features.
13- Microsoft Excel Advanced Tutorials | Pivot Table - Part - 2 | IT Plus
มุมมอง 1004 หลายเดือนก่อน
Learn how to create, customize, and effectively use Pivot Tables in Microsoft Excel. This comprehensive guide covers everything from basic setup to advanced data analysis techniques, empowering you to summarize and analyze your data with ease. Whether you're a beginner or an experienced Excel user, this tutorial will help you make the most of Pivot Tables to visualize trends, patterns, and insi...
27 - Adobe Photoshop || Single row marquee and Single column marquee tool || Sinhala || IT Plus
มุมมอง 434 หลายเดือนก่อน
Single row marquee tool : - A "single row marquee tool" is a selection tool often found in graphic design and image editing software like Adobe Photoshop. This tool allows the user to select a single row of pixels across the entire width of an image. The selected row is typically only one pixel tall, enabling precise horizontal selections. It's useful for tasks like copying, cutting, or editing...
12- Microsoft Excel Advanced Tutorials | Pivot Table - Part - 1 | IT Plus
มุมมอง 1314 หลายเดือนก่อน
Learn how to create, customize, and effectively use Pivot Tables in Microsoft Excel. This comprehensive guide covers everything from basic setup to advanced data analysis techniques, empowering you to summarize and analyze your data with ease. Whether you're a beginner or an experienced Microsoft Excel user, this tutorial will help you make the most of Pivot Tables to visualize trends, patterns...
26 - Adobe Photoshop || Pixels || Sinhala || IT Plus
มุมมอง 344 หลายเดือนก่อน
"Pixels in Adobe Photoshop" refers to the fundamental building blocks of digital images in Adobe Photoshop, the leading graphic design and photo editing software. Understanding pixels is crucial for tasks like image editing, retouching, resizing, and optimizing graphics. This guide explores how pixels function in Adobe Photoshop, how to manipulate them effectively, and tips for achieving the be...
25 - Adobe Photoshop || Layer Mask - Part- 2 || Sinhala || IT Plus
มุมมอง 274 หลายเดือนก่อน
25 - Adobe Photoshop || Layer Mask - Part- 2 || Sinhala || IT Plus
24 - Adobe Photoshop || Layer Mask - Part- 1 || Sinhala || IT Plus
มุมมอง 365 หลายเดือนก่อน
24 - Adobe Photoshop || Layer Mask - Part- 1 || Sinhala || IT Plus
23 - Adobe Photoshop || Screen Blending mode || Sinhala || IT Plus
มุมมอง 315 หลายเดือนก่อน
23 - Adobe Photoshop || Screen Blending mode || Sinhala || IT Plus
Microsoft Excel Advanced Tutorials |Text To Columns | IT Plus
มุมมอง 2855 หลายเดือนก่อน
Microsoft Excel Advanced Tutorials |Text To Columns | IT Plus
22 - Adobe Photoshop || Blending mode || Sinhala || IT Plus
มุมมอง 636 หลายเดือนก่อน
22 - Adobe Photoshop || Blending mode || Sinhala || IT Plus
21 - Adobe Photoshop || Layers group || Sinhala || IT Plus
มุมมอง 456 หลายเดือนก่อน
21 - Adobe Photoshop || Layers group || Sinhala || IT Plus
20 - Adobe Photoshop || Clone Stamp Tool || Sinhala || IT Plus
มุมมอง 946 หลายเดือนก่อน
20 - Adobe Photoshop || Clone Stamp Tool || Sinhala || IT Plus
19 - Adobe Photoshop || Feather Effectes || Sinhala || IT Plus
มุมมอง 556 หลายเดือนก่อน
19 - Adobe Photoshop || Feather Effectes || Sinhala || IT Plus
18 - Adobe Photoshop || Blur, Sharpen and Smudge tool || Sinhala || IT Plus
มุมมอง 1067 หลายเดือนก่อน
18 - Adobe Photoshop || Blur, Sharpen and Smudge tool || Sinhala || IT Plus
17 - Adobe Photoshop || Duplicate Layer & New Layer || Sinhala || IT Plus
มุมมอง 427 หลายเดือนก่อน
17 - Adobe Photoshop || Duplicate Layer & New Layer || Sinhala || IT Plus
16 - Adobe Photoshop || Brush Tool || Part 2 || Sinhala || IT Plus
มุมมอง 298 หลายเดือนก่อน
16 - Adobe Photoshop || Brush Tool || Part 2 || Sinhala || IT Plus
15- Adobe Photoshop || Brush Tool || Sinhala || IT Plus
มุมมอง 468 หลายเดือนก่อน
15- Adobe Photoshop || Brush Tool || Sinhala || IT Plus
10 - Microsoft Excel Advanced Tutorials |Text functions -2 | IT Plus
มุมมอง 1168 หลายเดือนก่อน
10 - Microsoft Excel Advanced Tutorials |Text functions -2 | IT Plus
9 - Microsoft Excel Advanced Tutorials |Text functions | IT Plus
มุมมอง 1419 หลายเดือนก่อน
9 - Microsoft Excel Advanced Tutorials |Text functions | IT Plus
14- Adobe Photoshop || Image Modes and Channels || Sinhala || IT Plus
มุมมอง 419 หลายเดือนก่อน
14- Adobe Photoshop || Image Modes and Channels || Sinhala || IT Plus
super
thanka
Katahada pahadili na
මේ වීඩියෝ එක ගහද්දී මයි එකේ අවුලක් තිබිලා තියනවා. මේකෙන් පස්සෙ වීඩියෝ වල අවුලක් නෑ.
Thank you very much sir..
Sir, excel solver gana video akak danna...thanks
අනිවාරයෙන් දානවා. හැබැයි ඊට කලින් තව දැන ගන්න ඕන පාඩම් ටිකක් තියනවා. ඒ ටික දාලා solver වීඩියෝ එක දානවා. ඒක වැඩ ගොඩක් කරන්න පුලුවන් කොටසක්.
Thank you very much sir...
🎉
Thank You Very mutch
වටිනා අදහසක්❤
March, April spelling waradi-spealt wrong
Ok bro Thank you.
Good tutorial 🎉
Very good tutorial on XL
Good tutorial
Ok Wellcome
Good tutorial 👌
Ok Wellcome
Thanks sir
OK Welcome
Where is practice files
click the link docs.google.com/spreadsheets/d/13OgfPCDC0cfE_ce4pp7sfdlcNyq0J6lZ/edit?usp=drive_link&ouid=111565254204968141185&rtpof=true&sd=true and select File -->download
Godak pahadiliwama kiyala denawa sir.thank you so much sir.
Ok Welcome
🤗🤗
🤗🤗
🥰
😍
Is there any possibility to download this data sheet in order to practice this ?
use this link docs.google.com/spreadsheets/d/1ifkQc9OQv0Visff-ti-n00moGi-m9a42/edit?usp=drive_link&ouid=111565254204968141185&rtpof=true&sd=true
Not possible to download, pls assist
docs.google.com/spreadsheets/d/1ifkQc9OQv0Visff-ti-n00moGi-m9a42/edit?usp=drive_link&ouid=111565254204968141185&rtpof=true&sd=true
😍
🥰
🤩
😍
Hi Chaminda I went through your advanced tutorials up to 11 and gained a considerable knowledge starting from "zero" In this VLOOKUP lesson, I have a problem in example 1.As you said in the video, I entered the "lookup vales" as the first name of the "NAME" column. Then made the array table values "ABSOLUTE". This did not work. Then, I again started with the VLOOKUP function and this time I selected the whole "NAME" column (Earlier only the first name was selected) of the main table. This time I straight a way got the required answers under the column "COURSE" of the main table. There was no need to make array table values "ABSOLUTE) I shall be thank full if you kindly explain the reason for this Rgds Lalith
i will give new viedo for your problem
Thank you sir❤
Hi Chaminda I started to follow your tutorials with no knowledge in Excel.I went through our basic and advanced tutorials and gained fairly good knowledge in the subject. Now, I stared to save your advanced tutorials and practice with many data sheets to gain a significant knowledge in Excel. However, now I could not file your basic tutorials in the U Tube. How can I access to those now? your way of teaching is excellent. Beginner like me was able to acquire very good knowledge. Thank you so much.
Ok friend Thank you and Wellcome Excel basic play list link You can Follow this. th-cam.com/video/a9VA_ahu4pw/w-d-xo.html
Thank sar
GOOD
Thankyou sir🙏
Thankyou sir🙏
Thankyou sir🙏
Thankyou sir🙏
Thankyou sir🙏
Thankyou sir 🙏
👍
Good job sir.................😊👍👍👍👍
Thanks sir ❤
sir apita kamathnm writeln hari write hari me deken onama ekk danna puluwanda ex:-write(count) or writeln(count)
write දැම්මොත් එකම පේලියේ print වෙනවා writeln දැම්මොත් massage එකට පහල පේලියේ තමා අදාල දේ print වෙන්නේ. දෙකෙන් කෝක දැම්මත් අවුලක් නම් නෑ
@@itplus4042 thank you sir🙏👍
😡 P R O M O S M
Explaning supiri
Sir,BCD values colours walata ganne kohomada?
මේ ගැන මම ඉක්මනින් video එකක් ගේන්නම්
"NEXT Nor" danna ona nada?
ඒන දැම්මත් නොදැම්මත් අවුලක් නෑ. Programming Language හැබැයි එකක නම් දාන්නම ඕන.
Sir ai Next walata passe variable ekn iwara kare naththe?
ඒන දැම්මත් නොදැම්මත් අවුලක් නෑ. Programming Language හැබැයි එකක නම් දාන්නම ඕන.
ඒන දැම්මත් නොදැම්මත් අවුලක් නෑ. Programming Language හැබැයි එකක නම් දාන්නම ඕන.