Introduction:

The Advanced program is designed for those with intermediate knowledge of Excel who wish to progress to the most complicated functions and features in Excel 2016.

What Will You Learn:

By the end of the program, learner will be able to:

• work with cell references;
• create and use range name in Formula & Function;
• apply conditional formatting;
• group and ungroup cells;
• perform calculation by consolidation;
• create commonly used analysis charts;
• create a simple PivotTable and PivotChart;
• work with links;
• use various protection in Excel;
• use analysis tools.

Who Should Attend:

Learners who wants to create reports and perform calculation by using the Excel functions and features.

Prerequisite:

• Learners should have already known the intermediate level of Microsoft Excel.