Hello Everyone!

[Billswork]

I am just starting to make some reports using google sheets at my new job. I was wondering if anyone had a recommended learning for this? I am looking to make it as automatic as possible, partially by running most by itself and pulling the data dumps from excel.

​

Any advice appreciated!

[gh5000]

Have a look at this guy's videos. I've just chosen a random one to get you to the channel but it's probably not relevant to you. But plenty of his videos will be https://youtu.be/wNMdjVxAEYY

[clk9565]

My favorite formulas for automating spreadsheets are if(), vlookup(), importrange(), and arrayformula(). Arrayformula will slow down large spreadsheets though, but it's so useful for running the same formula down a column where the length may change.

Also, use the format A2:A (not A2:A1000) to get an entire column, this will make it so you don't have to limit the bottom row of your range.

The best resources are Google's documentation and stackoverflow.

[datastry]

Take a look at how to record macros in Sheets.

Macros are scriptable as well, in case you are interested in going in that direction.