Is there a guide, or is it impossible to pass the Avery visit? If it is possible, how?
It's not impossible! You have to collect 6 souls before he arrives.
Usually the easiest route is the 'trio' in Chapter 1 (Damien, Cassandra, and Jolie). In Chapter 2 you can pick up Mason, which a lot of people don't realize! Make sure you talk to him about himself and his past in Chapter 1, and then again after your performance evaluation in Chapter 2. You'll get a bit more information out of him, and a few days after that, something should happen!
Then, in Chapter 2, once you build the Bank, a few days after that you should be alerted to a mysterious intruder. That storyline lets you transform Xavier, if you can catch him! After you catch Xavier, Petra is a little more relaxed in the evenings, and by working with her during her shift, you can unlock her storyline/transformation.
Lastly, once you build the Casino, you'll meet newhire Sara, who can also be transformed! Talk to her either during her shift in the Casino (afternoons), or after she's offwork (evenings) to pursue her possible transformation paths.