Microsoft® Excel – Intermediate

QUICK PAY
Debit Card/Credit CardSEND AN INQUIRY
Talk to our team!Overview
This programme is designed for delegates who has completed our Microsoft® Excel – Basic programme, or has equivalent knowledge of using the various parts of the Microsoft Excel interface, can use absolute, relative and mixed references, use formulas and functions, manage and organise worksheets, edit and format data, print and save files and customise the Excel interface.
Overview
This intermediate level course is intended to help all users get up to speed on many of the different features found in Excel and to become familiar with its more advanced selection of features. We will cover how to create and use advanced formulas, analyse data, organise worksheet data with tables, visualise data with charts, insert graphics, and enhance workbooks.
Objectives
- Learn how to apply range names and use specialist functions
- Explore the function categories, references, syntax and entry dialogue boxes
- Learn how to use text, logical and lookup functions
- Be able to create and modify tables and sort and filter data
- Know how to create charts, modify and format existing charts and create a trend line
- Learn how to create a PivotTable, filter data using slicers and analyse data using PivotCharts
- Learn how to insert and modify graphical objects and incorporate SmartArt into workbooks
- Customise workbooks, manage themes and create and use templates
Course Content
Below is an example of the course content. The content can be ‘tailored’ to meet the exact requirements of the client.
- Apply range names
- Use specialised functions
- Enabling interactive calculations
- Text functions
- Logical functions
- Lookup functions
- Date functions
- Financial functions
- Create and modify tables
- Sort and filter data
- Subtotal and database functions
- Create charts
- Modify and format charts
- Create trendline
- Create advanced charts
- Create a pivot table
- Filter data by slicers
- Analyse data with PivotCharts
- Insert and modify graphic objects
- Layer and group graphic objects
- Incorporate SmartArt
- Customise workbooks
- Manage themes
- Create and use template
- Protect files
- Preparing a workbook for multiple audiences
Methodology
The foundation of our training is anchored in activity-based experiential learning. This methodology takes into consideration different learning and communication styles, and more importantly language and cultural differences. It is through active participation that the adoption and application of theory is expedited.
Our training team pays careful attention to planning and designing effective instructional methods essential for the transfer of knowledge. It is the creative skill of our management trainers and consultants that reveal untapped skills of the delegates through:
- Practical sessions
- Individual and syndicate activities
- Individual and group tasks
- Case studies
- Role plays
- Audio and video evaluation
- Action planning
- Experiential learning games
- Presentations
- Assessments
