B for Basic
B for Basic
  • 66
  • 19 181
Advanced Excel Smart Doughnut Chart
#excel #advancedexcel #chart #doughnutchart
Data that is arranged in columns or rows only on a worksheet can be plotted in a doughnut chart. Just like a pie chart, a doughnut chart shows the relationship of parts to a whole, but a doughnut chart can contain more than one data series. Each data series that you plot in a doughnut chart adds a ring to the chart. The first data series is displayed in the center of the chart.
Because of their circular nature, doughnut charts are not easy to read, especially when they display multiple data series. The proportions of outer rings and inner rings do not represent the size of the data accurately - data points on outer rings may appear larger than data points on inner rings while their actual values may be smaller. Displaying values or percentages in data labels is very useful in a doughnut chart, but if you want to compare the data points side by side, you should use a stacked column or stacked bar chart instead.
Переглядів: 78

Відео

Conditional Formatting Duplicate Values in Excel
Переглядів 368 місяців тому
#excel #advancedexcel #conditionalformatting #duplicatevalues Conditional formatting makes it easy to highlight certain values or make particular cells easy to identify. This changes the appearance of a cell range based on a condition (or criteria). Data bars, color scales, and icon sets are conditional formats that create visual effects in your data. These conditional formats make it easier to...
Conditional Formatting Icons Set in Excel
Переглядів 308 місяців тому
#excel #advancedexcel #conditionalformatting #iconsset Conditional formatting makes it easy to highlight certain values or make particular cells easy to identify. This changes the appearance of a cell range based on a condition (or criteria). Data bars, color scales, and icon sets are conditional formats that create visual effects in your data. These conditional formats make it easier to compar...
Conditional Formatting Data Bars in Excel
Переглядів 389 місяців тому
#excel #advancedexcel #conditionalformatting Conditional formatting makes it easy to highlight certain values or make particular cells easy to identify. This changes the appearance of a cell range based on a condition (or criteria). Data bars, color scales, and icon sets are conditional formats that create visual effects in your data. These conditional formats make it easier to compare the valu...
Advanced EXCEL Conditional Formatting on Numbers
Переглядів 819 місяців тому
#excel #advancedexcel #conditionalformatting Conditional formatting makes it easy to highlight certain values or make particular cells easy to identify. This changes the appearance of a cell range based on a condition (or criteria). You can use conditional formatting to highlight cells that contain values which meet a certain condition. Or you can format a whole cell range and vary the exact fo...
How to become an ASP Dot Net Expert Lesson #8 Validation Controls
Переглядів 61Рік тому
#aspdotnet #dotnet #webform #webdevelopment #validation #validationcontrols ASP.NET provides several validation controls that help developers implement client-side and server-side validation in web forms. These controls are part of the ASP.NET Web Forms framework and assist in validating user input and ensuring data integrity.
How to become an ASP Dot Net Expert Lesson #7 ASP.Net Page Lifecycle
Переглядів 47Рік тому
#aspdotnet #dotnet #webform #webdevelopment #pagecycle #pagelifecycle ASP.NET Page Life Cycle is a series of sequential events that occur when a web page is requested and processed by the ASP.NET runtime. Understanding the page life cycle is crucial for developing ASP.NET web applications, as it allows developers to control and manage the various stages of page processing.
How to become an ASP Dot Net Expert Lesson #6 More Tools
Переглядів 43Рік тому
#aspdotnet #dotnet #webform #webdevelopment #checkbox #listbox #radiobutton 1. ListBox: The asp:ListBox control allows users to select one or more items from a list of options. It is typically represented as a box with a scroll bar, displaying a list of items. Users can select multiple items by holding down the Ctrl key (for non-sequential selection) or the Shift key (for sequential selection)....
How to become an ASP Dot Net Expert Lesson #5 DropdownList
Переглядів 26Рік тому
#aspdotnet #dotnet #webform #webdevelopment #dropdownlist In ASP.NET, the asp:DropDownList control is used to create a dropdown list or a selection menu on a web form. It allows users to choose an item from a list of options. The asp:DropDownList control provides various properties and attributes that you can use to customize its behavior and appearance. Here's an overview of some commonly used...
How to become an ASP Dot Net Expert Lesson #4 Attributes of TextBox
Переглядів 40Рік тому
#aspdotnet #dotnet #webform #webdevelopment #textbox In ASP.NET, the asp:TextBox control is used to create a text input field on a web form. It allows users to enter and edit text data. The asp:TextBox control provides various attributes that you can use to customize its behavior and appearance. Here are some commonly used attributes: ID: Specifies a unique identifier for the TextBox control. T...
How to become an ASP Dot Net Expert Lesson #3 Creating Web Form
Переглядів 37Рік тому
#aspdotnet #dotnet #webform #webdevelopment In ASP.NET, a form refers to the server-side control that encapsulates HTML form functionality. It is represented by the asp:Form tag in the ASP.NET markup. The form control provides a container for other controls and allows you to collect user input and submit it to the server for processing. The asp:Form control serves as the root container for cont...
How to become an ASP Dot Net Expert Lesson #2 Introduction to ASP Net
Переглядів 45Рік тому
#aspdotnet #dotnet #webform #webdevelopment ASP.NET is a popular framework developed by Microsoft for building dynamic web applications and services. ASP.NET stands for Active Server Pages .NET and is built on top of the .NET framework. It provides a powerful and flexible environment for creating web-based applications that can be used for a wide range of purposes, including e-commerce, content...
How to become an ASP .Net Expert-Lesson #1 Introduction to Dot Net
Переглядів 83Рік тому
#asp.net #dotnet #introduction ASP.NET is a web application framework developed by Microsoft that allows developers to build dynamic, interactive, and scalable websites and web applications. ASP.NET stands for Active Server Pages.NET, and it is a part of the larger .NET framework.
Learn Basics of HTML 5 Lesson #20 CSS3 Input Types
Переглядів 33Рік тому
#html #html5 #inputtype #input #webdevelopment HTML 5 came with several input types like : -Date, Month, Week, Time -DateTime-local -email -Tel -URL -Search -Range -Color and Number To improve the user experience and to make the forms more interactive. However, if a browser failed to recognize these new input types, it will treat them like a normal text box. Learn HTML & CSS in hindi & urdu, ea...
Learn Basics of HTML 5 Lesson #19 CSS3 Media Queries
Переглядів 29Рік тому
#html #html5 #mediaquery #webdevelopment Media queries are a feature in CSS that allow you to apply different styles based on various device characteristics, such as screen size, resolution, orientation, and more. They are commonly used for creating responsive designs that adapt to different devices and screen sizes.
Learn Basics of HTML 5 Lesson #18 CSS3 Layout Multiple Columns
Переглядів 29Рік тому
Learn Basics of HTML 5 Lesson #18 CSS3 Layout Multiple Columns
Learn Basics of HTML 5 Lesson #17 CSS3 Text Effects
Переглядів 44Рік тому
Learn Basics of HTML 5 Lesson #17 CSS3 Text Effects
Learn Basics of HTML 5 Lesson #16 CSS3 Animations
Переглядів 35Рік тому
Learn Basics of HTML 5 Lesson #16 CSS3 Animations
Learn Basics of HTML 5 Lesson #15 CSS3 Transformations
Переглядів 45Рік тому
Learn Basics of HTML 5 Lesson #15 CSS3 Transformations
Learn basics of HTML-5 - Lesson #2 Tags
Переглядів 86Рік тому
Learn basics of HTML-5 - Lesson #2 Tags
Learn Basics of HTML 5 Lesson #13 More Elements
Переглядів 87Рік тому
Learn Basics of HTML 5 Lesson #13 More Elements
Learn Basics of HTML 5 Lesson #14 CSS3 Floating Image
Переглядів 36Рік тому
Learn Basics of HTML 5 Lesson #14 CSS3 Floating Image
Learn Basics of HTML 5 Lesson #12 jQuery
Переглядів 61Рік тому
Learn Basics of HTML 5 Lesson #12 jQuery
Learn Basics of HTML 5 Lesson #11 JavaScript
Переглядів 105Рік тому
Learn Basics of HTML 5 Lesson #11 JavaScript
Learn Basics of HTML 5 Lesson #10 SVG
Переглядів 78Рік тому
Learn Basics of HTML 5 Lesson #10 SVG
Learn Basics of HTML 5 Lesson #9 CANVAS
Переглядів 60Рік тому
Learn Basics of HTML 5 Lesson #9 CANVAS
Learn Basics of HTML 5 Lesson #8 HTML5 Elements
Переглядів 70Рік тому
Learn Basics of HTML 5 Lesson #8 HTML5 Elements
Learn Basics of HTML 5 Lesson #7 Simple Login Page
Переглядів 105Рік тому
Learn Basics of HTML 5 Lesson #7 Simple Login Page
Learn Basics of HTML 5 Lesson #6 Simple School Website
Переглядів 67Рік тому
Learn Basics of HTML 5 Lesson #6 Simple School Website
Learn Basics of HTML 5 Lesson #5 Link
Переглядів 91Рік тому
Learn Basics of HTML 5 Lesson #5 Link

