For example, I'm trying to utilize ImportExcel. I don't really know enough yet to understand what the documentation is indirectly (and usually even directly) telling me. Even just scrapping together what probably should be basic examples from the documentation, I can't really make them work.

What is the 'correct' way I should be trying to look at the documentation to understand how to utilize a module? I definitely know I need to get a better understanding of classes (feel free to throw links at me, thank you).

I'm not trying to do anything fancy whatsoever, just append the contents of a hashtable to the lowest open row, or find a value in a column then get the associated cells next to it. I'm basically 90% of the way there, but I'm sure my answers are super overengineered compared to what's doable with the modules.

Of course, I know that's always the first step of learning, so whatever. Though it don't know if it helps that I feel the documentation kind of sucks (?) and is mostly just examples that go over my head as opposed to breaking down the entire module into what every piece can do. I plan to start dabbling with python soon, but trying to stay within powershell as much as I can since it's built into Windows and my boss doesn't mind it, whereas Python I'd have to either convince him to allow it or learn how to spin up a docker container.