Home
Videos uploaded by user “TechOnTheNet”
How to use the SUMIF function in Excel
 
02:34
Learn how to use the SUMIF function in Microsoft Excel. This tutorial demonstrates how to use Excel SUMIF with an easy to follow example and takes you step-by-step through the different options when entering your formula. SUMIF Function (and sample data): https://www.techonthenet.com/excel/formulas/sumif.php Excel Tutorials: https://www.techonthenet.com/excel/index.php Don't forget to subscribe to our channel for more great Excel tutorials! Visit us at: https://www.techonthenet.com or follow us on: Facebook: https://www.facebook.com/techonthenetcom Twitter: https://twitter.com/tech_on_the_net Google+: https://plus.google.com/+Techonthenetcom Pinterest: https://www.pinterest.com/techonthenetcom/
Views: 37131 TechOnTheNet
How to use the HLOOKUP function in Excel
 
03:01
Learn how to use the HLOOKUP function in Microsoft Excel. This tutorial demonstrates how to use Excel HLOOKUP with an easy to follow example and takes you step-by-step through the different options when entering your formula. HLOOKUP Function (and sample data): https://www.techonthenet.com/excel/formulas/hlookup.php Excel Tutorials: https://www.techonthenet.com/excel/index.php Don't forget to subscribe to our channel for more great Excel tutorials! Visit us at: https://www.techonthenet.com or follow us on: Facebook: https://www.facebook.com/techonthenetcom Twitter: https://twitter.com/tech_on_the_net Google+: https://plus.google.com/+Techonthenetcom Pinterest: https://www.pinterest.com/techonthenetcom/
Views: 17458 TechOnTheNet
How to use the INDEX function in Excel
 
02:47
Learn how to use the INDEX function in Microsoft Excel. This tutorial demonstrates how to use Excel INDEX with an easy to follow example and takes you step-by-step through the different options when entering your formula. INDEX Function (and sample data): https://www.techonthenet.com/excel/formulas/index_function.php Excel Tutorials: https://www.techonthenet.com/excel/index.php Don't forget to subscribe to our channel for more great Excel tutorials! Visit us at: https://www.techonthenet.com or follow us on: Facebook: https://www.facebook.com/techonthenetcom Twitter: https://twitter.com/tech_on_the_net Google+: https://plus.google.com/+Techonthenetcom Pinterest: https://www.pinterest.com/techonthenetcom/
Views: 6630 TechOnTheNet
How to use the VLOOKUP function in Excel
 
02:58
Learn how to use the VLOOKUP function in Microsoft Excel. This tutorial demonstrates how to use Excel VLOOKUP with an easy to follow example and takes you step-by-step through the different options when entering your formula. VLOOKUP Function (and sample data): https://www.techonthenet.com/excel/formulas/vlookup.php Excel Tutorials: https://www.techonthenet.com/excel/index.php Don't forget to subscribe to our channel for more great Excel tutorials! Visit us at: https://www.techonthenet.com or follow us on: Facebook: https://www.facebook.com/techonthenetcom Twitter: https://twitter.com/tech_on_the_net Google+: https://plus.google.com/+Techonthenetcom Pinterest: https://www.pinterest.com/techonthenetcom/
Views: 51347 TechOnTheNet
How to use the IF function in Excel
 
03:36
Learn how to use the IF function in Microsoft Excel. This tutorial demonstrates how to use Excel IF with an easy to follow example. We also point out one of the most common mistakes made when using the IF function. IF Function (and sample data): https://www.techonthenet.com/excel/formulas/if.php Excel Tutorials: https://www.techonthenet.com/excel/index.php Don't forget to subscribe to our channel for more great Excel tutorials! Visit us at: https://www.techonthenet.com or follow us on: Facebook: https://www.facebook.com/techonthenetcom Twitter: https://twitter.com/tech_on_the_net Google+: https://plus.google.com/+Techonthenetcom Pinterest: https://www.pinterest.com/techonthenetcom/
Views: 8225 TechOnTheNet
How to use the AND Condition with the OR Condition in SQL
 
