How about an L-shaped desk with file cabinets/storage shelves underneath. Looks like lots of stuff you don't use on a weekly basis - either get rid of it, or store it away. Delete shoe ...

My second bedroom needs to work as an office AND a guest bedroom but its very very small. I can probably fit (squeeze in) a daybed AND my desk, but i have to move the chair out when the guests are...