Home
Search results “Magic books index tricks”
DO SHOCKING 'MIND READING' MAGIC TRICK WITH ANY PAPER NAPKIN!
 
07:03
Jay Sankey shares the mind-blowing secret to being able to READ PEOPLE'S MINDS with an ordinary paper napkin. This cool street magic trick seems to be a demonstration of real psychic ability. Learn the secret NOW. Download 3 FREE Magic E-books! http://bit.ly/1wtBgkj Subscribe to the SankeyMagic CHANNEL http://bit.ly/1ZUkDLa Visit Jay's MAGIC SHOP http://bit.ly/Kn6fLe Connect with Jay on FACEBOOK http://bit.ly/27prrGh Follow Jay on TWITTER for daily magic tips + advice! http://bit.ly/16H4djN Visit InsideDeception the world's #1 training site for magicians + mentalists http://bit.ly/1dzLh71 Find out more about Jay at JAYSANKEY.COM http://bit.ly/1YtDM60 Welcome to the official YouTube channel of Jay Sankey Magic. Jay Sankey is a true magician’s magician and is widely considered to be one of the most original thinkers and finest magic teachers alive today. He is also one of the most prolific magic creators on the planet. Jay's original tricks have been performed by many of the world’s most famous magicians including David Copperfield, Criss Angel, David Blaine, Dynamo and Keith Barry. Jay also fooled Penn and Teller on the tv show 'FOOL US' and made Toronto's CN Tower vanish! Learn fun magic and mentalism tricks from one of the world's most experienced performers and teachers. Jay uploads new tutorial videos, comedy videos, and cartoons every week. Learn the secrets to card tricks, coin tricks, mentalism and psychic tricks. Jay also reveals the secrets to his favorite, easy to do street magic tricks!
Views: 1315547 SankeyMagic
Magic Card Trick from THEIR Pocket! Revealed!
 
10:18
Card Tricks ANYONE can do without mastering MAGIC! Learn a DAILY Card Trick all week! Subscribe Now for more Pranks, Tricks, Social Experiments and Fun Videos: http://bit.ly/ucmagic Follow me on Facebook: http://bit.ly/RichFB My 2ND Channel for VLOGS, EXTRAS: http://bit.ly/2ndrich Media Inquiries or USE OF CONTENT, please use our contact form: http://bit.ly/askrich For booking Magician/Mentalist Rich Ferguson for Corporate or VIP Entertainment, Motivational Speaking, Body Language Workshops: http://bit.ly/askrich Check out Rich’s CRAZY prank and magic products: Get Rich’s EPIC Mind Reading Card Trick App - A.I.Magic: http://bit.ly/phonemagic Get Rich’s INSANE Camera Prank App - TRICK PIX: http://bit.ly/trickpix Blank Gag Books: http://bit.ly/blankgagbooks Get Rich’s Magic Tricks and Bar Bets book - Tricks to Pick Up Chicks (Play on words, this is NOT a seduction book): http://amzn.to/11QPLz7 Get Rich’s Mind Reading Magic DVD “This is Mentalism”: http://bit.ly/1ibOGMC Get Rich’s Mind Reading Magic DVD “This is Mentalism”: http://bit.ly/1jDbzoO Get Rich’s Money Magic DVD “Serial Biller”: http://bit.ly/1nlXEsq Get Rich’s Mind Bending Word on Spectator Magic DVD “Tagged”: http://bit.ly/1hkN0u4 Wild and Cool Magic Moves - The Unorthodox Collection: https://www.youtube.com/watch?v=GCuoG91e0xM At The Table 4 HOUR Magic Lecture: http://bit.ly/1R8EmWP Follow Rich on Twitter: https://twitter.com/richferguson Follow Rich on Vine: https://vine.co/richferguson Follow Rich on Instagram: http://instagram.com/theicebreaker Follow Rich on facebook: http://www.facebook.com/richferguson See behind the scenes, Q&A and randomness at Rich's 2nd channel: http://bit.ly/2ndrich For more about Rich Ferguson, visit http://www.TheIceBreaker.com Rich Ferguson is a mentalist specializing in human behavior and travels globally for exclusive events. Rich also creates fun YouTube videos as a serious hobby and absolutely loves sharing content with you. Besides working or appearing on TV shows, managing entertainers, managing numerous products and inventions, doing workshops on body language(http://bit.ly/BLseminar) and speaking for at-risk youth groups(http://www.MotivationalMagicMaker.com), Rich is a father of twins - boy and girl. With all of his "spare" time, he makes original videos for you. Please subscribe and share with friends! Thanks for your support! We appreciate you liking and sharing our content so we can create and bring you more! If you have fun ideas, reach out anytime. We want to hear it! Lastly, people often ask where Rich lives and film his pranks. San Luis Obispo, CA: https://www.youtube.com/watch?v=-V7Mjl2f8ZE
Views: 848964 Rich Ferguson
Excel Magic Trick 1071: Dynamic Range Based on Product and Start & End Month: OFFSET, INDEX or AF?
 
21:59
Download Excel File: http://people.highline.edu/mgirvin/ExcelIsFun.htm See how to add the sales based on a 3 parameters: Product Name, Start Month and End Month. Video compares and contrasts OFFSET and INDEX function for creating Dynamic Ranges, and also looks at a number of other array formula solutions: 1. (01:15 min) OFFSET & MATCH & SUM functions. 2. (05:16 min) INDEX and MATCH & SUM functions. 3. (08:52 min) What to do if column numbers for lookup are in a single cell like: 2,3,4: OFFSET, MATCH, LEFT, RIGHT and LOOKUP function solution. 4. (14:18 min) SUMPRODUCT & Array constant in VLOOKUP. 5. (15:56 min) SUM, VLOOKUP and a Dynamic Variable-Length Array of Sequential Numbers created with ROW, INDIRECT and MATCH functions. 6. (18:33 min) INDEX to avoid Ctrl + Shift + Enter with formula in #5. 7. (19:05 min) If parameters for all months are given in cells, then a formula with SUMPRODUCT, SUMIFS, INDEX and MATCH can work. 8. (20:22 min) If parameters for all months are given in cells, then a formula with SUMPRODUCT, N, INDIRECT, ADDRESS, MATCH and MATCH with a function argument array operation can work. Excel Lookup last number in a text string.
Views: 24198 ExcelIsFun
MAKE ANY CARD APPEAR IN YOUR POCKET! (Astounding Magic Trick!)
 
11:01
Magic creator Jay Sankey shows you how you can have ANY card someone is thinking of - impossibly appear in your pocket. Your friends and family will swear it's REAL MAGIC! Learn the secrets right now. Here's the link to the kickstarter project featuring Chris' cool new deck! https://www.kickstarter.com/projects/2095634846/leon-playing-cards Also follow @leonplayingcards on Instagram! Download 3 FREE Magic E-books! http://bit.ly/1wtBgkj Subscribe to the SankeyMagic CHANNEL http://bit.ly/1ZUkDLa Visit Jay's MAGIC SHOP http://bit.ly/Kn6fLe Connect with Jay on FACEBOOK http://bit.ly/27prrGh Follow Jay on TWITTER for daily magic tips + advice! http://bit.ly/16H4djN Visit InsideDeception the world's #1 training site for magicians + mentalists http://bit.ly/1dzLh71 Find out more about Jay at JAYSANKEY.COM http://bit.ly/1YtDM60 Welcome to the official YouTube channel of Jay Sankey Magic. Jay Sankey is a true magician’s magician and is widely considered to be one of the most original thinkers and finest magic teachers alive today. He is also one of the most prolific magic creators on the planet. Jay's original tricks have been performed by many of the world’s most famous magicians including David Copperfield, Criss Angel, David Blaine, Dynamo and Keith Barry. Jay also fooled Penn and Teller on the tv show 'FOOL US' and made Toronto's CN Tower vanish! Learn fun magic and mentalism tricks from one of the world's most experienced performers and teachers. Jay uploads new tutorial videos, comedy videos, and cartoons every week. Learn the secrets to card tricks, coin tricks, mentalism and psychic tricks. Jay also reveals the secrets to his favorite, easy to do street magic tricks!
Views: 79977 SankeyMagic
PERFECT VISUAL Pen Spinning Trick - TUTORIAL!!!
 