02:52
Learn how to use the AND Condition with the OR Condition in SQL. This tutorial demonstrates how to write a query combining the AND condition with the OR condition in a single SQL query. We also explain how to let the database know which order to evaluate your conditions so that your query returns the correct results. SQL Combining the AND and OR Conditions (and sample data): https://www.techonthenet.com/sql/and_or.php SQL AND Condition: https://www.techonthenet.com/sql/and.php SQL OR Condition: https://www.techonthenet.com/sql/or.php SQL Tutorials: https://www.techonthenet.com/sql/index.php Don't forget to subscribe to our channel for more great SQL tutorials! Visit us at: https://www.techonthenet.com or follow us on: Facebook: https://www.facebook.com/techonthenetcom Twitter: https://twitter.com/tech_on_the_net Google+: https://plus.google.com/+Techonthenetcom Pinterest: https://www.pinterest.com/techonthenetcom/
Views: 1807 TechOnTheNet
How to create a Pivot Table in Excel
 
02:15
Learn how to create a Pivot Table in Microsoft Excel. This tutorial demonstrates how to create an Excel Pivot Table with easy to follow steps. Create a Pivot Table in 2016 (and sample data): https://www.techonthenet.com/excel/pivottbls/create2016.php Create a Pivot Table in 2013: https://www.techonthenet.com/excel/pivottbls/create2013.php Create a Pivot Table in 2011 for Mac: https://www.techonthenet.com/excel/pivottbls/create2011.php Create a Pivot Table in 2010: https://www.techonthenet.com/excel/pivottbls/create2010.php Create a Pivot Table in 2007: https://www.techonthenet.com/excel/pivottbls/create2007.php Create a Pivot Table in 2003: https://www.techonthenet.com/excel/pivottbls/create.php Excel Tutorials: https://www.techonthenet.com/excel/index.php Don't forget to subscribe to our channel for more great Excel tutorials! Visit us at: https://www.techonthenet.com or follow us on: Facebook: https://www.facebook.com/techonthenetcom Twitter: https://twitter.com/tech_on_the_net Google+: https://plus.google.com/+Techonthenetcom Pinterest: https://www.pinterest.com/techonthenetcom/
Views: 2139 TechOnTheNet
How to use the SWITCH function in Excel
 
02:54
Learn how to use the SWITCH function in Microsoft Excel. This tutorial demonstrates how to use Excel SWITCH with an easy to follow example. SWITCH Function (and sample data): https://www.techonthenet.com/excel/formulas/switch_ws.php Excel Tutorials: https://www.techonthenet.com/excel/index.php Don't forget to subscribe to our channel for more great Excel tutorials! Visit us at: https://www.techonthenet.com or follow us on: Facebook: https://www.facebook.com/techonthenetcom Twitter: https://twitter.com/tech_on_the_net Google+: https://plus.google.com/+Techonthenetcom Pinterest: https://www.pinterest.com/techonthenetcom/
Views: 1049 TechOnTheNet
How to create a Pie Chart in Excel
 
01:55
Learn how to create a Pie Chart in Microsoft Excel. This tutorial talks about what a pie chart is and then demonstrates how to create a simple Pie Chart in Excel with easy to follow steps. Create a Pie Chart in Excel (and sample data): https://www.techonthenet.com/excel/charts/pie_chart2016.php Excel Charts: https://www.techonthenet.com/excel/charts/index.php Excel Tutorials: https://www.techonthenet.com/excel/index.php Don't forget to subscribe to our channel for more great Excel tutorials! Visit us at: https://www.techonthenet.com or follow us on: Facebook: https://www.facebook.com/techonthenetcom Twitter: https://twitter.com/tech_on_the_net Google+: https://plus.google.com/+Techonthenetcom Pinterest: https://www.pinterest.com/techonthenetcom/
Views: 1301 TechOnTheNet
How to use the SQL UPDATE Statement
 
02:21
Learn how to use the SQL UPDATE Statement. This tutorial demonstrates how to write an UPDATE query with an easy to follow example. SQL UPDATE Statement (and sample data): https://www.techonthenet.com/sql/update.php SQL Tutorials: https://www.techonthenet.com/sql/index.php Don't forget to subscribe to our channel for more great SQL tutorials! Visit us at: https://www.techonthenet.com or follow us on: Facebook: https://www.facebook.com/techonthenetcom Twitter: https://twitter.com/tech_on_the_net Google+: https://plus.google.com/+Techonthenetcom Pinterest: https://www.pinterest.com/techonthenetcom/
Views: 1436 TechOnTheNet
How to use the CONCAT function in Excel
 
