• Provide participants with a comprehensive overview of Excel tools and functions to enhance productivity and accuracy in daily tasks.
• Build practical skills in formulas, functions (IF, SUM, COUNTIF,LOOKUP, Date &Time, Text), and data management techniques for effective problem-solving.
• Strengthen the ability to organize, analyze, and present data using
• conditional formatting, sort & filter, pivot tables, charts, and data validation.
• Develop proficiency in worksheet management, cell formatting, protection, and advanced features such as Flash Fill, Text to Columns, and hyperlinks.
• Enable participants to apply Excel efficiently in real work scenarios, ensuring improved reporting, decision-making, and data integrity.

• Operation / Reporting staff 
• Data analysis team
• Data input team
• Back office staff
• Anyone using Excel as a daily task

• 290$
• 250$

(Tax is excluded)

• Certificate
• Documents
• Materials
• Foods

Take your Excel skills to the next level with our Advanced Microsoft Excel training.

• Overview

Work sheets

Special Paste

Lock Cell F4

Format Cells

• Formula

           IF Function

           SUM & COUNT

           LOOKUP Funtion

           Date & Time

           Text Function

• Data Management

            Conditional Formatting

           Sort & Filter

           Find & Replace

           Data Validation

           Graph & Chart

           Pivot Table

           Lock & Protection

           Flash fill, Text to column

           Hyperlink