Advanced Excel Bookkeeping Training

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.