Microsoft Excel – Advance

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

  • Summarizes and auto-calculate complex data and present in chart

MODULE 2: CHART

  • Use charts in presentable way

MODULE 3: OFFSET

  • Use Offset function to automate pivot table

MODULE 4: DATABASE FUNCTIONS

  • Calculate and simplify data to show results using database functions

MODULE 5: LOOKUP & REFERENCE

  • Search, insert and display values from mapping table

MODULE 6: ADVANCE FILTERING

  • Use advance filtering for complex situations

MODULE 7: MACRO

  • Automate repetitive process using macro and reduce time to perform tasks

BONUS: SHORT CUT TIPS