excelisfun Search & Find Excel Videos, Playlists, Download Excel Workbooks and more...

[3Bidasha7]

Is it possible to use PDF files in PowerPoint? If possible, please email me at uguyh3377@gmail.com

[jloo1000]

I've bought your book but I regret that I did not order the DVD. Can I just purchase your DVD separately. Fyi - you excel series had helped me so much.

Thank you.

[ExcelIsFun]

@jloo1000 , Thank you very much for your support!!!

[shadowknight981]

66696666666666696666999999999

66696666666666696666666696666

66696666666666696666666696666

66699999999999996666666696666

66696666666666696666666696666

66696666666666696666666696666

66696666666666696666999999999

Press ctrl f then type in 9

[ElmarBischof]

It kind of is 10 x faster by remodeling the Database so it can use Vlookups ... but I don't want to remodel the Database all the time I have something similar... the power of sumifis made me lacy, so to say. But its slow.

Anyhow ... thx in advance.

[ExcelIsFun]

@ElmarBischof , SUMIFS is pretty fast as you will see in the playlist. Things like Helper Columns are usually a great way to speed things up. I have just recently made a few videos about Helper Columns: EMT 802 and Mr Excel excelisfun Trick 81. More to come also.

[ElmarBischof]

Could you recommend one of your videos regarding an alternative to an =sumifis Function ? (Trick #203 did not solve it, although was generally nice as all of them)

Once one uses 100 to xyz sumifis Functions containing 4 to 5 criteria within one Workbook it starts to get a bit slow at recalculating - as one changes a key-indicator that effects all of them for instance.

[ExcelIsFun]

@ElmarBischof , go to plaYLIST AND LOOK AT THE fORMULA eFFICENCY sERIES. tHE SOLUTION TOTALLY DEPENDS ON MANY FACTORS.

[natabelo]

Hi Mike!

In one of your videos you have mentioned the key short-cut for copying Conditional Formatting Rules when in "Conditional Formatting Rules Manager" window. But I have forgotten the short-cut and the video it was mentioned in. I've spent HOURS looking for it but no luck... Could you please, please, please remind me of the short-cut?

Thank you so much in advance!

[ExcelIsFun]

I do not know the keyboard for:

copying Conditional Formatting Rules when in "Conditional Formatting Rules Manager" window

[ElmarBischof]

@natabelo

Also had to duplicate a lot of continental formatting with slightly different formulas but similar Formatting rule.

Copy it to the cells to the right as often as you need it ... change the Formulas, select all the fields and then past them into the original cell with Merge (Alt+H+V+G). (Take care that you use the right reference type within your formulas or it might get scrambled at merging)

[ExcelIsFun]

@ElmarBischof , to really speed things up, post question to Mr Excel Message Board and get specific help for your project.

[robertoq33]

Hi,

I've been a big fan for a while. I have a quick problem and don't seem to find a video that can help me out (maybe my search skills are not that good :) ).

Anyways, my problem is that I have the same data elements coming every week and I want to store those with that particular date in order to create a database. Any suggestion?

Thanks!

[ExcelIsFun]

@robertoq33 , post Q to:

mrexcel [dot] com/forum

[rda51]

Hey Mike,

I was wondering why we hadn't received any notifications of new videos from you, so I checked it out and found out about your injury. Must be very frustrating for you. Hope the recovery is going well.

[ExcelIsFun]

@rda51 , yes, it has been no fun.

[aasabir1]

HELLO SIR

HOW ARE YOU

YOUR VIDEOS (EXCEL IS FUN) ARE REALLY FANTASTIC AND EDUCATIONAL

I WANT TO KNOW (IF I MADE A DATA PROGRAM AND A LOT OF FORMULAS ETC ) THE Q IS " CAN I RUN THAT EXCEL FILE AS .EXE FILE.

I MEAN .. THAT I DON'T WANT TO RUN THAT FILE IN EXCEL JUST I WANT TO INSTALLED AND THEN RUN WITHOUT EXCEL PROGRAM

SIR

IS IT POSSIBLE ?

[ExcelIsFun]

@aasabir1 , I do not know an answer.

[bodrulm1]

Thanks for your great videos. I've now bought your book, Slaying Excel Dragons, to show my support!

[ExcelIsFun]

You are welcome for the videos! Thanks for the support by buying the book!

[malibusurf99]

Mike, love your videos. I am preparing for the MOUS Excel expert certification and your tutorials are invaluable. Do you have a tutorial on iterative formulas and on auditing formula errors by tracing with precedents and dependents?

