Advanced Excel: Functions, Power Query and Power Pivots
19–23 Oct 2026 · Riyadh
View courseIntensive 5-day course · English, Arabic & European languages
Accounts payable managers and staff, together with finance and procurement colleagues, examine the AP function in seven modules over five days. Delegates study invoice processing and three-way matching, vendor management and controls. Microsoft Excel work covers monitoring performance, while sessions on supplier payments examine the department's relationship with treasury.
Public courses in our cities
Group discount: 2 delegates 20% · 3 delegates 35% · 5 or more delegates 50%
Can't make these dates? We can run this course for your team on dates that suit you. Ask for custom dates · In-house options
With a trainer, on dates to suit your team
This course can be taught live online by a trainer, in English, Arabic or any European language, for one person or a whole team.
£1,850 + VAT
Group discount: 2 delegates 20% · 3 delegates 35% · 5 or more delegates 50%
Pick what you want changed and we’ll come back with a proposal and price.
Accounts payable involves service as well as accounting. Managers need to understand how customer requests and vendor relationships affect the department, alongside handling Purchase Orders (POs), cheque requests and the supporting records needed to process payments. The programme relates these responsibilities to working capital and cash management.
Invoice handling leads into month-end accruals and the controls used to prevent errors. Delegates examine annual audits and departmental technology, then consider staff motivation, internal communication and disputes with vendors or colleagues. Microsoft Excel provides practical methods for managing and monitoring the function.
From module six onwards, delegates examine the accounts payable function as a genuine business partner. Work covers supplier payment timing, the cost of funds, and how to assess early payment discounts. The final module uses Microsoft Excel to prepare aging reports, perform reconciliations, and use pivot tables to extract information from accounts payable data.
By the end of the course, delegates will be able to:
This course suits:
Every delegate who completes the course receives an ARUK Training Certificate of Attendance.
Choose a date and city in the schedule and press Register, or send us an enquiry. Our team confirms your place and sends an invoice.
Fees are shown per delegate and exclude VAT, which is added to the invoice where applicable.
Yes. Any ARUK course can be delivered in-house at your premises, in a meeting room we book for you, or 1-to-1.
Yes. We run it live online with a trainer, on dates that suit your team, for £1,850 + VAT per delegate.
Yes. 20% for 2 delegates, 35% for 3 delegates and 50% for 5 or more delegates on the same course.
Yes. Our courses can be delivered in English, Arabic or any European language, by a trainer who teaches in that language. Mention your preferred language when you register or enquire.
An ARUK Training Certificate of Attendance.
19–23 Oct 2026 · Riyadh
View course19–23 Oct 2026 · Istanbul
View courseWe use analytics cookies (Google Analytics) to understand how the site is used and improve it. We do not use them for advertising. Do you accept? Details