1 Concord Business Centre, Concord Road, London, W3 0TJ

Mon-Sat, 8.00-18.00. Sunday CLOSED

Advanced Excel

Practical training course on Advanced Excel

London School of Accountancy and Business Studies (LSABS) offers a practical training programme on MS Excel. We will provide you with a proper understanding of Advanced Excel. The training course will help you become an Excel power user by learning tips, shortcuts, tricks, functions and formulas. Alongside, the Advanced Excel training programme helps users for performing financial analysis and financial modelling.

AT LSABS, you will have an opportunity of gaining accountancy work experience at our ACCA Gold Level recognised Chartered Accountant firm. You will work on real case scenarios at our accountancy workplace, where our high calibre accountants will help you while training at LSABS. Alongside Advanced Excel, you can also choose LSABS for Sage One, Sage CIS, Sage 50, Sage Payroll, IRIS, Xero, and QuickBooks.

Our Excel training programme is equally suitable for new entrants or individuals looking to enhance their Excel skills. LSABS has prepared thousands of Excel power users and offers you an advanced Excel training programme to help you gain command of this popular accounting application. 

MS Excel has recognition across the globe as a leading software for communicating, creating documents, and performing business analysis. Proficiency in Excel is essential for almost all professionals, especially accountants. Efficient Excel use is a prerequisite for any office-based job role. Employers worldwide are looking for professionals who have a firm grip on managing data on computers; hence, Advanced Excel competence has a good impact on your CV and boost your employability potential.


Advanced Excel course at LSABS will equip you to use Excel software's advanced features to a full extent. After the Advanced Excel course, you will become capable of the following:

  • Reporting on a data list using edit
  • Pivot Tables
  • Analyse complex data 
  • Proficiency in using advanced features 
  • Using solver
  • Using goal seek
  • Using scenarios
  • Using controls and macros
  • Using nested IF Functions to return 1 of 4 possible outcomes
  • Using absolute and relative cell references
  • Setting up a spreadsheet with active buttons
  • Using Excel HLOOKUP and VLOOKUP 
  • Developing tables to build a single formula to produce multiple results
  • Presenting specific data using Excel tools

If you are new and looking to gain Advanced Excel proficiency from start to end, this course is ideal for you. On the other hand, the programme is suitable for you if you have some Excel expertise but want to enhance your grip on the software.

You will go through many examples and exercises in an accountancy working environment because industry experts lead our Advanced Excel courses. Our certified accountants and trainers have decades of experience providing hands-on practical training that will give you lots of practical work experience. It will also equip you with valuable tips, techniques and tricks of using Excel effectively.

Progression pathway 

Advanced Excel proficiency opens many doors for accounting and finance jobs. After your training at LSABS, you can look for many job roles, including:

  • Bookkeeper
  • Assistant Accountant
  • Credit Controller
  • General Ledger Clerk
  • Sales Ledger Clerk
  • Purchase Ledger Clerk
  • Finance Assistant

Course outcome

After your Advanced Excel training programme, you will become competent in performing the tasks independently, which include:

  • Working on data listing
  • Data validation
  • Data consolidation
  • Ranges cell
  • Naming cells
  • Absolute cell addressing
  • Conditional functions
  • Conditional formatting 
  • Pivot tables and data 
  • Lookup functions
  • Nested IF functions
  • V LOOKUP tables
  • H LOOKUP tables
  • Creating macros 
  • Creating active buttons
  • Combining functions with buttons
  • Combining formulas with buttons
  • Using charts
  • Data analysis with ''What if'' tools