Analytics Training
Analytics Training
  • Видео 168
  • Просмотров 18 282
Extract data from ms access part 2 Power Query
This channel will give you understanding of analytics, data science, reporting. You will get expert level knowledge of Advance Excel, VBA, SQL, Ms access, Tableau, Power BI, SSRS, SSIS, SSAS, Data Science with R and Python.
Просмотров: 16

Видео

Extract data from SQL Server
Просмотров 9014 дней назад
This channel will give you understanding of analytics, data science, reporting. You will get expert level knowledge of Advance Excel, VBA, SQL, Ms access, Tableau, Power BI, SSRS, SSIS, SSAS, Data Science with R and Python.
Extract Data from Ms Access and Transformation (Power Query)
Просмотров 4121 день назад
This channel will give you understanding of analytics, data science, reporting. You will get expert level knowledge of Advance Excel, VBA, SQL, Ms access, Tableau, Power BI, SSRS, SSIS, SSAS, Data Science with R and Python.
Conditional Formatting3
Просмотров 1621 день назад
This channel will give you understanding of analytics, data science, reporting. You will get expert level knowledge of Advance Excel, VBA, SQL, Ms access, Tableau, Power BI, SSRS, SSIS, SSAS, Data Science with R and Python.
Conditional formatting Part 1
Просмотров 1821 день назад
This channel will give you understanding of analytics, data science, reporting. You will get expert level knowledge of Advance Excel, VBA, SQL, Ms access, Tableau, Power BI, SSRS, SSIS, SSAS, Data Science with R and Python.
Conditional Formatting2
Просмотров 221 день назад
This channel will give you understanding of analytics, data science, reporting. You will get expert level knowledge of Advance Excel, VBA, SQL, Ms access, Tableau, Power BI, SSRS, SSIS, SSAS, Data Science with R and Python.
Pivot Table Slicer
Просмотров 182 месяца назад
This channel will give you understanding of analytics, data science, reporting. You will get expert level knowledge of Advance Excel, VBA, SQL, Ms access, Tableau, Power BI, SSRS, SSIS, SSAS, Data Science with R and Python.
Advanced Offset Function to create dynamic range
Просмотров 1064 месяца назад
Offset function is used to create dynamic range.
Conditional Formatting for TOPN value
Просмотров 645 месяцев назад
Highlights your values based on TOPN parameters
Basics of Pivot Table
Просмотров 157 месяцев назад
This channel will give you understanding of analytics, data science, reporting. You will get expert level knowledge of Advance Excel, VBA, SQL, Ms access, Tableau, Power BI, SSRS, SSIS, SSAS, Data Science with R and Python.
Calculated Field in Pivot Table
Просмотров 278 месяцев назад
Calculated field in power bi helps to create drive column for data analytics
Excel Advanced Filter
Просмотров 108 месяцев назад
Filter data from one place to another place using advanced filter
Offset Advanced
Просмотров 6810 месяцев назад
Offset function is used to make your cell or range reference. Reference can be dynamic or static.
Advanced Date Functions in Excel
Просмотров 710 месяцев назад
These date function helps you to work on Time Series Analysis.
Offset Function
Просмотров 2710 месяцев назад
Offset function create a cell or range.
Date Function in Excel
Просмотров 1610 месяцев назад
Date Function in Excel
AND Operator in Excel
Просмотров 611 месяцев назад
AND Operator in Excel
Advanced Substitute Function
Просмотров 3411 месяцев назад
Advanced Substitute Function
Replace Function
Просмотров 3711 месяцев назад
Replace Function
Advance use of Substitute
Просмотров 3411 месяцев назад
Advance use of Substitute
Substitute Function to Replace Value
Просмотров 3911 месяцев назад
Substitute Function to Replace Value
MID Function
Просмотров 24Год назад
MID Function
Right Function with Dynamic Data
Просмотров 25Год назад
Right Function with Dynamic Data
Left Function with Live Example
Просмотров 13Год назад
Left Function with Live Example
Index on two data sets
Просмотров 19Год назад
Index on two data sets
Index Function in Excel
Просмотров 52Год назад
Index Function in Excel
Excel Shortcut
Просмотров 135Год назад
Excel Shortcut
Advanced Paste Special
Просмотров 24Год назад
Advanced Paste Special
Format Painter
Просмотров 37Год назад
Format Painter
HLOOKUP on Various Data Sets
Просмотров 46Год назад
HLOOKUP on Various Data Sets

