Видео 300
Просмотров 4 650 311

4:50

5:17

4:22

2:47

3:53

4:01

In Google Sheets, convert a data range into a table with the Convert to Table option. Each table header of such a table will have a pull-down menu, with options ranging from changing the column type to adding a column.
The table also allows to create a group by view and filter view. These views can assist in better data analysis.
-------------------------------------
How to Create a Table in Google Sheets?
Create a custom table from a pre-built table:
ruclips.net/video/KjxsJJM3EUw/видео.html
-------------------------------------
How to Use FREQUENCY in Google Sheets?
FREQUENCY returns the frequency distribution of data:
ruclips.net/video/mDKjYlqVHEk/видео.html
-------------------------------------
H...

Видео

Google Sheets | Group by View | Filter View | From Table | Example | Spreadsheet | Tutorial

4:50

Просмотров 85День назад

If you have created a Google Sheets table, you can create one or more group by views and filter views from the table. Such views can help you analyze your data better. What's more, you can save the views for later use. Here is an example of group by view: say you have a table titled Inventory, and one of its column is labeled as Delivered. This column is a dropdown column type with two options ...

Google Sheets | Table | Modify Pre-built Tables | Example | Column Types | Spreadsheet | Tutorial

5:17

Просмотров 9114 дней назад

In Google Sheets, use a pre-built table, or convert existing range of data into a table (when this feature is available). The column type can be, for example, dropdown, checkbox, number, text, date, smartchips, or none. When you insert a pre-built table, it is inserted in a separate sheet. How to Use FREQUENCY in Google Sheets? FREQUENCY returns the frequency distribution of data: ruclips.net/v...

Google Sheets | FREQUENCY | COUNTIFS | Function | Example | Comparison | Spreadsheet | Tutorial

4:22

Просмотров 7421 день назад

Google Sheets FREQUENCY or COUNTIFS function can return the count of values that meet one or more criteria. The question, then, is which of these two functions to use? While FREQUENCY is easy to use, COUNTIFS is versatile. For more info on FREQUENCY or COUNTIFS, please refer to their respective tutorials, whose links are given below. How to Use FREQUENCY in Google Sheets? FREQUENCY returns the ...

Google Sheets | FREQUENCY | Function | Count | Values | Example | Spreadsheet | Tutorial

2:47

Просмотров 46Месяц назад

With the Google Sheets FREQUENCY function, get the frequency distribution of data in one-column, based on the specified set of classes. For example, using FREQUENCY function, you can get the count of scores on a test in the range of each value in the set. How to Use QUERY in Google Sheets? QUERY helps, among others, to extract specific or all data from a range: ruclips.net/video/X36ILm2S_xI/вид...

Google Sheets | NPER | Function | No. of Months | To Make Specific Money | Spreadsheet | Tutorial

3:53

Просмотров 39Месяц назад

The Google Sheets NPER function returns the number of months required to reach a financial goal. NPER can also be used to calculate the number of months needed to repay a loan. Consider the first scenario. Say you want to find out how many months it would take to reach the target of Rs. 10,000, if you make a monthly investment of Rs. 500 every month, and if the rate of interest is 3% per year. ...

Google Sheets | PMT | Function | Calculate Monthly Savings Amount | Example | Spreadsheet | Tutorial

4:01

Просмотров 59Месяц назад

If you wish to calculate the monthly savings required to reach a financial goal, the Google Sheets PMT function is among the financial functions that can help you in this task. PMT has four arguments. These are the rate, number of periods, present value, future value, and end or beginning. Of the above PMT function arguments, only the rate, number of periods, and present value are mandatory. Th...

Google Sheets | NPV | Function | Compare NPV of Two Projects | Example | Spreadsheet | Tutorials

3:37

Просмотров 39Месяц назад

The Google Sheets NPV function assists to assess the viability of projects. Subtract the initial investment from the sum of the present values of the cash flows to get the NPV or the net present value. If the NPV is a positive value, it indicates that the investment on the project is viable. Assume that you want to assess the viability of two projects, say Project A and Project B. Calculate the...

google sheets XIRR function rate periodic investments example spreadsheet tutorial

3:04

google sheets XIRR function rate periodic investments example spreadsheet tutorial

