Excel (A-Z)
Excel (A-Z)
  • Видео 2 540
  • Просмотров 7 756 270
Data extraction from multiple pdf and append data in excel - Data Analytics Basics
This excel tutorial video shows you data extraction from multiple pdf's and append data using power query in excel.
Join this channel to get access to perks:
ruclips.net/channel/UCr_MTGrHVG78jGSWbGnNIvwjoin
Excel Tips & Tricks : ruclips.net/p/PLZnHzQfaP-kM1-Vfhd_h19jTKbYEuGgD-
Excel Analysis : ruclips.net/p/PLZnHzQfaP-kOY6XVgxq5KX94m9dvCp4I5
Excel Functions : ruclips.net/p/PLZnHzQfaP-kOV5sfQqKEHg4gD_88FPcfL
Excel DAX formulas : ruclips.net/p/PLZnHzQfaP-kPri8SUozzLqA6ZEF77-UVx
Excel for Job Interview : ruclips.net/p/PLZnHzQfaP-kNz4N7gdDwbw1-xelRiqNs8
Excel 365 Features : ruclips.net/p/PLZnHzQfaP-kP73WZ1j2r5eelCQv1nM8Fn
Excel 2019 Features : ruclips.net/p/PLZnHzQfaP-kNjDGlDUe7102SgVA2bNLHn
Mobile Exc...
Просмотров: 83

Видео

