Microsoft Excel Basics For Beginners

Course Overview

This course is designed for individuals new to Microsoft Excel. It covers the fundamental skills needed to navigate, organize, and analyze data using Excel. By the end of this course, participants will have a solid understanding of Excel’s core functions and be able to perform basic data management tasks with confidence.

Course Objective:

• Understand the Excel interface and basic navigation.
• Create, save, and manage Excel workbooks and worksheets.
• Enter, format, and edit data in cells.
• Use basic formulas and functions to perform calculations.
• Create and customize basic charts and graphs.
• Apply simple data analysis techniques.
• Utilize basic data validation and protection features.

Target Audience:

• Individuals new to Excel
• Professionals seeking to enhance their data management skills
• Students and educators requiring basic Excel skills for academic purposes

Entry Requirement:

• No prior experience with Excel is required.
• Basic computer skills are recommended.

Course Outline:

Module 1: Introduction to Excel

• Overview of the Excel interface
• Understanding the Ribbon, Tabs & menus
• Navigating worksheets and workbooks

Module 2: Working with Data

• Entering and editing data
• Formatting cells, rows, and columns
• Using the AutoFill and Flash Fill features

Module 3: Basic Formulas and Functions

• Introduction to formulas
• Using basic functions: SUM,AVERAGE, MIN, MAX, and COUNT
• Understanding relative and absolute references

Module 4: Data Visualization

• Creating basic charts and graphs
• Customizing chart elements
• Introduction to Sparklines

Module 5: Data Management

• Sorting and filtering data
• Using the Find and Replace feature
• Basic data validation techniques

Module 6: Basic Data Analysis

• Introduction to PivotTables
• Creating and modifying simple PivotTables
• Using conditional formatting

Module 7: Protecting and Sharing Workbooks

• Protecting worksheets and workbooks
• Setting permissions and passwords
• Sharing workbooks with others

Course Duration:

Day Class: 9 am to 6 pm (2 Days)

Evening Class: 6 pm to 10 pm (4 days Evening)

COURSE SCHEDULE:

Day class schedule:

1. 23 Sept 2024 (9 am to 6 pm)
2. 30 Sept 2024 (9 am to 6 pm)

Evening class schedule:

1. 10,11,12,13 Sept 2024 (6 pm to 10 pm)
2. 24,25,26,27 Sept 2024 (6 pm to 10 pm)

Course Fee:

$150 

ASSESSMENT:

Written Test Section A & B (MCQ)/Theory

ATTENDANCE:

100% Required

PASSING MARK:

60% each assessment Mode

CERTIFICATION:

Upon successful completion of the course a certificate endorsed by Ensure Safe Consultancy Pte Ltd will be issued to the participants.