05:58
In today's video, I am going to teach you how to spin a pen perfectly!!! ✅✅ My Savage Channel (2nd channel): https://www.youtube.com/channel/UCh7pxtWTvUYMMEYFuB6Ut1A 🔥🔥 Get YOUR INSTAGRAM FEATURED in my channel: ✔️ SUBSCRIBE TO THIS CHANNEL ✔️ LIKE THIS VIDEO ✔️ LEAVE A NICE COMMENT IN MY LATEST VIDEO(put your instagram @username in the end) ✔️✔️✔️ INCREASE YOUR CHANCE OF GETTING FEATURED BY REQUESTING A MAGIC TUTORIAL IN THE COMMENTS (put your instagram @username in the end) *You can re-enter every week **I will choose one lucky winner every for Monday episodes. ✅✅ Support me and my channel: ✔️ Follow me on Instagram: https://www.instagram.com/sohail_hazari ✔️ Like my facebook page: http://bit.ly/2zOt33K ✔️ Subscribe to my Channel: http://bit.ly/2jBPgvm ✔️ My Twitter: http://bit.ly/2iuSJIx ✔️ My Facebook: http://bit.ly/2AcgPT9 ROYALTY FREE MUSIC FOR YOUTUBERS: https://goo.gl/ovoJNP LIKE, COMMENT AND SUBSCRIBE :) ☑️ For collaboration or any personal issues DM me on instagram @sohail_hazari
Views: 4925854 Making Impossible
Dynamo's 7 Greatest Magic Tricks Finally Revealed | FactoFusion
 
