Job Description

Course level: Basic Microsoft Excel Certificate

Prerequisites: Basic understanding of Windows/macOS and mouse/keyboard skills.

Objective of the training

This course is designed for absolute beginners. Students will learn the fundamentals of Microsoft Excel, mastering data entry, essential mathematical formulas, basic formatting, and simple data visualization. By the end of this course, you will be able to efficiently navigate spreadsheets and produce professional work output.

Target Audience: Office professionals, administrative staff, and individuals seeking to acquire foundational digital skills

Format

Over the course of 5 days, you will be immersed in a dynamic on site/ Online learning journey, featuring expert-led classrooms, curated visual, and collaborative problem-based learning activities, all facilitated by skilled and experienced instructors in the field. Practical, hands-on assignment and/or a short multiple-choice quiz.

Experiences and Qualifications

The Training will cover the following Content

Module 1: Introduction to the Excel Interface

• Understanding the Environment: What is a workbook, a worksheet, and a cell?
• Navigation Basics: Moving around using the mouse, keyboard, and Name Box.
• The Ribbon and Tabs: Using Home, Insert, and Page Layout tabs.
• Creating and Saving Files: How to start a new blank workbook and save security.

Module 2: Data Entry and Manipulation

• Entering Data: Typing text, numbers, and dates into cells.
• Editing and Clearing: How to edit cell contents, undo mistakes, and clear ranges.
• Using the Fill Handle: Quickly copying data and generating sequential lists (e.g., months, days, numbers).
• Rows and Columns: Inserting, deleting, adjusting width/height, and freezing panes.

Module 3: Formatting Worksheets

• Font and Alignment: Changing text sizes, styles (Bold, Italic), and cell alignment.
• Number Formatting: Applying currency, percentage, and decimal formats.
• Styles and Colors: Using cell borders, fill colors, and built-in Table styles.
• Format Painter: Quickly copying formatting from one cell to another.
• Merge & Center: Combining cells for headers and titles.

Module 4: Formulas and Basic Functions

• Writing Simple Formulas: Addition, subtraction, multiplication, and division.
• The Order of Operations: Understanding mathematical syntax (BODMAS / PEMDAS).
• Core Functions: Utilizing AutoSum, SUM, AVERAGE, COUNT, MIN, and MAX.
• Basic Cell Referencing: Introduction to relative cell addresses and the use of the colon ( : ) for ranges.

Module 5: Data Management and Visuals

• Sorting Data: Organizing data alphabetically (A-Z) and numerically (smallest to largest).
• Filtering Data: Creating filters to find specific records in large lists.
• Basic Charts: Creating and customizing visual aids like Column charts, Bar charts, and Pie charts.

Module 6: Printing and Sharing

• Print Settings: Setting print areas, adjusting margins, and changing orientation (Portrait/Landscape).
• Headers and Footers: Adding page numbers, dates, and titles to printed pages.
• Exporting/Sharing: Saving as a PDF or sharing the workbook safely.

Skills Required

Follow us on social media