Excel- Intermediate to Advanced Hub  

Overview of the programme

Put your trainees in the lead by allowing ProBeta to help them be more efficient as we practically navigate the Excel functions/scenarios most often encountered in practice.

• Introduction: Terminology / layout and interface / move or copy sheets / Status Bar / various ways to Paste data
• Recovering Lost Documents: Finding lost documents / Attaching to emails
• Built-in Templates: Invoices / Loan amortisation schedule
• Navigating Seamlessly: Freeze panes / Quick access toolbar / How to navigate without a mouse / Line breaks.
• Data Editing: Sorting / filtering / Subtotal formula / conditional formatting.
• Data Searching: VLookUps / Search and Replace text.
• Data Extraction: Flash fill / Text-to-Columns / Concatenate.
• If Statements: If and CountIf formulae.
• Clean up GL: Various tools to tidy up a general ledger
• Building Formulae: Cell referencing within formulae, i.e. relative and absolute references.
• Tables / Graphs: Create pivot tables.

All courses available in the Hub:

• Excel – Intermediate

• Excel for Accounting and Audit Trainees