11:04
We reveal how Dynamo performs some of his greatest magic tricks. From street magic to digital channel Watch, magician Dynamo has been mystifying people for years with his amazing talent. And is also known for the blockbuster show 'Dynamo: Magician Impossible'. But sometimes, decoding the magic secrets can be very challenging especially the ones performed by Dynamo. So, be it his famous lean back levitation or the fountain ice trick, in this video, we have tried our best to reveal the top secrets behind Dynamo's greatest magic tricks of all time. Subscribe to FactoFusion: http://bit.ly/FactoFusion Our Social Media: Like us on Facebook: https://www.facebook.com/FactoFusion Follow us on Twitter: https://twitter.com/FactoFusion Below is the featured list of Dynamo's 7 greatest magic tricks revealed: At number 7: Fountain Ice Trick At number 6: Phone in Bottle At number 5: Walking on water At number 4: Shard Levitation Stunt At number 3: Twisting an iPhone At number 2: Lean Back Levitation At number 1: Bus Levitation Trick Music: Kool Kats by Kevin MacLeod is licensed under a Creative Commons Attribution license (https://creativecommons.org/licenses/by/4.0/) Source: http://incompetech.com/music/royalty-free/index.html?isrc=USUAN1100601 Artist: http://incompetech.com/ So guys, which Dynamo trick did you like the most? And who is your favorite magician? Leave us a comment below.. Thanks for watching!
Views: 9799070 FactoFusion
TOP 10 Magic Pranks with Rubber Bands!! - Easy to do Tricks!
 
21:38
How to do 10 awesome magic tricks with rubber-bands! More Pranks, magic and tutorials on our channel! Subscribe NOW! http://www.youtube.com/ucmagic FOLLOW ME ON FACEBOOK: http://bit.ly/RichFB Full tricks list and time in video: (0:19) 1. Rubber Band Penetration (3:11) 2. Broke/Restored Rubber Band Trick (5:44) 3. Anti-Gravity Rubber Band Trick (7:14) 4. Rubber Band for Vanishing Things! (9:16) 5. Rubber Band through NECK! (12:38) 6. Rubber Band jumping Fingers! (13:55) 7. Rubber Band jumping Fingers LOCKED (14:45) 8. Pick a Finger Rubber Band Trick! (17:28) 9. Rubber Band up Nose! (18:37) 10. Two Rubber Bands to One! Media Inquiries or USE OF CONTENT, please use our contact form: http://bit.ly/askrich For booking Magician/Mentalist Rich Ferguson for Corporate or VIP Entertainment, Motivational Speaking, Body Language Workshops: http://bit.ly/askrich Get Rich’s EPIC Mind Reading Card Trick App - A.I.Magic: http://bit.ly/phonemagic Get Rich’s INSANE Camera Prank App - TRICK PIX: http://bit.ly/trickpix Get Rich’s Magic Tricks and Bar Bets book - Tricks to Pick Up Chicks (Play on words, this is NOT a seduction book): http://amzn.to/11QPLz7 Rich Ferguson is a mentalist specializing in human behavior and travels globally for exclusive events. Rich creates or helps with fun YouTube videos as a serious hobby and absolutely loves sharing content with you. Besides working on TV shows, managing several entertainers, managing numerous products and inventions, doing workshops on body language(http://bit.ly/BLseminar) and speaking for at-risk youth groups(http://www.MotivationalMagicMaker.com), Rich is a brand new father of twins - boy and girl. With all of his "spare" time, he makes original videos for you. Please subscribe and share with friends! Follow Rich on Twitter: https://twitter.com/richferguson Follow Rich on Vine: https://vine.co/richferguson Follow Rich on Instagram: http://instagram.com/theicebreaker Follow Rich on facebook: http://bit.ly/richfanpage See behind the scenes, Q&A and randomness at Rich's 2nd channel: http://bit.ly/2ndrich For more about Rich Ferguson, visit http://www.TheIceBreaker.com Thanks for your support! We appreciate you liking and sharing our content so we can create and bring you more! If you have fun ideas, reach out anytime. We want to hear it! Lastly, people often ask where Rich lives and film his pranks: https://www.youtube.com/watch?v=-V7Mjl2f8ZE
Views: 3790872 Rich Ferguson
Excel Magic Trick 1352: Lookup 3 Items & Return to Single Cell VLOOKUP, INDEX or LOOKUP functions?
 
18:07
Download File: http://people.highline.edu/mgirvin/excelisfun.htm See how to create a formula that simultaneously looks up 3 item, joins then together in a single cell in order to produce a system code for CompanyName/PlantZipCode/. See 4 formula methods, including timing of calculation time for each formula: 1. (00:15) Introduction 2. (01:54) Formula 1: 3 VLOOKUP Exact Match functions 3. (04:45) Formula 2: 1 VLOOKUP Approximate Match function with Array Operation and the special keystroke Ctrl + Shift + Enter 4. (08:52) Formula 3: 1 INDEX & MATCH Approximate Match with Array Operation 5. (12:23) Formula 4: 3 LOOKUP Approximate Match functions 6. (15:12) Timing formula calculation time for each formula 7. (17:26) Ctrl + Shift + Enter: Mastering Excel Array Formulas Book 8. (17:38) Summary Related Videos: Excel Magic Trick 1282: Lookup And Return Multiple Items to a Single Cell: TEXTJOIN Function https://www.youtube.com/watch?v=oseoa_2OYqg Excel Magic Trick 901: Lookup First & Last Name From 2 Different Cells & Return Then To 1 Cell https://www.youtube.com/watch?v=IRcRDHMbMLI
Views: 8174 ExcelIsFun
How to BEND a COIN with FINGERS! Magic Trick!
 
03:54
Use your mind or strength to BEND a coin! Subscribe Now for more Pranks, Tricks, Social Experiments and Fun Videos: http://bit.ly/ucmagic FOLLOW ME ON FACEBOOK: http://bit.ly/RichFB Camera Prank App: http://bit.ly/trickpix Media Inquiries or USE OF CONTENT, please use our contact form: http://bit.ly/askrich For booking Magician/Mentalist Rich Ferguson for Corporate or VIP Entertainment, Motivational Speaking, Body Language Workshops: http://bit.ly/askrich Check out Rich’s CRAZY prank and magic products: Get Rich’s EPIC Mind Reading Card Trick App - A.I.Magic: http://bit.ly/phonemagic Get Rich’s INSANE Camera Prank App - TRICK PIX: http://bit.ly/trickpix Blank Gag Books: http://bit.ly/blankgagbooks Get Rich’s Magic Tricks and Bar Bets book - Tricks to Pick Up Chicks (Play on words, this is NOT a seduction book): http://amzn.to/11QPLz7 Get Rich’s Mind Reading Magic DVD “This is Mentalism”: http://bit.ly/1ibOGMC Get Rich’s Mind Reading Magic DVD “This is Mentalism”: http://bit.ly/1jDbzoO Get Rich’s Money Magic DVD “Serial Biller”: http://bit.ly/1nlXEsq Get Rich’s Mind Bending Word on Spectator Magic DVD “Tagged”: http://bit.ly/1hkN0u4 Wild and Cool Magic Moves - The Unorthodox Collection: https://www.youtube.com/watch?v=GCuoG91e0xM At The Table 4 HOUR Magic Lecture: http://bit.ly/1R8EmWP Follow Rich on Twitter: https://twitter.com/richferguson Follow Rich on Vine: https://vine.co/richferguson Follow Rich on Instagram: http://instagram.com/theicebreaker Follow Rich on facebook: http://www.facebook.com/richferguson See behind the scenes, Q&A and randomness at Rich's 2nd channel: http://bit.ly/2ndrich For more about Rich Ferguson, visit http://www.TheIceBreaker.com Rich Ferguson is a mentalist specializing in human behavior and travels globally for exclusive events. Rich also creates fun YouTube videos as a serious hobby and absolutely loves sharing content with you. Besides working or appearing on TV shows, managing entertainers, managing numerous products and inventions, doing workshops on body language(http://bit.ly/BLseminar) and speaking for at-risk youth groups(http://www.MotivationalMagicMaker.com), Rich is a father of twins - boy and girl. With all of his "spare" time, he makes original videos for you. Please subscribe and share with friends! Thanks for your support! We appreciate you liking and sharing our content so we can create and bring you more! If you have fun ideas, reach out anytime. We want to hear it! Lastly, people often ask where Rich lives and film his pranks. San Luis Obispo, CA: https://www.youtube.com/watch?v=-V7Mjl2f8ZE
Views: 4720199 Rich Ferguson
Excel 2010 Magic Trick 789: Extract Records That Match Criteria for Multiple Reports Across Sheets
 
17:43
Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm 1. See how to create Multiple Reports On Multiple Sheets That Extract Records That Match Criteria and displays records that come from rows in columns. 2. Excel 2010 Solution. 3. See the functions: AGGREGATE, IFFERROR, INDEX, MATCH, ROW, COLUMNS, TRANSPOSE. 4. See how to Copy Sheets with Keyboard Mouse Trick. 5. See solution for both Excel 2010 and 2007 and 2003.
Views: 252783 ExcelIsFun
Excel Magic Trick #193: Grade Book Based on Total Score
 
04:58
Use the SUM and VLOOKUP functions to create a Grade Book Based on Total Score that will calculate grade for you automatically. VLOOKUP function information. Formulas for Grades. Excel Lookup Series
Views: 15961 ExcelIsFun
7 Magic Tricks with Pencils
 
10:32
How To Pencil Magic Tricks! In this episode of How To Magic, Evan Era from EvanEraTV shows 7 Magic Tricks with Pencils! Easy pencil magic tricks for kids, beginners, and all ages! Family friendly fun magic trick tutorials with step by step instructions for each trick explanation! All secrets revealed! If you're new to the channel remember to hit that SUBSCRIBE button and welcome to the family! Until next time, remember that anything is possible as long as you stay positive, work hard, and [email protected] my friends! :) SUBSCRIBE - http://bit.ly/SubToEvan MY VLOGS - http://bit.ly/EvanVlogs SEND MAIL TO: PO BOX 943 Crestwood KY 40014 SHOP HERE - http://www.EvanEraTV.com EMAIL: [email protected] SNAPCHAT: http://bit.ly/SnapchatEvan TWITTER: http://www.twitter.com/EvnEra FACEBOOK: http://www.facebook.com/EvanEraTV INSTAGRAM: http://www.instagram.com/EvanRosenman Pencil Magic Tricks Revealed in this Video: 1.) Magic Pencil Thru Finger Trick - 0:35 2.) Floating Pencil Magic Trick Revealed - 1:36 3.) Magic Pencil Thru Coin Trick - 2:48 4.) Pencils Thru Bag of Water Trick - 3:57 5.) Magic Number 2 Spades Pencil Trick - 4:40 6.) Crazy Magic Rubber Pencil Illusion - 5:45 7.) Pencil Index Card Break Challenge - 6:32 GOOD LUCK in the FREE MAGIC PENCIL GIVEAWAY!! More Magic Tricks Here: http://bit.ly/2trm6yC #EvanEra #EvanEraTV #HowToMagic #eraSQUAD #LaughAtLife [email protected] This channel provides awesome content in the form of magic, pranks, and other cool videos - SUBSCRIBE for weekly uploads!! :) More Videos Here: http://www.youtube.com/EvanEraTV
Views: 1973122 EvanEraTV
Learn Easy Magic from a Top Magician [5 eBooks]
 
07:38
Here is the link: http://bit.ly/LearnEasyMagicEbooks The Books: That's 243 pages of magic! You won't find THAT in any bookstore! (Available in digital format for download only!) All FOUR eBooks plus the Special Bonus will be instantly downloaded for you to keep. Your Learn Easy Magic download will be delivered via the ClickBank web site AND by email! Bryan Dean, Professional Magician P.S. — You'll be amazed at how simple and easy it is to start learning magic now with Learn Easy Magic. You won’t need a huge amount of time to learn magic when you let me, Bryan Dean, show you my secrets... completely at my risk! "Learning magic isn't easy... there's just too much information out there these days. And, it's mighty expensive — just ONE trick could cost hundreds of dollars alone! "This 'Learn Easy Magic' collection from Bryan Dean is probably one of the BEST ways for anyone to learn some truly AMAZING magic tricks. They are easy-to-do, fun and entertaining. "And, this set covers it all: cards, money magic, ESP/mental magic and magic with ordinary objects. And, it's really great magic, too! (This isn't the stuff you get in your local bookstore or at online magic shops -- this is PERFECT for the beginning magician or someone who just wants to learn a few tricks to show off! "I have a magic book collection numbering in the hundreds. And, I am proud to add this 'Learn Easy Magic' set of ebooks to my library! Great job, Bryan... and thanks!" — John Cassidy, Professional Magician/Comedian Search results for: magic tricks magic tricks revealed magic tricks with cards magic trick gone wrong magic tricks explained magic trick videos magic tricks with coins magic trick thumper magic tricks easy magic tricks for sale magic trick with cards magic trick revealed magic trick store magic trick for kids magic trick out to lunch magic trick secrets magic trick gif magic trick apps magic trick accident magic trick answers magic trick apps for iphone magic trick at wedding magic trick america's got talent magic trick app for android magic trick agt magic trick at home magic trick at theatre row a magic trick with cards a magic trick reddit a magic trick candy crush a magic trick with a pencil a magic trick with your hands a magic trick with paper a magic trick with a coin a magic trick with numbers a magic trick gone wrong a magic trick that is easy magic trick books magic trick box magic trick bird magic trick bank magic trick band magic trick bank deck magic trick ball magic trick britain's got talent magic trick bird revealed magic trick bag b'wave magic trick b'wave magic trick revealed magic trick cards magic trick center tear magic trick cut in half magic trick coin magic trick card decks magic trick card index magic trick coin turtle magic trick carrot magic trick costume magic trick cop magic tricks c magic trick death magic trick decks magic trick definition magic trick disappear magic trick dabba magic trick dog magic trick dollar bill in lemon magic trick drawing prediction magic trick draw picture magic trick deck of cards how to do magic tricks magic trick force magic trick for beginners magic trick flip off magic trick floating card magic trick floating body magic trick floating table magic trick flowers magic trick for sale g sharp magic trick imagine by g magic trick revealed magic h card trick i learn magic tricks i phone magic tricks i cube magic trick i learn magic tricks for free i want learn magic tricks l magic tricks q and a magic trick magic trick reviews magic trick rings magic trick rabbit magic trick rope magic trick rubik's cube magic trick reddit magic trick rubber band magic trick revealed youtube magic trick rising card r/magic tricks toys r us magic tricks key r rect magic trick magic trick stores near me magic trick set magic trick show magic trick supplies magic trick song magic trick scarf magic trick sayings magic trick secrets revealed marvin's magic tricks s.s.s magic trick revealed grandpa's magic trick magic trick turtle magic trick tutorials magic trick tv shows magic trick toys magic trick to music magic trick terms magic trick theater row magic trick teacher magic trick thumb magic tricks youtube u-235 magic trick u-235 magic trick by thayer / viking u turn magic trick revealed youtube magic tricks revealed u and i magic trick magic tricks you can do at home u and i together magic trick youtube card magic tricks magic tricks 4u magic trick videos on youtube magic trick videos revealed magic trick video download magic vs trick
Views: 238 Learn Magic Tricks
Card Magic Tricks That Work By Themselves : Great Books to Learn Card Magic Tricks
 
01:34
Learn about Great Books to Learn Card Magic Tricks from in this free magic lesson video. Expert: Malik Haddadi Contact: www.malikthemagicguy.com Bio: Malik Haddadi is a magical comedy entertainer, balloon artist, and juggler with over 15 years experience.
Views: 14306 expertvillage
Excel Magic Trick 1110: Compare 2 Lists and Extract Records: Array Formula Method
 
12:58
Download Excel File: http://people.highline.edu/mgirvin/ExcelIsFun.htm See how to compare two lists and extract records with an array formula that uses these functions: MATCH, ISNA, ISNUMBER, IF, ROWS, ROW, INDEX, AGGREGATE and a number of array operations.
Views: 24303 ExcelIsFun
DIY MAGIC CARD. HOW TO MAKE MAGIC CARD.
 
05:48
Diy magic card (tutorial). How to make magic card (magic slider card). Handmade greeting card making ideas. Diy cards. Gift ideas. This creative card (handmade card) can be made for any holiday: Valentine's Day card (Valentine card), Mother's Day card, Father's Day card, Birthday card, Teachers Day card, Christmas card, card for boyfriend, card for girlfriend, card for best friend, card for mom, card for dad, card for scrapbook, card for explosion box, card for gift box... ***** ALL VIDEOS - IDEA OF THE DAY ↔ https://www.youtube.com/playlist?list=PLEC0z_NR7SGn1qIOvh7HoLPiCJandEYOL SUBSCRIBE ON NEW VIDEOS ↔ https://www.youtube.com/c/IDEAOFTHEDAY?sub_confirmation=1 ***** ↓ ↓ ↓ LOOK MY OTHER VIDEOS ↓ ↓ ↓ NEVER ENDING CARD - NEW SUPER EASY TUTORIAL https://youtu.be/HETTNsVx-LM ENDLESS CARD (ORIGAMI CARD) https://youtu.be/tWCX46g2Dps VALENTINE'S DAY CARD (VALENTINE CARD) https://youtu.be/PdAgVwbBiow LOVE SLIDER CARD https://youtu.be/Dk9ewakXg_E SPINNER CARD https://youtu.be/cD8UJiGnTcw WATERFALL CARD https://youtu.be/e81VoIErcUY MAGIC DOUBLE SLIDER CARD https://youtu.be/l6cZqopW-K4 POP UP CARD (TWIST & POP CARD) https://youtu.be/2oBkXmtGRSw CARD WITH DISAPPEARING MESSAGE (SECRET MESSAGE CARD) https://youtu.be/77qu-Az-dio SQUASH CARD (ACCORDION CARD) https://youtu.be/NmWsc48qJY4 DIY 3D FLOWER POP UP CARD https://youtu.be/TWOdlDD1Lo4 HEXAFLEXAGON ENDLESS CARD https://youtu.be/bakSg4lo6xw LOVE CARD INTERLOCKING HEARTS https://youtu.be/MeKM8qZmFKc 3D HEART POP UP CARD (RAINBOW HEART CARD) https://youtu.be/ugD3SRcIrzA
Views: 10901332 IDEA OF THE DAY
Excel Magic Trick 1145: Create Random Data Set with Formulas: 4 Unusual Formulas
 
14:02
Download Excel File: http://people.highline.edu/mgirvin/ExcelIsFun.htm See how to: 1) (00:08 min mark) Overview of Different data Types 2) (01:02 min mark) FORMULA 1: Create Random Serial Number Dates with RANDBETWEEN and actual Serial Numbers 3) (02:10 min mark) Keyboards to Copy Formulas down 2000 rows quickly: Ctrl + C, F5, Type address, Shift + Enter, Ctrl + V 4) (03:30 min mark) FORMULA 2: Create ISO Dates from Serial Numbers using the functions: YEAR, TEXT, MONTH, DAY. Also see Custom Number Format to show Leading Zeros. 5) (05:46 min mark) Paste Special Values with Right-Click Mouse Trick 6) (06:18 min mark) FORMULA 3: Formula to create random Numbers From Two Different Distributions (Uniform and Normal) using the functions: CHOOSE, RANDBETWEEN, ROUND, NORM.INV and RAND. 7) (10:18 min mark) FORMULA 4: Select Random Names from two separate lists that contain First and Last names. See the INDEX function and a Join Array Operation in the array argument of the INDEX function that does not require Ctrl + Shift + Enter. See the functions, INDEX and RANDBETWEEN. 8) (13:21 min mark) Screen Tip for Negative Dates / Times 9) (13:48 min mark) Add Text Number Format to ISO Dates.
Views: 10767 ExcelIsFun
Excel Magic Trick 1063: Pull Student Grades From Many Sheets onto Summary Table Excel Grade Book
 
18:38
Download Excel File: http://people.highline.edu/mgirvin/ExcelIsFun.htm See this multiple step project to create this Excel Grade Book Uses VLOOKUP, INDIRECT and INDEX functions: 1. (00:15 min) Goal of video: Master Name Sheet will contains names of students. Assignment sheets will contain scores for each assignment or section of the class. Summary Table will pull students data from each sheet. 2. (01:50 min) Drill Through many Sheets to add a formula on each assignment sheet that will pick up new students added to the Master Name Sheet. Use the IF function and a Null Text String to check for cells with no student name. 3. (04:17 min) Create Dynamic Range Formula using INDEX and MATCH and "looking up last Text Entry in Column" or "Big Text" formula trick, and then paste name into Name Manager to create a Defined Name Dynamic Range Formula. 4. (09:10 min) Use Defined Name Dynamic Range Formula for a Data Validation Drop Down List in a cell on the Summary Table. 5. (09:47 min) Create MATCH formula to lookup last row for student assignment data. 6. (12:16 min) Create INDIRECT Formula that will create a different sheet reference for each row in the summary table. In essence, the INDIRECT function that uses the Ampersand and Mixed Cell References and Absolute Cell References will create a different lookup table for the VLOOKUP function for each row in the summary table based on the sheet name that comes from each row header at the head of each row in the summary table. 7. (15:06 min) VLOOKUP to lookup the scores from each assignment sheet for the selected student. 8. (17:07 min)Test it by adding a new Student name in the Master Name Sheet.
Views: 23323 ExcelIsFun
Excel Magic Trick #194: Grade Book Based on Percentages
 
10:16
Use the SUM, VLOOKUP and ROUND functions to create a Grade Book Based on Percentage Scores that will calculate grade for you automatically. See how the VLOOKUP and the Percentage format can deliver the wrong Grade when you dont use the Round Function. VLOOKUP function information. ROUND function Formulas for Grades. Excel Lookup Series
Views: 136248 ExcelIsFun
Phoenix Deck Large Index - USA Magic Tricks
 
01:48
Get it here https://usamagictricks.com/product_info.php?products_id=41323&osCsid=f721d4f5bee78442cb8a81f1f32b57ec
Views: 19 Angela Caraballo
Excel Magic Trick 714: Three Criteria Lookup Adding SUMIF, INDEX, MATCH, SUMPRODUCT (2 examples)
 
08:13
See how to lookup and then add values with three criteria using 2 methods: 1. Add helper column that joins two criteria, SUMIF function, Ampersand to join criteria, INDEX and MATCH function to retrieve entire column of values (3rd criteria). 2. SUMPRODUCT and joining columns and matching joined criteria and , INDEX and MATCH function to retrieve entire column of values. Download file: http://people.highline.edu/mgirvin/ExcelIsFun.htm
Views: 94071 ExcelIsFun
Excel Magic Trick 1304: List Text Modes in Single Cell TEXTJOIN, INDEX, N, IF, MATCH & MODE.MULT
 
06:14
Download File: http://people.highline.edu/mgirvin/excelisfun.htm Learn how to create an array formula to show a sorted list of modes in a single cell. Learn how to get INDEX function to deliver an array of items using the formula element: N(IF(1,Array)). Thanks to Bill Szysz and XLarium at YouTube and to this amazing blog: https://excelxor.com/2014/09/05/index-returning-an-array-of-values/
Views: 4943 ExcelIsFun
Excel Magic Trick 319: VLOOKUP - Lookup Table In Descending Order Use INDEX & MATCH
 
06:13
See how to do VLOOKUP in reverse order using the INDEX & MATCH functions and Custom Number Formatting. We will sort out first column in Descending order and then MATCH and INDEX will look for the smallest value that is greater than or equal to the lookup value. This is different than the VLOOKUP which looks for the greatest value that is less than or equal to the lookup value. We will see the MATCH function 3rd argument as -1 as an approximate match.
Views: 19390 ExcelIsFun
Excel Magic Trick 1305: Adding Multiple Two-Way Lookups INDEX function & N(IF(1,Array) Trick
 
07:12
Download File: http://people.highline.edu/mgirvin/excelisfun.htm Learn how to perform multiple two-way lookups for a cross tabulated table to get multiple sales numbers and then add them using an array formula. Learn how to get INDEX function to deliver an Array of Items using N(IF(1,Array) Trick. Thanks to Bill Szysz and XLarium at YouTube and to this amazing blog: https://excelxor.com/2014/09/05/index-returning-an-array-of-values/ See how to get INDEX to return an array of values INDEX function to deliver an Array of Items using N(IF(1,Array) Trick
Views: 6045 ExcelIsFun
Excel Magic Trick 1259: Can VLOOKUP Lookup Duplicates? Yes! Helper Column or Array Formula?
 
08:02
Download File: http://people.highline.edu/mgirvin/excelisfun.htm Learn how to use two lookup values to lookup an item in a table: 1. (00:11) Problem Introduction and discussion of default behavior for VLOOKUP for Exact Match. 2. (01:00) Helper Colum Solution with Joined Values to create Unique Identifier in First Column. VLOOKUP and Joined Lookup-Value. 3. (03:01) Single Cell Array Formula with INDEX and MATCH functions and an array operation using the join symbol. Array Formula that requires Ctrl + Shift + Enter. 4. Array Formula that does NOT requires Ctrl + Shift + Enter. Using INDEX array argument to avoid Ctrl + Shift + Enter.
Views: 29400 ExcelIsFun
Excel Magic Trick 1491: “Lookup Latest Product Price” Survey Results, Winner of Free Book
 
04:03
Survey Results for “Lookup Latest Product Price” Winner of Free Book Other Related Videos: Excel Magic Trick 1483: LOOKUP Array Formula: Lookup Correct Price Based on Effective Date Excel Magic Trick 1484: LOOKUP & Sorted Helper Column: Lookup Price Based on Effective Date Excel Magic Trick 1485: SUMIFS & MAXIFS Functions: Lookup Correct Price Based on Effective Date Excel Magic Trick 1486: VLOOKUP, MAXIFS, & Key: Lookup Correct Price Based on Effective Date Excel Magic Trick 1487: INDEX, MATCH & MAXIFS : Lookup Correct Price Based on Effective Date Excel Magic Trick 1488: Vote For Favorite Formula to Lookup Correct Price Based on Effective Date
Views: 3581 ExcelIsFun
Excel Magic Trick 358: Part 1: Return Multiple Items From One Lookup Value for Table w Formula
 
12:43
Duplicate Lookup or Lookup 1 value, return many for a table Part 1. Return winning bets for week from a football betting database. See a formula that will return multiple items when there are two criteria for the data extraction. See an INDEX and MATCH functions formula that uses SUMPRODUCT, COUNTIFS, IF, ROWS, INDEX, MATCH, SMALL, IF, and ROW functions. This is a data extract with 2 criteria using a formula solution. Return Multiple Items From One Lookup Value. Related Videos: Excel Magic Trick 359: Part 2: Return Multiple Items From One Lookup Value for Column, Excel Magic Trick 360: Part 3: Return Multiple Items From One Lookup Value for Row List Winning Bets With Array Formula
Views: 299152 ExcelIsFun
Excel Magic Trick 1056: Excel 2013 Slicer Formulas
 
12:45
Download Excel File: http://people.highline.edu/mgirvin/ExcelIsFun.htm See how to add Slicers to Excel 2013 Tables and then: 1. Slicers for Total Row to calculate MIN value for two criteria 2. Slicers for SUBTOTAL function to calculate MIN value for two criteria 3. Slicers for AGGREGATE function to calculate MIN value for two criteria 4. SUMPRODUCT, SUBTOTAL and OFFSET Function to create formula to multiply filtered columns based on Slicer Criteria
Views: 48196 ExcelIsFun
Excel Magic Trick 1100: Cross Tabulated Lookup: 1) Lookup Row then match or 2) Array Multiplication?
 