[ExcelIsFun]

No I do not have videos on either topic. Sorry.

[KCBombay]

Mr. Excel is fun. You ROCK!!! Thanks for taking the time to share your knowledge and skills with so many people, including myself.

[ExcelIsFun]

You are welcome!

[aasabir1]

Hello Sir

I want to download All Excel Videos

but I can't

I want to download a full playlist of all videos

HOW IS IT POSSIBLE.?????????

[Pavel1088]

@aasabir1

Use Internet Download Manager to download them ! Very easy ! All file is FLV file. Good luck !

[ExcelIsFun]

I do not know how to 'download' videos. Try a Google search - I think there are a few aps to do it.

[rodrjua]

Thanks Mr excel is fun! your videos are really great and educational, I am sorry to hear of your accident I hope you will recover soon and best wishes for you Thank you again

[ExcelIsFun]

Thanks!

[UneduSchlr]

I'm using Excel 2007 and I had a specific question. I have some raw data that is from A1:H500 and I made three pivot tables out of the same data. Those three pivot tables then feed into a model that I created. The only problem I have is that in my three pivot tables each of them have a "report filter" that is independent of all the other pivot tables. Can I create one "report filter' that will automatically filter all three pivot tables or will I have to filter each pivot table one at a time?

[ExcelIsFun]

currently working 70+ hours a week, No time, Post to THE best Excel question site:

mrexcel[dot]com/forum

[Asusisuful]

hi, how did you zoom the certain area as your wish?

could you teach me?

i am using window 7, will it be able to do that?

[1002vicky]

Hello sir.

I am copying the data from the source file to the target file where i want to do data validqations.

So i have given the formaula as "=IFERROR(IF([MasterFile.xlsx]­PList!A6=" "," ",[MasterFile.xlsx]PList!A6)," ")"

but in the new row where there is no data in the source file. I get the value as 0 instead of a null value.

[ExcelIsFun]

I have no idea!? Try THE best Excel question site:

mrexcel[dot]com/forum

[79RamaRama]

Sorry for the typo. I meant dropped an email and not "workbook".

[79RamaRama]

people.highline.edu/mgirvin/Ex­­­celisFun.htm. Could you please let me know if you can access the link sent by you now.Also, I am unable to visit the highline.edu website.

[79RamaRama]

But sorry, I am unable to access the below link.

[79RamaRama]

Thanks a lot for your prompt response.

[ExcelIsFun]

The web site is working and the download is available. If you send me an e-mail to excelisfun at gmail dot com

I will e-mail you all the workbooks.

But the address is working, you just need to type the correct address in. :)

[79RamaRama]

hi

[79RamaRama]

Hi,

After purchasing the ebook, I was able to access the site yesterday

people.highline.edu/mgirvin/Ex­­­celisFun.htm

But I am unable to access it now. I am getting the below error.

Firefox can't find the server at people.highline.edu. Could you please let me know if there is any issue with the site.

[ExcelIsFun]

I sent you a message. You just typed the wrong address. it is:

Try:

people.highline.edu/mgirvin/Ex­­­celisFun.htm

E x c e l i s f u n

l then i (L then little eye)

[79RamaRama]

Sorry a typo.

I mean I  purchased the ebook a few days ago and was given the below link to access excel exercised.

people.highline.edu/mgirvin/Ex­celIsFun.htm.

I am unable to access the link. Could someone please get back to me asap on how the issue can be fixed.

[ExcelIsFun]

Try:

people.highline.edu/mgirvin/Ex­­celisFun.htm

E x c e l i s f u n

l then i (L then little eye)

[79RamaRama]

I purchased the ebook a few books and was given the below link to access excel exercised.

people.highline.edu/mgirvin/Ex­celIsFun.htm.

I am unable to access the link. Could someone please get back to me asap on how the issue can be fixed.

[ExcelIsFun]

Try:

people.highline.edu/mgirvin/Ex­­­celisFun.htm

E x c e l i s f u n

l then i (L then little eye)

[79RamaRama]

I purchased the ebook a few books and was given the below link to access excel exercised.

people.highline.edu/mgirvin/Ex­celIsFun.htm.

I am unable to access the link. Could someone please get back to me asap on how the issue can be fixed.

[ExcelIsFun]

Try:

people.highline.edu/mgirvin/Ex­­­celisFun.htm

E x c e l i s f u n

l then i (L then little eye)

[PhanganMoonstone]

@ExcelIsFun 

[huztin1]

