Girvin video compilations - By Magic Tricks Videos

music and lyrics by girvin and LeeAnn
Posted by: d3vil

Video duration: 174 seconds
Global video hits: 220

Video duration: 86 seconds
Global video hits: 735

An interesting montage of the work of Tim Girvin and his design studio in Seattle, Washington. For more information please link to www.girvin.com

Related: filmmaker, reel, girvin, hollywood, seattle, titles, movies, matrix, unforgiven

Display Video Comments | Hide Video Comments | Add Comment

GIRVIN Lobby - Enso Creation
Posted by: GIRVIN888

Video duration: 340 seconds
Global video hits: 265

Tim painted an enso banner for the new GIRVIN office space.

Related: tim girvin, girvin, enso

Display Video Comments | Hide Video Comments | Add Comment

Girvin and the maze
Posted by: gee4ord213

Video duration: 33 seconds
Global video hits: 808

GOT CHEA!

Related: scary, maze, funny

Display Video Comments | Hide Video Comments | Add Comment

Gwen Girvin at Nuvein Presents
Posted by: nuveinTV

Video duration: 225 seconds
Global video hits: 197

Nuvein Presents Spotlight Pasadena Senior Center featuring Gwen Girvin

Related: nuvein, music, guwen, girvin, pasadena

Display Video Comments | Hide Video Comments | Add Comment

$MrExcel\$

MrExcel's Learn Excel #980 - Dueling: Wildcard Match
Posted by: bjele123

Video duration: 378 seconds
Global video hits: 723

Mike Girvin and Bill Jelen meet up again to offer three solutions to the problem of counting how many records match a wildcard criteria.Episode 980 shows you how. This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Related: excel, business, accounting, spreadsheets, tutorial, technology, mrexcel, formula, duel

Display Video Comments | Hide Video Comments | Add Comment

Latest comments made on this video:

it is gr8, how can ...
By: impathan321. on 04 May 09, 22:44:43
it is gr8, how can i use wildcard to count sale of a prodcuct on a specified date.. please advice. smilarly to find the count of product sale per sales person

Dear amianondito, ...
By: ExcelIsFun. on 28 Mar 09, 16:18:15
Dear amianondito, Yes, dynamic criteria always makes Excel more fun!! --excelisfun

I liked yours ...
By: amianondito. on 28 Mar 09, 16:00:01
I liked yours because of the ability to use dynamic criteria. It's the same reason I liked MrExcel's method better on the last lookup challenge. You're both awesome!

Dear amianondito, ...
By: ExcelIsFun. on 28 Mar 09, 13:37:58
Dear amianondito, Thanks for the vote!!! But The two methods that Mr Excel showed are clearly the best for most Excel users (The vast majority of people do not know how to use wildcards or the ampersand). The method that I used is clearly best because it shows all three at once. Now who really won? Only Context knows who really won!! --excelisfun

Really enjoyed the ...
By: rickcjohnson. on 27 Mar 09, 22:00:31
Really enjoyed the podcast! Watched it twice and look forward to the next one. I also like the theme song!!!

I am an official ...
By: amianondito. on 27 Mar 09, 20:37:25
I am an official nerd. I love this, including the theme song :) Mike won this round, I'm afraid. Bring on more challenges!!

Dear Team, 3 ...
By: ExcelIsFun. on 27 Mar 09, 19:26:32
Dear Team, 3 methods to make different sorts of people happy: 1) Filter & SUBTOTAL solution good for: a) Don't mess with criteria syntax b) Works in all versions 2) Table & SUBTOTAL solution good for: a) Don't mess with criteria syntax b) Works only in 2003 & 2007 3) COUNTIF and criteria syntax solution good for: a) Mess with criteria syntax b) Works in all versions --excelsifun

I think it is a ...
By: planiolro. on 27 Mar 09, 19:06:03
I think it is a good solution for this dual approach.Having 2 solutions help you to understand much better and faster the solutions.Why do you want to keep the videos under 5 min?Mike has awesome videos on his channel but none of those awesome videos are under 5 min, since he is explaining everything in great detail.Bottom line: awesome video and Mike's idea seems more appealing. You aare doing an excellent job.

Highline Excel Class 12: DATE functions & Formulas
Posted by: ExcelIsFun

Video duration: 592 seconds
Global video hits: 7274

See how to use the functions: TODAY, NOW, DATE, YEAR, MONTH, DAY, EDATE. This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109

Related: excel, today, now, date, year, month, day, edate, functions, formulas, mike, gel, girvin, highline, community, college, busn, 214

Display Video Comments | Hide Video Comments | Add Comment

Latest comments made on this video:

I am glad that it ...
By: ExcelIsFun. on 19 Jun 10, 18:47:17
I am glad that it helps!

thanx so much. just ...
By: jagiter. on 19 Jun 10, 18:42:38
thanx so much. just what i needed for the EDATE :)