14:11
Download Excel File: http://people.highline.edu/mgirvin/ExcelIsFun.htm See Two Methods that can return a "Yes" when a Two Way Lookup based on a Column Header and Row Header must lookup items from a second table that presents Dimension (row / column size) Problems (01:59 min) 1. Method 1: INDEX to lookup a row based on a column header that can then be matched against a row header. See the functions: INDEX, MATCH, ISNUMBER and IF. Learn about array syntax. Learn that although the evaluated INDEX function looks like it returns an array, it actually returns a range that the MATCH function can understand. (08:09 min) 2. Method 2: Array Comparative Operation and Array Multiplication. See the functions SUMPRODUCT and IF. Learn about array syntax. Lookup based on row and column headers. Two Way Lookup.
Views: 16013 ExcelIsFun
Excel Magic Trick 1311: Return Multiple Items from One Lookup Value & Show Total for Invoice Items
 
07:11
Download File: http://people.highline.edu/mgirvin/excelisfun.htm See an Array Formula that can extract (from a proper data set) multiple invoice items for one lookup value & show total. See the functions: COUNTIFS, ROW, AGGREGATE, ROWS, INDEX, IF and SUMIFS. See a number of Array Operations in the formula. Learn how AGGREGATE function can handle array operations without using Ctrl + Shift + Enter
Views: 38548 ExcelIsFun
Excel Magic Trick 186 Dynamic Formula Extract Data 2 criteria
 
