Career Companion Institute (CCI) | Computer Courses, AI Skills & Spoken English

Bestseller

0 rating

Certification In Basic Microsoft Excel(BME)

Last updated Oct, 2026
Certified Course

Duration1 Month
Lectures36
Videos0
Notes0
CertificateYes

What you'll learn

Learn the fundamentals of Microsoft Excel, from data entry and formatting to basic formulas, functions, data organization, and professional report creation. This course helps students develop practical Excel skills for office work, record management, calculations, and everyday business tasks.

What You’ll Learn

Understand the Excel interface, workbooks, worksheets, rows, columns, and cells.
Enter, edit, organize, and format data professionally.
Use basic formulas and functions for calculations.
Apply sorting, filtering, and basic data management techniques.
Create tables, charts, and simple reports.
Use conditional formatting and data validation.
Prepare professional worksheets for printing and sharing.
Develop practical skills through real-world Excel exercises.

Course Syllabus

Module 1: Introduction to Microsoft Excel

Excel Interface, Ribbon, Tabs & Menus
Workbooks, Worksheets, Cells, Rows & Columns
Creating, Saving & Managing Excel Files
Data Entry, Editing & AutoFill

Module 2: Data Formatting & Organization

Number, Date, Text & Cell Formatting
Font, Alignment, Borders & Colors
Row Height, Column Width & Cell Styles
Sorting and Filtering Data
Find & Replace, Copy, Cut & Paste

Module 3: Basic Formulas & Functions

Basic Arithmetic Operations
SUM(), AVERAGE(), MAX() & MIN()
COUNT() & COUNTA()
Basic Cell References
Formula Syntax and Error Prevention

Module 4: Data Management

Excel Tables
Conditional Formatting Basics
Data Validation and Drop-Down Lists
Remove Duplicates
Basic Data Cleaning

Module 5: Charts & Reports

Creating Column, Bar, Line & Pie Charts
Chart Titles, Labels & Formatting
Preparing Simple Reports
Page Layout, Print Settings & Page Setup
Saving and Sharing Worksheets

Module 6: Practical Projects

Student Marks and Result Sheet
Monthly Expense Tracker
Employee Attendance Sheet
Sales Record and Summary Report
Basic Data Analysis Exercises

Course Benefits

By completing this course, students will be able to use Microsoft Excel confidently for basic office work, data entry, calculations, record keeping, and report preparation.