Explore Financial Academy
About the Academy
Discover our Rich, 60-Year Journey
Jadarat
A Comprehensive System for Skill and Knowledge Development
Governance
Meet our Inspiring Leadership
Success Stories
Check out our Clients’ Reviews and Testimonials
...
Analyze data smarter and elevate your Excel skills to support decision making.
The Microsoft Excel – Intermediate Level program is designed to enhance participants’ ability to use Excel as a powerful tool for data analysis and decision support. The program enables learners to move beyond basic usage toward more professional and analytical applications of Excel. It covers advanced formulas and functions, including logical, text, and date functions, to ensure accurate and efficient calculations. Participants will develop skills in sorting, filtering, and querying data using lists and database functions. The program also focuses on organizing and visualizing data through advanced charts and graphical representations. In addition, it emphasizes data analysis using pivot tables and pivot charts to extract meaningful insights. Delivered through hands-on practice and real-world exercises, the program strengthens productivity and prepares participants for advanced Excel applications.
Banking
Capital Market
Insurance
Financing
Artificial Intelligence and Data Management
Not Exist
Lecture
Practical Implementation +1
Lecture
Practical Implementation
Exercises and assignments
Pre Exam
Post Exam
All job families in the financial sector
This provides you with the opportunity to select the available times that suit you best for participation in our program. These times represent slots during which we are ready to welcome you and provide assistance and guidance.
In Class Training-Online Training
Define Cell Ranges and Reference Them in Formulas
Perform Conditional Calculations
Carry Out Logical and Specialized Functions
Work with Date and Time Functions
Understand and Execute Text Functions
In Class Training-Online Training
Sort and Filter Data
Learn the Capabilities of Database Functions
Query Data with Database Functions
Outline and Subtotal Data
In Class Training-Online Training
Build and Modify Tables
Create Formatting Rules
Apply Conditional Formatting to Alter Groups of Cells
In Class Training-Online Training
Organize and Represent Data with Charts
Modify and Format Charts
Search for and Replace Data.
Discover and Implement Advanced Chart Features
In Class Training-Online Training
Create a Pivot Table
Analyze Pivot Table Data
Present Data with Pivot Charts
Filter Data Using Timelines and Slicers
Accurately perform calculations using advanced functions and formulas.
Sorting, filtering and querying the data skillfully, which helps in facilitating and accelerating the work performance.
Create and format tables appropriately to ensure data consistency and presentation.
Display data clearly and attractively with graphs.
Analyze data with pivot tables and pivot charts to reach the best decision.