11:05
This formula will extract records that meet two conditions (criteria) and list them in order with no extra rows between records. Create a formula to extract part of a table from a larger table based on two criteria. Similar to a query in Access, but with a array formula in Excel that uses the functions: IF, ROWS, INDIRECT, COUNTIF, INDEX, SMALL, and ROW. Related Videos: Excel Magic Trick #180: COUNTIF function formula 21 Examples 05 Excel Series: Array Formulas 1-14 Various INDEX Lookup w TRUE/FALSE criteria "Reverse Lookup" Excel Magic Trick 185 Dynamic Formula Extract Data 1 criteria 04 Excel Series: Names 1-12 Excel Magic Trick #187: Unique List w Dynamic Formula Excel Magic Trick #81: Advanced Filter AND OR Data Extract
Views: 97688 ExcelIsFun
Index Card Tricks
 
00:23
Magic tricks by Mon Abram Siojo. Published on dec. 29 2016
Views: 40 Mark Anthony Siojo
10 EASY MAGIC TRICKS ANYONE CAN DO HINDI/URDU
 
04:55
You can impress your friends with really easy magic tricks.learn them in hindi/urdu. For copyright matters please contact us at: [email protected] These tricks include classics like card tricks, making a coin disappear or bending a paperclip with your mind. What’s more, most of these simple and easy magic tricks only take a few minutes to learn. ☀ Subscribfor more http://youtube.com/pointplaypk ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ☀ If you found this video valuable, give it a ❤ like. ☀ If you know someone who needs to see it, share it. ☀ Leave a comment below with your thoughts. ☀ Add it to a playlist if you want to watch it later. Featuring... Turn paper into cash magic trick - Magic always looks more impressive with fire. The levitating card trick - the levitating card trick is another very easy piece of magic. The disappearing crayons - Disappearing coin trick - This is one of a host of classic coin tricks you’ve probably seen a version of dozens of times before. Disappearing match trick - Disappearing coin trick off table - Some more coin trickery now. Magic liquid through a plastic cup trick - This is another trick that requires a little bit of advance preparation. Wine glass and coin trick - This is another perennial favourite of magicians the world over. Signed card trick - We’ve been light on card tricks thus far, so let’s address that issue right now. For this trick you’ll need a deck of cards, a marker and a see-through bag. Breaking a pencil with an index card - This is another really simple trick that you can do with a regular old pencil and an index card. The torn corner card trick - Bend a paperclip with your mind - Bending a paperclip with your mind is not as difficult as it sounds. Magic chalk powder - For this you’ll need some chalk and an assistant's hands, preferably attached to their body. Disappearing ring - Ever wanted to make a ring disappear? Magic slap card trick - Now we’re going back to card tricks. Get your assistant to pick a card. Any card. Look at it and put it back anywhere in the deck. Anti-gravity ring - Now we’re going to do something really cool. Levitating money trick - With this trick it appears that all you're doing is taking a standard note and folding it. Disappearing foil coin trick - This is a delightfully simple trick that looks wonderful if pulled off correctly. Take a coin and a piece of paper. Torn and Restored Dollar Bill Trick Revealed - Now we’re going to destroy some money, well, not really. We are sure that at least once you have tried to impress your friends or family with some incredible trick. But for some strange reason, they don't usually appreciate this kind of fun and laugh at you as soon as you finish. What do you think, why does this happen? It is probably because of your lack of skills or imagination... But hey, the reason doesn't matter. Anyway, we thought that we could teach our beloved spectators some simple and fabulous tricks. Are you ready for some magic? Here are 10 simple tricks that everyone can do at home. We are sure that at least once you have tried to impress your friends or family with some incredible trick.. Anyway, we thought that we could teach our beloved spectators some simple and fabulous tricks. Are you ready for some magic? Here are 10 simple tricks that everyone can do at home. We are sure that at least once you have tried to impress your friends or family with some incredible trick. But for some strange reason, they don't usually appreciate this kind of fun and laugh at you as soon as you finish. What do you think, why does this happen? It is probably because of your lack of skills or imagination... But hey, the reason doesn't matter. Anyway, we thought that we could teach our beloved spectators some simple and fabulous tricks. Are you ready for some magic? Here are 10 simple tricks that everyone can do at home. We are sure that at least once you have tried to impress your friends or family with some incredible trick. But for some strange reason, they don't usually appreciate this kind of fun and laugh at you as soon as you finish. What do you think, why does this happen? It is probably because of your lack of skills or imagination... ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ Social Handles ☀ Twitter : https://twitter.com/PointPlayPK ☀ Pinterest : https://www.pinterest.com/PointPlayPK ☀ Facebook : http://facebook.com/pointplayyoutube/ ☀ Instagram : https://www.instagram.com/PointPlayPK ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ✦ ☀ Visit Us https://www.tumblr.com/blog/playpoint ☀ Visit Our Blog : http://pointplaypk.blogspot.com/ ☀ Visit Our Website : http://pointplaysite.wordpress.com ☀ Visit Our Reddit : https://www.reddit.com/user/pointplay/
Views: 1584239 iArslan
Excel Magic Trick 741: Avoid Errors & Blanks In Chart Using Formulas & Defined Name Dynamic Ranges
 