There is nothing ...
By: ExcelIsFun. on 19 Feb 10, 17:48:59
There is nothing wrong with your formula. The number 21 is in the cell with Date Formatting. Apply General Number with: Ctrl + Shift + ~ and you will remove Date format and see 21. Number format is a facade. This is very important to know if you are going to advanced in your Excel expertise. See this video: Excel Magic Trick 450: Number Formatting Abbreviated Notes (House Paint or Halloween Mask)

Dear Excellisfun, ...
By: thuynguyenable. on 19 Feb 10, 15:51:23
Dear Excellisfun, Can you help me,please? My date is 2/19/2010 in A3 cell When I use =Day(A3), it give me 19. It's OK. But when I use=Day(A3)+2, It gives me 1/21/1900. I thought it would give me No.21, two days after Feb 19. Can you show me where I am wrong with the formula? Thanks.

in my Excel 2003, ...
By: bogdanakice. on 26 Nov 09, 18:39:42
in my Excel 2003, EDATE works just fine. It doesn't point that it would be a formula, but it does exact the same thing like in Excel 2007. Curious...

You are welcome!
By: ExcelIsFun. on 05 Nov 09, 02:26:00
You are welcome!

Thanks!!
By: secoja. on 05 Nov 09, 02:23:09
Thanks!!

Yes that will work! ...
By: ExcelIsFun. on 03 Nov 09, 00:01:15
Yes that will work! + 1 works becasue a date is a serial number.

cheers, that was ...
By: Strftw. on 02 Nov 09, 23:34:12
cheers, that was helpful. one thing i don't quite understand is, say im entering things and i want to just add one day onto a following day - how can i do this... something like typing +1? thanks

Go to Tools Menu, ...
By: ExcelIsFun. on 23 Sep 09, 13:17:19
Go to Tools Menu, Add-ins, then add the Data Analysis Toolpak.

i have office 2003 ...
By: secoja. on 23 Sep 09, 06:05:02
i have office 2003 and EDATE doesnt appear!

dear excelisfun ...
By: soulsaver04. on 28 Jun 09, 18:49:18
dear excelisfun the computer i hav in my office right now is not good and sometimes a simple copy paste does not work. i have problem using vlookup so what i did was to delete columns just to make the number of table array small. 2 columns only just to make the formula work. so i think the computer is the problem. i reviewing your videos maybe ive forgotten them . i was just wondering if formulas does not work even on good condition pc. thanks by the way im still using excel 2003. thanks

Dear soulsaver04, ...
By: ExcelIsFun. on 28 Jun 09, 18:08:52
Dear soulsaver04, Excel almost never makes math or logic errors. Formulas don't work right, when the person who made them made a mistake. In big spreadsheets sometimes formulas calculate very slowly. If you know how to get to my Playlists, I have a whole videos series about big spreadsheets named "Formula Efficiency Series". What specifically is not working in your spreadsheet? --excelisfun

hello excel, ...
By: soulsaver04. on 28 Jun 09, 17:24:11
hello excel, may i ask if its normal for formulas not to work on really big spreadsheets?? is it common?? do i have to check always if my formulas actually work

Dear fantazticc, ...
By: ExcelIsFun. on 13 Apr 09, 13:02:32
Dear fantazticc, That is a great idea! I have a video on this topic, but it is at my college web site for my Busn 214 class, but it is in a different file format. I will put it on my list of videos to make for YouTube! --excelisfun

Thanks for the ...
By: fantazticc. on 13 Apr 09, 05:52:35
Thanks for the video the EDATE was new for me. Very useful! One thing that I think you could have mentioned about the DATE formula is how to use it together with the LEFT, MID and RIGHT formula to get a date that you can group etc. when working with data stored in databases. Many databases store them like this YYYYMMDD. Thanks again

Dear scottylad2, ...
By: ExcelIsFun. on 07 Apr 09, 23:49:21
Dear scottylad2, I am glad that you like the Series. Do you know how to find all my Excel video Series (Playlists)? If not, watch this video (Search for this title, then watah it): Search For Excel Videos Download Excel Files excelisfun --excelisfun --excelisfun

Dear scottylad2, ...
By: ExcelIsFun. on 07 Apr 09, 23:47:31
Dear scottylad2, I made a video where I explain why the MOD function works for time. Search for and watch this video: Excel Magic Trick 286: MOD function & Time Calculations and this one: Excel Magic Trick 298: MOD function Formula for Total Time Worked --excelisfun

Great series ...
By: scottylad2. on 07 Apr 09, 18:42:50
Great series otherwise. Learned loads from these tutorials. many thanks

I use the MOD ...
By: scottylad2. on 07 Apr 09, 18:41:18
I use the MOD function to calculate times that span 1 day into the next, IE a night worker who starts at 18:00 and ends shift at 02:00am. =MOD(later time minus earlier time,Divisor 1) but not really sure what the function is doing.

