Another top-notch video. Happy recommending your videos because they are consistently well-prepared, clearly presented and excellent for learning from.
This was great. I was just working on a project that needed to have data from multiple reports in one place. this video has really helped me understand what I need.
No way. I was watching your another video about Pivot Table. And you didn't mention anything about multiple sheets. So I ended up Google it. But boom you just posted a video 35 mins ago. Thank you!
This is pretty cool way to import large chunks of data. It appears you do the query on the same workbook. I wouldn't think it would allow you do that since you're essentially loading a workbook while it's open. I tried this on my data and had to close the workbook to get it to work.
I love your tutorials, very well explained and easy to comprehend. I would like to know, which version of Microsoft excel are you using for illustrations. Thank You.
Kevin, hello! First of all, let me thanks you for your lessons, they are great and useful. I'd like to ask you about how to connect several tables with different data into one pivot? In this lesson you used the tables with the similar headers, but what if my tables have different data and different quantity of columns? I have a timesheet tables of workers (one month in one table). The common between my tables is the names of workers and the project names, but none of them are the same each month.
You can rename the column header before append the query. It will match according to column name, so do not need the worry two tables have different quantity of columns. E.g this platform ABC may use the column header as OrderID, the platform XYZ is Order Number. You just need to rename Order Number to OrderID will do.
Thank you so much for the very useful tips, right in time for my massive report. However, can I know if we can keep adding tabs/ sheet to the current append data? It looks like I have to rerun the append process in order to add new sheet. Thank you.
Awesome!! Please if you want to capitalize an already typed data in a sheet what is the shortcut in excel (I'm finding that tedious) Thank you for the sample workbooks too
Is it possible to add one table to another horizontally (IE adding columns from table 2 to the end of table 1) assuming you can find a relationship to align the rows?
I can’t import worksheets from the workbook I have open. It tells me there is an error because the workbook is being used for another processZ it looked like you were able to put the query/pivot table in the same workbook you were pulling data from. Do you know how I can circumvent this?
but should we take loads of all data in the pivot table instead of only appended data ...?? Can we not ignore the basic sheets while loading the pivot?
When trying to connect a sheet in the Query Editor, I get an error saying unable to connect because my sheet is being used in another process. I had to create it in a blank workbook to get the pivot table.
Amazing content Kevin, as always. Thank you Question: to what extent does the "Relate Data Table" tool that you describe in the timeline at minute 8.40 dispense with the somehow more intimidating Diagram View tool that is available within Power Pivot for establishing relationships? Do they sit at the same level?
Great video! Relationships in Excel could make a lot of database use obsolete. Is there any practical size limit, beyond which using a database for the raw data would be more robust? I currently use Access database for this kind of work and it's been rock solid-my basic approach is Access for data, Excel for analysis and presentation.
I have the same approach. I guess it is also about what the data is (numbers or text) and how much data must be related. If it requires calculations I try to use Excel for the numbers. But printed reports are much easier made in Access. But I am also curious when to use what.
Power Query can handle large amounts of data, more so than you're able to load into an Excel sheet. Excel maxes out at a little over a million rows. I also used to use Access back in the day when I analyzed millions of rows of data, but this provides an alternative if you're comfortable using Excel.
Hello Kevin. I like your videos, they very helpful. I need your help. I bought a GoPro Hero 11 black and when i download the videos to my laptop which is Asus VivaBook Pro 15 Ryzen 9 Processor RAM 16GB, 1TB and here I have a problem that the VIDEOS I download from the GoPro 11 camera on this laptop do not open. They ask me for some CODEC and I don't understand it I just need your help. If you can tell me how I can watch my videos on the laptop and which codec? What is it necessary to do? Thank you
Greetings 👋 Do you know how to recover files in PC if suddenly they're appearing as 0Kb & can't be accessed? Is there a way to retrieve them? I have lost all the data in my PC, theyre all showing 0KB but theyre appearing and i cant open them Your positive response will be highly appreciated
I don't get it. How does power query pull in ONLY from the existing worksheet you're in? I just want to keep my row headers, I can pull in a pivot table from multiple sheets but I don't keep my row headers and that's the issue. I guess the question isn't answered in this video.
I have an issue around the 3:05 mark. When I try to import the Pivot Tables Multiple file, I get an error because that's already open. Why am I getting this error, but Kevin is not?
Not enough explanation. What are the prerequisites? What are we going to get? We dont have to follow the whole video just to find out that at the end. We dont have to clickc click click without knowing what we are clicking for.
I can't find a video to save my life, i want to make a piechart in excel, i want to do a percentage of a chosen number and i can't seem to get the percentages correct...