14:31
Download file: http://people.highline.edu/mgirvin/ See how to use Formulas & Defined Name Dynamic Ranges to avoid errors and blanks in a column chart. See INDEX function to create Defined Name Dynamic Range (different than OFFSET function) and an array formula that extracts data that is not an error or blank. See the functions: SUMPRODUCT, ISNUMBER, IF, ROWS, INDEX, SMALL, ROW AND Excel 2010 AGGREGATE FUNCTIONS.
Views: 18963 ExcelIsFun
Excel Magic Trick 1205: Rearrange Data with INDEX Function & Formula Number Incrementers
 
11:27
Download File: http://people.highline.edu/mgirvin/excelisfun.htm See how to Rearrange Data With INDEX Function & Formula Number Incrementers: 1. () Problem Setup. 2. (01:57) Formula Number Incrementer to generate the pattern: 1,1,2,2,3,3… or 1,1,1,2,2,2,3,3,3… 3. (04:23) Formula Number Incrementer to generate the pattern: 1,2,1,2,1,2… or 1,2,3,1,2,3,1,2,3… 4. (05:40) How to use INDEX and Formula Number Incrementers to rearrange data from a two way table. 5. (07:03) How to use INDEX and Formula Number Incrementers to rearrange data from a two separate columns. 6. (11:03) Summary “Formula Number Incrementers” or “Formulas for Sequential Numbers” or
Views: 11005 ExcelIsFun
Excel Magic Trick 923: Recorded Macro Basics: Click Button To Move Data To Table On Another Sheet
 
13:34
Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm See how to: 1. Enter Data On One Sheet and then click Button To Send Data To Table on Second Sheet 2. Recorded Macro: Move Record From Data Entry Sheet To Table On Second Sheet 3. Learn how to Show Developer Ribbon (Excel 2010 = Right-click Ribbon, Customize Ribbon, Checkbox for Developer Ribbon) 4. Keyboard: Alt + F8 = List of Macros 5. Keyboard: Alt + F11 = VBA Editor 6. Learn how to use Absolute and Relative References in Recorded Macro 7. Add Form Button To Sheet that can be clicked to execute recorded Macro. 8. Absolute References = Selecting Cells with Macro Recorder on means Absolute Movement 9. Relative References = Selecting Cells with Macro Recorder on means Relative Movement 10. View Code: Range function for Absolute References, OFFSET Function for Relative References
Views: 354274 ExcelIsFun
Excel Magic Trick 1325: MIN & MAX Functions For Alphanumeric / Text Values Report (8 Examples)
 
31:55
Download File: http://people.highline.edu/mgirvin/excelisfun.htm See how to create a report that require that we find the MIN and MAX Alphanumeric Academic Quarters for each Student ID. See eight different methods including: 1) VLOOKUP, 2) MIN & IF Array Formula, 3) AGGREGATE function, 4) MINIFS function, 5) MIN & IF & MATCH non-Helper Column Array Formula, 6) Access Query, 7) Power Query, 8) SQL: (00:17) Introduction To Problem of finding MIN & MAX Alphanumeric/Text Values 1. (01:42) VLOOKUP: 1) No Helper Column & 2) Columns Sorted (Any Version of Excel) 2. (05:35) MIN/MAX & IF Array Formula with INDEX & MATCH Helper Column: 1) Helper Column Okay & 2) Columns Not Sorted (Any Version of Excel) 3. (11:37) AGGREGATE Array Formula with INDEX & MATCH Helper Column: 1) Helper Column Okay & 2) Columns Not Sorted (Excel 2010 or later) 4. (11:53) MINIFS/MAXIFS, INDEX & MATCH Helper Column: 1) Helper Column Okay & 2) Columns Not Sorted (Excel 2016 or later) 5. (12:18) Excel Lookup Array Formula MIN/MAX & IF & MATCH Array Formula: 1) No Helper Column & 2) Columns Not Sorted (Any Version of Excel) 6. (17:22) Access Query made in Design View, then Import into Excel. MIN and MAX functions can handle Alphanumeric/Text Values. (Any Version) 7. (21:51) Power Query (Get & Transform). MIN and MAX functions can handle Alphanumeric/Text Values. See Group By feature and Add Custom Column Feature. (Excel 2010, 2013, 2016). 8. (27:02) SQL in MS Query Data Import feature. MIN and MAX functions can handle Alphanumeric/Text Values. (Any Version) (30:48) Summary
Views: 6499 ExcelIsFun
Excel Magic Trick 1483: LOOKUP Array Formula: Lookup Correct Price Based on Effective Date
 
13:35
Download Files: Start Excel File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1483-1487.xlsx Entire page with all Excel Files for All Videos: http://people.highline.edu/mgirvin/excelisfun.htm In this video learn how to Lookup the correct product price based on the latest Effective Date. The Lookup table has multiple listings of the product, each with a different effective date and price. In this video learn about how to use the LOOKUP Function in an Array Formula. Other Related Videos: Excel Magic Trick 1483: LOOKUP Array Formula: Lookup Correct Price Based on Effective Date Excel Magic Trick 1484: LOOKUP & Sorted Helper Column: Lookup Price Based on Effective Date Excel Magic Trick 1485: SUMIFS & MAXIFS Functions: Lookup Correct Price Based on Effective Date Excel Magic Trick 1486: VLOOKUP, MAXIFS, & Key: Lookup Correct Price Based on Effective Date Excel Magic Trick 1487: INDEX, MATCH & MAXIFS : Lookup Correct Price Based on Effective Date Excel Magic Trick 1488: Vote For Favorite Formula to Lookup Correct Price Based on Effective Date
Views: 5871 ExcelIsFun
30 EASY MAGIC TRICKS
 
