Someone posted an urgent request. Some contacts from a small list had gotten combined with a larger list. Question: how can I compare the 2 lists and extract the ones that shouldn’t be in the big list? This video shows 3 ways: Formulas: – VLOOKUP – MATCH and Get and Transform (Power Query) – Left […]
In the previous video I showed how to retrieve Word data and bring it into Excel. However, Nisha in Chicago noticed that the original data was in lists, but I didn’t retain the lists when the data was brought into Excel. (The original video: https://www.youtube.com/watch?v=-jihz5E0X5k) Nisha asked, what it would take to get the data […]
Data is in tables in Microsoft Word and needs to be moved over to Excel–and retain the table structure. PROBLEM: copy from Word and into Excel creates a mess. Items that were in the same cell in Word are in different cells in Excel. The solution is to replace ^p in the document with something […]
Once again, Kevin Lehrbass (MySpreadsheetLab) and I are taking on a common challenge and comparing each others’ solutions. Today’s challenge: if you have 10 students in a class, and would like each student to work with a different student each week, how can you get a list of all of the unique pairs? My favorite […]
FREE EXCEL ONLINE TRAINING (THIS WEEK ONLY): Power Query & Data Cleansing Techniques! SIGN UP HERE: http://myexcelonline.com/blog/datacleansingsignup ~ Receive 3 FREE training videos that will show you how to save HOURS EACH DAY using Excel’s built in features…including Formulas, Text to Columns, Pivot Tables plus much more! ~Learn the most powerful feature in Excel since […]
Taking you for a drive around Portland, OR while I answer 10 questions about travel and I’ve tagged: Mr Excel, Bill Jelen and https://www.youtube.com/user/bjele123 St. Lucian vocalist, Sherwin Dupes Brice https://www.youtube.com/channel/UCDJWTHHxVpOBmyTwuLYkd1w I also mention my favorite sriracha: Ghost Pepper Sriracha from California Blazin’ Chile Farms (I am not compensated for this shout-out, at all) https://www.etsy.com/listing/165113213/blazing-dragon-ghost-pepper-sriracha […]
I never expected to do a VLOOKUP tutorial because there are so many that other excellent folks have done. But … it’s time. In this video: – When to use VLOOKUP 0:50 – VLOOKUP’s pieces 1:45 – Raw VLOOKUP 3:52 – VLOOKUP with Tables 10:23 – Flash Fill 8:39 – weaknesses and Controversies 12:18 I […]
Revisiting Excel Tables! Using tables is a good habit to get into. Tables allow your spreadsheets to flex easily, and ease your worries about delicate formulas that might break or miss important data. This video goes deeper into tables than the Day 11 video did. Here, you’ll see the Table nomenclature; how Tables compare to […]
This video picks up exactly where Day 13 stopped. Here’s that video: Day 13 introduced the AND and OR functions. This video – Nests AND inside IF to test for True and False – Compares cell values to see if an exam was submitted within the time allotted. Excel Ignited is a video series for […]