Просмотров 1772 месяца назад

The Google Sheets XIRR function assists to calculate the rate of return for investments that are made at different time gaps. XIRR stands for eXtended Internal Rate of Return. How to Use QUERY in Google Sheets? QUERY helps, among others, to extract specific or all data from a range: ruclips.net/video/X36ILm2S_xI/видео.html How to Use QUERY with WHERE clause and MATCHES operator in Google Sheets...

Google Sheets | QUERY | Function | ORDER BY | Sort Data | Example | Spreadsheet | Tutorial

3:12

Просмотров 1212 месяца назад

Use the Google Sheets QUERY function with ORDER BY clause to sort data. The default sort order is ascending. ORDER BY also assists to sort in descending order. How to Use QUERY in Google Sheets? QUERY helps, among others, to extract specific or all data from a range: ruclips.net/video/X36ILm2S_xI/видео.html How to Use QUERY with WHERE clause and MATCHES operator in Google Sheets? MATCHES operat...

Google Sheets | Query | Function | PIVOT | Clause | Example | GROUP BY | Spreadsheet | Tutorial

3:55

Просмотров 1032 месяца назад

Use the Google Sheets QUERY function and PIVOT clause to create a column for each unique value in the column, in the source data range, specified for pivot. This clause allows to use the following aggregate functions: avg, count, sum, max, and min. Let's look at an example where using the PIVOT clause would be ideal: Say there is a source data range with three columns Asset Class, No. of Invest...

Google Sheets | QUERY | Function | GROUP BY | Clause | How To | Example | Spreadsheet | Tutorial

3:18

Просмотров 1982 месяца назад

Use the Google Sheets QUERY function and GROUP BY clause to group data by a column which has repetitive data using one or more of the following aggregate functions: avg, count, sum, max, and min. Here's a scenario where using GROUP BY would be ideal: Consider a workshop registrants database. It has data like registration date, registrant name, city, payment mode, and food preference, which are ...

Google Sheets | QUERY | Function | WHERE | LIKE | Wildcard | Match | Example | Spreadsheet Tutorial

4:47

Просмотров 1003 месяца назад

With the Google Sheets QUERY function's WHERE clause and LIKE operator you can conduct exact matches for a specified string or do a wildcard search. The wildcard characters you can use with LIKE are % and _(underscore). For an intro to QUERY function, please refer to the tutorial How to Use Query in Google Sheets whose link is given below. How to Use QUERY in Google Sheets? QUERY helps, among o...

Google Sheets | QUERY | Function | MATCHES Operator | WHERE Clause | Example | Spreadsheet Tutorial

4:40

Просмотров 1183 месяца назад

The Google Sheets QUERY function's WHERE clause and MATCHES operator assists to get data based on conditions. Use MATCHES to conduct exact or wildcard search. This operator uses regular expressions, which are search templates with a set of characters like . and *, to conduct search. For an intro to QUERY function, please refer to the tutorial How to Use Query in Google Sheets whose link is give...

Google Sheets | QUERY | Function | WHERE Clause | Starts With | Ends With | Example | Tutorial

5:04

Просмотров 933 месяца назад

Use the Google Sheets QUERY function's WHERE clause and starts with and ends with operators to extract data based on conditions. For an intro to QUERY function, please refer to the tutorial How to Use Query in Google Sheets whose link is given below. How to Use QUERY in Google Sheets? QUERY helps, among others, to extract specific or all data from a range: ruclips.net/video/X36ILm2S_xI/видео.ht...

Google Sheets | QUERY | Function | WHERE Clause | CONTAINS Operator | Example | Spreadsheet Tutorial

4:53

Просмотров 1883 месяца назад

Google Sheets | QUERY | Function | Example | Spreadsheet | Tutorial | Select Clause | Extract Data

4:21

Просмотров 1633 месяца назад

Google Sheets | XLOOKUP | Function | Vertical & Horizontal Search | Example | Spreadsheet Tutorial

3:45

Просмотров 4904 месяца назад

Google Sheets | XLOOKUP | VLOOKUP | Function | A Key Difference | Example | Spreadsheet | Tutorial

3:44

Просмотров 794 месяца назад