10:07
Timestamps: 00:27 DIY compass using a magnet 01:46 Flying cup 04:33 Wonderful coin trick 06:31 DIY colorful flowers 08:43 Cool candle trick Our Social Media: 5-Minute Crafts: https://www.goo.gl/8JVmuC Facebook: https://www.facebook.com/5Minute.Craf... Instagram: https://www.instagram.com/5.min.crafts/ Twitter: https://twitter.com/5m_crafts 5-Minute Crafts KIDS: https://goo.gl/PEuLVt 5-Minute Crafts GIRLY: https://goo.gl/fWbJqz The Bright Side of Youtube: https://goo.gl/rQTJZz Music: There You Go by Audionautix is licensed under a Creative Commons Attribution license (https://creativecommons.org/licenses/by/4.0/) Artist: http://audionautix.com/ In Motion by Audionautix is licensed under a Creative Commons Attribution license (https://creativecommons.org/licenses/by/4.0/) Artist: http://audionautix.com/ Inner Journey by Audionautix is licensed under a Creative Commons Attribution license (https://creativecommons.org/licenses/by/4.0/) Artist: http://audionautix.com/ Destiny Day by Kevin MacLeod is licensed under a Creative Commons Attribution license (https://creativecommons.org/licenses/by/4.0/) Source: http://incompetech.com/music/royalty-free/index.html?isrc=USUAN1500008 Artist: http://incompetech.com/
Views: 11332 5-MINUTE MAGIC
Excel Magic Trick 1016: Randomly Do A Two Way Lookup INDEX, VLOOKUP and RANDBETWEEN
 
04:03
Download Excel File: http://people.highline.edu/mgirvin/ExcelIsFun.htm See how to randomly do a two way lookup: 1. INDEX and RANDBETWEEN 2. VLOOKUP and RANDBETWEEN 3. 5 ways to do Paste Special Values
Views: 3828 ExcelIsFun
Excel Magic Trick 1137: Excel & PowerPivot DAX Formula: Approximate Match Lookup Without VLOOKUP
 
12:23
Download Excel File: http://people.highline.edu/mgirvin/ExcelIsFun.htm See how to 1) (00:08 min) Intro. 2) (01:21 min) Approximate Match with VLOOKUP. 3) (02:20 min) Approximate Match with AGGREGATE (to simulate logic that is present in DAX formula). 4) (05:11 min) Approximate Match Lookup in PowerPivot DAX using CALCULATE, MAX, FILTER and Boolean Logic.
Views: 23333 ExcelIsFun
Excel Magic Trick 1226: Compare 2 Lists, Extract Items In List 2 That are NOT in List 1 (6 Examples)
 
22:32
Download File: http://people.highline.edu/mgirvin/excelisfun.htm Learn how to Compare 2 Lists, Extract Items In List 2 That are NOT in List 1: 1. (00:12) Problem Description and Intro To Topic 2. (01:57) Example 1: Method 1: MATCH function Helper Column, Sort Z to A, Copy and Paste 3. (04:15) Example 2: Method 2: Advanced Filter and Criteria Area with Empty Field Name and Logical Formula Criteria 4. (07:59) Example 3: Method 3: Automat Process with Excel 2010 or later Array Formula. See the Functions: IF, ROWS, ROW, MATCH, ISNA, INDEX, AGGREGATE, SUMPRODUCT. This Array Formula does not require Ctrl + Shift + Enter. 5. (15:29) Why you should NOT use IFERROR on Data Extract Array Formulas 6. (17:17) Example 4: Method 3: Automat Process with Excel 2007 or before Array Formula. See the Functions: IF, ROWS, ROW, MATCH, ISNA, INDEX, SMALL, SUMPRODUCT. This Array Formula DOES require Ctrl + Shift + Enter. 7. (18:25) Example 5: Method 2: Extract E-mails in List 1 that are NOT in List 2. 8. (19:35) Caveat about Advanced Filter: Be sure to NOT have data below Extract Area (because it will be deleted when you run Advance d Filter. 9. (20:24) Example 6: How to Extract Items that are in BOTH lists: Learn how to slight change the formula for all three methods. Use ISNUMBER rather than ISNA. Related Videos for Comparing Two Lists and Extracting Records: Other Excel Methods for Comparing Two Lists: Excel Magic Trick 1226: Compare 2 Lists, Extract Items In List 2 That are NOT in List 1 (6 Examples) https://www.youtube.com/watch?v=9h1omv60MCA Excel Magic Trick 1229 Extract Items NOT in List 1: Conditional Format Unique Values & Sort by Color https://www.youtube.com/watch?v=E3_vMI3LjJU Excel Magic Trick 1441: Power Query to Extract Items In List 1 That Are NOT In List 2 https://www.youtube.com/watch?v=JztEKJ-XkCU Excel Magic Trick 1442: DAX Query & EXCEPT Function to Extract Items In List 1 That Are NOT In List 2 https://www.youtube.com/watch?v=lLMXFLr9Aeg
Views: 43938 ExcelIsFun
Excel Magic Trick 1382: Extract Records With Multiple Contains (Partial Text) Criteria: 4 Examples
 
38:13
Download File: http://people.highline.edu/mgirvin/excelisfun.htm See how to: 1. (00:15) Introduction to Contains Criteria (Partial Text Criteria) in an OR Logical Test, when search for records with Multiple Contains Criteria. 2. (02:00) #1 Filter & Helper Column with Formula that uses OR, ISNUMBER & SEARCH functions. This Array Formula requires Ctrl + Shift + Enter. 3. (07:23) #2 Filter & Helper Column with Formula that uses ISNUMBER, LOOKUP & SEARCH functions. This Array Formula does NOT require Ctrl + Shift + Enter. 4. (12:11) #3 Easiest solution: Advanced Filter with Formula Criteria, where formula uses LOOKUP & SEARCH functions. This Array Formula does NOT require Ctrl + Shift + Enter. 5. (15:56) #4: Array formula #1 to count matching records using an OR Logical Test with Multiple Contains Criteria. Use SEARCH function with two different size Function Argument Array Operations that require that we flip one of the ranges using the TRANSPOSE Array Function. Also see the functions: ISNUMBER, MMULT, ROW and SUM. This Array Formula requires Ctrl + Shift + Enter. 6. (21:45) Introduction to Matrix Multiplication, the Excel MMULT Array Function and detailed explanation of the mechanics of how it works in Array Formula to add all the numbers for each row in a two-way array and produce a single column of totals. This Array Function requires Ctrl + Shift + Enter. 7. (30:18) #4: Array formula #2 to extract records. See the functions: SEARCH, TRANSPOSE, ISNUMBER, MMULT, ROW, IF, ROWS, INDEX and SMALL. This Array Formula requires Ctrl + Shift + Enter. 8. (36:52) Test Array Formulas when source data changes. 9. (37:39) Summary. Match Job Title to List of Key Words Reference Video: Excel Magic Trick 1383: Conditional Format Row w OR Logical Test with Multiple Partial Text Criteria
Views: 23151 ExcelIsFun
Excel Magic Trick 984: Lookup Penultimate: Get Second To Last Item From Column Of Mixed Data
 
06:44
Download Excel File: http://people.highline.edu/mgirvin/ExcelIsFun.htm See Two Examples for getting the Second To Last Item From Column Of Mixed Data: 1) INDEX and LARGE functions with an array calculation (Requires Ctrl + Shift + Enter) 2) INDEX and AGGREGATE function with an array calculation (not require Ctrl + Shift + Enter)
Views: 5453 ExcelIsFun
Excel Magic Trick #117: Reverse 2-Way Lookup Part 1
 
09:16
Really Hard formula!!! See the functions, IF, INDEX, MATCH, SMALL, ROW, ROWS, COLUMN and COLUMNS all in one array formula. See how to do a Reverse 2-Way Lookup with a complex Array formula. See how to populate a list of names for patients with schedule book entries using this complex Array formula.
Views: 13488 ExcelIsFun
20 MAGIC TRICKS THAT WILL BLOW YOUR FRIENDS' MIND
 
