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 […]
Continuing the series for Excel beginners, this video shows the usefulness of the functions AND and OR. My book: Guerrilla Data Analysis 2nd Edition http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336 My blog: http://datascopic.net/blog-2-2
This was a real question that came to me. Someone has 113 worksheets in a single Excel file. How can he get all of the data stacked up in a single worksheet? Here, I show how to consolidate the data on 7 worksheets. For 113, the process would be the same. Thanks to Ken Puls […]
In a previous video I showed pivot tavles and said that they big problem with pivot tables isn’t the pivot table; it’s having the data being ready to go into the pivot table. In this video I list some features and concepts that make source data pivot table ready. The first is the data must […]
In the previous video you saw pivot tables. We added new data to the pivot table and had to change the source range. In this video, the use of Excel tables eliminates the need for that extra step. We just have to refresh. Also in this video you’ll see Flash Fill and how Excel’s tables […]