Dear planiolro, ...
By: ExcelIsFun. on 06 Apr 09, 13:16:18
Dear planiolro, This video is just Date functions, not Date Math. For Date Math see these: Highline Excel Class 04: Style & Number Format & ROUND Excel Magic Trick #151: DATEDIF function (between two dates) Excel Magic Trick #12: Date Math! But, planiolro, I think you have seen all those. And then there is Houdini's DATEDIF substitute formula (so amazing), but you have to go to the Mr Excel Message Board for that one. --excelisfun

Awesome video as ...
By: planiolro. on 06 Apr 09, 09:58:02
Awesome video as usually! However I was surprised that you didnt mention anything about calculating difference between two dates. Moreover about the setbacks of DATEDIF function which is not giving right results all the time. I know that Houdini from Mr. Excel message board offered a solution using that constant array. The concept of constant array is very interesting. Where this concept can be applied besides calculating difference between two dates would very interesting! Thank you!

Highline Excel Class 01: Back To Basics
Posted by: ExcelIsFun

Video duration: 751 seconds
Global video hits: 16018

Learn about: How Excel is setup Ribbons Quick Access Toolbar QAT Scroll Bars Numbers and Text Keyboard shortcuts This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109

Related: excel, basics, cell, worksheet, workbook, ribbon, quick, access, toolbar, mike, gel, girvin, highline, community, college

Display Video Comments | Hide Video Comments | Add Comment

Latest comments made on this video:

I use the Enter ...
By: ExcelIsFun. on 06 Apr 10, 22:57:19
I use the Enter button "Speak On Enter" because I am such a bad typer and speller. Sometimes I catch errors. I do remember that movie. But let's use Excel to make Peace in the world, instead of war!!

Hi, Mike. I was ...
By: shiryu008. on 06 Apr 10, 21:19:37
Hi, Mike. I was wondering why do you like to hear excell talking to ya. I mean that talk enter button we usually hear in your fantastic videos? It remainds me to a movie "games of war" where a clever young guy hacked a military defence program and chalenge it to a nuclear world war, everybody on the defence got crazy. on the movie we used to hear the voice of the program through old fashined speakers, ¿ do you remeber it? that was an amazing movie. Let make an excell war movie shall we?

Those sounds ...
By: ExcelIsFun. on 27 Mar 10, 20:14:06
Those sounds actualyy help Excel work more efficiently!! I am glad that you like the videos!

the sound in 7' 51' ...
By: thrylos32. on 27 Mar 10, 18:21:05
the sound in 7' 51'' is legendary !! ty man this video really really helps. Excel is a super tool...

I am glad that the ...
By: ExcelIsFun. on 21 Mar 10, 18:07:22
I am glad that the video helps!

Love you man. may ...
By: ddcdpkhb. on 21 Mar 10, 09:33:17
Love you man. may Almighty God bless you...

Send me the link by ...
By: ExcelIsFun. on 19 Mar 10, 13:47:40
Send me the link by e-mail so I can follow along and learn too!

Thanks Mike. I ...
By: Thahzeeb. on 19 Mar 10, 05:32:49
Thanks Mike. I have just posted the same question on the Excel Message Board. Great work and Excel is really interesting. Started learning them through your videos.

I don't know a good ...
By: ExcelIsFun. on 18 Mar 10, 23:06:34
I don't know a good way. Try the Mr Excel Message Board: mrexcel[dot]com/forum

Hi Mike, Is ...
By: Thahzeeb. on 18 Mar 10, 19:01:42
Hi Mike, Is there any way to delete alternative rows without actually doing it manually? For example, I have a data set and I would like to delete rows 2,4,6 and so on. My work actually requires me to do so and I spend a lot of time deleting the rows manually. My extracted data is in such a way that there is an Item No. in one row and in the next row there is the description of the Item No. which I want to get rid of. I hope you understand the question.

You are welcome!
By: ExcelIsFun. on 03 Feb 10, 03:03:04
You are welcome!

Fiirst class on ...
By: youtoobeking. on 03 Feb 10, 02:10:15
Fiirst class on Highline Excel Class is done ready for the whole trip of ExcelIsFun. Really great work Thanx Mike

@ExcelIsFun I'll be ...
By: Oub2. on 28 Jan 10, 14:42:10
@ExcelIsFun I'll be waiting!

I use VBA all the ...
By: ExcelIsFun. on 28 Jan 10, 04:20:20
I use VBA all the time, but I am not good enough to make videos. As I said I do have a few videos... When I learn enough to be good, I''ll make more!

@ExcelIsFun I can't ...
By: Oub2. on 28 Jan 10, 03:16:03
@ExcelIsFun I can't believe you know that much about Excel and don't know much about VBA... If Excel is really your hobby than you HAVE to take a look into VBA. I think it's amazing. And if you do learn something, don't forget to make a video explaining it :D

