Mastering Microsoft Excel (Intermediate)

by De Novo Training And Consultancy Claim Listing

Microsoft Excel has emerged as a financial tool, providing high spreadsheet capabilities for managing financial data and accounting tasks effectively.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

De Novo Training And Consultancy Logo

img Duration

Please Enquire

Course Details

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.

 

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
  • Petaling Jaya Branch

    1113, 11th Floor, Lobby 4, Block A, Damansara Intan, No. 1 Jalan SS20/27, 47400, Petaling Jaya

Check out more MS Excel courses in Malaysia

Centrilinc Logo

Microsoft Access (Advance)

Microsoft Access course is offered by Centrilinc. User application software training has been one of our core business focus. Our application courses were developed, and are consistently updated to meet the current, and practical need of the local workforce.

by Centrilinc [Claim Listing ]
SIRIM Academy Logo

MS Excel (Beginner)

Microsoft Excel remains the go-to spreadsheet software for millions of people around the world. If you have been meaning to learn Excel for years but have not quite got around to it, or if you use Excel every day but feel lost when you log in, then this course is for you.

by SIRIM Academy [Claim Listing ]
Iconic Training Solutions Logo

Microsoft PowerPoint (Foundation)

Our Microsoft PowerPoint Foundation course is suitable beginners to Microsoft PowerPoint. At the end of this course, you will have a good working knowledge of PowerPoint basics.

by Iconic Training Solutions [Claim Listing ]
PSDC (Penang Skills Development Centre) Logo

Interactive Business Presentation With Microsoft Powerpoint (Basic Level)

This is a beginner’s course and aims to give the new user who want to learn the beginning-level PowerPoint skills.

by PSDC (Penang Skills Development Centre) [Claim Listing ]
Sabah Skills & Technology Centre Logo

Microsoft Excel (Basic To Intermediate)

Microsoft Excel course is offered by Sabah Skills & Technology Centre. SSTC aspires to actively provide the best of skills training available to meet current needs and strengthen the knowledge and skills level of the State’s workforce.

by Sabah Skills & Technology Centre [Claim Listing ]

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy