Excel Is About to Save You Hours

[@launchexcel]

*Get the FREE Excel workbook for this video* Step 1: Sign up for free: go.launchexcel.com/email-signup-youtube Step 2: Log in here: courses.launchexcel.com/dashboard/en/login Step 3: Get the workbook: courses.launchexcel.com/school/course/workbook-downloads/lecture/5612592#headline-7a3210d3 TIP: Stay logged in for quick access to ALL workbook downloads ✅ Learn Power Query Fast: go.launchexcel.com/moth-power-query-course *Chapters:* 00:00 Have you ever spent hours getting data from PDFs into Excel? 00:44 LEVEL 0: Copy and Paste 01:59 LEVEL 1: Basic Power Query Import (for simple PDFs) 05:49 LEVEL 2: What if there are no column headers on page 2+? 10:34 LEVEL 3: How to make it quick and easy to refresh the data 15:58 Watch this next... *Watch this video next* The Easy Way to Scrape Web Data into Excel kzbin.info/www/bejne/fnrPkH-Kl6utgdk

[@JoseAntonioMorato]

Dear Victor, I noticed that every time you load a table consult, you change the style from green to blue. Why don't you make the blue style standard? It's easy: Load the query to spreadsheet; Change the table type to your preferred one; Once the style has been changed, right-click on the chosen style and choose "Set as default"; The next queries, when loaded into the spreadsheet, will adopt the defined pattern. 🤗

[@launchexcel]

This is a nice tip Jose! Thanks for sharing.

[@JJ_TheGreat]

1:46 Why not try the “Fixed Width” option in Text-to-Columns?

[@launchexcel]

Good idea to try, in some cases it might work. In this case it doesn't because most of the columns have different widths.

[@JJ_TheGreat]

7:05 Click on the folder icon!

[@launchexcel]

Great tip! Yes if we click on the folder we can import everything in the folder, then filter out all the pages so we're left with just the tables.

[@muhammadasifpk]

Nice teaching way

[@RiminiVirage]

Excellent video, thankyou. You are an Excel Jedi Master without doubt.

[@launchexcel]

Rimini, thank you for the kind words. I'm always looking to learn more and make videos that are helpful!

[@merrillb7023]

Omg I think you solved huge issue for me

[@launchexcel]

Hi Merillb, I hope your issue is now solved! If not, just drop another comment.

[@merrillb7023]

@launchexcel it seems to bring over the headers with each worksheet and I can't get rid of them. What di I do? Thx

[@JJ_TheGreat]

11:04 Actually, it stands for “Mashup” code!

[@launchexcel]

Thank you JJ! I made up the phrase "Magic code" to be fun and memorable for newbies. Yes, "Mashup" code is what M Code actually stands for because it's a mashup language designed to create queries that mix together data.

[@JJ_TheGreat]

12:03 Or you can right-click and select the delete until end option…

[@launchexcel]

JJ that's a great tip! Keep them coming 😄