Advanced Excel Bookkeeping Training

by Future Connect Training Institute

Our Advanced Excel training course will provide you with the knowledge and skills to use Microsoft spreadsheet programme to an advanced level.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Future Connect Training Institute Logo

img Duration

6 Months

Course Details

Our Advanced Excel training course will provide you with the knowledge and skills to use Microsoft spreadsheet programme to an advanced level.

Microsoft Excel programme is the most popular spreadsheet program, with Future Connect Training you will get hands-on practical experience on one of the best Advance Excel training courses. With this course, you will learn how to perform formatting, recording, working with pivot tables and running macros with up to date material to practice during the training.

 

What Is Included In This Advanced Excel Training?

  • Using AutoFill, using functions: ROUND; SUMIF; SUMIF; IF; IFERROR; AND, using the IF function
  • Carrying out date calculations and adding a watermark
  • Creating and working with tables, removing duplicates, converting text to columns,
  • consolidating data, using paste special, creating a custom format
  • Defining, using and managing named ranges, inserting, modifying and removing hyperlinks, formatting elements of a column
  • Pie charts, creating a combination chart.
  • Using the VLOOKUP function, adding a linked object into a spreadsheet, linking Excel workbooks, using the scenario manager, setting up data tables
  • Using features: COUNTA, COUNTIF, using text functions: PROPER, UPPER; LOWER, TRIM, LEFT, MID, RIGHT, CONCATENATE
  • Protecting worksheet cells, applying and removing passwords
  • Recording and running macros, running a macro deleting macros, using data validation, tracing dependent cells in a worksheet, evaluating formulas, tracking errors.
  • Using formatting, formatting cells meeting a specific condition, applying more than one conditional formatting rule
  • Sorting data using cell attributes, filtering data.

 

  • Finchley Branch

    4th Floor Office Suite, Lawford House, 4 Albert Place, Finchley, London
  • Birmingham Branch

    Cobalt Square, Hagley Rd, Birmingham
  • Manchester Branch

    7 St James's Square, Manchester
  • Harrow Branch

    Sigma Business Centre, 7 Havelock Place, Harrow, London
  • Mile End Branch

    119 Hamlets Way, Mile End, London
  • Hounslow Branch

    1st Floor Suite 6, Ashley House, 86/94 High Street, Hounslow, London
  • Brixton Branch

    5th Floor, Blue Star House, 234-244 Stockwell Rd, Brixton, London

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy