IT Plus
IT Plus
  • 94
  • 13 908
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
Переглядів: 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

КОМЕНТАРІ

  • @chandudisanayaka503
    @chandudisanayaka503 2 дні тому

    Katahada pahadili na

    • @itplus4042
      @itplus4042 День тому

      මේ වීඩියෝ එක ගහද්දී මයි එකේ අවුලක් තිබිලා තියනවා. මේකෙන් පස්සෙ වීඩියෝ වල අවුලක් නෑ.

  • @wbmtbandara2217
    @wbmtbandara2217 3 дні тому

    Thank you very much sir..

  • @wbmtbandara2217
    @wbmtbandara2217 5 днів тому

    Sir, excel solver gana video akak danna...thanks

    • @itplus4042
      @itplus4042 3 дні тому

      අනිවාරයෙන් දානවා. හැබැයි ඊට කලින් තව දැන ගන්න ඕන පාඩම් ටිකක් තියනවා. ඒ ටික දාලා solver වීඩියෝ එක දානවා. ඒක වැඩ ගොඩක් කරන්න පුලුවන් කොටසක්.

    • @wbmtbandara2217
      @wbmtbandara2217 3 дні тому

      you very much sir...

  • @KUMARICHANDRIKA-ir7xx
    @KUMARICHANDRIKA-ir7xx 20 днів тому

    🎉

  • @ramseyfernando3420
    @ramseyfernando3420 Місяць тому

    වටිනා අදහසක්❤

  • @RoshanDeSilva-o6l
    @RoshanDeSilva-o6l Місяць тому

    March, April spelling waradi-spealt wrong

  • @pushpakumaraathukorala6564
    @pushpakumaraathukorala6564 Місяць тому

    Good tutorial 🎉

  • @pushpakumaraathukorala6564
    @pushpakumaraathukorala6564 Місяць тому

    Very good tutorial on XL

  • @pushpakumaraathukorala6564
    @pushpakumaraathukorala6564 Місяць тому

    Good tutorial

  • @pushpakumaraathukorala6564
    @pushpakumaraathukorala6564 Місяць тому

    Good tutorial 👌

  • @Rambukwellagb
    @Rambukwellagb Місяць тому

    Thanks sir

  • @chiranjeevivarma8258
    @chiranjeevivarma8258 Місяць тому

    Where is practice files

    • @itplus4042
      @itplus4042 Місяць тому

      click the link docs.google.com/spreadsheets/d/13OgfPCDC0cfE_ce4pp7sfdlcNyq0J6lZ/edit?usp=drive_link&ouid=111565254204968141185&rtpof=true&sd=true and select File -->download

  • @wasanarajapaksha-n8r
    @wasanarajapaksha-n8r 2 місяці тому

    Godak pahadiliwama kiyala denawa sir.thank you so much sir.

  • @amdas3636
    @amdas3636 2 місяці тому

    🤗🤗

  • @amdas3636
    @amdas3636 2 місяці тому

    🤗🤗

  • @rajithsuriyapperuma9180
    @rajithsuriyapperuma9180 3 місяці тому

    🥰

  • @rajithsuriyapperuma9180
    @rajithsuriyapperuma9180 3 місяці тому

    😍

  • @samanthadangampola5028
    @samanthadangampola5028 3 місяці тому

    Is there any possibility to download this data sheet in order to practice this ?

    • @itplus4042
      @itplus4042 3 місяці тому

      use this link docs.google.com/spreadsheets/d/1ifkQc9OQv0Visff-ti-n00moGi-m9a42/edit?usp=drive_link&ouid=111565254204968141185&rtpof=true&sd=true

    • @samanthadangampola5028
      @samanthadangampola5028 3 місяці тому

      Not possible to download, pls assist

    • @itplus4042
      @itplus4042 3 місяці тому

      docs.google.com/spreadsheets/d/1ifkQc9OQv0Visff-ti-n00moGi-m9a42/edit?usp=drive_link&ouid=111565254204968141185&rtpof=true&sd=true

  • @rajithsuriyapperuma9180
    @rajithsuriyapperuma9180 3 місяці тому

    😍

  • @rajithsuriyapperuma9180
    @rajithsuriyapperuma9180 3 місяці тому

    🥰

  • @rajithsuriyapperuma9180
    @rajithsuriyapperuma9180 3 місяці тому

    🤩

  • @rajithsuriyapperuma9180
    @rajithsuriyapperuma9180 3 місяці тому

    😍

  • @lalithfernando9779
    @lalithfernando9779 3 місяці тому

    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

    • @itplus4042
      @itplus4042 3 місяці тому

      i will give new viedo for your problem

  • @MalinduMalshan46
    @MalinduMalshan46 3 місяці тому

    Thank you sir❤

  • @lalithfernando9779
    @lalithfernando9779 4 місяці тому

    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.

    • @itplus4042
      @itplus4042 3 місяці тому

      Ok friend Thank you and Wellcome Excel basic play list link You can Follow this. ua-cam.com/video/a9VA_ahu4pw/v-deo.html

  • @RasikaManamperigunawardhana
    @RasikaManamperigunawardhana 4 місяці тому

    Thank sar

  • @sanu909
    @sanu909 5 місяців тому

    GOOD

  • @ThesharaBandara
    @ThesharaBandara 6 місяців тому

    Thankyou sir🙏

  • @ThesharaBandara
    @ThesharaBandara 6 місяців тому

    Thankyou sir🙏

  • @ThesharaBandara
    @ThesharaBandara 6 місяців тому

    Thankyou sir🙏

  • @ThesharaBandara
    @ThesharaBandara 6 місяців тому

    Thankyou sir🙏

  • @ThesharaBandara
    @ThesharaBandara 6 місяців тому

    Thankyou sir🙏

  • @ThesharaBandara
    @ThesharaBandara 6 місяців тому

    Thankyou sir 🙏

  • @MIGIYA462
    @MIGIYA462 6 місяців тому

  • @MIGIYA462
    @MIGIYA462 6 місяців тому

  • @MIGIYA462
    @MIGIYA462 6 місяців тому

  • @MIGIYA462
    @MIGIYA462 6 місяців тому

  • @MIGIYA462
    @MIGIYA462 6 місяців тому

  • @MIGIYA462
    @MIGIYA462 6 місяців тому

  • @dasniilanka9373
    @dasniilanka9373 7 місяців тому

    👍

  • @dasniilanka9373
    @dasniilanka9373 7 місяців тому

    Good job sir.................😊👍👍👍👍

  • @Masterseniors
    @Masterseniors 7 місяців тому

    Thanks sir ❤

  • @Aestheticgirl-o9e
    @Aestheticgirl-o9e 7 місяців тому

    sir apita kamathnm writeln hari write hari me deken onama ekk danna puluwanda ex:-write(count) or writeln(count)

    • @itplus4042
      @itplus4042 7 місяців тому

      write දැම්මොත් එකම පේලියේ print වෙනවා writeln දැම්මොත් massage එකට පහල පේලියේ තමා අදාල දේ print වෙන්නේ. දෙකෙන් කෝක දැම්මත් අවුලක් නම් නෑ

    • @Aestheticgirl-o9e
      @Aestheticgirl-o9e 7 місяців тому

      @@itplus4042 thank you sir🙏👍

  • @buddysweeney2044
    @buddysweeney2044 9 місяців тому

    😡 P R O M O S M

  • @takshilapriyadarshani4508
    @takshilapriyadarshani4508 10 місяців тому

    Explaning supiri

  • @imashafernando2507
    @imashafernando2507 10 місяців тому

    Sir,BCD values colours walata ganne kohomada?

    • @itplus4042
      @itplus4042 10 місяців тому

      මේ ගැන මම ඉක්මනින් video එකක් ගේන්නම්

  • @imashafernando2507
    @imashafernando2507 10 місяців тому

    "NEXT Nor" danna ona nada?

    • @itplus4042
      @itplus4042 10 місяців тому

      ඒන දැම්මත් නොදැම්මත් අවුලක් නෑ. Programming Language හැබැයි එකක නම් දාන්නම ඕන.

  • @imashafernando2507
    @imashafernando2507 10 місяців тому

    Sir ai Next walata passe variable ekn iwara kare naththe?

    • @itplus4042
      @itplus4042 10 місяців тому

      ඒන දැම්මත් නොදැම්මත් අවුලක් නෑ. Programming Language හැබැයි එකක නම් දාන්නම ඕන.

    • @itplus4042
      @itplus4042 10 місяців тому

      ඒන දැම්මත් නොදැම්මත් අවුලක් නෑ. Programming Language හැබැයි එකක නම් දාන්නම ඕන.

  • @imashafernando2507
    @imashafernando2507 10 місяців тому

    Sir meke ai api output ekak show karan natta?

    • @itplus4042
      @itplus4042 10 місяців тому

      examples 2 අව්සානේදී output දෙනවානේ

    • @itplus4042
      @itplus4042 3 місяці тому

      කොයි Example එක ගැනද ඔයා අහන්නේ? එකෙ output දීලා තියෙන්නෙ Example දෙකේම . display වලින්

  • @imashafernando2507
    @imashafernando2507 10 місяців тому

    Sir meke Total cost AS kiyala enna ona nadda output eke