Course Objective – Microsoft Excel 2013 – Advanced
Microsoft Excel 2013 – Advanced is designed for the participant who wants to leverage on the Advanced functions and features to improve productivity and enhance your spreadsheets to simplify your daily work activities.
You will learn how to use advanced functions such as text formulas, lookup functions, understand errors, manage names, consolidate data, organise and analysis data, create Pivot tables and macros.
For learners who need to enhance productivity by automating repetitive tasks or simplify the complex task, you can register the Visual Basic for Applications in Microsoft Excel – Fundamental. Learn Macros and the programming knowledge behind the Excel programs.