- 22
- 466 411
Excel Pro
เข้าร่วมเมื่อ 5 พ.ย. 2017
Excel Pro Teaches you to master Excel basics, using our Excel Tips & Tricks you can be a pro too!+
Microsoft Excel Count Function Guide, there are five COUNT functions for excel and we walkthrough each one in detail in this Excel COUNT Video
=COUNT(range)
How to use COUNT function in excel:
The Excel COUNT function is useful for determining how many cells within your selected range contain a number, you input a range the Count formula will count how many numbers there are.
=COUNTA(range)
How to use COUNTA function in excel
The Excel COUNTA function is very similar to the COUNT function but it can count how many cells within your range contain some value, that can be a number or a letter or a character, as long as the cell is not blank, the COUNTA function will let you know how many cells there are.
=COUNTBLANK(range)
How to use COUNTBLANK function in excel
The COUNTBLANK function is really the inverse of the COUNTA function. It will count the number of sells within your selected da
Microsoft Excel Count Function Guide, there are five COUNT functions for excel and we walkthrough each one in detail in this Excel COUNT Video
=COUNT(range)
How to use COUNT function in excel:
The Excel COUNT function is useful for determining how many cells within your selected range contain a number, you input a range the Count formula will count how many numbers there are.
=COUNTA(range)
How to use COUNTA function in excel
The Excel COUNTA function is very similar to the COUNT function but it can count how many cells within your range contain some value, that can be a number or a letter or a character, as long as the cell is not blank, the COUNTA function will let you know how many cells there are.
=COUNTBLANK(range)
How to use COUNTBLANK function in excel
The COUNTBLANK function is really the inverse of the COUNTA function. It will count the number of sells within your selected da
Filter Unique Values from a List
Filter Unique Values from a List in this video we will be removing all duplicate values that leaves you with a list of unique values in excel.
มุมมอง: 159
วีดีโอ
E in Excel (in under 1 minute)
มุมมอง 2944 ปีที่แล้ว
This is going to be one of my quickest videos yet! I've been getting the question how to do the number e in excel, well it's really simple and this video will show you how to do e in excel. The function is really basic, simple its =EXP(1) and that will get you the number e in excel. Don't forget to smash that like button if it helped you!
How to Flip Data in Excel
มุมมอง 3.3K4 ปีที่แล้ว
This video will show you how to flip data in excel. What I will be showing you is how to flip columns in excel, its fairly simple, but very powerful. This is a simple example, but you can use the same method on any amount of data you want to flip in excel.
How to Make Column and Bar Charts in Google Sheets
มุมมอง 544 ปีที่แล้ว
We're looking at how to make bar charts in google sheets, of course when we say bar charts we probably mean column charts, but we'll get into that in the video. There are three types of column charts in google sheets and depending on your data and the relationship you are trying to show we will use a different google sheets chart. It's important to remember that you are trying to simply show a ...
How to Make a Graph on Google Sheets
มุมมอง 194 ปีที่แล้ว
How to make a graph on google docs. We're looking at the basics of making a graph on google sheets, which will discuss how to turn data into a chart on google docs. It's pretty basic to build your first gsheets graph, but there is almost unlimited flexibility on what you can do with it. In this video we look at a few of the graph options in google sheets, but we'll go into more detail in other ...
Free Microsoft Word Download Word Online Excel Online Free
มุมมอง 5624 ปีที่แล้ว
Subscribe for more videos This is a short video showing you how to get Microsoft Office Free, including free excel and free word. There is also skype, powerpoint, and the other free microsoft products.
Absolute and Relative Cell Referencing in Google Sheets
มุมมอง 4364 ปีที่แล้ว
Subscribe to become a Google Sheets Expert! Google sheets tutorial that teaches the basics of absolute and relative cell referencing. This is a very simple google sheets method that will allow you to create a formula once and fill out entire tables by using the power of absolute referencing. If you have any questions or want to see any other google sheets tutorials let me know.
How to Sort by Date in Excel - ExcelPro
มุมมอง 69K5 ปีที่แล้ว
In this video we're going to learn how to sort by date in Excel. It's a straightforward method using the excel date formula as well as the excel today's date formula. Between these functions we will show you how to sort by column either ascending or descending order excel.
Crunching the Titanic Dataset with Excel
มุมมอง 7K5 ปีที่แล้ว
Don't forget to subscribe for part 2 of the video. We've got all the data from the titanic and we're going to have some fun with it while we learn how to use excel. For example, did you know that two thirds of the passengers on the titanic were men? Or that half the passengers were third class paying just 20% of first class passengers?
Excel Tutorials: Using the Goal Seek Function in Excel | Excel Tips and Tricks
มุมมอง 685 ปีที่แล้ว
Let us know what tips and tricks you want to see next. Please support us by liking the video and subscribing to the channel Video discussing how to use Excel goal seek functionality, this is very powerful when you are trying to solve for a missing piece of information.
Impress Your Boss With Killer Excel Charts
มุมมอง 7935 ปีที่แล้ว
Let us know what Excel tips and tricks you want to see in the comments below! And don't forget to subscribe so you can become an Excel Pro too. In this Microsoft 2016 Excel video guide we'll be looking at making killer excel charts that will make your boss give you a raise. Microsoft excel line charts and column charts are often far too basic, and lack simple descriptive data to make them usefu...
Calculating Percentages in Excel **NEW and IMPROVED**
มุมมอง 1916 ปีที่แล้ว
How to calculate percentages in Excel. Calculating Percentages in Excel is fairly straightforward, we will show you two Excel percentage formulas which are mathematically equivalent. Also in this video we will introduce some basic formatting for Excel percentage calculations.
How to do a CAGR in Excel
มุมมอง 4.4K6 ปีที่แล้ว
Video shows you how to do a cagr in excel, the formula for an annual compound growth rate in excel is simple, this will let you quickly determine the growth rate between two time periods. Learn how to build a CAGR in Excel.
Create a Two Variable Data Table Excel 2016
มุมมอง 68K6 ปีที่แล้ว
Create a Two Variable Data Table Excel 2016
Apply a Formula to an Entire Column in Excel
มุมมอง 252K6 ปีที่แล้ว
Apply a Formula to an Entire Column in Excel
How to Count Between Ranges Using the Excel Dynamic Countifs Function
มุมมอง 2.8K6 ปีที่แล้ว
How to Count Between Ranges Using the Excel Dynamic Countifs Function
How To Add Secondary Axis Excel 2016; Two Axis Chart Excel 2016
มุมมอง 54K6 ปีที่แล้ว
How To Add Secondary Axis Excel 2016; Two Axis Chart Excel 2016
How to use COUNTIF COUNTIFS COUNT COUNTA COUNTBLANK functions in Excel 2016
มุมมอง 1.9K6 ปีที่แล้ว
How to use COUNTIF COUNTIFS COUNT COUNTA COUNTBLANK functions in Excel 2016
Thank you
YOURE THE GOAT
Can't you have it such that every time there is a new data row, the formula cells dynamically appear on the new row without having to use keyboard shortcuts or mouse drags?
Thank you so much. Very helpful❤
Thanks
Bro while dragging the amount there will be some zero ,so what is the formula for changing zero into numbers ?
Thank you!!! I knew there had to be a better way!
How to copy 10 rows data and paste in 10000 rows without dragging
Like 10 names copy and paste 10000 rows in another column without dragging
Elegant solution. Thanks😊👍
I have 541910 column and it's refusing to do the calculation...stating the data is too large
thank you for the step by step instructions, I've taken huge benefit from this video.
Owo Chumu bro ❤❤
Thank You
I have prepare PIVOT table and Date are not in right order.. How can we get in order in PIVOT table
Like to find a way to sort Employee name by date and once that employee worked moved them to the bottom of the active sheet
Thank you very much for this!
I double clicked and it copied the same value all the way down instead of applying the formula... Please help
Tank you very much sir!!
How to g total column copy to new sheet
Wow superb thanks
doesn't work it just past the same value !!!
This little trivial thing is my biggest pet peeve in Excel. From an old hand Lotus 1-2-3, I don't know why Excel is unwilling to move the active cell when you Shift-arrow to the left. It's such a small thing, but it would be so helpful to allow you to "ride" the data block.
I try it but still not work..i do both but still
Thnx
Thank you
THANKS
Superrrr SIMPLE!!!!
What happens when the evaluated column, column "B" is also dynamic?
Thank you!!! I was stuck on a problem but you really helped me!
Thank you kind sir!
Thanks a lot Sir
How would i set my worksheet to automatically organize my data by the date. Let's say I have a monthly report and at the end of the month I forgot to enter a line and I want to automatically have it go in the order that it needed to be without having to highlight the entire worksheet. Is that possible? Hope that makes sense. I am new to Excel and found this video very helpful. Thank you
Sir copy kar rhe hain to same e value aa jaa rhi hai har jagah Kya problem ho ri smjh ni aa rha
Thank you so much. This is the only video that is made out there to get the entire columns of over 30 million data and the only video that does step by step how to calculate the data.
My man!
Great
Life savior! thanks a lot!!
This was so helpful! Thank you very much.
how do you know what formula to use?
THIS SAVED MY LIFE!!!!!!!!!!!!!!!!
THANK YOU
Really
This was INCREDIBLY useful! Thank you!
Can you tell us how to make formula repeat itself in next row when there is a new entry in the worksheet, I don't want to drag the mouse every time when I enter new data
Of course, nowadays you can write b4:b243*c4:c243.
saved my life thanks!
Thank YOU
Thakyou✌✌
I was able to make a dynamic model thanks to you, may even get promoted because of this ;)
Thank you, Great data, 👏🏾👏🏾👏🏾👏🏾👏🏾👏🏾🙏🏾🙏🏾🙏🏾🙏🏾🙏🏾💯👑🤔