02:54
Learn how to use the CONCAT function in Microsoft Excel. This tutorial demonstrates how to use Excel CONCAT to concatenate values together with an easy to follow example and takes you step-by-step through some of the different values that could be entered and what will happen. CONCAT Function (and sample data): https://www.techonthenet.com/excel/formulas/concat.php Excel Tutorials: https://www.techonthenet.com/excel/index.php Don't forget to subscribe to our channel for more great Excel tutorials! Visit us at: https://www.techonthenet.com or follow us on: Facebook: https://www.facebook.com/techonthenetcom Twitter: https://twitter.com/tech_on_the_net Google+: https://plus.google.com/+Techonthenetcom Pinterest: https://www.pinterest.com/techonthenetcom/
Views: 1681 TechOnTheNet
How to use the SQL INSERT Statement
 
04:17
Learn how to use the SQL INSERT Statement. There are 2 syntaxes for the INSERT statement depending on whether you want to insert one record or multiple records into a table. We will cover both of these syntaxes in this tutorial with easy to follow examples. SQL INSERT Statement (and sample data): https://www.techonthenet.com/sql/insert.php SQL Tutorials: https://www.techonthenet.com/sql/index.php Don't forget to subscribe to our channel for more great SQL tutorials! Visit us at: https://www.techonthenet.com or follow us on: Facebook: https://www.facebook.com/techonthenetcom Twitter: https://twitter.com/tech_on_the_net Google+: https://plus.google.com/+Techonthenetcom Pinterest: https://www.pinterest.com/techonthenetcom/
Views: 1460 TechOnTheNet
How to use the IFS function in Excel
 
03:57
Learn how to use the IFS function in Microsoft Excel. This tutorial demonstrates how to use Excel IFS with an easy to follow example. This is a new Excel function that is available in Office 365 and Excel 2019 and replaces the old method of nesting multiple IF functions in a formula. You can enter up to 127 conditions. We also show you a workaround that allows you to enter an ELSE condition in the IFS function. IFS Function (and sample data): https://www.techonthenet.com/excel/formulas/ifs.php Excel Functions/Formulas: https://www.techonthenet.com/excel/formulas/index.php Excel Tutorials: https://www.techonthenet.com/excel/index.php Don't forget to subscribe to our channel for more great Excel tutorials! Visit us at: https://www.techonthenet.com or follow us on: Facebook: https://www.facebook.com/techonthenetcom Twitter: https://twitter.com/tech_on_the_net Google+: https://plus.google.com/+Techonthenetcom Pinterest: https://www.pinterest.com/techonthenetcom/
Views: 3182 TechOnTheNet
How to use the COUNTIF function in Excel
 
02:11
Learn how to use the COUNTIF function in Microsoft Excel. This tutorial demonstrates how to use Excel COUNTIF with an easy to follow example and takes you step-by-step through the different options when entering your formula. COUNTIF Function (and sample data): https://www.techonthenet.com/excel/formulas/countif.php Excel Tutorials: https://www.techonthenet.com/excel/index.php Excel Functions: https://www.techonthenet.com/excel/formulas/index.php Don't forget to subscribe to our channel for more great Excel tutorials! Visit us at: https://www.techonthenet.com or follow us on: Facebook: https://www.facebook.com/techonthenetcom Twitter: https://twitter.com/tech_on_the_net Google+: https://plus.google.com/+Techonthenetcom Pinterest: https://www.pinterest.com/techonthenetcom/
Views: 1644 TechOnTheNet
How to use the NETWORKDAYS function in Excel
 
03:02
Learn how to use the NETWORKDAYS function in Microsoft Excel. This tutorial demonstrates how to use Excel NETWORKDAYS with an easy to follow example. The NETWORKDAYS function allows you to calculate the number of work days between two dates and exclude weekends and holidays from the calculation. NETWORKDAYS Function (and sample data): https://www.techonthenet.com/excel/formulas/networkdays.php Excel Tutorials: https://www.techonthenet.com/excel/index.php Don't forget to subscribe to our channel for more great Excel tutorials! Visit us at: https://www.techonthenet.com or follow us on: Facebook: https://www.facebook.com/techonthenetcom Twitter: https://twitter.com/tech_on_the_net Google+: https://plus.google.com/+Techonthenetcom Pinterest: https://www.pinterest.com/techonthenetcom/
Views: 812 TechOnTheNet
How to use the CHOOSE function in Excel
 
