JavierDiaz4's channel

JavierDiaz4 liked 3 months ago

4:44 Add to

Excel Magic Trick #15: SUM or COUNT Above Some Limit!

See how to use the SUMIF and COUNTIF functions to add and count above some limit. You can add only the Sales above $5000, or any other number! See ...

15,643 views

• 3:12 Add to

  Excel Magic Trick #14: Amazing Find & Go To Trick!

  See how to use the Find command to go to all cells with a certain formatting, or even a certain function! Then it is easy to make universal changes...

  22,411 views

• 4:48 Add to

  Excel Magic Trick #13: SUM or COUNT only certain items! SUMIF COUNTIF functions

  See how to use the SUMIF and COUNTIF functions to add and count given a certain condition. With this trick you can add only the sales for the sales...

  46,841 views

• 3:45 Add to

  Excel Magic Trick #12: Date Math!

  Excel! Learn how to calculate the time between 2 dates like invoices past due. Learn how to calculate a loan due date or how many days you have bee...

  66,050 views

+ 3 more videosshow less

JavierDiaz4 liked 3 months ago

5:00 Add to

Excel Magic Trick #11: How Good Is Your Average?

Excel! Learn 3 types of Variation measures including Standard Deviation. See how to determine whether your average fairly represents its data point...

16,409 views

• 4:08 Add to

  Excel Magic Trick # 10: 3 types of Averages!

  Excel! 3 types of Averages! See how to use the AVERAGE, MEDIAN and MODE functions in Excel. Also see how to name a cell range and how to sort to ve...

  18,958 views

• 2:56 Add to

  Excel Magic Trick # 9: Join 2 Cells into 1

  Excel! See how to take two columns of data and join them into one column! This process is called Concatenation. And we will use the join operator "...

  30,488 views

• 1:59 Add to

  Excel Magic Trick #8: Text To Column

  Excel! Need to separate first and last name into two cells? Need to take a column of text and break it apart into multiple columns? This is called ...

  29,674 views

+ 3 more videosshow less

JavierDiaz4 liked 4 months ago

1:54 Add to

Excel Magic Trick #7: Clear Formatting Only!

Excel! See how to remove the formatting from the cell, but not the cell content! Then see how to remove Everything -- the formatting and the cell c...

20,713 views

• 3:09 Add to

  Excel Magic Trick #6: Conditional Formatting for a Row

  Excel! See how to add Conditional Formatting to a whole row of data. See that the formula for this is a True/False formula. Then see how as you cha...

  57,769 views

+ One more videoshow less

JavierDiaz4 liked 4 months ago

6:57 Add to

Excel 2010 Business Math 09: Summarize Formula Inputs, Formulas & Stylistic Number Formatting

Download file: http://people.highline.edu/...

This is a Business Mathematics Class (Busn Math 135) taught by Mike excelisfun Gir...

707 views

• 6:16 Add to

  Excel 2010 Business Math 06: Math Order Of Operations & Formulas In Excel

  Download file: http://people.highline.edu/...

  This is a Business Mathematics Class (Busn Math 135) taught by Mike excelisfun Gir...

  683 views

• 3:10 Add to

  Excel 2010 Business Math 04: Range Functions Rule!

  Download file: http://people.highline.edu/...

  This is a Business Mathematics Class (Busn Math 135) taught by Mike excelisfun Gir...

  1,219 views

+ 2 more videosshow less

JavierDiaz4 liked 7 months ago

3:17 Add to

incomprensible amor ANIBAL PEÑA

2,087 views

• 3:17 Add to

  MUCHACHITA DE MI PUEBLO - ANIBAL PENA 1.mpg

  ANIBAL DE PENA - COMPOSITOR - PIANISTA Y CANTANTE DOMINICANO

  6,323 views

• 3:13 Add to

  MI DEBILIDAD ANIBAL PEÑA

  17,335 views

+ 2 more videosshow less