Organizations depend on highly skilled employees to produce high-quality work. This course is designed to equip participants with the essential skills to leverage Microsoft Excel in their daily tasks. In this course, participants will gain the knowledge and skills required to create and edit worksheets, apply basic formatting techniques, use data validation, charts, and tables, and leverage conditional formatting. This course is ideal for users who have little knowledge of using Microsoft Excel.
OBJECTIVES
• Discover Excel by navigating the Interface, Ribbon and the Toolbar
• Apply the techniques and rules in entering, editing, formatting data orderly and accurately
• Perform calculations and summarized data using relevant functions and formulas
• Manage and format data across multiple worksheets systematically
• Apply Data Validation in setting criteria and rules on entering data
• Leverage on the Conditional Formatting
• Apply Charts and Tables for clearer presentations
• Set and manage printing of Excel spreadsheet
• Explore the techniques of using Excel shortcuts