01:52
Learn how to use the CHOOSE function in Microsoft Excel. This tutorial demonstrates how to use Excel CHOOSE with an easy to follow example and takes you step-by-step through the different options when entering your formula. CHOOSE Function (and sample data): https://www.techonthenet.com/excel/formulas/choose.php Excel Tutorials: https://www.techonthenet.com/excel/index.php Don't forget to subscribe to our channel for more great Excel tutorials! Visit us at: https://www.techonthenet.com or follow us on: Facebook: https://www.facebook.com/techonthenetcom Twitter: https://twitter.com/tech_on_the_net Google+: https://plus.google.com/+Techonthenetcom Pinterest: https://www.pinterest.com/techonthenetcom/
Views: 1407 TechOnTheNet
How to use the EOMONTH function in Excel
 
03:05
Learn how to use the EOMONTH function in Microsoft Excel. This tutorial demonstrates how to use Excel EOMONTH with an easy to follow example. Never have trouble calculating the last day of the month again! EOMONTH Function (and sample data): https://www.techonthenet.com/excel/formulas/eomonth.php Excel Tutorials: https://www.techonthenet.com/excel/index.php Don't forget to subscribe to our channel for more great Excel tutorials! Visit us at: https://www.techonthenet.com or follow us on: Facebook: https://www.facebook.com/techonthenetcom Twitter: https://twitter.com/tech_on_the_net Google+: https://plus.google.com/+Techonthenetcom Pinterest: https://www.pinterest.com/techonthenetcom/
Views: 1169 TechOnTheNet
How to use the SQL LIKE Condition
 
02:27
Learn how to use the SQL LIKE Condition to perform pattern matching in SQL. This tutorial demonstrates how to write a query using the LIKE Condition with an easy to follow example. SQL LIKE Condition (and sample data): https://www.techonthenet.com/sql/like.php SQL Tutorials: https://www.techonthenet.com/sql/index.php Don't forget to subscribe to our channel for more great SQL tutorials! Visit us at: https://www.techonthenet.com or follow us on: Facebook: https://www.facebook.com/techonthenetcom Twitter: https://twitter.com/tech_on_the_net Google+: https://plus.google.com/+Techonthenetcom Pinterest: https://www.pinterest.com/techonthenetcom/
Views: 691 TechOnTheNet
How to create a Line Chart in Excel
 
02:05
Learn how to create a Line Chart in Microsoft Excel. This tutorial talks about what a line chart is and then demonstrates how to create a simple Line Chart in Excel with easy to follow steps. Create a Line Chart in Excel (and sample data): https://www.techonthenet.com/excel/charts/line_chart2016.php Excel Charts: https://www.techonthenet.com/excel/charts/index.php Excel Tutorials: https://www.techonthenet.com/excel/index.php Don't forget to subscribe to our channel for more great Excel tutorials! Visit us at: https://www.techonthenet.com or follow us on: Facebook: https://www.facebook.com/techonthenetcom Twitter: https://twitter.com/tech_on_the_net Google+: https://plus.google.com/+Techonthenetcom Pinterest: https://www.pinterest.com/techonthenetcom/
Views: 3722 TechOnTheNet
How to use the IF function with the AND function in Excel
 
02:42
Learn how to use the IF function with the AND function in Microsoft Excel. This tutorial demonstrates how to use the 2 Excel functions together with an easy to follow example. IF Function with AND Function (and sample data): https://www.techonthenet.com/excel/formulas/if_with_and.php IF Function: https://www.techonthenet.com/excel/formulas/if.php AND Function: https://www.techonthenet.com/excel/formulas/and.php Excel Tutorials: https://www.techonthenet.com/excel/index.php Don't forget to subscribe to our channel for more great Excel tutorials! Visit us at: https://www.techonthenet.com or follow us on: Facebook: https://www.facebook.com/techonthenetcom Twitter: https://twitter.com/tech_on_the_net Google+: https://plus.google.com/+Techonthenetcom Pinterest: https://www.pinterest.com/techonthenetcom/
Views: 257 TechOnTheNet
How to use the BETWEEN Condition in SQL
 
