Advance Excel
For
Working Professional
Why Advance Excel?
Time-saving
Better analysis
Increased productivity
Career advancement
Better decision-making
Why Us?
Trainers have industry experience.
Will provide practical hands-on sessions.
Explanation with real-world examples
Who Should Attend
Who want to take their excel skills to next level.
Accountants who wants to improve
their accuracy and efficiency.
People who want to take full advantage
of everything, excel has to offer.
Who want to integrate their business
with excel.
Prerequisite
Computer Literacy
Basic knowledge of excel
Basic Data analysis skills
What You’ll Learn
- Introduction
- Data sorting
- Name and name range
- Data management
- Advance data analysis
- Pivot tables
- Introduction & creation
- Slicer
- VLOOKUP
- HLOOKUP
- COUNTIF
- SUMIF
- SUMPRODUCT
- Nested formulas
- Basics of macros