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

Global Knowledge Hub Plt Logo

Microsoft office Access (Beginners/Intermediate/Advanced

Microsoft office Access training is offered by Global Knowledge Hub Plt. Global Knowledge Hub Plt has a diverse group of trained, experienced and dynamic personnel ranging from training advisors and consultants.

by Global Knowledge Hub Plt [Claim Listing ]
New Horizons Malaysia Logo

Microsoft Word

Microsoft Office Certification proves that you have core to advanced skills in Microsoft Office applications. Certification is helpful for those new to the workforce or transitioning to a more analytical role, since it proves you can perform tasks at a higher level. This gives you a leg up against ...

by New Horizons Malaysia [Claim Listing ]
Fajar International College Logo

Microsoft Excel Basic Training

Microsoft Excel Basic course is offered by Fajar International College. Fajar International College (FIC) is in business to provide the highest standard of education in Occupational Safety and Health, Business Management, and Accounting Courses.

by Fajar International College [Claim Listing ]
ProCom Computer Centre Logo

Microsoft Access

Access is a Relational Database Management System (RDMS) that you can use to store and manipulate large amounts of information.

by ProCom Computer Centre [Claim Listing ]
Intellects Global Learning Logo

Microsft Access Database (Intermediate To Advance)

Microsft Access Database training is offered by Intellects Global Learning. We are committed to continually improve the effectiveness and efficiency of our processes, so as to provide outstanding consulting and training services to our customers.

by Intellects Global Learning [Claim Listing ]

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