01:57
Learn how to use the SQL BETWEEN Condition. This tutorial demonstrates how to write a query using the BETWEEN Condition with an easy to follow example. SQL BETWEEN Condition (and sample data): https://www.techonthenet.com/sql/between.php SQL Tutorials: https://www.techonthenet.com/sql/index.php Don't forget to subscribe to our channel for more great SQL tutorials! Visit us at: https://www.techonthenet.com or follow us on: Facebook: https://www.facebook.com/techonthenetcom Twitter: https://twitter.com/tech_on_the_net Google+: https://plus.google.com/+Techonthenetcom Pinterest: https://www.pinterest.com/techonthenetcom/
Views: 477 TechOnTheNet
How to create a Column Chart in Excel
 
02:12
Learn how to create a Column Chart in Microsoft Excel. This tutorial talks about what a column chart is and then demonstrates how to create a simple Column Chart in Excel with easy to follow steps. Create a Column Chart in Excel (and sample data): https://www.techonthenet.com/excel/charts/column_chart2016.php Excel Charts: https://www.techonthenet.com/excel/charts/index.php Excel Tutorials: https://www.techonthenet.com/excel/index.php Don't forget to subscribe to our channel for more great Excel tutorials! Visit us at: https://www.techonthenet.com or follow us on: Facebook: https://www.facebook.com/techonthenetcom Twitter: https://twitter.com/tech_on_the_net Google+: https://plus.google.com/+Techonthenetcom Pinterest: https://www.pinterest.com/techonthenetcom/
Views: 2081 TechOnTheNet
How to use the SQL SELECT Statement
 
03:08
Learn how to use the SQL SELECT Statement. This tutorial demonstrates how to write a SELECT query with an easy to follow example. SQL Select Statement (and sample data): https://www.techonthenet.com/sql/select.php SQL Tutorials: https://www.techonthenet.com/sql/index.php Don't forget to subscribe to our channel for more great SQL tutorials! Visit us at: https://www.techonthenet.com or follow us on: Facebook: https://www.facebook.com/techonthenetcom Twitter: https://twitter.com/tech_on_the_net Google+: https://plus.google.com/+Techonthenetcom Pinterest: https://www.pinterest.com/techonthenetcom/
Views: 3289 TechOnTheNet
How to use the SQL DELETE Statement
 
02:17
Learn how to use the SQL DELETE Statement. This tutorial demonstrates how to write a DELETE query with an easy to follow example. SQL DELETE Statement (and sample data): https://www.techonthenet.com/sql/delete.php SQL Tutorials: https://www.techonthenet.com/sql/index.php Don't forget to subscribe to our channel for more great SQL tutorials! Visit us at: https://www.techonthenet.com or follow us on: Facebook: https://www.facebook.com/techonthenetcom Twitter: https://twitter.com/tech_on_the_net Google+: https://plus.google.com/+Techonthenetcom Pinterest: https://www.pinterest.com/techonthenetcom/
Views: 574 TechOnTheNet
How to find the closest larger number in an unordered list of values in Excel
 
03:04
Have you ever needed to find the closest larger number in an unordered list of values in Excel? In this tutorial, we'll show you how! This is a great formula to use when you need to determine a material size based on the length or size requested by a customer. Find the Closest Larger Number in Unordered List of Values (and sample data): https://www.techonthenet.com/excel/formulas/closest_larger_number.php SMALL Function: https://www.techonthenet.com/excel/formulas/small.php COUNTIF Function: https://www.techonthenet.com/excel/formulas/countif.php Excel Tutorials: https://www.techonthenet.com/excel/index.php Excel Functions: https://www.techonthenet.com/excel/formulas/index.php Don't forget to subscribe to our channel for more great Excel tutorials! Visit us at: https://www.techonthenet.com or follow us on: Facebook: https://www.facebook.com/techonthenetcom Twitter: https://twitter.com/tech_on_the_net Pinterest: https://www.pinterest.com/techonthenetcom/
Views: 224 TechOnTheNet