Bestseller
Bestseller
Excel Essential
Excel Essential is a practical 1-month Microsoft Excel course designed for beginners, students, job seekers, office staff, business owners and anyone who wants to develop essential spreadsheet skills.
The course focuses on Excel fundamentals, data entry, worksheet management, formatting, basic formulas and functions, data sorting and filtering, charts, printing and PDF sharing.
Students learn through practical exercises and real-world worksheets to build confidence in using Microsoft Excel for everyday office and business tasks.
WHAT YOU WILL LEARN
• Introduction to Microsoft Excel
• Workbook and Worksheet Management
• Rows, Columns and Cells
• Cell and Range Selection
• Data Entry and Editing
• Copy, Cut and Paste
• Undo and Redo
• Opening and Saving Workbooks
• Worksheet Navigation
• Cell Formatting
• Number, Date and Currency Formatting
• Borders and Alignment
• Row Height and Column Width
• Basic Formulas and Operators
• SUM, AVERAGE, MIN and MAX
• COUNT and COUNTA
• AutoFill and Flash Fill Basics
• Sorting and Filtering Data
• Basic Tables
• Basic Charts
• Page Setup and Printing
• Saving and Sharing Excel Files as PDF
PRACTICAL PROJECTS
• Student Marksheet
• Monthly Expense Sheet
• Employee Attendance Sheet
• Simple Salary Sheet
• Sales Report
• Basic Inventory Sheet
• Personal Budget Sheet
COURSE OUTCOME
After completing this course, learners will be able to create, format and manage Excel worksheets, perform basic calculations, organize data, create simple charts and prepare professional basic reports for everyday use.
Learning Method: Practical Training + Exercises + Real-World Worksheets + Assessment
Module 1 – Excel Fundamentals
• Introduction to Microsoft Excel
• Excel Interface and Ribbon
• Workbook and Worksheet
• Rows, Columns and Cells
• Cell Addresses
• Selecting Cells and Ranges
• Entering Data
• Editing Data
• Copy, Cut and Paste
• Undo and Redo
• Opening and Saving Workbooks
• Worksheet Navigation
Module 2 – Data Entry and Formatting
• Text, Numbers and Dates
• AutoFill
• Flash Fill Basics
• Font Formatting
• Font Size and Styles
• Bold, Italic and Underline
• Text Alignment
• Borders and Shading
• Row Height and Column Width
• Merge and Center
• Number Formatting
• Currency and Percentage Formatting
• Date Formatting
Module 3 – Basic Formulas
• Introduction to Formulas
• Formula Structure
• Arithmetic Operators
• Addition, Subtraction, Multiplication and Division
• Cell References
• Relative Cell References
• Basic Calculation Exercises
• Using AutoSum
Module 4 – Basic Excel Functions
• SUM
• AVERAGE
• MIN
• MAX
• COUNT
• COUNTA
• Basic Function Syntax
• Function AutoComplete
• Practical Function Exercises
Module 5 – Data Management
• Creating Excel Tables
• Sorting Data
• Ascending and Descending Sort
• Multi-Level Sorting Basics
• Filtering Data
• Number Filters
• Text Filters
• Date Filters
• Removing Duplicates
• Practical Data Management
Module 6 – Basic Charts
• Introduction to Charts
• Creating a Chart
• Column Chart
• Bar Chart
• Pie Chart
• Line Chart
• Selecting the Correct Chart
• Chart Title
• Data Labels
• Chart Formatting
• Basic Business Charts
Module 7 – Page Layout and Printing
• Page Layout
• Margins
• Orientation
• Paper Size
• Print Area
• Page Breaks
• Headers and Footers
• Print Preview
• Scaling Worksheets
• Printing Excel Reports
Module 8 – PDF and File Management
• Saving Excel Files
• Excel File Formats
• Save As
• Exporting Excel to PDF
• Basic PDF Sharing
• File Organization
• Workbook Protection Basics
Module 9 – Practical Excel Applications
• Student Marksheet
• Attendance Sheet
• Salary Sheet
• Monthly Expense Sheet
• Sales Report
• Inventory Sheet
• Personal Budget Sheet
FINAL ASSESSMENT
• Practical Excel Examination
• Objective Examination
• Data Entry Task
• Formatting Task
• Formula Task
• Data Management Task
• Chart Creation Task
• Basic Excel Project
Who can apply for this course
Minimum Qualification: 10th Pass
Prerequisite: No previous Excel experience is required. Basic computer knowledge is preferred.
Suitable For: Beginners, students, job seekers, office staff, business owners and anyone starting with Microsoft Excel.
Copyright © 2026 DITRP INDIA. All Rights Reserved
