![ExcelTips](/img/default-banner.jpg)
- Видео 36
- Просмотров 644 127
ExcelTips
США
Добавлен 4 апр 2020
Looking for Excel Tips and Tricks to make your life easier? We make videos on some of the must-have excel skills like excel formulas, excel formatting, excel charts, and basic visual basic.
So if you want to breeze through those excel spreadsheets and create stunning charts - then this is the community for you.
So if you want to breeze through those excel spreadsheets and create stunning charts - then this is the community for you.
Calculate Rank in Excel (Both Ascending and Descending)
Use Excel RANK function to compare numbers in an Excel list. Here we will show which student got the highest number or which athelete completed the race with the lowest time - i.e. using the Rank function for descending as well as ascending rank.
Click here to subscribe to my channel to get more videos of Excel formula tips and uses:
ruclips.net/channel/UCSd9vq86eRNejw_WoxlSFZw
Click here to subscribe to my channel to get more videos of Excel formula tips and uses:
ruclips.net/channel/UCSd9vq86eRNejw_WoxlSFZw
Просмотров: 941
Видео
Add bullet points in Excel (Works with Laptop Keyboard)
Просмотров 5 тыс.2 года назад
In this video, we will see how to add bullet points in Excel. We will see how to add bullet points from a laptop keyboard ( a keyboard without the num pads) - We will also see how we can create a Bullet List by adding multiple Bullet points in an Excel cell. Click here to subscribe to my channel to get more videos of Excel formula tips and uses: ruclips.net/channel/UCSd9vq86eRNejw_WoxlSFZw
Calculate Cube Root in Excel (Using a Simple Formula)
Просмотров 2,2 тыс.2 года назад
In this video, we will see how to find cube root in excel - using an excel formula We will use the POWER formula to find the cube root of a number. Click here to subscribe to my channel to get more videos of Excel formula tips and uses: ruclips.net/channel/UCSd9vq86eRNejw_WoxlSFZw Check out this video on how to calculate the Square Root in Excel : ruclips.net/video/bjoFT8byRlI/видео.html
Find top 5 values in excel list (Works for Top N Values | No Formula Required)
Просмотров 1,6 тыс.2 года назад
In this video, I will show you how to find the top 5 values in an excel list. I will also show you how to make the results dynamic - so that you can display the top 10 values in an excel list. This method can also be used to find the top n values from an excel list - without using a formula Please refer to the below video to know more about Slicers: ruclips.net/video/UX5pehohal8/видео.html Clic...
Calculate Future Value Of Investment (Using a Simple Excel Formula)
Просмотров 7182 года назад
In this video, we will see how to calculate the future value in Excel using the FV function. We will see how to calculate the future value of an investment assuming a constant interest rate and periodic, constant payments. We will look at 3 examples that will help you to understand how to use the FV function correctly. Let me know in the comments if you face issues in calculating the future val...
Find the Highest Number in Excel Column (Works with Blank Cells and Text Cells also)
Просмотров 2062 года назад
In this video, I will show you how to find the largest number in excel using the MAX and the MAXA formula. I will show you how a method that can find the largest number in an Excel column that also has Blank Cells or has Text values. We will also discuss the differences between the MAX and MAXA formulas and when to use which formula. Click here to subscribe to my channel to get more videos of E...
Copy values not formulas (Remove Formula keep Values) - Excel
Просмотров 4712 года назад
How to copy values not formulas in Excel? We discuss three easy ways to copy values in Excel without the formulas in this video - We will easily copy cells that contain a formula and paste them in a way that will keep only the values of the cells, not the formulas inside them. Using any of the three methods, you can Remove formulas and keep values in Excel Please also refer to these keyboard sh...
How to Remove Table format in Excel
Просмотров 3892 года назад
In this video, we will see how to Remove Table Format in Excel using two easy steps Please use the below Key combination to remove all formatting as shown in the video: ALT E A F Click here to subscribe to my channel to get more videos of Excel formula tips and uses: ruclips.net/channel/UCSd9vq86eRNejw_WoxlSFZw Check out our Excel Graph Playlist for ideas on creating great-looking charts : rucl...
Remove all unwanted spaces in Excel
Просмотров 1,5 тыс.2 года назад
In this video, we will see how to Remove All Unwanted Spaces by using a very simple formula This method also allows you to remove whitespaces, non-printable characters as well as Non-breaking spaces (CHAR160). The formulae used are as below: = TRIM("CELL REFERENCE") = TRIM(CLEAN("CELL REFERENCE")) = TRIM(CLEAN(SUBSTITUTE("CELL REFERENCE",CHAR(160)," "))) Click here to subscribe to my channel to...
Reverse or Flip Data range in Excel
Просмотров 2,6 тыс.3 года назад
In this video, we will see how to reverse a list in Excel using a simple trick. This method allows you to Reverse or Flip Data range in Excel in place - you do not need to create a copy - the original list is reversed. Click here to subscribe to my channel to get more videos of Excel formula tips and uses: ruclips.net/channel/UCSd9vq86eRNejw_WoxlSFZw Check out our Excel Graph Playlist for ideas...
Calculate months between two dates excel - No VBA
Просмотров 4,7 тыс.3 года назад
In this video, we will see how to Calculate months between two dates in excel by using a very simple formula This method also allows you to Calculate days or years between two dates in excel Click here to subscribe to my channel to get more videos of Excel formula tips and uses: ruclips.net/channel/UCSd9vq86eRNejw_WoxlSFZw Check out our Excel Graph Playlist for ideas on creating great-looking c...
Find percentage difference between two numbers - In Excel
Просмотров 39 тыс.3 года назад
In this video, we will see how to find percentage difference between two numbers in excel using a very simple formula This method allows you to find percentage increase as well as percentage decrease. Click here to subscribe to my channel to get more videos of Excel formula tips and uses: ruclips.net/channel/UCSd9vq86eRNejw_WoxlSFZw Check out our Excel Graph Playlist for ideas on creating great...
How to add cumulative sum to your chart in Excel
Просмотров 12 тыс.3 года назад
In this video, we will see how to add a cumulative sum to your chart - using simple steps If you want to find out more about how to find the cumulative sum - do check out our video on finding the running total by clicking here ruclips.net/video/-Q1EzLoBBaU/видео.html Click here to subscribe to my channel to get more videos of Excel formula tips and uses: ruclips.net/channel/UCSd9vq86eRNejw_Woxl...
Find Square Root - Using Excel Formula - Square Root Trick
Просмотров 62 тыс.3 года назад
In this video, we will see how to find square root in excel - using an excel formula We will use the two methods - using the SQRT and POWER formula to find the square root of a number. We will also use the POWER formula to find the cube root of a number. Click here to subscribe to my channel to get more videos of Excel formula tips and uses: ruclips.net/channel/UCSd9vq86eRNejw_WoxlSFZw Check ou...
Count duplicate values in excel | Using Formulas
Просмотров 172 тыс.3 года назад
In this video, we will see how to Count duplicate values in excel using a simple formula. We will use the COUNTIF formula to quickly Count duplicate values in excel and show a frequency table. Click here to subscribe to my channel to get more videos of Excel formula tips and uses: ruclips.net/channel/UCSd9vq86eRNejw_WoxlSFZw Check out our Excel Graph Playlist for ideas on creating great-looking...
How to count blank cells in excel | Excel Formulas
Просмотров 4343 года назад
How to count blank cells in excel | Excel Formulas
Add Zeros in front of Numbers in Excel - Add Leading Zeros
Просмотров 9453 года назад
Add Zeros in front of Numbers in Excel - Add Leading Zeros
Convert Excel Column to comma separated values
Просмотров 84 тыс.3 года назад
Convert Excel Column to comma separated values
Add target line to Graph in excel - Dynamic Target Line
Просмотров 4263 года назад
Add target line to Graph in excel - Dynamic Target Line
Split data into different columns in excel !
Просмотров 2163 года назад
Split data into different columns in excel !
COUNT CELLS BETWEEN TWO VALUES USING COUNTIFS
Просмотров 52 тыс.3 года назад
COUNT CELLS BETWEEN TWO VALUES USING COUNTIFS
Using Excel Slicers (Advanced Filters)
Просмотров 1,8 тыс.4 года назад
Using Excel Slicers (Advanced Filters)
How to add space between text in excel cell - after N characters
Просмотров 39 тыс.4 года назад
How to add space between text in excel cell - after N characters
Select an excel chart with drop down list | Switch between graphs
Просмотров 8 тыс.4 года назад
Select an excel chart with drop down list | Switch between graphs
How to sum in excel with filtered data - Subtotal Formula
Просмотров 1454 года назад
How to sum in excel with filtered data - Subtotal Formula
Compare Two sheets side by side in the same excel file - Find Differences
Просмотров 9384 года назад
Compare Two sheets side by side in the same excel file - Find Differences
Brilliant. This totally helped me out! THank you.
Sir, thanks for sharing.very helpful for me. Again thank you very much.
sir, what about comma to column
That will have to be a separate video
THANK YOU SO MUCH !!! HUHUHU IT TOOK ME HOURS IN RUclips SEARCHING FOR THIS !!! WTH
Tahnks from BHARAT (India) !
thanks a lot sir
thank you sir for excellent video.
Welcome!
Amazing !!! Great stuff thank you
Glad you enjoyed it!
Thank you so much
I dont understand how this doesnt work for me 😭 All i get are red dots around that cell
Thanks for sharing, my corrective value is not correcting for the total of the remaining days left, is only showing corrective vale only up the next working day and not the whole remaining days?
excellent thank u
excellent, thank you
Thank you very much for this! It was so helpful and saved me a ton of time :)
That's very helpful. How about if we have 2 Call of Duty games in a cell. How can we count the Call of Duty is there twice?
Very helpful, thank you
Why 1/2... I didn't get it
Raising a number to the power of 1/2 helps us find its square root. Similarly raising a number to the power of 1/3 helps us find its cube root.
Very useful
easier way: =Concatenate_Range(B2:B23,",")
Hello , Can you help me if cell color based on conditional formatting how we can count by color ?
You’re amazing!!! Thank you so much.
Thanks for sharing
Just reverse process???
THANK YOU. you saved me countless hours of trying to filter WITH - indexes, countif's, large, and rank.eq...... THANKS!
Glad it helped!
How to list with decimal? For an example to find value for 90.5x90.5 ? Moreover can I get provision for list of value like 100x100 = 10000, but need 100.05x100.05, 100.10x100.10, 100.15x100.15 n so on. Where I can get this data? Any possibility in Excel? Please advise or website
Thank you so much!
Thank bo
mine is not working. Ask to remove the outline. Already remove the borders. Still not function😢
EXCELLENT
Many thanks!
Cant count the data of 8.1
Thank you. Related to above, can you please help with this. Please see below data in column A, The desired result are in column B, how can we get the results in column B with formula. Column A required output in Column B Cell A1= Peter Cell B1= Cell A2= John Cell B2= Cell A3= Peter Cell B3= 1 Cell A4= David Cell B4= Cell A5= Peter Cell B5=2 Cell A6= Blank cell Cell B6= Cell A7= Peter Cell B7= Cell A8= John Cell B8= Cell A9= John Cell B9=1 Cell A10= John Cell B10=2 Cell A11= Maria Cell B11= Cell A12= Blank cell Cell B12= Cell A13= Maria Cell B13= Cell A14= Maria Cell B14=1 Cell A15= Peter Cell B15= Cell A16= David Cell B16= Cell A17= Maria Cell B17=2 I have used =SUBSTITUTE((COUNTIF($A$1:A1,A1)-1),0,"") but it works fine only untill first blank cell in column A. In B7 this formula is giving 3, but it should be blank. Basically after every blank in Column A a new set of data develops. The requirement is to serial the duplicates between two blanks in column. Hope this explains the problem. Thank you. Much appreciated.
this is what i looking for, thanks a lot!
Does anyone knows how to make this automated that the result will dinimically changes as we enter or edit the records and / or thier values?
😮
thanks very much! this is super helpful and super easy!
You're welcome!
Thanks a lot!!! Are there anyways to convert the final result of this video back to a raw list because I've got a file which already count duplicates however I also needed a raw list too. So I need a way to convert the count duplicate list back to only duplicate list. I hope this question doesn't confused you thankyou
lovely you saved me a day before my acca exam thank you cant be much grateful obliged
Thank you! You saved me so much time :)
Thank you so much!! Exactly what I needed. At first I was trying to count colour cells in a row ,probably my excel is old version or me:)) Thank you so much!!!
Am not able to give the dotted lines and actual is showing until the end date which is incorrect representation
Thank you..
Thank you brother Very informative
Many thanks good sir- this was very helpful.
Here's the quick one, in Cell B type =A1&"," then double click the cell to run down the formula in Cell B. then in Cell C type =concat(B:B). Thanks!
Thank you! just a question.. what if my initial data is from a pivot table?
Great sir thanks
Great To Watch, Thanks For Making
Glad that it was helpful
Thank you so much, this really helped :))
Glad that I could help
this is great, thank you!
Can you use lesser than equal to and greater than equal to in same formulae