- 94
- 13 908
IT Plus
Sri Lanka
Приєднався 21 бер 2021
Discover the pinnacle of ICT education with the 'IT Plus' UA-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.
20- Microsoft Excel Advanced Tutorials |Index & Match Function Examples | IT Plus (SINHALA)
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: -
ua-cam.com/video/My_S2zcV5jA/v-deo.html
Data Validation viedo link: -
ua-cam.com/video/D_39xAIenVA/v-deo.html
Index & Match Function viedo link: -
ua-cam.com/video/My_S2zcV5jA/v-deo.html
Data Validation viedo link: -
ua-cam.com/video/D_39xAIenVA/v-deo.html
Переглядів: 18
Відео
29 - Adobe Photoshop || Camera Raw Filter || Sinhala (සිංහල) || IT Plus
Переглядів 2914 днів тому
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)
Переглядів 4421 день тому
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)
Переглядів 85Місяць тому
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
Переглядів 183Місяць тому
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
Переглядів 3102 місяці тому
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
Переглядів 1592 місяці тому
"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
Переглядів 1192 місяці тому
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
Переглядів 482 місяці тому
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
Переглядів 273 місяці тому
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
Переглядів 973 місяці тому
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
Переглядів 433 місяці тому
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
Переглядів 1273 місяці тому
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
Переглядів 323 місяці тому
"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
Переглядів 234 місяці тому
Learn how to effectively use layer masks in Adobe Photoshop to enhance your photo editing and design projects. This comprehensive guide covers the basics of layer masks, advanced techniques, and practical tips to improve your work flow. 24 - Adobe Photoshop || Layer Mask - Part- 1 || Sinhala || IT Plus ua-cam.com/video/EZz7-8Wfbts/v-deo.html
24 - Adobe Photoshop || Layer Mask - Part- 1 || Sinhala || IT Plus
Переглядів 334 місяці тому
24 - Adobe Photoshop || Layer Mask - Part- 1 || Sinhala || IT Plus
23 - Adobe Photoshop || Screen Blending mode || Sinhala || IT Plus
Переглядів 274 місяці тому
23 - Adobe Photoshop || Screen Blending mode || Sinhala || IT Plus
Microsoft Excel Advanced Tutorials |Text To Columns | IT Plus
Переглядів 2825 місяців тому
Microsoft Excel Advanced Tutorials |Text To Columns | IT Plus
22 - Adobe Photoshop || Blending mode || Sinhala || IT Plus
Переглядів 545 місяців тому
22 - Adobe Photoshop || Blending mode || Sinhala || IT Plus
21 - Adobe Photoshop || Layers group || Sinhala || IT Plus
Переглядів 415 місяців тому
21 - Adobe Photoshop || Layers group || Sinhala || IT Plus
20 - Adobe Photoshop || Clone Stamp Tool || Sinhala || IT Plus
Переглядів 825 місяців тому
20 - Adobe Photoshop || Clone Stamp Tool || Sinhala || IT Plus
19 - Adobe Photoshop || Feather Effectes || Sinhala || IT Plus
Переглядів 546 місяців тому
19 - Adobe Photoshop || Feather Effectes || Sinhala || IT Plus
18 - Adobe Photoshop || Blur, Sharpen and Smudge tool || Sinhala || IT Plus
Переглядів 976 місяців тому
18 - Adobe Photoshop || Blur, Sharpen and Smudge tool || Sinhala || IT Plus
17 - Adobe Photoshop || Duplicate Layer & New Layer || Sinhala || IT Plus
Переглядів 377 місяців тому
17 - Adobe Photoshop || Duplicate Layer & New Layer || Sinhala || IT Plus
16 - Adobe Photoshop || Brush Tool || Part 2 || Sinhala || IT Plus
Переглядів 247 місяців тому
16 - Adobe Photoshop || Brush Tool || Part 2 || Sinhala || IT Plus
15- Adobe Photoshop || Brush Tool || Sinhala || IT Plus
Переглядів 388 місяців тому
15- Adobe Photoshop || Brush Tool || Sinhala || IT Plus
10 - Microsoft Excel Advanced Tutorials |Text functions -2 | IT Plus
Переглядів 1128 місяців тому
10 - Microsoft Excel Advanced Tutorials |Text functions -2 | IT Plus
9 - Microsoft Excel Advanced Tutorials |Text functions | IT Plus
Переглядів 1338 місяців тому
9 - Microsoft Excel Advanced Tutorials |Text functions | IT Plus
14- Adobe Photoshop || Image Modes and Channels || Sinhala || IT Plus
Переглядів 408 місяців тому
14- Adobe Photoshop || Image Modes and Channels || Sinhala || IT Plus
13- Adobe Photoshop ||Feather, Save Selection and Load Selection || Sinhala || IT Plus
Переглядів 589 місяців тому
13- Adobe Photoshop ||Feather, Save Selection and Load Selection || Sinhala || IT Plus
Katahada pahadili na
මේ වීඩියෝ එක ගහද්දී මයි එකේ අවුලක් තිබිලා තියනවා. මේකෙන් පස්සෙ වීඩියෝ වල අවුලක් නෑ.
Thank you very much sir..
Sir, excel solver gana video akak danna...thanks
අනිවාරයෙන් දානවා. හැබැයි ඊට කලින් තව දැන ගන්න ඕන පාඩම් ටිකක් තියනවා. ඒ ටික දාලා solver වීඩියෝ එක දානවා. ඒක වැඩ ගොඩක් කරන්න පුලුවන් කොටසක්.
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. ua-cam.com/video/a9VA_ahu4pw/v-deo.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 හැබැයි එකක නම් දාන්නම ඕන.
Sir meke ai api output ekak show karan natta?
examples 2 අව්සානේදී output දෙනවානේ
කොයි Example එක ගැනද ඔයා අහන්නේ? එකෙ output දීලා තියෙන්නෙ Example දෙකේම . display වලින්
Sir meke Total cost AS kiyala enna ona nadda output eke