Microsoft Excel – Basic/Intermediate Level

This course, Microsoft Excel - Basic/Intermediate Level, builds introductory and foundational knowledge on Excel functionalities to gain business and personal efficiency. You will develop essential Excel skills, such as organising, analyzing data, and managing spreadsheets, with a foundational understanding of business data analysis.

With Microsoft Excel - Basic/Intermediate Level you will be equipped with the confidence to navigate the Excel interface.

Training Objectives

• To expose participants to the functionalities of Microsoft excel such as performing calculations using formulas and functions
• To help participants build the capability to effectively visualize data using basic charts.
• To increase the capacity and speed of usage of MS Excel as a powerful tool in driving efficiency, productivity, and professionalism in business

Course Modules

• General Overview of Microsoft Excel
• Understanding Microsoft Excel
• Introduction to Spreadsheets
• Basic Spreadsheet Skills
• Excel Help System
• Understanding Workbook File Formats
• Creating New Workbooks
• Selecting Cells
• Auto Sum and Auto Fill Function
• Cell Referencing and Request
• Formatting Cells
• Formatting Numbers
• Placing Cell Alignment
• Cell, Rows and Columns
• Understanding Worksheets
• Editing, Copying and Moving Cells
• Page Layouts in Excel
• Proofing Workbooks
• Basic Options, Ribbons and Toolbar
• Defining Names in Excel
• Sorting Data
• Using Excel Tables
• Filtering Data in Excel
• Understand Charts
• Chart Design Options and Tools
• Chart Format Tools
• Combo Charts
• Functions within Excel
• Understanding Date Function
• Information Functions
• Logical Functions
• Financial Functions
• Find and Replace
• Headers and Footers
• Adding Comments
• Conditional Formatting

Mode of Delivery

Face-to-face learning with instructor-led hands-on practical demonstration and learning. Each participant is expected to work individually on a computer.
2 days of learning sessions
Course material and Course Certificate will be issued
Virtual learning option is available