Комментарии

  • @09kq1a0158
    @09kq1a0158 15 дней назад

    Can I get your contact info please need a help

  • @MariopMack
    @MariopMack 26 дней назад

    Hello Shishir Kumar , Can you give me a chance to ask a question about your course on udemy?

  • @MariopMack
    @MariopMack 26 дней назад

    Hello Shishir Kumar , Can you give me a chance to ask a question about your course on udemy?

  • @mr.panchal2304
    @mr.panchal2304 7 месяцев назад

    Keep it up bro

  • @Gamer1050Ti
    @Gamer1050Ti 10 месяцев назад

    what if i want full names in lower case as result

  • @harshtanwar1140
    @harshtanwar1140 11 месяцев назад

    Very informative video sir

  • @shishirkumar9176
    @shishirkumar9176 Год назад

    Call me 9899282365

  • @cosmopolitanguru3595
    @cosmopolitanguru3595 Год назад

    How can I get your course ?

  • @engineerimrana2213
    @engineerimrana2213 Год назад

    Hello sir How i can join your live classes ?

  • @jonnathanjon1
    @jonnathanjon1 Год назад

    Hello Thanks for this simple video. Can you please suggest how to modify it to concatenate based on Column header name "Firstname", "Lastname" instead of Range("A" & Counter) , Range("B" & Counter)? my data keep changing every week.

  • @Victoria-dh9jp
    @Victoria-dh9jp Год назад

    Thanks

  • @RArcher18
    @RArcher18 Год назад

    Very EASY to follow. Thank you! Let's say we wanted to: Delete columns "A" and "B" afterwards, and Autofit column "C", AND change the order or position of other columns by their header in the same worksheet. Can you create another video demonstrating this?

  • @AnekDhara
    @AnekDhara 2 года назад

    Its a good example, but the code is concatenating only 20 rows maximum, please explain

  • @ORANGEPICTURESOFFICIAL
    @ORANGEPICTURESOFFICIAL 2 года назад

    Sir please continue with more concepts........

  • @deninsrmic4165
    @deninsrmic4165 2 года назад

    Thank you for nice explanation on Environ Function.

  • @gabrielalade7793
    @gabrielalade7793 3 года назад

    Wow, this is nice. is there a shot way to write the code?

  • @viveksharma4193
    @viveksharma4193 3 года назад

    From where we can acess your 90 video

  • @LearnMoreOnline1
    @LearnMoreOnline1 3 года назад

    Keep it up. I have subscribed your very informative channel and like your video also. You will do fantastic ... 👍👍👍👍. I am your permanant SUBSCRIBER.

    • @shishirkumar9176
      @shishirkumar9176 3 года назад

      Thank you so much. pls provide me feedback also to enhance quality of videos and channel

  • @helensullivan4418
    @helensullivan4418 3 года назад

    ki0fg vyn.fyi

  • @anuptiwari4754
    @anuptiwari4754 3 года назад

    Great.. 👍👍

  • @MohAboAbdo
    @MohAboAbdo 3 года назад

    Thank you so match, Sir.

  • @MohAboAbdo
    @MohAboAbdo 3 года назад

    Thank you so match, Sir.

  • @MohAboAbdo
    @MohAboAbdo 3 года назад

    Thank you so match, Sir.

  • @MohAboAbdo
    @MohAboAbdo 3 года назад

    Thank you so match, Sir.

  • @MohAboAbdo
    @MohAboAbdo 3 года назад

    Thank you so match, Sir.

  • @anuptiwari4754
    @anuptiwari4754 3 года назад

    This is very helpful sir... Great.. 👍👍

  • @arjuno5950
    @arjuno5950 3 года назад

    👍

  • @arjuno5950
    @arjuno5950 3 года назад

    Nice

  • @emmaelaine2874
    @emmaelaine2874 3 года назад

    vx9 vum.fyi

  • @tanujsharma2812
    @tanujsharma2812 3 года назад

    I need a code in vba that pastes a range from sheet 2 to sheet 3 automatically when any value in that range changes Please help.

  • @MohAboAbdo
    @MohAboAbdo 3 года назад

    Thank you so mutch.

  • @faris-math
    @faris-math 3 года назад

    Very good

  • @RajKumar-si2os
    @RajKumar-si2os 3 года назад

    🖒

  • @SIRJITechnical
    @SIRJITechnical 3 года назад

    Gud

  • @matorwmasen
    @matorwmasen 3 года назад

    Please, what code will select the next available row eg. A28 Thanks alot. Learning from your video.

    • @shishirkumar9176
      @shishirkumar9176 3 года назад

      You are talking about blank row. Wait for next video

  • @RajKumar-si2os
    @RajKumar-si2os 3 года назад

    👍

  • @cameronbetts6720
    @cameronbetts6720 3 года назад

    Great uploads 😃 Hopefully you’ll be interested in my mates content too. He features tips and DIY info. Take a gander! --> #HondaMobileMechanic 🤙🏼🚗