The end of the ...
By: ExcelIsFun. on 26 Jan 10, 23:20:26
The end of the series I teach Macros but no VBA. If you don't know something, you can't teach it!

Wow. Your videos ...
By: Oub2. on 26 Jan 10, 22:53:28
Wow. Your videos are just perfect, you manage to keep my attencion for over 1 hour, and I wasn't even close to get bored!! I am on Highline Excel Class 04 now. And learning a lot from each video. There is only 1 thing that made me really sad: You don't teach about VBA... VBA is so great! I now very little about it, but I think it is amazing... You have to make VBA classes!!! Thanks alot!

You are welcome!!
By: ExcelIsFun. on 22 Jan 10, 22:35:00
You are welcome!!

Many many many ...
By: lexingtonlp. on 22 Jan 10, 22:03:52
Many many many thanks to you. I am so grateful for your help and time in these videos. Every video just keeps amazing me...awesome job sir...your teaching skills are phenomenal!

This Series is the ...
By: ExcelIsFun. on 24 Sep 09, 20:00:26
This Series is the most complete one that I have. This series has all of what is in the Lookup Series (but not until video 40). I am glad that the videos are helpful!

so i've "graduated" ...
By: thirthyest. on 24 Sep 09, 19:14:57
so i've "graduated" :) from your Excel Basics Series: The Story Of Excel 23 vids+2 on if function , then got to excel lookup series 1 to 5 (6 to 15 seem quite advanced stuff), so now i'm back to the basics :))) didn't knew excel was so fun! it is so great that you uploaded these videos thanks thanks thanks thanks thanks

You are welcome!
By: ExcelIsFun. on 15 Sep 09, 22:09:24
You are welcome!

Thanks for all ...
By: gchengtan. on 15 Sep 09, 16:57:56
Thanks for all these useful videos!

Dear vsramesh45, ...
By: ExcelIsFun. on 06 Jul 09, 17:43:38
Dear vsramesh45, I am glad that you like it! --excelisfun

great
By: vsramesh45. on 06 Jul 09, 17:37:16
great

Highline Excel Class 06: Worksheet & Workbook References
Posted by: ExcelIsFun

Video duration: 521 seconds
Global video hits: 4951

Learn how to create worksheet and workbook references in formulas. This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109

Related: excel, worksheet, and, workbook, references, in, formulas, busn, 214, betch, 109, mike, gel, girvin, highline, community, college

Display Video Comments | Hide Video Comments | Add Comment

Latest comments made on this video:

I am glad that you ...
By: ExcelIsFun. on 29 Jul 10, 13:41:38
I am glad that you like them!

Thanks again for ...
By: aman1245singh. on 29 Jul 10, 05:11:46
Thanks again for the wonderful videos.

You are welcome!!
By: ExcelIsFun. on 25 Jan 10, 01:54:27
You are welcome!!

Very grateful for ...
By: lexingtonlp. on 24 Jan 10, 23:19:12
Very grateful for your hard work. Outstanding teaching! Thank you so much!!

You are welcome!
By: ExcelIsFun. on 05 Nov 09, 17:10:38
You are welcome!

thanks
By: ALIKALVERT. on 05 Nov 09, 15:15:06
thanks

You are welcome. I ...
By: ExcelIsFun. on 30 Sep 09, 22:54:25
You are welcome. I put a lot of work into this Highline Series. It is the best one that I have posted. My intention is to spread as much fun and good/useful Excel knowledge as possible!

i liked this one, ...
By: thirthyest. on 30 Sep 09, 20:19:14
i liked this one, it's so cool to be able to take classes/have fun on youtube and get from beginner to interm and maybe advanced w excel :))) i appreciate your work very much!!

As I mention in the ...
By: ExcelIsFun. on 07 Sep 09, 16:26:21
As I mention in the video, for workbook references you must keep the files in the same location as when you made the original workbook reference. If the file is not found, you have to re-establish the link 03: File, Links, then use the Change Source button. 07: Office Button, Prepare, Edit Links, then use the Change Source button.

thank you for the ...
By: cindywuzh. on 07 Sep 09, 04:58:26
thank you for the video! Great job. I have a question. I use Excel 03. After I changed the info on the linked sheet, and re-open the week2 sheet, click yes on the warning message (ask me if I want to updated the information with the information on the linked sheet), and it shows that ":the file not found". Can you please explain what can I do? thank you!

I have no idea how ...
By: ExcelIsFun. on 22 Jul 09, 12:44:01
I have no idea how to use a Mac. I started off my computer days using a Mac, but as I worked more and more in the business world, I used my Mac less and less, until today, I am Mac clueless!

Excellent video! ...
By: jack40russel. on 22 Jul 09, 12:17:12
Excellent video! Since I am working on a Mac, I am having trouble with some of your shortcuts. For instance, F4 does not toggle between the cell references (although I did change the settings on my Mac). Could you perhaps make a suggestion how to use these shortcuts in MS Excel for Mac 2008?

