Komal Kanwar Shekhawat
Komal Kanwar Shekhawat
  • 86
  • 368 352
9. Text Functions in Excel || Beginner's Guide to Excel || Excel Tutorial
Hello everyone,
This video explains some of the most important Text Functions in MS Excel.
In this video I have specifically discussed the following Text Functions-
1. TRIM
2. PROPER
3. UPPER
4. LOWER
Do watch the video till end. Do SUBSCIBE to the channel.
Please subscribe to the channel. Happy learning !!
#excel #msexcel #keyboard #keyboardshortcuts
Link to join telegram channel: t.me/kshekhawat
zhlédnutí: 184

Video

8. XLOOKUP in Excel || Beginner's Guide to Excel || Excel Tutorial
zhlédnutí 213Před 5 měsíci
Hello everyone, This video explains how to use XLOOKUP function in MS Excel. XLOOKUP is a very powerful and useful function that can be utilized when you are dealing with a large set of data. The XLOOKUP function searches a range or an array, and then returns the item corresponding to the first match it finds. If no match exists, then XLOOKUP can return the closest (approximate) match. It is ty...
7. HLOOKUP in Excel || Beginner's Guide to Excel || Excel Tutorial
zhlédnutí 117Před 5 měsíci
Hello everyone, This video explains how to use HLOOKUP function in MS Excel. HLOOKUP is a very powerful and useful function that can be utilized when you are dealing with a large set of data. HLOOKUP stands for Horizontal Lookup and can be used to retrieve information from a table by searching a row for the matching data and outputting from the corresponding column. While VLOOKUP searches for t...
6. VLOOKUP in Excel || Beginner's Guide to Excel || Excel Tutorial
zhlédnutí 234Před 5 měsíci
Hello everyone, This video explains how to use VLOOKUP function in MS Excel. VLOOKUP is a very powerful and useful function that can be utilized when you are dealing with a large set of data. The VLOOKUP function is a premade function in Excel, which allows searches across columns. It is typed =VLOOKUP and has the following parts: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup...
5. How to create Pivot Table || Beginner's Guide to Excel || Excel Tutorial
zhlédnutí 273Před 6 měsíci
Hello everyone, This video explains how to create basic Pivot tables in MS Excel in the most easiest way. PivotTable is a powerful tool to calculate, summarize, and analyse data that lets you see comparisons, patterns, and trends in your data. Do watch the video till end. Do SUBSCIBE to the channel. The subsequent videos will explain how to create advance Pivot tables in MS Excel Please subscri...
4. Most Useful Excel Tricks || Beginner's Guide to Excel || Excel Tutorial
zhlédnutí 132Před 6 měsíci
Hello everyone... This video explains some of the most useful MS Excel tricks. Using these MS Excel tricks can make your task efficient. The video explains- 1. How to select a range of cells in Excel. 2. How to create serial number. 3. How to seperate First name & Last name 4. How to put together Full name. Do watch the video till end. Keep following and do subscribe to watch more such content....
3. Most Useful Excel Keyboard Shortcuts || Beginner's Guide to Excel || Excel Tutorial
zhlédnutí 178Před 6 měsíci
Hello everyone..... This video explains the most useful MS Excel Keyboard Shortcuts. The video mentions the following Excel Keyboard shortcuts - Save - Print - Cut - Paste - Copy - Create Table - Up & Down Navigation - Navigation across Excel sheets and so forth..... The video focuses on the most quick and simple way to use Excel Keyboard Shortcuts to make task efficient. Do watch the video til...
2. Graphical presentation in Excel || Beginner's guide to Excel || Excel Tutorial
zhlédnutí 159Před 6 měsíci
Hello everyone..... This video explains how to represent data in MS Excel using graphs/ charts. The video shows the basic components/ elements that can be used to generate graphs. The video focuses on the most quick and simple way to create graph. Do watch the video till end. Watch this video on 'Interface of MS Excel' - A beginner's guide to Excel- czcams.com/video/9b2XKEyLiyE/video.htmlsi=mk0...
1. Interface of MS Excel || Beginner's Guide to Excel || Excel Basics Tutorial
zhlédnutí 160Před 7 měsíci
Hello everyone!! This videos explains - 'The Interface of MS Excel'. If you are beginner, then this MS Excel video is for you. This is the first video in MS Excel series. The video explains: 1. How to open new workbook in Excel? 2. What is a cell and range in Excel? 3. Menu tabs in Excel 4. Different Groups/ Segments in Excel The subsequent videos shall explain all the functionalities of MS Exc...
OLS Method & Descriptive Statistics in STATA | STATA Tutorial
zhlédnutí 462Před 7 měsíci
Hello everyone!! This video explains - How to obtain the descriptive statistics of a data set and how to run an OLS model in STATA. 1. The video first explains how to obtain the descriptive statistics of the data set in STATA. The video also mentions about additional descriptives that could be obtain in STATA by following simple steps. 2. The second half of the video explains how to run OLS mod...
Block Exogeneity Wald Tests/ VAR Granger Causality/ EViews Tutorial
zhlédnutí 1,9KPřed 11 měsíci
Hello everyone!! This video explains how to " run Block Exogeneity Wald Tests/ VAR Granger Causality" using EVIEWS. In the first part, the video first explains the VAR Granger Causality test. In the second part, the video mentions about the Block Exogeneity Wald test and how to run this method in EViews. Watch this video till end ✌️👍 1. 👉 Link to join telegram channel: t.me/kshekhawat 2. 👉 VAR ...
Treatment of Missing Values || Forecasting in EVIEWS || @komalkanwarshekhawat_
zhlédnutí 1,7KPřed rokem
Treatment of Missing Values || Forecasting in EVIEWS || @komalkanwarshekhawat_
Engle Granger Residuals Based Cointegration Test || EViews@komalkanwarshekhawat_
zhlédnutí 924Před rokem
Engle Granger Residuals Based Cointegration Test || EViews@komalkanwarshekhawat_
Paired Sample t Test || SPSS Software || Paired t Test using SPSS @komalkanwarshekhawat_
zhlédnutí 235Před rokem
Paired Sample t Test || SPSS Software || Paired t Test using SPSS @komalkanwarshekhawat_
How to decide Optimal Lag in EViews || EViews Tutorials @komalkanwarshekhawat_
zhlédnutí 2,3KPřed rokem
How to decide Optimal Lag in EViews || EViews Tutorials @komalkanwarshekhawat_
System GMM in EViews || EViews Tutorials || EViews@komalkanwarshekhawat_
zhlédnutí 5KPřed rokem
System GMM in EViews || EViews Tutorials || EViews@komalkanwarshekhawat_
What is GMM ?? || Difference GMM and System GMM
zhlédnutí 1,9KPřed rokem
What is GMM ?? || Difference GMM and System GMM
Generalized Method of Moments || GMM Model || Difference and System GMM
zhlédnutí 2,8KPřed rokem
Generalized Method of Moments || GMM Model || Difference and System GMM
How to Find Lag of a Variable ? | Generate Lags in EViews | Lag Variable | EViews Tutorials
zhlédnutí 1,5KPřed rokem
How to Find Lag of a Variable ? | Generate Lags in EViews | Lag Variable | EViews Tutorials
Model Selection Criteria || R Square || Adjusted R Square || AIC || SIC
zhlédnutí 1,1KPřed rokem
Model Selection Criteria || R Square || Adjusted R Square || AIC || SIC
How to arrange Cross- Sectional Data? || EViews Tutorials || Cross- Sectional Data
zhlédnutí 1,1KPřed rokem
How to arrange Cross- Sectional Data? || EViews Tutorials || Cross- Sectional Data
How to convert a series in Log in EViews? || EViews Tutorials || EViews @komalkanwarshekhawat_
zhlédnutí 2KPřed rokem
How to convert a series in Log in EViews? || EViews Tutorials || EViews @komalkanwarshekhawat_
How to convert a series into First Difference and Second Difference? || EViews Tutorials || EViews
zhlédnutí 2,5KPřed rokem
How to convert a series into First Difference and Second Difference? || EViews Tutorials || EViews
How to convert Yearly Data to Quarterly/ Monthly data? || EViews || EViews Tutorials
zhlédnutí 3,5KPřed rokem
How to convert Yearly Data to Quarterly/ Monthly data? || EViews || EViews Tutorials
What is a Dummy Variable ? || DUMMY VARIABLES || ECONOMETRICS
zhlédnutí 1,6KPřed rokem
What is a Dummy Variable ? || DUMMY VARIABLES || ECONOMETRICS
Second Generation Panel Unit Root Test || EViews Tutorials || CADF || CIPS || PANIC
zhlédnutí 8KPřed 2 lety
Second Generation Panel Unit Root Test || EViews Tutorials || CADF || CIPS || PANIC
Time Series Analysis || EViews Tutorials
zhlédnutí 2,8KPřed 2 lety
Time Series Analysis || EViews Tutorials
Gravity Model of Trade || Part 2 || EViews Tutorials
zhlédnutí 4,5KPřed 2 lety
Gravity Model of Trade || Part 2 || EViews Tutorials
Gravity Model of International Trade || Part I || EViews Tutorials
zhlédnutí 8KPřed 2 lety
Gravity Model of International Trade || Part I || EViews Tutorials
Impulse Response Function || EViews || EViews Tutorials
zhlédnutí 2,1KPřed 2 lety
Impulse Response Function || EViews || EViews Tutorials

