Excel in Treasury – advanced use cases

  • Post
    • March 5, 2024 at 1:23 pm
    Patrick Kunz
    Keymaster
    NL
    Today automation boutique wrote about excel in treasury and advance uses. Like power query and power pivot. I know a lot of treasurers who are advanced excel users (wizards!).

    What is your best Excel skill ? Queries, Macros ?

    Treasury for champions
Viewing 1 replies (of 1 total)
  • Replies
    • March 9, 2024 at 10:37 pm
    Danilo
    Participant
    Hi,

    For me, definitely Macros with VBA, you can create reports, PDFs, send automatic e-mails with those reports. Very handy for repetitive tasks.

    I did even XML payment files based on Excel Macros (XML mass payment files).

    Cheers,

    Danilo

Viewing 1 replies (of 1 total)

Tagged: , , ,

  • You must be logged in to reply to this topic.