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

See how to use the excelisfun YouTube channel:

1) Search For Videos
2) Download Workbooks
3) Find Playlists With The Videos You Want!

Excel How To Videos
Excel Videos
Learn How To Use Excel Videos
Excel Tutorial Videos
Excel Formula Videos
Excel Functions Videos
Excel Pivot Tables PivotTables Videos
Excel VLOOKUP Videos
Videos About Excel

Category:

Science & Technology

Tags:

• Excel
• 2007
• 2003
• 2010
• excelisfun
• Is
• Fun
• Learn
• How
• To
• Mike
• Girvin
• Highline
• Community
• College
• Formulas
• Functions
• Search
• For
• Videos
• Download
• Workbooks
• Find
• Playlists
• PivotTables
• Pivot
• Tables
• Data
• Analysis
• Format
• Cells
• Math
• Statistics
• Basic
• Advanced
• Slaying
• Dragons

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

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

[3Bidasha7]

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

[shadowknight981]

66696666666666696666999999999

66696666666666696666666696666

66696666666666696666666696666

66699999999999996666666696666

66696666666666696666666696666

66696666666666696666666696666

66696666666666696666999999999

Press ctrl f then type in 9

[ExcelIsFun]

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

[ExcelIsFun]

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

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

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