15:59
Do you believe in magic? I surely do! This video will show you some of the most incredible magic tricks that you can easily perform yourself or even teach you friend! DIY lava Do you want to impress you friends with a glass full of lava? Mix water with a few drops of food dye, add any oil you prefer and drop in a pill of aspirin. You will get some real lava in a glass. Just do not forget about atmosphere and accessories. Decorate a place of your performance with some magical artifacts that you can make yourself. Wear a hat or a magic gown. Trust me, your friends will be truly amazed! Magic spinning card You can make a fascinating magic spinning card Kirigami from a simple sheet of paper? Cut the necessary lines from a sheet of paper. Now fold the paper correctly. For a greater effect use bright colorful paper. Your friends will be totally amazed by this card. Levitation bank note magic trick How to make your money fly? Pretty easy. Check it out in our video. You will simple need to attach small pieces of a drinking straw to the back of the bank note and poke an invisible thread through it. Done! Just don't forget to practice in front of the mirror for a while to look professional. Timestamps: 01:24 Cool coin trick 03:49 Magic trick with water 05:40 Bar bets you will always win 12:42 Levitating bank note 14:19 How strong paper actually yes Subscribe to our new channel 'SLICK SLIME SAM' - https://goo.gl/zarVZo Give a thumbs–up to see more adventures! Subscribe to 5-Minute Crafts: https://www.goo.gl/8JVmuC ---------------------------------------------------------------------------------------- Our Social Media: Facebook: https://www.facebook.com/5min.crafts/ Instagram: https://www.instagram.com/5.min.crafts/ The Bright Side of Youtube: https://goo.gl/rQTJZz SMART Youtube: https://goo.gl/JTfP6L ---------------------------------------------------------------------------------------- For more videos and articles visit: http://www.brightside.me/ Music: 1. Thingamajig by Audionautix is licensed under a Creative Commons Attribution license (https://creativecommons.org/licenses/by/4.0/) Artist: http://audionautix.com/ 2. Rhastafarian by Audionautix is licensed under a Creative Commons Attribution license (https://creativecommons.org/licenses/by/4.0/) Artist: http://audionautix.com/ 3. Essence 2 by Audionautix is licensed under a Creative Commons Attribution license (https://creativecommons.org/licenses/by/4.0/) Artist: http://audionautix.com/ 4. Green Leaves by Audionautix is licensed under a Creative Commons Attribution license (https://creativecommons.org/licenses/by/4.0/) Artist: http://audionautix.com/ 5. Pop Tune by Audionautix is licensed under a Creative Commons Attribution license (https://creativecommons.org/licenses/by/4.0/) Artist: http://audionautix.com/
Views: 32625446 5-Minute Crafts
Excel Magic Trick 1313: Array Formula to Create Sorted Unique List in Cell. HUGE Formula. TEXTJOIN.
 
20:54
Download File: http://people.highline.edu/mgirvin/excelisfun.htm Formula posted by Bill Szysz. Lean how to create an Array Formula to Create Sorted Unique List in Cell. This is a huge complicated formula that requires the Excel 2016 function TEXTJOIN. There are many interesting formula elements in a single array formula to do the near impossible. Here are the topics covered (different parts that go into the final single cell formula): 1. (00:09) Problem Introduction 2. (01:43) Array of All Relative Positions & FALSEs for Unique List: using MATCH, IF and ROW functions. This is Formula Element #1. 3. (04:36) Unique Count: using previous formula element inside COUNT function. This is Formula Element #3. 4. (05:03) Array of Sequential Numbers for Unique Count: using ROW function, INDIRECT function and previous formula element. In chapter 7 of the Ctrl + Shift + Enter book, this formula element is called “Dynamic Variable-Length Array of Sequential Numbers”. Learn about the difference between using “1:” (just a row reference) and “A1:A” (a range of cells reference) (trick from Bill Szysz) in this formula element. This is Formula Element #3. 5. (06:58) Array of All Relative Positions: using SMALL function, Formula Element #1 and Formula Element #2. This is Formula Element #4. 6. (08:13) Unique List: using INDEX function, N function, IF function and Formula Element #5. 7. (09:57) Ranks (How Many Equal To or Above): using Formula Element #5, TRANSPOSE Function, Comparative Operator (to help sort), MMULT function (to add rows and convert 9 by 9 array into a single column array with the dimensions 9 by 1), Formula Element #3, and an exponent of zero (to convert all numbers to one). This is a trick I first learned from Domenic at the Mr Excel Message Board. This is Formula Element #6. 8. (16:08) Sort Relative Positions of Rank: using: MATCH function, Formula Element #3 and Formula Element #6. This is Formula Element #7. 9. (18:07) Sorted Unique List: using INDEX function, Formula Element #5 (Unique List), Formula Element #7 (Sort Relative Positions of Rank), N function, IF function and TEXTJOIN function. This is the final formula. 10. (20:30) Summary, Closing Note.
Views: 6651 ExcelIsFun
Excel Magic Trick 1254: Lookup Item Where 2 Values Are Closest: Helper Column or Array Formula?
 
08:56
Download File: http://people.highline.edu/mgirvin/excelisfun.htm Learn how to create solution to lookup an item where two values are closets in value: 1. (00:10) Problem Introduction 2. (00:36) Helper Column Solution and two cell formulas using ABS, MIN and INDEX & MATCH functions. 3. (03:15) Single Cell Formula using ABS, MIN and INDEX & MATCH functions, and two array operations. Learn about what an array operation and array formula is, and learn how to enter an array formula into a cell using Ctrl + Shift + Enter. 4. (08:13) Look at list of functions that can handle array operations without any special keystrokes. Link to buy Ctrl + Shift + Enter: Mastering Excel Formulas book: http://www.amazon.com/Ctrl-Shift-Enter-Efficient-Calculating/dp/1615470077 Alan Douglas at YouTube asks: I have two columns running side by side with random numbers. And I would like a formula that will find the which two values (one in each column) are the closest in value...
Views: 5103 ExcelIsFun
Disappearance Matches Revealed Easy Magic Tricks revealed Compilation
 
01:27:29
Disappearance Matches Revealed Easy Magic Tricks revealed Compilation Want to Learn Magic? Learn Easy Magic Tricks magiczne sztuczki, ujawnił Musica gratis trumenti creazione youtube: titolo The_Farmer_In_The_Dell Musica gratis da strumenti di creazione youtube: Mary Had A Little Lamb (instrumental) Hit the Streets (Version 1) di Kevin MacLeod è un brano autorizzato da Creative Commons Attribution (https://creativecommons.org/licenses/by/4.0/) Fonte: http://incompetech.com/music/royalty-free/index.html?isrc=USUAN1100881 Artista: http://incompetech.com/ Puoi utilizzare liberamente questo brano e monetizzare il tuo video, ma devi includere quanto segue nella descrizione del video: Dangerous di Kevin MacLeod è un brano autorizzato da Creative Commons Attribution (https://creativecommons.org/licenses/by/4.0/) Fonte: http://incompetech.com/music/royalty-free/index.html?isrc=USUAN1100414 Artista: http://incompetech.com/ Puoi utilizzare liberamente questo brano e monetizzare il tuo video, ma devi includere quanto segue nella descrizione del video: Dangerous di Kevin MacLeod è un brano autorizzato da Creative Commons Attribution (https://creativecommons.org/licenses/by/4.0/) Fonte: http://incompetech.com/music/royalty-free/index.html?isrc=USUAN1100414 Artista: http://incompetech.com/ Facebook: http://www.facebook.com/milleaccendinifunpage Youtube: http://www.youtube.com/user/milleaccendini Sito: http://www.magiamagia.org/ twitter: http://twitter.com/#!/milleaccendinit google+:https://plus.google.com/u/0/b/106818816560256164710/106818816560256164710/posts Instagram: http://instagram.com/milleaccendini Pinterest: http://www.pinterest.com/Milleaccendini/ Accedi a Amazon con il seguente Link e offri una Birra a Milleaccendini: http://www.amazon.it/?_encoding=UTF8&camp=3370&creative=23322&linkCode=ur2&tag=milleaccendin-21
Views: 112402 Milleaccendini
Excel Magic Trick 1086: 3 Way Lookup Formula & Conditional Formatting, Date Criteria Mismatch
 
10:33
Download Excel File: http://people.highline.edu/mgirvin/ExcelIsFun.htm Full Title: Excel Magic Trick 1086: 3 Way Lookup Formula & Conditional Formatting, Date Criteria Mismatch & Merged Cell Trouble See how to: 1. (00:11 min) Create formula to lookup a value from a table with three criteria: INDEX and MATCH and MONTH functions. MONTH and Text Month Name Joined (Ampersand) to the number 1 to get a month value and match a serial number date with month Number Format to match against a text month. 2. (05:24 min) Conditional formatting formula to highlight the intersection based on three criteria: one row header and two criteria as column headers. AND, DATE, MONTH and LOOKUP functions.
Views: 22352 ExcelIsFun