ADVANCED EXCEL TRAINING | JOHOR BAHRU

ADVANCED MICROSOFT EXCEL – INTENSIVE & EFFECTIVE TRAINING WORKSHOP

[ Offering Online Training ]


LEARNING OBJECTIVE:

– Understand how you can apply Advanced functions of Microsoft Excel to improve productivity, enhance spreadsheets with charts & formulas and streamline your work.
– Learn how you can automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and leverage on Excel’s advanced functionality to simplify your day-to-day work.



WHO SHOULD ATTEND:

– The Advanced Excel Training Workshop course is tailored for managers and executives who are seeking practical solutions to their Excel problems in raw data management, business analysis and reporting.
– It is conducted based on business case studies with the aim of maximizing your benefits (e.g. productivity, report accuracy) in the use of Excel. Its purpose is to equip you with foundational skills and competence to explore Excel on your own.
– All persons involved in using Excel to process large datasets, especially those received from other systems, and converting them into reports to be utilized in the business.


LEARNING OUTCOMES:
– By the end of the course delegates will recognize areas where they could improve their own spreadsheet.
– They will be in a position to immediately apply the lessons learn to their own models in their own environment.
– They will immediately to be able to save time on their everyday Excel tasks.




MICROSOFT ADVANCED EXCEL COURSE CONTENT:

Working With Custom And Conditional Formats

Using Formulas And Functions

Using Advanced Filter

Consolidation Data

Conditional Logic And Functions Wizard

Lookup & References Formula

Scenarios Reporting In Excel

Data Validation

Working With Multiple Worksheet

Working With Pivot Tables In Excel

Working With Pivot Charts In Excel



Training detail:
Course Duration: 2 days



Requirements:
- Participants require to bring their own laptop during the training.
- Please ensure that your laptop are equipped with pre-installed software related to their course taken.




Registration & Fee Payment Term & Condition:

- Enrollment fee is a one-time payment.
- Training Course Fees must be FULLY PAY by Bank Into Account or made Online Instance Cash Transfer BEFORE training session start.
- After registration made, please attached with Online Transaction Receipt / Bank In Slip as proof of fee payment via whatsapp to our management for verification purposes.




Please set up an appointment for registration via contact at:
+6 012 74 61 5 82


[ Only for serious keen learner will be attend]




Copyright © ICT Training. All Right Reserved

Warning!

– We will prosecute all internet theft of our copyrighted material & text content.

– Re-post our material on your Website, Facebook, Twitter, Instagram or Blog are strictly prohibited!