Komentáře

  • @ragtagyt
    @ragtagyt Před 16 hodinami

    how to convert annual panel data to semi-annual panel data inside eviews?

  • @bbaed
    @bbaed Před 2 dny

    Thank you for your favor and reply, I have installed Eviews 12 and this option was shown to me. but my data is an unbalanced panel, and Eviews gave an error that this test (panel unit root with cross-sectional dependence) cannot be performed for an unbalanced panel. Please introduce me to the link of the video where you have taught the unit root test test (the second generation of the unit root test, with cross-sectional dependence) for the unbalanced panel. I looked for it myself, but I didn't find anything, thanks. My emphasis is on the unbalanced panel.

  • @AlexanderGG86
    @AlexanderGG86 Před 2 dny

    Thank you !

  • @IdontKnow-et7qb
    @IdontKnow-et7qb Před 4 dny

    pleasse ye be bata dy ke hum FTAbothin and FTAonein include kry

  • @IdontKnow-et7qb
    @IdontKnow-et7qb Před 4 dny

    how we include pairs of countries please tell me

  • @bbaed
    @bbaed Před 6 dny

    Hello and thank you for your scientific and valuable content, I need this answer urgently. thanks. At minute 5:51, when your mouse is on the unit root test, a small black triangle can be seen on the right side of the unit root, which shows two separate parts: 1. cross-sectionally dependent 2. cross-sectionally independent But for me, in my eviwes it is not displayed like that, and two options 1. cross sectionally dependent 2. cross-sectionally independent Is it not displayed !! My Eviews is version 11, what is the cause of this problem?

    • @komalkanwarshekhawat_
      @komalkanwarshekhawat_ Před 4 dny

      This option is available in Eviews 12.

    • @bbaed
      @bbaed Před 3 dny

      @@komalkanwarshekhawat_ Thank you for your favor and reply, I have installed Eviews 12 and this option was shown to me. but my data is an unbalanced panel, and Eviews gave an error that this test (panel unit root with cross-sectional dependence) cannot be performed for an unbalanced panel. Please introduce me to the link of the video where you have taught the unit root test test (the second generation of the unit root test, with cross-sectional dependence) for the unbalanced panel. I looked for it myself, but I didn't find anything, thanks. My emphasis is on the unbalanced panel.

  • @EkaAprilia-t8n
    @EkaAprilia-t8n Před 7 dny

    Where is the part 2 to SYS-GMM? Thank you

  • @Jesshandle
    @Jesshandle Před 8 dny

    Can you examine long-run and short-run effects using IV-GMM?

  • @lovenepal8756
    @lovenepal8756 Před 14 dny

    Hello mam how to get longrun coefficient of cross sectional data in eviews ardl?

  • @jemeka26
    @jemeka26 Před 17 dny

    Thanks for the video. Is this also applicable to the panel regression (OLS)?

  • @MahipalRathore-jn5ij
    @MahipalRathore-jn5ij Před 18 dny

    how can i and how many days are required to learn panel regression with gmm ?

  • @NYJanus
    @NYJanus Před 24 dny

    Very helpful video, thank you!

  • @tingjesline8777
    @tingjesline8777 Před 24 dny

    Hi, may I know what is the name for this test that used for endogeneity? May I know would it be possible for me to have references to test for endogeneity?

  • @mohapatraful
    @mohapatraful Před 25 dny

    Is it necessary that for causality test variables should be stationary

  • @pepe_the_frog-123
    @pepe_the_frog-123 Před 28 dny

    Thank you very much for the video and the explanation. When we are referring to "shock" of the impulse variable, do we mean like a negative or positive "shock" will result in a positive reaction of the response variable?

  • @tinaparate5400
    @tinaparate5400 Před měsícem

    Hi Ma'am, I have a question. Now I know how to get long-term coefficients, but what about the significance of thse long-run coefficients? How to get p-value for those? Also, which are the short-run coefficients? I am doing NARDL on STATA and I got variables like var1 and d(var1), I thought var1 could be long-run and and d(var1) could be short-run. I am using the NARDL module created by Marco Sunder. Could you please help me

  • @RAHULKUMAR-mt5dg
    @RAHULKUMAR-mt5dg Před měsícem

    Excellent video! Clear and easy to understand.

  • @amandeepsidhu1113
    @amandeepsidhu1113 Před měsícem

    Amazing 😍 video mam

  • @achrajkanwar3998
    @achrajkanwar3998 Před měsícem

    Veri nice video🎉🎉👌👌🥰

  • @GagandeepKaur-ul7tl
    @GagandeepKaur-ul7tl Před měsícem

    That's helpful mam and very easy to understand ❤ Thank you mam.

  • @sumanpreetkaur9159
    @sumanpreetkaur9159 Před měsícem

    That's helpful and insightful, ma'am. Thank you for sharing:)

  • @aroraji5635
    @aroraji5635 Před měsícem

    knowledgeable video mam 🙌🏻👏🏻

  • @NamrataBishnoi1103
    @NamrataBishnoi1103 Před měsícem

    ❤😊

  • @bhattianamika
    @bhattianamika Před měsícem

    👏👏🥰

  • @Astro-Secrets
    @Astro-Secrets Před měsícem

    I have one problem remove autocorrelation through lag the p value is less than 0.05 how I can slove these problem if using the log but data are both type of data positive and negative can it handle the data change into positive and using log ?

  • @mohammedkuku4744
    @mohammedkuku4744 Před měsícem

    Thanks

  • @amyfarzanasyedahamedshah3876

    Thank you very much Komal! Your videos are very helpful for my Ph D.

  • @ketkikaushik3789
    @ketkikaushik3789 Před měsícem

    very helpful video, please tell how to have long run causality test results using Block Exogeneity Wald Test, from where we can have ECT values and how to interpret them ?

  • @AleksandraSmith-p5g
    @AleksandraSmith-p5g Před měsícem

    Hello...i am getting "N/A" for my dummy variable when doing the granger causality test...please explain

  • @user-km3vo9zj9h
    @user-km3vo9zj9h Před 2 měsíci

    thank sir

  • @toammel
    @toammel Před 2 měsíci

    Unless you are willing to make assumptions, there is no way to convert yearly data into monthly or quarterly data. If you are willing to make the assumption that whatever it is you have data on happens at a uniform rate throughout the year then quarterly data would just be yearly data divided by 4.

  • @aakritigoyal3954
    @aakritigoyal3954 Před 2 měsíci

    do we check for heteroscedasticity and autocorrelation after selecting the model based on chow test, hausman test and breusch pagan test of should be check for heteroscedasticity and autocorrelation in initial stage

  • @sherin7592
    @sherin7592 Před 2 měsíci

    how did you determine the 10 lags in the command (aic 10)?

  • @AyaKhater-yn4cb
    @AyaKhater-yn4cb Před 2 měsíci

    Ma'am, I guess this was a mistake at 10.35 onwards. You said since p<0.05 (which is the case here), "we cannot reject H0, and hence we accept the alternate hypothesis of having no unit root, i.e. data is stationary." However, this conclusion is not correct: if p>0.05, yes we do not reject H0, meaning that in the case of stationarity, we would ACCEPT H0 (not H1), that is, data has a unit root or is non-stationary. I think you need to clarify this, as it will lead to a lot of confusion for others watching this video.

  • @hamzahh9932
    @hamzahh9932 Před 2 měsíci

    Menit 2:20 oke

  • @jagatdave
    @jagatdave Před 2 měsíci

    perfect... in short time.. optimum gyaan shared

  • @redaoumlil1465
    @redaoumlil1465 Před 2 měsíci

    Hello how can i generate impulse response function for parsimonious VAR model ? there is no option for that in eviews

  • @DafneHuayta
    @DafneHuayta Před 2 měsíci

    Thank you so much for your videos, they are very useful for me. My question is if I can use this model to estimate the effect of the trade agreement on the exports of a single trading partner, without using the data panel for several countries.

  • @fezilemakhuleni5329
    @fezilemakhuleni5329 Před 2 měsíci

    Thank you

  • @smeethbista7926
    @smeethbista7926 Před 3 měsíci

    Is your data of t-bill in percentage?

  • @richapatel8892
    @richapatel8892 Před 3 měsíci

    Why does panel ardl doesn't have rsquare value

  • @krhng-ev5zm
    @krhng-ev5zm Před 3 měsíci

    thank you...also show on spss how anova &.Acnova model results are interpreted

    • @komalkanwarshekhawat_
      @komalkanwarshekhawat_ Před 3 měsíci

      Welcome 🙏 Video is already uploaded, kindly watch - czcams.com/video/oBOr6pNF_Qg/video.htmlsi=SbY3jRsTtRNMBk8W

  • @academydrawing
    @academydrawing Před 3 měsíci

    For unbalanced panel fata how to do it in ky case problem of csd cone so i want to run cips but since data unbalanced i cant apply also cadf is not giving t value what shall i do

  • @deeplearners5563
    @deeplearners5563 Před 3 měsíci

    Dear Komal, Can you please help me how to apply quantile VAR approach?????

  • @joseph_tuakolontokpah3468
    @joseph_tuakolontokpah3468 Před 3 měsíci

    Thanks so kindly for this informative video. However, the interpolation feature is not available in the student version of "Eviews 12". Can you help with an alternative?

    • @komalkanwarshekhawat_
      @komalkanwarshekhawat_ Před 3 měsíci

      Dear, the interpolation feature is available.

    • @josephtokpah8238
      @josephtokpah8238 Před 3 měsíci

      What possibly could be reason preventing the feature to displayed?

    • @josephtokpah8238
      @josephtokpah8238 Před 3 měsíci

      Is it that missing value should be consistent with each other? Should the missing values have the same gap?

  • @achouak4140
    @achouak4140 Před 4 měsíci

    Hank you so much ❤❤❤

  • @yasirzia
    @yasirzia Před 4 měsíci

    Thank you very much, Komal, for a nice explanation.

  • @dr.syedmd.khaledrahman8240
    @dr.syedmd.khaledrahman8240 Před 4 měsíci

    Greetings. Do you have time series data analysis videos?

  • @raufkhan5846
    @raufkhan5846 Před 4 měsíci

    Ma'am how can I contact you?

    • @komalkanwarshekhawat_
      @komalkanwarshekhawat_ Před 4 měsíci

      Mail your query - kshekhawat599@gmail.com Join my Telegram channel- t.me/kshekhawat

  • @dr.syedmd.khaledrahman8240
    @dr.syedmd.khaledrahman8240 Před 4 měsíci

    Good explanation