Problem Solving Using Excel : Tips and Tricks Beyond Numbers
LEVEL: INTERMEDIATE HRDF: CLAIMABLE
TRAINER:
Ts. Jale Bin Ahmad
9 - 10 MAY 2023
CAPE
Level 8, Permata Sapura, Kuala Lumpur City Centre 50088 Kuala Lumpur​
9.00AM - 5.00PM
RM 2,500 FOR PROFESSIONALS
10% Discount for Early Bird (until 9 April 2023) / Group / Students
CONTENT SUMMARY
INTRODUCTION
This course is suitable for anyone who wants to improve their problem-solving skills using Excel, including business analysts, data analysts, researchers, and project managers.
The "Problem Solving Using Excel" course is a 2-day training program that aims to equip participants with the necessary skills and knowledge to solve real-world problems using Microsoft Excel. The course will blend the theoretical with practical sessions, with hands-on exercises. The course will also provide participants with tips and tricks on how to maximize their productivity using Excel.
Introduction to Excel and Problem Solving Techniques
- Understanding Excel Interface and its basic features
- Solving problems using Excel
- Types of data analysis techniques available in Excel
Data Analysis and Management Techniques
- Sorting, Filtering, and Grouping data
- Using Pivot Tables for Data Analysis
Solving Mathematical Problems using Excel
- Basic Mathematical functions
- Understanding formulas and Functions
- Solving equations using Excel
Solving Statistical Problems using Excel
- Statistical Analysis using Excel
- Hypothesis Testing using Excel
Solving Optimization Problems using Excel
- Using Solver for Optimization
- Linear Programming using Excel
Visualizing Data and Results
- Creating charts, graphs, and tables
- Understanding and using conditional formatting
- Presenting Data for better decision making
OBJECTIVES
Upon completion of this course, participants will be able to:
- Be able to understand the Excel interface and its features for solving real-world problems using Excel.
- Use and understand different problem-solving techniques available in Excel.
- analyze and manage data using Excel, including sorting, filtering, grouping, and using Pivot Tables.
- solve optimization problems using Excel, including using Solver for optimization, Linear Programming, and Non-Linear Programming.
- present data in a visually appealing manner using charts, graphs, and tables in Excel.
WHO SHOULD ATTEND?
- Excel users looking to level-up and master the same tools and techniques used by Excel MVPs
- Anyone hoping to maximize productivity, work more efficiently, and take their career to a new level
- Students looking for an engaging, hands-on, and highly interactive approach to Excel training
- Anyone looking to pursue a career in data analysis or business intelligence
- This course is NOT recommended for absolute beginners (some prior experience with Excel is encouraged)
OUR TRAINER
1. Ts. Jale B. Ahmad (UTP)
Ts. Jale B. Ahmad is an HRDF Certified Trainer. The trainer has worked in Artificial Intelligence, Optimization Algorithms, Object Oriented Programming, Website Development (HTML, CSS and PHP), Microsoft Excel, Microsoft Visual Basic and VBA, Microsoft Word, Microsoft Powerpoint, Microsoft Power BI, Microsoft Power App, Microsoft Power Automate, Microsoft Power Virtual Agent, Adobe Illustrator, Adobe Photoshop, Adobe Animate, Cloudera Hortonworks Data Platform (Big Data Analytics) and education for more than 20 years. The trainer has worked with two private universities in Malaysia. Jale B. Ahmad has a Bachelor of Computer Science (hons) from Universiti Putra Malaysia and a Master in Autonomous Systems from University of Exeter, UK.
The trainer teaches courses such as Structured Programming, Object Oriented Programming (C++, Java, Python), Statistics and Empirical Method and Web Development.
REGISTRATION FEES
PROFESSIONALS
MYR2,500*
*fee quoted does not include SST, HRDF service fee, GST/VAT or withholding tax (if applicable).
EARLY BIRD/ GROUP/ STUDENT
MYR2,250*
*fee quoted does not include SST, HRDF service fee, GST/VAT or withholding tax (if applicable).
OUR LOCATION
Centre for Advanced & Professional Education (CAPE)
Level 8, Permata Sapura, Kuala Lumpur City Centre, 50088 Kuala Lumpur​
CALL US
+605 - 368 7558 /
+605 - 368 8485
DROP US AN EMAIL
cape@utp.edu.my