Dear kami645464, ...
By: ExcelIsFun. on 08 Jun 09, 16:26:57
Dear kami645464, EXCELlent!!! --excelisfun

It is a project ...
By: kami645464. on 08 Jun 09, 14:28:08
It is a project about a railway company that needs a timetable for the morning peak time, which I have to create using data from many other railway companies that run on the same track. So I had to make sure for example that there is always a safety gap between the trains and that my company uses the train at appropriate times... . So mainly I had to link the timetable workbook with the workbooks of other companies.

Dear kami645464, ...
By: ExcelIsFun. on 08 Jun 09, 00:03:41
Dear kami645464, You are welcome! What IT project are you working on? --excelisfun

Another great video ...
By: kami645464. on 07 Jun 09, 20:09:28
Another great video! This was especially helpful for my proect in IT at my college. Thank you so much!

Highline Excel Class 04: Style & Number Format & ROUND
Posted by: ExcelIsFun

Video duration: 963 seconds
Global video hits: 5708

Learn about: Style Formatting Number Formatting (Date, Time, Currency, Accounting) ROUND function This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109

Related: excel, style, number, format, formatting, round, function, date, time, mike, gel, girvin, highline, community, college

Display Video Comments | Hide Video Comments | Add Comment

Latest comments made on this video:

I am glad that the ...
By: ExcelIsFun. on 20 Apr 10, 23:13:56
I am glad that the videos are helpful!

Thank you very much ...
By: marcelaaugusta. on 20 Apr 10, 21:16:24
Thank you very much! I thought I knew something about excel but watching your videos I realized I did not. I've learned a lot.

You are welcome!
By: ExcelIsFun. on 21 Mar 10, 20:00:28
You are welcome!

Best Excel teacher ...
By: acromath. on 21 Mar 10, 19:22:43
Best Excel teacher ever! Thank you soooooo much!!

EXCELlent!!!!!!!
By: ExcelIsFun. on 24 Jan 10, 04:53:40
EXCELlent!!!!!!!

God has blessed you ...
By: lexingtonlp. on 24 Jan 10, 03:39:56
God has blessed you with an amazing talent. These videos are an answer to prayer!

You are welcome!
By: ExcelIsFun. on 05 Jan 10, 21:53:09
You are welcome!

Soo many things I ...
By: SanadFeisal. on 05 Jan 10, 17:14:32
Soo many things I thought I knew but didn't! Thanks so much best Excel teacher!

You can use the ...
By: ExcelIsFun. on 29 Oct 09, 16:26:17
You can use the NETWORKDAYS function. I'll make a video about it soon.

I haven´t watched ...
By: juanvitor. on 29 Oct 09, 16:08:00
I haven´t watched many videos so far, but there is one par to count days ... what if i want to count labor days? like monday to friday? greetings from Brazil, Juan Maqueda

check
By: secoja. on 09 Sep 09, 00:00:04
check

I am glad that you ...
By: ExcelIsFun. on 29 Aug 09, 01:06:50
I am glad that you like it! I am not so much good, as just having fun with Excel!!

Thank you so much!! ...
By: familybra. on 29 Aug 09, 00:32:22
Thank you so much!! You are so Good!!

You are welcome!
By: ExcelIsFun. on 17 Aug 09, 13:34:31
You are welcome!

Excellent refresher ...
By: angrychef1. on 17 Aug 09, 02:50:19
Excellent refresher course. Thank you for sharing your knowledge.

Dear kami645464, ...
By: ExcelIsFun. on 07 Jun 09, 23:52:09
Dear kami645464, Excel is great, isn't it? There are a lot of content-rich and long videos in this series - good if you like Excel! --excelisfun

Another great video ...
By: kami645464. on 07 Jun 09, 19:02:52
Another great video of yours. I believe I will never get bored from today onwards until I finish watching all your videos. They are really amazing. Keep it up!

Dear Dave51262, ...
By: ExcelIsFun. on 14 May 09, 01:18:35
Dear Dave51262, Both are useful tricks! I am glad that you like the videos! --excelisfun

Great tip on double ...
By: Dave51262. on 14 May 09, 01:01:13
Great tip on double clicking the format painter. I also like the center over selection tip rather than merge cells and center. Thanks!

Highline Excel Class 10: VLOOKUP SUMIF & Percentage Increase
Posted by: ExcelIsFun

Video duration: 679 seconds
Global video hits: 7559

See how to create projections for sales numbers from a database using the SUMIF, VLOOKUP and COLUMNS functions and a Percentage Increase Formula. This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109

Related: excel, vlookup, sumif, columns, function, percentage, increase, formula, projections, mike, gel, girvin, highline, community, college

Display Video Comments | Hide Video Comments | Add Comment

Latest comments made on this video:

I briefly mention ...
By: ExcelIsFun. on 27 Feb 10, 02:56:18
I briefly mention this at the 1:20 to 1:30 minute mark.