КОМЕНТАРІ

  • @spreadthehappiness695
    @spreadthehappiness695 12 днів тому

    Literally great ..!! Thanks to you SIR

  • @nmishurentertainment7438
    @nmishurentertainment7438 28 днів тому

    বাংলায় কিভাবে

  • @COLLINSCHISOYA-ux9td
    @COLLINSCHISOYA-ux9td 2 місяці тому

    Kindly share the sàmple of this

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

    Thank you so much sir!!

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

    Thank you …good video

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

    ❤❤❤ماشاءاللہ❤❤❤

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

    Sir, if only the employee id that change in my pdf file. what is the problem?

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

      Hi @miki, i didn't get what you are saying, send me the macro code, so i can see that what is the problem. send me on bashkhannew@hotmail.com

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

    Can you please make a tutorial how to sent the pay slip by email from excel file sir? Thank you in advance

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

    Thank you very much i will try it hope i am successfull. newbie here, never try macro before

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

    I'm getting error as macros disabled for this excel even after macro settings changed and file saved as macro excel book pl advise what to do

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

      Please send me a screen shot to understand the issue

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

      or email me at bashkhannew@hotmail.com

  • @VartikaTiwari-v6q
    @VartikaTiwari-v6q 7 місяців тому

    HELLO SIR, i AM FACING PROBLRM IN APPLYING VLOOKUP FORMULA IN SAME DATA ITS SHOWING NA....CAN YOU PLEASE SHARE YOUR SALARY DATA AND Salary slip file

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

      HI, please send me your file , let me see the issue to fix it. email: bashkhannew@hotmail.com

  • @santhoshrajpn3910
    @santhoshrajpn3910 8 місяців тому

    Run time error 424

  • @syedshahzaib5032
    @syedshahzaib5032 8 місяців тому

    how do we email the individual pay slips to the employees?

  • @isaacboye6803
    @isaacboye6803 8 місяців тому

    Thanks Sir. How do I email the payslip to the employee automatically?

  • @ashishpuri-mh9lg
    @ashishpuri-mh9lg 9 місяців тому

    Sir instead of emp. id hiw to save with emp.name

    • @ashishpuri-mh9lg
      @ashishpuri-mh9lg 9 місяців тому

      Plz upload one video on it

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

      OK, please name the cell which have employee name to "EmpName" and write the below code Sheet2.ExportAsFixedFormat xlTypePDF, "D:\PaySlip\" & Sheet2.Range("EmpID") & " - " & Sheet2.Range("EmpName").Value & ".pdf", , , False, , , False

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

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

    This is very informative and you explained everything very well and in detail. I really admire your work keep it up❤ thanks sir❤

  • @shalumagan
    @shalumagan 11 місяців тому

    Thanka for the detailed info. I am facing an error while clicking on printpdf. How to solve it?

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

      Hi, please send me the file and let me check bashkhannew@hotmail.com

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

      You might be using some other name of the sheet, or syntax errorr.

  • @anups2122
    @anups2122 Рік тому

    Sir how about if i want to name pdf employee name along with employee id

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

      Yes it is possible, you can name he employee name as pdf

  • @anups2122
    @anups2122 Рік тому

    its awesome some i followed as suggested and its working fine

  • @bahadinsaeed4947
    @bahadinsaeed4947 Рік тому

    thanks for detailed explanation , I repeat the code according to my scenario but it tells me the "variable not defined" and it highlights a . in which in my case a= 5 to 39 kindly advise how to solve this issue. thanks in advance

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

      Hi, please send me the file and let me check bashkhannew@hotmail.com

  • @zayadgamer_123
    @zayadgamer_123 Рік тому

    Can you load more videos please like database connectivity , using connection string and make complete project

  • @JunaidAlam-zm6vm
    @JunaidAlam-zm6vm Рік тому

    Whatsapp number ???

  • @JunaidAlam-zm6vm
    @JunaidAlam-zm6vm Рік тому

    Assalamualaikum

  • @khalil5908
    @khalil5908 Рік тому

    Promo`SM

  • @ajiteshmishra0005
    @ajiteshmishra0005 Рік тому

    I have learnt UI Full Stack Web Development Which includes HTML CSS BootStrap Javascript jQuery AJAX MongoDB

  • @ammarhussain4131
    @ammarhussain4131 Рік тому

    Nice one

  • @mr_kpexor
    @mr_kpexor Рік тому

    I'm having a problem with my VBA code its giving me a run time error

    • @basheerkhan6742
      @basheerkhan6742 Рік тому

      send me your file at bashkhannew@gmail.com, let me check

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

      Hi, please send me the file and let me check bashkhannew@hotmail.com

  • @zarnishshah-ko5tn
    @zarnishshah-ko5tn Рік тому

    v informative

  • @samarumbreen5106
    @samarumbreen5106 Рік тому

    👍😍

  • @RamK-x5q
    @RamK-x5q Рік тому

    How to protect the generated salary slip with password? The password can be , for example, the employee's PAN

    • @basheerkhan6742
      @basheerkhan6742 Рік тому

      This is posible bu you need to install a 3rd party software.

  • @zarnishshah-ko5tn
    @zarnishshah-ko5tn Рік тому

    v nice and informative video keep it up

  • @FahimKhan-y5g
    @FahimKhan-y5g Рік тому

    Keep uploading such interesting videos

    • @basheerkhan6742
      @basheerkhan6742 Рік тому

      Thank you Fahim, yes many more coming.

    • @basheerkhan6742
      @basheerkhan6742 Рік тому

      I have planned many videos, i will post one by one daily, need your support please.

  • @saymongemar3204
    @saymongemar3204 Рік тому

    Hi sir

  • @gkmkbya.n3930
    @gkmkbya.n3930 Рік тому

    Very nice

  • @gkmkbya.n3930
    @gkmkbya.n3930 Рік тому

    Hi basheer

  • @MuhammadAli-ty8kh
    @MuhammadAli-ty8kh Рік тому

    very nice video

  • @MuhammadAli-ty8kh
    @MuhammadAli-ty8kh Рік тому

    thanks for uploading it is helpful

  • @MuhammadAli-ty8kh
    @MuhammadAli-ty8kh Рік тому

    very nice video thanks for explaining so simplely 😊

    • @basheerkhan6742
      @basheerkhan6742 Рік тому

      Thank you, you will also going to like next 2 videos about html-5.

  • @usman_lhr
    @usman_lhr Рік тому

    Knowledgeable vedio, thanks

  • @ammarhussain4131
    @ammarhussain4131 Рік тому

    Great work

  • @zarnishshah-ko5tn
    @zarnishshah-ko5tn Рік тому

    v easy to learn HTML v informative

  • @samarumbreen5106
    @samarumbreen5106 Рік тому

    zabardast v informative keep it up

  • @harisshaikh3185
    @harisshaikh3185 Рік тому

    please more videos on Front-End-Development

    • @basheerkhan6742
      @basheerkhan6742 Рік тому

      Thank you watching this, more coming soon, I am going to start with Visual Studio!

  • @muhammadimtiazimtiaz3210
    @muhammadimtiazimtiaz3210 Рік тому

    Well done

  • @zarnishshah-ko5tn
    @zarnishshah-ko5tn Рік тому

    nice work,👍

  • @zarnishshah-ko5tn
    @zarnishshah-ko5tn Рік тому

    buhat achi information mili apkay videos say keep it up

  • @JannatSheikh-i3w
    @JannatSheikh-i3w Рік тому

    Very helpful i was searching for it thank you sir ☺️

  • @animexsupra
    @animexsupra Рік тому

    Congrats on hitting 1k subs keep carry on we will support you

  • @zarnishshah-ko5tn
    @zarnishshah-ko5tn Рік тому

    nice v informative and easy to learn ,👍