Microsoft Office Excel (Advanced) 2016

This course covers how to work more efficiently using "Advanced" Techniques with workbooks and worksheets, enhance the appearance of data and worksheets, perform analysis using functions and use the sorting and filtering features to manage and analyse ;Our Excel Advanced training program digs deeper into the advanced features and functions of this powerful spreadsheet software. In this course, you will learn ADVANCED and In-Depth features such as nesting IF statements, how to calculate the Mean of a group of numbers using AVERAGEIF, SUMIF and many more such as LOOKUP Functions, Pivot Tables, Charts, Create & Record Macros.

This advanced Excel video course is not for beginners and you should have a firm grasp of the basics before taking this Advanced Excel training course. By the conclusion of this program you will have mastered the advanced features and functions of this software.

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

• Use the fill operations available to fill a data series
• Understand and use formula cell referencing to create more complex formulas
• Use a range of logical functions
• Apply conditional formatting to ranges in a worksheet
• Create and use labels in a workbook
• Work with various elements of a worksheet
• Use a range of techniques to work with worksheets
• Use a range of find and replace techniques
• Apply a variety of page setup techniques
• Sort data in a list in a worksheet
• Filter data in a table
• Create effective charts in Microsoft Excel
• Use a range of techniques to enhance charts
• Apply formatting techniques to text on charts
• Data Analysis & Pivot Tables
• V-Lookup & H-Lookup
• Auditing
• Proofing
• Reviewing

Eligibility / Requirements

Candidates should have already completed Excel basic level training or have the basic knowledge in using the Excel software such as knowing how to create and save an excel workbook, enter simple formulas, print and chart data.