If 10% up, then (1+ ...
By: ExcelIsFun. on 27 Feb 10, 02:55:46
If 10% up, then (1+.1) If 10% down, then (1-.1)

Bad YouTube is ...
By: ExcelIsFun. on 27 Feb 10, 02:54:45
Bad YouTube is doing it again. I have prepared a good answer, but it won't let me post it with the characters that it contains... I'll try again...

Mike you have given ...
By: MrHelal123. on 27 Feb 10, 01:12:56
Mike you have given excellent examples on how to increase a value by 10%, what formulas can i use if i wanted to decrease the values by 10%? Thanks

I do not understand ...
By: ExcelIsFun. on 22 Jan 10, 18:10:09
I do not understand your question. Can you re-state your question? --excelisfun (not Mr Excel)

Dear Mr Excel, ...
By: rameshsolonely. on 22 Jan 10, 16:14:32
Dear Mr Excel, thank you very much for help in inventory . i have a Question if is possible to show up value equal to P or Off in Roster i want to 2 different page like 12-8 sun on 3-12 mon tues off i want to see in next page sun p, mon p tues off if is possible in excel i am waiting your answer SunJoy Kuwait

Me too -- that is ...
By: ExcelIsFun. on 01 Oct 09, 16:19:35
Me too -- that is how I learn the best tricks in Excel!

me too :))))
By: thirthyest. on 01 Oct 09, 16:18:35
me too :))))

Dear jaeheerang, ...
By: ExcelIsFun. on 19 Jul 09, 16:33:07
Dear jaeheerang, Practice Makes perfect! --excelisfun

I have some ...
By: jaeheerang. on 19 Jul 09, 14:50:02
I have some difficulties to understand this. I think I have to go back and watch it again. But I'm sure this will be a very useful formula. Excel is getting exciting! Thank u so much!

Dear slaves2sin, ...
By: ExcelIsFun. on 02 Jul 09, 13:34:00
Dear slaves2sin, EXCELlent!! I love to hear that! When you make lots of mistakes and you keep moving forward, that is when you learn the most!!! --excelisfun

this is bloody ...
By: slaves2sin. on 02 Jul 09, 07:11:44
this is bloody tricky i made so many mistakes

Highline Excel Class 08: 3-D Cell References Add Across Sheets
Posted by: ExcelIsFun

Video duration: 330 seconds
Global video hits: 4707

Learn about how to add across sheets using 3-D cell References and the SUM function. This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109

Related: excel, add, across, sheets, using, 3-d, cell, references, sum, function, mike, gel, girvin, highline, community, college

Display Video Comments | Hide Video Comments | Add Comment

Highline Excel Class 11: Logical formulas, IS & IF functions
Posted by: ExcelIsFun

Video duration: 1652 seconds
Global video hits: 8799

Learn about: 1.Comparative Operators 2.Logical TRUE FALSE formulas 3.IS functions (ISTEXT, ISNUMBER, ISBLANK, ISERROR, ISNONTEXT) 4.IF function (1 of 2 words in a cell, 1 of 2 numbers in a cell, 1 of 2 formulas in a cell) 5.Conditional Formatting TRUE FALSE formula This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109

Related: excel, logical, true, false, formulas, is, if, functions, istext, isnumber, iserror, conditional, formatting, mike, gel, girvin, highline, community, college

Display Video Comments | Hide Video Comments | Add Comment

Latest comments made on this video:

I do not know. Try ...
By: ExcelIsFun. on 22 Apr 10, 00:07:00
I do not know. Try the Mr Excel Message Board: mrexcel[dot]com/forum

what excel formula ...
By: pinkyme86. on 21 Apr 10, 22:03:54
what excel formula should I use which will count phrases in first column and will display two word phrases in 2nd column (if a row in 1st column contains two word phrases) and will display the word "ERROR" if a row in 1st column contains 1, 3 or more phrases?

what excel formula ...
By: pinkyme86. on 21 Apr 10, 21:57:27
what excel formula should I use which will count phrases in 1st column and will display two word phrases in 2nd column (if a row in 1st column contains two word phrases) and will display the word "ERROR" if a row in 1st column contains 1, 3 or more phrases?

I am glad that thet ...
By: ExcelIsFun. on 11 Mar 10, 14:36:45
I am glad that thet are helpful!

I love these ...
By: WEIRDOinPANTS. on 11 Mar 10, 11:12:31
I love these classes! They are awesome!

You are welcome!!
By: ExcelIsFun. on 10 Mar 10, 16:13:25
You are welcome!!

Thank you.
By: lovsgms. on 10 Mar 10, 15:58:22
Thank you.

Thanks! :D
By: simabah. on 26 Oct 09, 22:24:25
Thanks! :D

