Microsoft Excel – Intermediate

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

  • Absolute & Relative Referencing
  • SUM, COUNT, COUNTA, AVERAGE, LEFT, RIGHT, MID

MODULE 2: Working With Names

  • Create, edit and delete defined names to simplify calculations

MODULE 3: Conditional Formatting

  • Use conditional formatting to highlight specific defined values

MODULE 4: Data Validation

  • Define restrictions on what data can or should be entered in a cell

MODULE 5: Formulas & Functions

  • IF, NESTED IF, IFERROR, AND, OR
  • SUMIF, COUNTIF

MODULE 6: Basic Pivot Table

  • Summarizes and auto-calculate values on data created

BONUS: SHORT CUT TIPS