So if John (i select john from the drop down) likes apples i want the next cell to show a drop down list to different types of apples (drop drown list of apple type choices). I want the 3rd cell to give out a corresponding cost of the Red (from drop down list in the 2nd cell) Apple (from drop down list in the 1st cell) selected.

[79RamaRama]

Many thanks. I got it. Will go through it in the next few days.

[79RamaRama]

Hi,

Thanks a lot for the info.

I purchased the ebook slaying excel dragons from mrexcel.com. However I couldnt find any exercises that I could work on to test my skill-once I was done with the topic.

Could you please let me know if there any exercises that I could get. Also, I would like to download the excel workbooks.

[ExcelIsFun]

If you read the introduction to the book it shows web address to download files. Here is the address:

people.highline.edu/mgirvin/Ex­celIsFun.htm

[79RamaRama]

Thanks for the info. Do you have also the data in the form of ebook or pdf-as that would be easier option to obtain access.

I am in India and thinking that it would take sometime for the dvd to be shipped.

[ExcelIsFun]

If you are in India, I do not think you can buy the e-book, but flipkart.com in India has paper book for a good price. You can get the "Slaying Excel Dragon" e-book from mrexcel.com for $19 and then you can just download it. Here is the link for the e-book:

mrexcel[dot]com/store/index.ph­p?l=product_detail&p=211

[79RamaRama]

Hi, This is great. I now realized that my knowledge of excel is not great as i thought it was.

Wondering if you have an ebook with all the exercises that I could download to not only personally benefit but also support your cause

[ExcelIsFun]

I do not a free download, but I have written the book "Slaying Excel Dragons". The DVD has the 550 page e-book, 53 videos, Excel workbooks that allow you to do all examples in video and book and an Excel workbook with 103 practice problems with solutions and all). The "Slaying Excel Dragon DVD is $39 at:

mrexcel[dot]com/slayingdragons­dvd2011.html

[ExcelIsFun]

79RamaRama, Thanks for the support!

[huztin1]

Mike, I am trying to create a drop down select list via VLOOKUP, can you please direct me to a video. So say tom, john, Dan etc like different foods Say Apple, Citrus. And table 2 has different types of apples (red, green etc), cirtus etc. I want to be able to select a name Say John and then i get a selection of apple types to choose from.

[ExcelIsFun]

here is a play list of videos for Daat Validation:

youtube[dot]com/user/excelisfu­n#g/c/0EB55D99E9CF7E13

[huztin1]

Mike, thanks for your response, i looked t your recepie example. However i need the rseults of the vlookup to show up in a drop down format as well. So say first i seleced the name of the person using data validation (drop down list), based on my name selection i want next cell to get populated with a dropdown of the food choices based on the food type the like.

[ExcelIsFun]

Watch the video above that shows how to use this channel. Then go to the Data Validation playlist of videos. In the first 5 - 6 videos in tht playlist, there are 3 videos that show how to do DV based on DV list.

[jahobb]

I really appreciate all your videos, I've been studying them for a little while now and they have proven to be extremely helpful. Just wanted to say thank you and that I will surely purchase your book and support the cause. Thanks!

[ExcelIsFun]

I am glad that the videos are helpful! Thanks for supporting the cause: Excel is fun & Excel makes our job easier!

[linden87]

Hi, For some reason I cannot open the page containing all the workbooks to download! help!!

[ExcelIsFun]

March 12, 2011 8:03 AM:

Yes, the college server computers are down. I have no idea when they will be back up, maybe in a few hours...

I can't get any of my work done because they are down...

[Scythian61]

Years ago, my first project your vids helped me build a bankruptcy calc workbook at a law firm while my co-workers were using calculators. I churned out plans in a 10th of the time and could adjust complex variables/assets on the fly without starting the calc over. I'm no techie, I'm a paralegal halfway through law school; but your vids have allowed me to have an amazing new job against steep competition. I always recommend your site, you are a godsend! Sincerest thanks & keep up the hard work!

[ExcelIsFun]

Thanks, Scythian61 ! That is why I post the videos! I totally agree with you & from my own experience, I have come to the same conclusions: Since everyone is required to know Excel & so few do, the best way to beat the competition is to know Excel well. What always amazes me is that this fact is so obvious & yet so few people leverage this fact in their career and life. After so many years of free videos, be sure to support the cause & buy the new book "Slaying Excel Dragons" – DVD out soon too

[dmr450]

Congratulations and many thanks for the 1400 videos!! 

[ExcelIsFun]

Thanks!