If number is A1: ...
By: ExcelIsFun. on 26 Oct 09, 22:09:34
If number is A1: =IF(A1

Hello, On the ...
By: simabah. on 26 Oct 09, 19:32:48
Hello, On the example for the Income Statement's IF formula for "Net Income" and "Net Loss" how do we include & show the "break-even" point when there is neither a profit nor a loss?

Use AND function. ...
By: ExcelIsFun. on 04 Oct 09, 21:45:03
Use AND function. Try these videos: Excel Magic Trick #31 Part 1: IF AND OR functions, logical or Highline Excel Class 33: IF AND OR Customer Credit Analysis

i forgot something ...
By: thirthyest. on 04 Oct 09, 17:43:14
i forgot something from previous classes and i don't remember which one :) it's about logical tests, you used AND/or in this vid, i wanted to use the if function instead of those so i came up with: =IF(B30>=B32&(B31>=B33), "extend credit", "no credit") instead of AND how about the "OR" (nothing i tried worked:))))) (i believe you show somewhere how to do if you have 2 logical tests with the if function )

Dear kami645464 , ...
By: ExcelIsFun. on 09 Jun 09, 00:46:15
Dear kami645464 , Apply Currency will work: Ctrl + 1, select Number tab, Select Currency, select red or black parenthesis. That should do it. --excelisfun

How do you get ...
By: kami645464. on 09 Jun 09, 00:17:52
How do you get negative numbers in red and brackets without (I assume) doing any conditional formatting? I tried formatting the cells into accounting or currency, but don't work. Hope for a quick reply as always. Thank you in advance!

Dear chippendails , ...
By: ExcelIsFun. on 28 Apr 09, 00:48:33
Dear chippendails , Search for and watch these two videos: YouTubersLoveEx cel#42: Format Negative Numbers Highline Excel Class 21: Conditional Formatting 12 Examples --excelisfun

hey at the end ...
By: chippendails. on 27 Apr 09, 17:41:48
hey at the end when you made the cell green if it was positiv: what do I have to do if I want it blue if it is negative and green if it is positive? how do I enter this 2 things?

Dear soulsaver04, ...
By: ExcelIsFun. on 14 Apr 09, 20:42:28
Dear soulsaver04, This video shows something like that: YTLE#89: Relative & Absolute Macro together and YTLE#89 part 2: VBA Code for Relative & Absolute Macro But really, if you want to write VBA code the smartest VBA Excelers are at the Mr Excel Message Board. Here is a video for that: How To Post Questions At The Mr Excel Message Board --excelisfun

hello excelisfun ...
By: soulsaver04. on 14 Apr 09, 18:46:31
hello excelisfun ive seen a spreadsheet and im wondering how to do it.. what i saw was a bunch of data inputed and then theres a save button and once save is clicked then everything clears on the template and the data transfers to a table on another spreadsheet.. sorry i have not yet watched all of your videos , so if you made one similiar to this may you please tell me the title of the video.. thanks

Dear oburcrod , ...
By: ExcelIsFun. on 08 Apr 09, 15:41:22
Dear oburcrod , I am glad that the video is useful to you!! --excelisfun

Hi Master Excel is ...
By: oburcrod. on 08 Apr 09, 15:24:51
Hi Master Excel is Fun I am a English learning student, but I already can understand your lessons, in fact, in my work I am known as a advanced excel user, but thanks to your lessons, your lessons are the best way to learn. God bless you and pay you for it. Regards from Mexicali, Mexico

Dear alonemusic, ...
By: ExcelIsFun. on 07 Apr 09, 00:13:23
Dear alonemusic, In Excel 2007, the keyboard shortcut to zoom to Selection is: Alt + W + G. I use that one eveyday! --excelisfun

what short cut do ...
By: alonemusic. on 06 Apr 09, 15:27:58
what short cut do you use at 17:02 to adjust your zoom to the selection ?

Highline Excel Class 03: Names, Cell References, Formula Inputs
Posted by: ExcelIsFun

Video duration: 2018 seconds
Global video hits: 10226

Learn about: How to Name a range of cells Use Names in Formulas Cell References: Relative, Absolute, Mixed Assumption Tables Formula Inputs Comparative Common Size Income Statement Fixed Cost Variable Cost Analysis This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109

Related: excel, cell, references, relative, absolute, mixed, formula, inputs, mike, gel, girvin, highline, community, college

Display Video Comments | Hide Video Comments | Add Comment

Latest comments made on this video:

I do not have a ...
By: ExcelIsFun. on 10 May 10, 02:49:16
I do not have a number in mind. But as long as I still have ideas and it is still fun, I;ll keep making them. Probably no other MS non-Excel videos, though.

Hi Mike. As always ...
By: shiryu008. on 09 May 10, 21:06:38
Hi Mike. As always a superb job. Cuestion: have you a number in mind of how many excell videos are you planning to do? And what about other MS office tools like word or Power point? that would be tremendous!. I'am an egoist right :). Thanks, Keep Exceel-youtubing us!

