MICROSOFT EXCEL has emerged as a financial tool, providing high spreadsheet capabilities for managing financial data and accounting tasks effectively. In all decisions, businesses need to use the right financial tools to identify where value can be created and how it can be maximized. Participants will gain solid understanding of using common use functions in Microsoft Excel.
OBJECTIVE
After completing the training, the participants should be able to utilize Microsoft Excel to perform simple data analysis
WHO SHOULD ATTEND
This training course is highly recommended for Financial Professionals, Accounts Clerk, Accounts Assistant and users who uses spreadsheet in their daily work
PRACTICAL APPLICATION
This course includes extensive explanations, case-studies and real- life samples of how each of the modules could be applied to real-world situation in daily work.
PREREQUISITE
Participants should have basic knowledge of Microsoft Excel. Participants are required to bring laptops with Microsoft Excel installed.
COURSE OUTLINE
MODULE 1: Formulas & Functions
MODULE 2: Working With Names
MODULE 3: Conditional Formatting
MODULE 4: Data Validation
MODULE 5: Formulas & Functions
MODULE 6: Basic Pivot Table
BONUS: SHORT CUT TIPS