What's on this page?        

  • Basic excel training tutorial videos
  • Advanced excel training tutorial videos

 Contact the Experts     

    Expert help for your enquiries.    

    E: This email address is being protected from spambots. You need JavaScript enabled to view it.    

    T: +65 6227 4180    


Basic Excel Training

Basic formulas and functions

Basic shortcuts

Basic shortcuts 2

 Basic accounting formulas and format

Keyboard shortcuts for accountants

Formulas: Auditing tricks

Applying accounting format to Pivot tables

Calculating % change

Copying date from one excel sheet to another

SUMIF function

How to freeze panes

AUTOSUM formula

Using the IF function

Combining multiple files into one excel file

How to create Bookkeeping spreadsheet

How to create Bookkeeping spreadsheet 2



Advanced Excel Training

Pivot tables

How to make a pivot table

How to create pivot tables

Step-by-step process

Detailed pivot tables for accounting


KLP LLP is a chartered accounting firm, serving over 400 clients from a range of industries locally, and across the region. Our clients include SMEs and listed companies.

ADD: 13A Mackenzie Road, Singapore 228676

TEL: +65 6227 4180

EMAIL: klp@klp.com.sg

Mon to Fri 9am - 5pm
Closed on Sat, Sun and all public holidays