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

International College of Management and Sports - ICMS Logo

Microsoft Visio (Basic to Expert)

The Microsoft Visio (Basic to Expert) Program is offered by the International College of Management and Sports (ICMS)

by International College of Management and Sports - ICMS [Claim Listing ]
Quest International University (QIU) Logo

Data Analysis Using Microsoft Office Excel 365

This training is designed to enable participants to apply intermediate and advanced functions of Microsoft Excel to increase productivity, enhance spreadsheets with charts & formulas and streamline their work.

by Quest International University (QIU) [Claim Listing ]
Sendayan Training & Consultancy Logo

Microsoft Excel

Microsoft Excel course is offered by Sendayan Training & Consultancy. STC is aiming at bringing only the best training programs with passionate trainers. We strongly believe that knowledgeable and passionate trainers will be able to deliver the best only.

by Sendayan Training & Consultancy [Claim Listing ]
Iconic Training Solutions Logo

Microsoft Excel - Advanced

This course is intended for participants who wish to gain more knowledge from the intermediate level of Excel.

by Iconic Training Solutions [Claim Listing ]
Training Valley Logo

Microsoft Excel Power Pivot & Power Query

Microsoft Excel Power Pivot & Power Query course is offered by Training Valley. Leave your employees in our hands and we will return them completely equipped with enriched skill set, fresher attitude, world-class knowledge and impressive competency.

by Training Valley [Claim Listing ]

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