How to ignore errors and sum data in excel - MS Excel Tips & Tricks
Просмотров 957 часов назад
This excel tutorial video shows you how to ignore errors and sum data in excel using formula. Join this channel to get access to perks: ruclips.net/channel/UCr_MTGrHVG78jGSWbGnNIvwjoin Excel Tips & Tricks : ruclips.net/p/PLZnHzQfaP-kM1-Vfhd_h19jTKbYEuGgD- Excel Analysis : ruclips.net/p/PLZnHzQfaP-kOY6XVgxq5KX94m9dvCp4I5 Excel Functions : ruclips.net/p/PLZnHzQfaP-kOV5sfQqKEHg4gD_88FPcfL Excel DA...
#44 - Excel Functions MCQ - Impress Interviewers with Your Expertise!
Просмотров 4612 часов назад
What excel function returns statistics for a time series forecast based on exponential smoothing and state space models? Join this channel to get access to perks: ruclips.net/channel/UCr_MTGrHVG78jGSWbGnNIvwjoin Excel Tips & Tricks : ruclips.net/p/PLZnHzQfaP-kM1-Vfhd_h19jTKbYEuGgD- Excel Analysis : ruclips.net/p/PLZnHzQfaP-kOY6XVgxq5KX94m9dvCp4I5 Excel Functions : ruclips.net/p/PLZnHzQfaP-kOV5s...
101 Master Excel VBA Code with an Exciting Quiz | Let's Play and Learn
Просмотров 5014 часов назад
How to close the workbook without saving in excel using vba code? Join this channel to get access to perks: ruclips.net/channel/UCr_MTGrHVG78jGSWbGnNIvwjoin This excel quiz tutorial video shows you VBA code related MCQ with question and answer. Challenge Your Knowledge and Level Up in excel vba code. Let's start and learn. This is quick excel video tutorial created for quiz and to save your tim...
Quickly get flag, gdp, official language for 50 countries in excel - MS Excel Tips & Tricks
Просмотров 5719 часов назад
This excel tutorial video shows you how to get flag, gdp, official language details for 50 countries quickly in excel. Join this channel to get access to perks: ruclips.net/channel/UCr_MTGrHVG78jGSWbGnNIvwjoin Excel Tips & Tricks : ruclips.net/p/PLZnHzQfaP-kM1-Vfhd_h19jTKbYEuGgD- Excel Analysis : ruclips.net/p/PLZnHzQfaP-kOY6XVgxq5KX94m9dvCp4I5 Excel Functions : ruclips.net/p/PLZnHzQfaP-kOV5sfQ...
How to change date format super quickly in excel - Excel Tips & Tricks
Просмотров 140День назад
This excel tutorial video shows you how to change date format super quickly in excel using simple excel technique. If you like this video, please like and comment. Thanks for watching this video. Please do share! Join this channel to get access to perks: ruclips.net/channel/UCr_MTGrHVG78jGSWbGnNIvwjoin Excel Tips & Tricks : ruclips.net/p/PLZnHzQfaP-kM1-Vfhd_h19jTKbYEuGgD- Excel Analysis : rucli...
#43 - Excel Functions MCQ - Impress Interviewers with Your Expertise!
Просмотров 51День назад
What excel function calculates the chi-squared statistic for testing independence of two sets of data? Join this channel to get access to perks: ruclips.net/channel/UCr_MTGrHVG78jGSWbGnNIvwjoin Excel Tips & Tricks : ruclips.net/p/PLZnHzQfaP-kM1-Vfhd_h19jTKbYEuGgD- Excel Analysis : ruclips.net/p/PLZnHzQfaP-kOY6XVgxq5KX94m9dvCp4I5 Excel Functions : ruclips.net/p/PLZnHzQfaP-kOV5sfQqKEHg4gD_88FPcfL...
100 Master Excel VBA Code with an Exciting Quiz | Let's Play and Learn
Просмотров 41День назад
How to delete worksheet in excel using vba code? Join this channel to get access to perks: ruclips.net/channel/UCr_MTGrHVG78jGSWbGnNIvwjoin This excel quiz tutorial video shows you VBA code related MCQ with question and answer. Challenge Your Knowledge and Level Up in excel vba code. Let's start and learn. This is quick excel video tutorial created for quiz and to save your time as well. If you...
Quickly map all data using single formula in excel - Excel for Audit and Auditors
Просмотров 11714 дней назад
How to map al data quickly using xlookup formula in excel. This method will reduce your mapping time drastically. This mapping will increase your efficiency in excel. Join this channel to get access to perks: ruclips.net/channel/UCr_MTGrHVG78jGSWbGnNIvwjoin Excel Tips & Tricks : ruclips.net/p/PLZnHzQfaP-kM1-Vfhd_h19jTKbYEuGgD- Excel Analysis : ruclips.net/p/PLZnHzQfaP-kOY6XVgxq5KX94m9dvCp4I5 Ex...
How to review data super quickly in excel - Excel for Audit and Auditors
Просмотров 19014 дней назад
How to review data super quickly in excel - Excel for Audit and Auditors
#42 - Excel Functions MCQ - Impress Interviewers with Your Expertise!
Просмотров 5414 дней назад
#42 - Excel Functions MCQ - Impress Interviewers with Your Expertise!
99 Master Excel VBA Code with an Exciting Quiz | Let's Play and Learn
Просмотров 4614 дней назад
99 Master Excel VBA Code with an Exciting Quiz | Let's Play and Learn
How to create Data modelling in excel - Data Analytics Basics
Просмотров 52721 день назад
How to create Data modelling in excel - Data Analytics Basics
How to make P&L (capital gain) report quickly for stocks investment in excel
Просмотров 13521 день назад
How to make P&L (capital gain) report quickly for stocks investment in excel
#41 - Excel Functions MCQ - Impress Interviewers with Your Expertise!
Просмотров 5121 день назад
#41 - Excel Functions MCQ - Impress Interviewers with Your Expertise!
70 Can you pass this beginner-friendly VBA Excel quiz?
Просмотров 6121 день назад
70 Can you pass this beginner-friendly VBA Excel quiz?
How to clean the data quickly in excel - Data cleaning in excel
Просмотров 44528 дней назад
How to clean the data quickly in excel - Data cleaning in excel
98 Master Excel VBA Code with an Exciting Quiz | Let's Play and Learn
Просмотров 6128 дней назад
98 Master Excel VBA Code with an Exciting Quiz | Let's Play and Learn
How to check and clean minor differences in excel - Data cleaning in excel
Просмотров 13428 дней назад
How to check and clean minor differences in excel - Data cleaning in excel
69 Can you pass this beginner-friendly VBA Excel quiz?
Просмотров 70Месяц назад
69 Can you pass this beginner-friendly VBA Excel quiz?
97 Master Excel VBA Code with an Exciting Quiz | Let's Play and Learn
Просмотров 84Месяц назад
97 Master Excel VBA Code with an Exciting Quiz | Let's Play and Learn
How to delete unwanted custom format in excel - MS Excel Tips & Tricks
Просмотров 151Месяц назад
How to delete unwanted custom format in excel - MS Excel Tips & Tricks
#40 - Excel Functions MCQ - Impress Interviewers with Your Expertise!
Просмотров 86Месяц назад
#40 - Excel Functions MCQ - Impress Interviewers with Your Expertise!
68 Can you pass this beginner-friendly VBA Excel quiz?
Просмотров 76Месяц назад
68 Can you pass this beginner-friendly VBA Excel quiz?
Multi Dynamic conditional using custom format in excel - MS Excel Tips & Tricks
Просмотров 76Месяц назад
Multi Dynamic conditional using custom format in excel - MS Excel Tips & Tricks
96 Master Excel VBA Code with an Exciting Quiz | Let's Play and Learn
Просмотров 63Месяц назад
96 Master Excel VBA Code with an Exciting Quiz | Let's Play and Learn
How to add suffix data using custom format in excel - MS Excel Tips & Tricks
Просмотров 137Месяц назад
How to add suffix data using custom format in excel - MS Excel Tips & Tricks
#39 - Excel Functions MCQ - Impress Interviewers with Your Expertise!
Просмотров 62Месяц назад
#39 - Excel Functions MCQ - Impress Interviewers with Your Expertise!
67 Can you pass this beginner-friendly VBA Excel quiz?
Просмотров 70Месяц назад
67 Can you pass this beginner-friendly VBA Excel quiz?
How to get required columns from bulk data in excel | Excel for auditing & auditors
Просмотров 157Месяц назад
How to get required columns from bulk data in excel | Excel for auditing & auditors

Комментарии

  • @markheatherington8367
    @markheatherington8367 День назад

    clear and to the point, thanks!!

    • @ExcelAZ
      @ExcelAZ День назад

      Yep. Thanks for your valuable feedback!

  • @sazisomnyandu9546
    @sazisomnyandu9546 2 дня назад

    Thank you it works so well

    • @ExcelAZ
      @ExcelAZ 2 дня назад

      You're welcome!

  • @khaledkelany4052
    @khaledkelany4052 2 дня назад

    After the sequence formula, you can just check for duplicates and then filter by color

    • @ExcelAZ
      @ExcelAZ 2 дня назад

      Wow! Thanks for the info! 🥂

  • @GameAGuy
    @GameAGuy 3 дня назад

    OK QUESTION. WHENEVER YOU TRY TO PROTECT SHEET YOU GET ERROR DEBUG MESSAGE CAUSE PROTECT BLOCKS THE CODE. HOW DO WE PREVENT THIS WHILE STILL PROTECTING SHEET?

    • @ExcelAZ
      @ExcelAZ 3 дня назад

      🤔

    • @GameAGuy
      @GameAGuy 3 дня назад

      @@ExcelAZ ran a macro to auto fit

    • @GameAGuy
      @GameAGuy 3 дня назад

      When you click protect it gives error 1004

    • @ExcelAZ
      @ExcelAZ 3 дня назад

      Do you want to autofit in protect sheet?

    • @GameAGuy
      @GameAGuy 2 дня назад

      @@ExcelAZ yes

  • @MahmoodKhan-z2f
    @MahmoodKhan-z2f 5 дней назад

    😁

  • @mohammadalbizri2013
    @mohammadalbizri2013 9 дней назад

    Nice

    • @ExcelAZ
      @ExcelAZ 7 дней назад

      Thanks 🥂

  • @sunilnag5611
    @sunilnag5611 12 дней назад

    its working ...awesome trick..Thanks

    • @ExcelAZ
      @ExcelAZ 12 дней назад

      Great 🥂

  • @kukingkong7827
    @kukingkong7827 13 дней назад

    Thank you, finally found exactly what I wished for.

    • @ExcelAZ
      @ExcelAZ 12 дней назад

      Glad I could help! 🥂

  • @B1tkidd
    @B1tkidd 15 дней назад

    e

  • @WhiskerJargon
    @WhiskerJargon 19 дней назад

    Thank you for dropping the links to the excel spreadsheets. You helped make my life a lot easier. 🫡

    • @ExcelAZ
      @ExcelAZ 19 дней назад

      You are so welcome!

  • @abderrahmaneazibi8056
    @abderrahmaneazibi8056 19 дней назад

    I'm late for four years since you shared this emerald. Many thanks bro.

    • @ExcelAZ
      @ExcelAZ 19 дней назад

      You're welcome bro 💐

  • @adimasprasetyaaji9995
    @adimasprasetyaaji9995 20 дней назад

    Haha

  • @manjmax
    @manjmax 21 день назад

    Please explain and make a video. That would be very much helpful rather than BG music..

    • @ExcelAZ
      @ExcelAZ 21 день назад

      Noted. Thanks!

  • @ahsanw2136
    @ahsanw2136 Месяц назад

    Great JOB

    • @ExcelAZ
      @ExcelAZ Месяц назад

      Thank you my dear 🥂

  • @karansmarty515
    @karansmarty515 Месяц назад

    I never thought about this. 👍 One more question what us thr name of the tool which you have used after taking screenshot.

    • @ExcelAZ
      @ExcelAZ Месяц назад

      Thanks for your comment 🥂

  • @annephilipiah1455
    @annephilipiah1455 Месяц назад

    Thank you

    • @ExcelAZ
      @ExcelAZ Месяц назад

      You're welcome

  • @josephbennett7162
    @josephbennett7162 Месяц назад

    Thank you!

    • @ExcelAZ
      @ExcelAZ Месяц назад

      You're welcome! 💐

  • @hafizuldee8662
    @hafizuldee8662 Месяц назад

    thanks this really helpfull

    • @ExcelAZ
      @ExcelAZ Месяц назад

      Glad it helped 🥂

  • @godsontc243
    @godsontc243 Месяц назад

    Great video , incredable time saving method

    • @ExcelAZ
      @ExcelAZ Месяц назад

      Glad you think so! 💝

  • @donak19
    @donak19 Месяц назад

    Thank you for the video. The steps were simple and easy to follow. After spending hours on unhelpful video finally used your steps which worked perfectly on the spreadsheet.

    • @ExcelAZ
      @ExcelAZ Месяц назад

      Glad it helped! 👏👏

  • @user-ll6es2ds9x
    @user-ll6es2ds9x Месяц назад

    Pune cut Ho Gaya

  • @ConfusedKoala-tf1np
    @ConfusedKoala-tf1np Месяц назад

    Meaning of Kurt

    • @ExcelAZ
      @ExcelAZ Месяц назад

      Function name

  • @TheKratosLegacy
    @TheKratosLegacy Месяц назад

    Good morning, could be helpfull if you copy the code directly under the video.

    • @ExcelAZ
      @ExcelAZ Месяц назад

      You may take screenshot

  • @sugunachandran1263
    @sugunachandran1263 Месяц назад

    Great effort but not understood without audio because im having low memory capacity

    • @ExcelAZ
      @ExcelAZ Месяц назад

      Action speaks louder than words! The concept is watch & practice. You will learn. There is no need to memorize. Thanks!

  • @peerzadabashir4540
    @peerzadabashir4540 Месяц назад

    Sir how to convert word to number. Not convert number into word.

    • @ExcelAZ
      @ExcelAZ Месяц назад

      At present there is no formula available in excel. But using VBA code it can be done.

  • @Alesini100
    @Alesini100 Месяц назад

    Thanks! :D

  • @mkaberli614
    @mkaberli614 Месяц назад

    Maybe someone got something out of this video, but I didn't

  • @DipakShelake
    @DipakShelake 2 месяца назад

    Bolo yar😂😂

    • @ExcelAZ
      @ExcelAZ Месяц назад

      Hindi or English or French ???

  • @Tommy7417
    @Tommy7417 2 месяца назад

    👍👍👍

  • @chrisk.9765
    @chrisk.9765 2 месяца назад

    What is the purpose this kind of video series?

    • @ExcelAZ
      @ExcelAZ 2 месяца назад

      This is for VBA beginners.

  • @IOSALive
    @IOSALive 2 месяца назад

    Excel (A-Z), This is fantastic! I subscribed because I love it!

    • @ExcelAZ
      @ExcelAZ 2 месяца назад

      Wow, thanks!

  • @isakkronlund4755
    @isakkronlund4755 2 месяца назад

    Thank you for your amazing tutorial🙌.This really helps me to prepare for an incoming test in excel😁

  • @xeeshanahmad8757
    @xeeshanahmad8757 2 месяца назад

    ❤ Excellent video. Keep up

  • @mohammadalbizri2013
    @mohammadalbizri2013 2 месяца назад

    Thank you

    • @ExcelAZ
      @ExcelAZ 2 месяца назад

      You're welcome

  • @user-sn7wk8ng6v
    @user-sn7wk8ng6v 2 месяца назад

    IT WORKED!!!! BLESS YOU!!

    • @ExcelAZ
      @ExcelAZ 2 месяца назад

      Glad to hear 👍

  • @yxllow7296
    @yxllow7296 2 месяца назад

    I need the data analysis for my hypothesis testing😭

  • @xeeshanahmad8757
    @xeeshanahmad8757 2 месяца назад

    Very informative

    • @ExcelAZ
      @ExcelAZ 2 месяца назад

      Glad it was helpful!

  • @timdurgan
    @timdurgan 2 месяца назад

    Why is the answer 2? If you're trying to forecast a value figure, shouldn't it be somewhere between 5k and 6k?

    • @ExcelAZ
      @ExcelAZ 2 месяца назад

      Why not?

    • @timdurgan
      @timdurgan 2 месяца назад

      @@ExcelAZ well if the formula is meant to be forecasting based on the data you have, the forecast should be somewhere in the range of 5 - 6k, considering that's the range of the dataset. I don't understand why a dataset would go from 5.5k to 2 all of a sudden

    • @ipolendo
      @ipolendo 2 месяца назад

      @timdurgan I think the function is trying to calculate the seasonalities, not the value. In other words, according to Excel in this excercise detects two seasonalities .. moreless like 2 quarters.

  • @melodygeddes7622
    @melodygeddes7622 2 месяца назад

    Thank you… what if I am not seeing the sheets listed below… like sheet 1 | sheet 2 | sheet 3 (all gone!) I’m not seeing the option to click on any of them.

  • @Nascimento_Pop100
    @Nascimento_Pop100 2 месяца назад

    Excelent!

    • @ExcelAZ
      @ExcelAZ 2 месяца назад

      Thanks 🥂

  • @castransfin1024
    @castransfin1024 2 месяца назад

    what happen?how to teach something that no one is explaining? do you think is effective?

    • @ExcelAZ
      @ExcelAZ 2 месяца назад

      Action speaks louder than words 📸

  • @Mubashar783
    @Mubashar783 2 месяца назад

    The Music reminds me of time when i used to watch Mr. Scientific Years ago 😢 (nostalgia) That was my Golden age

    • @ExcelAZ
      @ExcelAZ 2 месяца назад

      💝💐📸

  • @sugunachandran1263
    @sugunachandran1263 2 месяца назад

    Sir please provide audio it will help to easy understand

    • @ExcelAZ
      @ExcelAZ 2 месяца назад

      Yeah sure 👍

  • @djkelemics8078
    @djkelemics8078 2 месяца назад

    Thanks 🙏

    • @ExcelAZ
      @ExcelAZ 2 месяца назад

      You’re welcome 😊

  • @louibaby0890
    @louibaby0890 2 месяца назад

    I don’t have that green box how do u do it?

    • @ExcelAZ
      @ExcelAZ 2 месяца назад

      Color it dude

  • @SivaSankar-du1ur
    @SivaSankar-du1ur 2 месяца назад

    what to do if the no of rows is very large like 100 rows then how to do

    • @ExcelAZ
      @ExcelAZ 2 месяца назад

      It doesn't matter.

  • @antony_vijay16
    @antony_vijay16 2 месяца назад

    What about Google sheet. This formula works?

  • @deepakbhatia9757
    @deepakbhatia9757 2 месяца назад

    VERY NICE THANKS

    • @ExcelAZ
      @ExcelAZ 2 месяца назад

      Most welcome 😊

  • @deprof10
    @deprof10 2 месяца назад

    Thank you but next time, try to the talk in your tutorial, talk, talk, talk, not only video, talk, so that people will understand fast

    • @ExcelAZ
      @ExcelAZ 2 месяца назад

      Thanks for the tip 🥂

  • @horacioelizondo7133
    @horacioelizondo7133 2 месяца назад

    I hope you would call things for what they are. This is not 'Make sentences quickly'. This is just, 'how to use the fill function in excel'.

    • @ExcelAZ
      @ExcelAZ 2 месяца назад

      👏📸👏