Google Sheets | SWITCH | IF | Function | What are the Differences | Example | Spreadsheet | Tutorial

5:15

Просмотров 2594 месяца назад

Google Sheets | Checkbox | How to Insert | A Business Application | Example | Spreadsheet | Tutorial

4:50

Просмотров 674 месяца назад

Google Sheets | SUM | FILTER | Function | OR Logic to Filter Data | Example | Spreadsheet | Tutorial

4:17

Просмотров 4665 месяцев назад

Google Sheets | DSUM | SUMPRODUCT | Functions | Do Conditional Sum |Example | Spreadsheet | Tutorial

5:17

Просмотров 2135 месяцев назад

Google Sheets | IF | IFS | Function | What are the Differences | Example | Spreadsheet | Tutorial

5:14

Просмотров 2905 месяцев назад

Google Sheets | IF | AND | Function | Use Multiple Conditions | Example | Spreadsheet | Project

4:25

Просмотров 1845 месяцев назад

Google Sheets | IF Function | When to Use | Example | Spreadsheet | Tutorial | Compare Values

3:29

Просмотров 1026 месяцев назад

Google Sheets | FV | Function | Quiz | Demo | Future Value | Spreadsheet | Interview Question

3:17

Просмотров 566 месяцев назад

Google Sheets | What-If Analysis | Example | PMT | Function | Spreadsheet | Tutorial | How To

3:23

Просмотров 3106 месяцев назад

Google Sheets | How to Count Words in a Cell | Example | Spreadsheet | Step-by-Step Tutorial

3:33

Google Sheets | How to Count Words in a Cell | Example | Spreadsheet | Step-by-Step Tutorial

Просмотров 1116 месяцев назад

Google Sheets | How to Count Words in a Cell | Example | Spreadsheet | Step-by-Step Tutorial

Google Sheets | Extract Duplicate Values From a Column | Example | Spreadsheet | Tutorial | How To

5:22

Просмотров 1837 месяцев назад

@poojajoshi5184 3 года назад
Super
@poojajoshi5184 3 года назад
😊
@poojajoshi5184 3 года назад
😊
@dharmshipatel4451 3 года назад
It is very awesome,superb,I can't define it with my words it is so good Thank you so much!
@lorenecarr145 3 года назад
I appreciate this; however, I am unable to name the slides I am just not seeing that option so my slides are named slide 1 and 2.
@Zarude69 3 года назад
WOW! thank u soo much I did this for my computer assignment online and got full marks again thank u so much <3
@jshana100 4 года назад
I followed each step by pausing the video and doing it simulatenously ,It works so well , i wonder why you have not added audio to the video,.
@sarahkelly1819 4 года назад
This is clear and informative video with clear instructions. This would be helpful for me to create interactive courses as i am new to elearning design so was looking for tutorials on tools like Storyline and Captivate. It would be useful if you create videos on those tools as well. One such video i found is: ruclips.net/video/jQTKd_jzar4/видео.html
@katmusswoodwind 4 года назад
Can I please take this video and attempt to put a VO against it? I think it would be useful for those trying to follow along and do something at same time (plus I'm looking to create a voicereel with some explainer videos on there too!). Is that possible?
@katmusswoodwind 4 года назад
I will of course credit those who actually created the video and link bank to this video
@immane75 2 года назад
@@katmusswoodwind I wish you can do that
@katmusswoodwind 2 года назад
@@immane75 would a VO help you too?
@williamgeorge3157 4 года назад
Superb! It works perfectly well
@dimitrispsarris9697 5 лет назад
Hi can i ask a question about a serious problem i m facing? I m trying to make an interactive presentation about excursions. The referring slides of the different excursions have animations. At the end of each slide i create a hyperlink button that takes the customer back to the list of the different excursion. if the customer want to review the same excursion again which means to play the slide again the animation does not work. Through research the only way around it is to create a new slide before the animated one which transition is set to 0 which makes the animated slide play again. i kind of feel lost. is it seriously to your knowledge the only way around it, because for even frictions of a second the customer has to see an intermediate slide of "Nothing" even with the backround of the animated one. Could you tell if you are aware of a more professional way? Thank you for your time in advance Dimitris

Software Spring

Видео

Комментарии