Bestseller
Bestseller
Mastering MS Excel for Beginners is a practical, hands-on course designed to help learners build a strong foundation in Microsoft Excel. The course covers spreadsheets, data entry, formatting, formulas, functions, charts, sorting, filtering, and basic data analysis. It is ideal for students, job seekers, office professionals, and anyone looking to improve productivity and data management skills using Excel.
This syllabus involves covering the essential skills and knowledge that a beginner or intermediate user would need to be proficient in the software.
Introduction to Excel
· Understanding the Excel interface
· Navigating the Ribbon and Tabs
· Creating a new workbook
· Saving and opening workbooks
Basic Operations
· Entering and editing data
· Formatting cells (number format, alignment, font)
· Basic cell operations (cut, copy, paste, drag-fill)
· Using AutoSum for quick calculations
Formulas and Functions
· Understanding formulas and functions
· Basic arithmetic functions (SUM, AVERAGE, COUNT)
· Relative and absolute cell references
Working with Data
· Sorting and filtering data
· Inserting and deleting rows and columns
· Basic data organization techniques
Charts and Graphs
· Creating simple charts (column, line, pie)
· Formatting chart elements
· Inserting and modifying chart titles and labels
Printing and View Options
· Adjusting page setup for printing
· Using print preview
· Setting print areas and printing selected ranges
Introduction to Tables
· Creating and managing tables
· Using table styles
· Basic table operations (sorting, filtering within tables)
Copyright © 2026 DITRP INDIA. All Rights Reserved