high class videos, ...
By: thrylos32. on 28 Mar 10, 10:45:02
high class videos, ty

You are welcome! ...
By: ExcelIsFun. on 11 Mar 10, 14:44:37
You are welcome! Thanks for the EXCELlent comment!

Excellent lesson & ...
By: thuynguyenable. on 11 Mar 10, 14:42:57
Excellent lesson & Excellent Instructor. Thank you for sharing.

THanks for the ...
By: DeoKorneo. on 24 Jan 10, 20:47:29
THanks for the advice -? I will look into it. Keep up the good work excelisfun.

Yes, I do not cover ...
By: ExcelIsFun. on 24 Jan 10, 17:13:05
Yes, I do not cover VBA. The best video series for VBA is by Mr Excel, but it is not free. However the 49 bucks for his VBA series is well worth it: mrexcel[dot]com

Mike, your work is ...
By: DeoKorneo. on 24 Jan 10, 16:21:03
Mike, your work is absolutely brilliant. Thanks for spending the time making the videos and letting us newbies access it so freely and easily. Just a selfish question: It looks like you cover nearly everything in all your videos, could you advise if there is something that might be useful which you haven't covered, for example the vb side, or others? Many thanks once again. Excel is indeed lots of fun!! Well, at least you make it fun!

You are welcome!
By: ExcelIsFun. on 23 Jan 10, 21:13:09
You are welcome!

Thank you very much ...
By: lexingtonlp. on 23 Jan 10, 20:01:57
Thank you very much! Awesome video.

You are welcome!
By: ExcelIsFun. on 31 Oct 09, 13:56:07
You are welcome!

Thank you !
By: Gilllionaire. on 30 Oct 09, 23:29:13
Thank you !

That sounds great ...
By: ExcelIsFun. on 06 Oct 09, 04:38:39
That sounds great to me!! Good work!

Mike, I use a ...
By: 154song. on 06 Oct 09, 01:34:37
Mike, I use a named table for a bank recs file. On my bank download I use VLookup to return issued cks cleared the same month from a named table (w/ck #s and $) of the GL download. Then I code the cleared checks issued the same month "a" and "e" for cleared checks issued prior months. After that, another vlookup bringing "a" from bank file to GL file to determine the outstanding list. When I sort the coded GL file the range of the NAME is shifted. Any better ways to handle it? Thanks. Swei

EXCELlent!! Getting ...
By: ExcelIsFun. on 26 Sep 09, 21:59:30
EXCELlent!! Getting it is great!

now i get it, thank ...
By: thirthyest. on 26 Sep 09, 19:19:57
now i get it, thank you :))

COUNTIF(Car_Type,F6 ...
By: ExcelIsFun. on 26 Sep 09, 19:05:17
COUNTIF(Car_Type,F6)+COUNTIF(C ar_Type,G6) is saying add the F6 criteria first, then add the G6 criteria second (and separately), then add. =COUNTIFS(Car_Type,F6,Car_Type ,G6) is saying find the records that are both F6 criteria and F6 criteria at the same time.

i have a question ...
By: thirthyest. on 26 Sep 09, 17:02:15
i have a question on countif/s so COUNTIF(Car_Type,F6)+COUNTIF(Car_Type,G6) equals 72 then why this one does not work =COUNTIFS(Car_Type,F6,Car_Type,G6) (equals 0) prolbably because i did something wrong but what :))

You are welcome!
By: ExcelIsFun. on 02 Sep 09, 18:13:11
You are welcome!

Thank you so much ...
By: cindywuzh. on 02 Sep 09, 17:44:33
Thank you so much for sharing your teaching with us!

Dear ...
By: ExcelIsFun. on 27 Apr 09, 16:52:31
Dear CHAMPAGN3SUP3ERNOVA , There is a setting in theOptions that will allow you to use PC shortcuts. --excelisfun

oh man im using a ...
By: CHAMPAGN3SUP3ERNOVA. on 27 Apr 09, 13:59:16
oh man im using a mac and excel 08 so i can's use some of your shorcuts.

Dear MmansoorM, ...
By: ExcelIsFun. on 30 Mar 09, 21:07:18
Dear MmansoorM, Yes, YouTube has been having trouble lately... --excelisfun

Now it is working.
By: MmansoorM. on 30 Mar 09, 19:50:21
Now it is working.

Your website is not ...
By: MmansoorM. on 30 Mar 09, 19:21:20
Your website is not working....

Highline Excel Class 23: Import Different Types of Data
Posted by: ExcelIsFun

Video duration: 834 seconds
Global video hits: 3650

See how to import data into Excel from text files, web sites, Excel files and Access files. See how to import Currency Rates and Major Indicies from real-time data. This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109

Related: excel, import, access, text, web, data, currency, indicies, excelisfun, mike, gel, girvin, highline, community, college

Display Video Comments | Hide Video Comments | Add Comment

Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40