- Видео 46
- Просмотров 14 639 012
TechOnTheNet
Канада
Добавлен 27 фев 2016
Your trusted resource for learning new technologies. We've been providing tutorials, references, and step-by-step instructions since 2003.
TechOnTheNet.com is a great place to learn a new technology, or find a quick reference. It has never been easier to learn Database technologies, Microsoft Office products, and more!!
Don't forget to subscribe to our channel for upcoming tutorials!
Visit us at: www.techonthenet.com
or follow us on:
Facebook: techonthenetcom
Twitter: tech_on_the_net
Google+: plus.google.com/+Techonthenetcom
Pinterest: www.pinterest.ca/techonthenetcom/
TechOnTheNet.com is a great place to learn a new technology, or find a quick reference. It has never been easier to learn Database technologies, Microsoft Office products, and more!!
Don't forget to subscribe to our channel for upcoming tutorials!
Visit us at: www.techonthenet.com
or follow us on:
Facebook: techonthenetcom
Twitter: tech_on_the_net
Google+: plus.google.com/+Techonthenetcom
Pinterest: www.pinterest.ca/techonthenetcom/
How to use the SUM function in Excel
Learn how to use the SUM function in Microsoft Excel. This tutorial demonstrates how to use Excel SUM to create a subtotal with a vertical column of numbers as well as a horizontal row of numbers.
00:40 - Overview
00:22 - Sum values in a column
01:04 - Sum values in a row
SUM Function (and sample data):
www.techonthenet.com/excel/formulas/sum.php
Excel Functions/Formulas:
www.techonthenet.com/excel/formulas/index.php
Excel Tutorials:
www.techonthenet.com/excel/index.php
Don't forget to subscribe to our channel for more great Excel tutorials!
Visit us at: www.techonthenet.com
or follow us on:
Facebook: techonthenetcom
Twitter: tech_on_the_net
Pinterest: www.pinterest.com/techonth...
00:40 - Overview
00:22 - Sum values in a column
01:04 - Sum values in a row
SUM Function (and sample data):
www.techonthenet.com/excel/formulas/sum.php
Excel Functions/Formulas:
www.techonthenet.com/excel/formulas/index.php
Excel Tutorials:
www.techonthenet.com/excel/index.php
Don't forget to subscribe to our channel for more great Excel tutorials!
Visit us at: www.techonthenet.com
or follow us on:
Facebook: techonthenetcom
Twitter: tech_on_the_net
Pinterest: www.pinterest.com/techonth...
Просмотров: 16 663
Видео
How to sort data in Excel
Просмотров 24 тыс.Год назад
Have you ever wanted to sort the data in anExcel table? In this tutorial, we'll show you how! In this video, we'll cover 2 easy to follow examples and take you step-by-step through the options in Microsoft Excel. #excel #exceltutorial #sort 00:00 - Overview 00:08 - Sort by 1 Column 01:28 - Sort by 2 Columns Excel Tutorials: www.techonthenet.com/excel/index.php Don't forget to subscribe to our c...
How to use the XLOOKUP function in Excel
Просмотров 227 тыс.2 года назад
0:32 - VERTICAL lookup example 2:21 - HORIZONTAL lookup example Learn how to use the XLOOKUP function which is the next generation lookup function in Microsoft Excel. The XLOOKUP function has the functionality of both the VLOOKUP as well as the HLOOKUP functions, without the limitations. This tutorial demonstrates how to use Excel XLOOKUP with our easy to follow examples and takes you through h...
How to use the MATCH function in Excel
Просмотров 272 тыс.3 года назад
Learn how to use the MATCH function in Microsoft Excel. This tutorial demonstrates how to use Excel MATCH with our easy to follow examples and takes you step-by-step through the different options when entering your formula. MATCH Function (and sample data): www.techonthenet.com/excel/formulas/match.php Excel Functions/Formulas: www.techonthenet.com/excel/formulas/index.php Excel Tutorials: www....
How to use the TEXTJOIN function in Excel
Просмотров 66 тыс.3 года назад
Learn how to use the TEXTJOIN function in Microsoft Excel. This tutorial demonstrates how to use Excel TEXTJOIN with our easy to follow examples and takes you step-by-step through the different options when entering your formula. TEXTJOIN Function (and sample data): www.techonthenet.com/excel/formulas/textjoin.php Excel Functions/Formulas: www.techonthenet.com/excel/formulas/index.php Excel Tut...
How to use a WHILE Loop in Excel VBA
Просмотров 18 тыс.3 года назад
Learn how to create a WHILE LOOP using the While…Wend statement in Microsoft Excel VBA. WHILE LOOPS are used when you are not sure how many times you want to execute the VBA code within the loop body. This tutorial demonstrates how to use the Visual Basic Editor in Excel to write a WHILE Loop. We provide 2 easy to follow examples and take you step-by-step through the process of creating the VBA...
How to use the COUNTA function in Excel
Просмотров 88 тыс.3 года назад
Learn how to use the COUNTA function in Microsoft Excel. This tutorial demonstrates how to use Excel COUNTA with our easy to follow examples and takes you step-by-step through the different options when entering your formula. COUNTA Function (and sample data): www.techonthenet.com/excel/formulas/counta.php Excel Functions/Formulas: www.techonthenet.com/excel/formulas/index.php Excel Tutorials: ...
How to use the CONCAT function in Excel (vs the CONCATENATE function)
Просмотров 291 тыс.3 года назад
Learn how to use the CONCAT function in Microsoft Excel (vs the CONCATENATE function). This tutorial demonstrates how to use Excel CONCAT to concatenate values together with an easy to follow example and step-by-step instructions. We also provide a comparison of the CONCAT function with the CONCATENATE function. The CONCATENATE function is an older Excel function that the CONCAT function is int...
How to use the MINIFS function in Excel
Просмотров 39 тыс.4 года назад
Learn how to use the MINIFS function in Microsoft Excel. This tutorial demonstrates how to use Excel MINIFS with our easy to follow examples and takes you step-by-step through the different options when entering your formula. MINIFS Function (and sample data): www.techonthenet.com/excel/formulas/minifs.php Excel Functions/Formulas: www.techonthenet.com/excel/formulas/index.php Excel Tutorials: ...
How to use the Excel MAXIFS Function
Просмотров 66 тыс.4 года назад
Learn how to use the MAXIFS function in Microsoft Excel. This tutorial demonstrates how to use Excel MAXIFS with our easy to follow examples and takes you step-by-step through the different options when entering your formula. MAXIFS Function (and sample data): www.techonthenet.com/excel/formulas/maxifs.php Excel Functions/Formulas: www.techonthenet.com/excel/formulas/index.php Excel Tutorials: ...
How to use a FOR Loop in Excel VBA
Просмотров 59 тыс.4 года назад
Learn how to create a FOR LOOP using the For…Next statement in Microsoft Excel VBA. FOR LOOPS are used to execute code a fixed number of times and can be accessed through the Visual Basic Editor in Excel. This tutorial demonstrates how to use the Visual Basic Editor in Excel to write a FOR Loop. We provide 2 easy to follow examples and take you step-by-step through the process of creating the V...
How to use the IF-THEN-ELSE statement in Excel VBA
Просмотров 74 тыс.4 года назад
Learn how to use the IF-THEN-ELSE statement in Microsoft Excel VBA. This tutorial demonstrates how to use the Visual Basic Editor in Excel to write an IF-THEN-ELSE statement. We provide 2 easy to follow examples and take you step-by-step through the process of creating the VBA code and running it. IF-THEN-ELSE statement in VBA: www.techonthenet.com/excel/formulas/if_then.php How to display the ...
How to use Aliases in SQL
Просмотров 33 тыс.4 года назад
Learn how to use aliases in SQL with easy to follow examples. This tutorial explains what an alias is and how to create an alias for a column name as well as how to alias table names. SQL Aliases (and sample data): www.techonthenet.com/sql/alias.php SQL Tutorials: www.techonthenet.com/sql/index.php Don't forget to subscribe to our channel for more great SQL tutorials! Visit us at: www.techonthe...
How to use the COUNTIFS function in Excel
Просмотров 1 млн4 года назад
How to use the COUNTIFS function in Excel
How to use the JavaScript findIndex (Array method)
Просмотров 3 тыс.4 года назад
How to use the JavaScript findIndex (Array method)
How to highlight the top score (highest value) in an Excel table
Просмотров 45 тыс.5 лет назад
How to highlight the top score (highest value) in an Excel table
How to use the MID function in Excel
Просмотров 53 тыс.5 лет назад
How to use the MID function in Excel
How to use the FIND function in Excel
Просмотров 257 тыс.5 лет назад
How to use the FIND function in Excel
How to use the SQL IS NULL Condition
Просмотров 13 тыс.5 лет назад
How to use the SQL IS NULL Condition
How to use the AVERAGEIF function in Excel
Просмотров 348 тыс.5 лет назад
How to use the AVERAGEIF function in Excel
How to find the closest larger number in an unordered list of values in Excel
Просмотров 21 тыс.5 лет назад
How to find the closest larger number in an unordered list of values in Excel
How to use the COUNTIF function in Excel
Просмотров 1,3 млн5 лет назад
How to use the COUNTIF function in Excel
How to use the IFS function in Excel
Просмотров 264 тыс.5 лет назад
How to use the IFS function in Excel
How to use the SWITCH function in Excel
Просмотров 69 тыс.5 лет назад
How to use the SWITCH function in Excel
How to use the NETWORKDAYS function in Excel
Просмотров 82 тыс.5 лет назад
How to use the NETWORKDAYS function in Excel
How to use the EOMONTH function in Excel
Просмотров 45 тыс.5 лет назад
How to use the EOMONTH function in Excel
How to use the BETWEEN Condition in SQL
Просмотров 6 тыс.5 лет назад
How to use the BETWEEN Condition in SQL
Upton Branch
Beulah Alley
Streich Street
Lurline Cliffs
Kiana Bridge
Goodwin Mill
Vicente Mission
Quinten Field
Isaias Trail
Is it different if I want to search the last letter of a word? For example; if I wanted to search for d as the last letter, would I have to do WHERE first_name LIKE '%d' or would I still use the same process which is WHERE first_name LIKE "d%'
If you wanted to search for d as the last letter, you would use: first_name LIKE '%d'
Thank you
I'm in college and have been busy with excel for more than a month. I'm preparing for a test based on excel and after watching your videos I fully understand all the functions I've been struggling to learn.
THANK YOU!
It is helped for my work. Thanks
what's the difference of x and v?
vlookup - you provide one table (as a parameter) that contains both your lookup and return values and the value you are searching for MUST be in the first column of the table. xlookup is the next generation lookup function where you provide two arrays (as parameters) - one rray to search for a value and a second array to return a value. It can perform either a vertical or horizontal lookup (basically replacing vlookup and hlookup).
Very helpful
Thanks for help out this formula
SHORT AND PRECISE. I LOVE THIS!
I want to paste a column of post codes, and have the next column show the address. Can this formula be adapted for my scenario?
......accurate, understandable and right to the point. i will seek out more of your tutorials.
I haven't used Pivot tables in a while and forgot where to find where to add them in Excel. Your clip got me the info I needed in seconds. Thank you.
Nice
Very helpful, thanks for sharing ❤
Thanks so much for making these short and precise videos. As a student who's taking a spreadsheet class I appreciate it.
Thank you
Thank You... 😊🙏🏻
MID CAP NIFTY ME GAMMA HO GAYA KYA
LAGTA HAI AAJ GADE AARAM SE CHALIYE HOGI
GOOD MORNI
How do we separate the concatenated values by a comma?
bar chart and coloumn chart looks the same
hell nahh
MAM YOU TEACHING SO WELL KYA AAP KE CRASH COURSE ME AUR KUCH HAI
Thank you for the explanation very easy to understand the concept in short period of time.
👍🏽
like
Tomorrow is my exam
Not Bad
Yesss! This was sooo helpful and needed! I have data where it repeats criteria names for different months and you helped me crack the code to group them soo easy!
this saved my life , wonderful video and explanation.
This channel has very few videos but is literally a gem!! Please make more videos on excel or any related tools Your tutorials are very precise and great! ❤
Helpful for me. Thanks.
why do people use 0 for the approximate match??
0 is equivalent to FALSE
Very grateful for this video. I was having a hard time understanding how to format this based off text guides.
Very helpful thank u
Very nice & thanks
Thank you
Came here for my paper which is tommorow really easy😅
Mine is in an hour😐
Came here cause a kid asked me how to use it,gave a lame excuse bought my self some time
Can anyone share a real life example where they used Index? Like what is the purpose of using index if you know where the results lies in the table?
Right!?!!
excellent explanation !
Thanks! Very simple and to the point!