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.
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 and intermediate knowledge of Microsoft Excel. Participants are required to bring laptops with Microsoft Excel installed.
COURSE OUTLINE
MODULE 1: ADVANCE PIVOT TABLE & PIVOT CHART
MODULE 2: CHART
MODULE 3: OFFSET
MODULE 4: DATABASE FUNCTIONS
MODULE 5: LOOKUP & REFERENCE
MODULE 6: ADVANCE FILTERING
MODULE 7: MACRO
BONUS: SHORT CUT TIPS