TechOnTheNet
TechOnTheNet
  • Видео 46
  • Просмотров 14 639 012
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...
Просмотров: 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 SQL LIKE Condition
Просмотров 25 тыс.5 лет назад
How to use the SQL LIKE Condition
How to use the SWITCH function in Excel
Просмотров 69 тыс.5 лет назад
How to use the SWITCH function in Excel
How to create a Pie Chart in Excel
Просмотров 14 тыс.5 лет назад
How to create a Pie Chart in Excel
How to use the SQL DELETE Statement
Просмотров 9 тыс.5 лет назад
How to use the SQL DELETE Statement
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

Комментарии

  • @MaryPowell-f9b
    @MaryPowell-f9b 7 часов назад

    Upton Branch

  • @BarbaraRichey-j4k
    @BarbaraRichey-j4k 11 часов назад

    Beulah Alley

  • @JonathanaWilliams-o9z
    @JonathanaWilliams-o9z 13 часов назад

    Streich Street

  • @ThurmanPioche-n2s
    @ThurmanPioche-n2s 18 часов назад

    Lurline Cliffs

  • @user-pq8it1nc9d
    @user-pq8it1nc9d День назад

    Kiana Bridge

  • @NicolDunn-o3l
    @NicolDunn-o3l День назад

    Goodwin Mill

  • @WillieStevenson-l5e
    @WillieStevenson-l5e День назад

    Vicente Mission

  • @CarlDylan-m2h
    @CarlDylan-m2h 2 дня назад

    Quinten Field

  • @CodyNasta-h5q
    @CodyNasta-h5q 3 дня назад

    Isaias Trail

  • @BingoPerson
    @BingoPerson 12 дней назад

    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%'

    • @Techonthenetcom
      @Techonthenetcom 12 дней назад

      If you wanted to search for d as the last letter, you would use: first_name LIKE '%d'

  • @taranazare2633
    @taranazare2633 18 дней назад

    Thank you

  • @hotmilo
    @hotmilo 19 дней назад

    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.

  • @cristiankahn2315
    @cristiankahn2315 25 дней назад

    THANK YOU!

  • @rehimbinali
    @rehimbinali Месяц назад

    It is helped for my work. Thanks

  • @mitoali5151
    @mitoali5151 Месяц назад

    what's the difference of x and v?

    • @Techonthenetcom
      @Techonthenetcom Месяц назад

      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).

  • @robertodhiambo6148
    @robertodhiambo6148 Месяц назад

    Very helpful

  • @Waytoepicofficial
    @Waytoepicofficial Месяц назад

    Thanks for help out this formula

  • @deez6584
    @deez6584 Месяц назад

    SHORT AND PRECISE. I LOVE THIS!

  • @nelftm
    @nelftm Месяц назад

    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?

  • @r.o.1330
    @r.o.1330 Месяц назад

    ......accurate, understandable and right to the point. i will seek out more of your tutorials.

  • @technologistonthego2377
    @technologistonthego2377 Месяц назад

    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.

  • @Nishanthanto91
    @Nishanthanto91 Месяц назад

    Nice

  • @stlabido11
    @stlabido11 Месяц назад

    Very helpful, thanks for sharing ❤

  • @Leemberi9893
    @Leemberi9893 Месяц назад

    Thanks so much for making these short and precise videos. As a student who's taking a spreadsheet class I appreciate it.

  • @shabbarmostafa
    @shabbarmostafa Месяц назад

    Thank you

  • @bhaskarchangmai6851
    @bhaskarchangmai6851 Месяц назад

    Thank You... 😊🙏🏻

  • @sanjaysharma8474
    @sanjaysharma8474 2 месяца назад

    MID CAP NIFTY ME GAMMA HO GAYA KYA

  • @sanjaysharma8474
    @sanjaysharma8474 2 месяца назад

    LAGTA HAI AAJ GADE AARAM SE CHALIYE HOGI

  • @sanjaysharma8474
    @sanjaysharma8474 2 месяца назад

    GOOD MORNI

  • @walterjohnson8192
    @walterjohnson8192 2 месяца назад

    How do we separate the concatenated values by a comma?

  • @jerrygeorge-i5o
    @jerrygeorge-i5o 2 месяца назад

    bar chart and coloumn chart looks the same

  • @sanjaysharma8474
    @sanjaysharma8474 2 месяца назад

    MAM YOU TEACHING SO WELL KYA AAP KE CRASH COURSE ME AUR KUCH HAI

  • @gopichattu5679
    @gopichattu5679 2 месяца назад

    Thank you for the explanation very easy to understand the concept in short period of time.

  • @Mibethshe
    @Mibethshe 2 месяца назад

    👍🏽

  • @terrybohn2942
    @terrybohn2942 2 месяца назад

    like

  • @tanishazapper1954
    @tanishazapper1954 2 месяца назад

    Tomorrow is my exam

  • @Ehsan-hd7by
    @Ehsan-hd7by 2 месяца назад

    Not Bad

  • @yaritzamartinez1111
    @yaritzamartinez1111 2 месяца назад

    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!

  • @alexterra3467
    @alexterra3467 2 месяца назад

    this saved my life , wonderful video and explanation.

  • @shreshthsanjay1702
    @shreshthsanjay1702 2 месяца назад

    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! ❤

  • @SuTUM94
    @SuTUM94 2 месяца назад

    Helpful for me. Thanks.

  • @weneed3171
    @weneed3171 3 месяца назад

    why do people use 0 for the approximate match??

  • @shamans123
    @shamans123 3 месяца назад

    Very grateful for this video. I was having a hard time understanding how to format this based off text guides.

  • @LeochrisWanangwa-tq7ud
    @LeochrisWanangwa-tq7ud 3 месяца назад

    Very helpful thank u

  • @moussayoussef236
    @moussayoussef236 3 месяца назад

    Very nice & thanks

  • @yalobeko7978
    @yalobeko7978 3 месяца назад

    Thank you

  • @user-fx4uq4qw8p
    @user-fx4uq4qw8p 3 месяца назад

    Came here for my paper which is tommorow really easy😅

    • @omphemetsematshidiso4984
      @omphemetsematshidiso4984 3 месяца назад

      Mine is in an hour😐

    • @red34x52
      @red34x52 3 месяца назад

      Came here cause a kid asked me how to use it,gave a lame excuse bought my self some time

  • @suaaddalvi1132
    @suaaddalvi1132 3 месяца назад

    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?

  • @vmtejaswini4351
    @vmtejaswini4351 3 месяца назад

    excellent explanation !

  • @lola0821
    @lola0821 4 месяца назад

    Thanks! Very simple and to the point!