top of page

EXCEL Advanced

Our Microsoft Excel Advanced course is suitable for those with a sound working knowledge of Excel who wish to progress to the most complicated functions and features.

At the end of this course you will have a complete understanding of the higher functions of Excel.

You will be able to perform the most advanced calculations and functions, manipulate data using pivot tables and 'advanced' analysis, record macros and integrate with other office applications.

Learning Outcomes

Upon successful completion of this course, the participant will be able to:

  • Use a range of techniques to work with worksheets;

  • Apply a variety of page setup techniques;

  • Apply borders to cells and ranges in a worksheet;

  • Use the most popular and common worksheet functions;

  • Create more complex formulas and functions;

  • Use a variety of functions;

  • Use the date and time functions to perform calculations;

  • Create and use defined names in a workbook;

  • Apply a range of number formatting techniques to worksheet cells;

  • Apply conditional formatting to ranges in a worksheet;

  • Use goal seeking to determine the values required to reach the desired result;

  • Work with tables in Microsoft Excel;

  • Understand and create simple Pivot Tables;

  • Use a range of elements and features to enhance charts;

  • Select and change the format of objects in a chart.

bottom of page