Master Spreadsheets from Scratch – Learn to Use Excel with Confidence
This beginner-friendly course is designed for absolute newcomers or self-taught learners who want to master Microsoft Excel fundamentals. Whether you’re a student, office worker, business owner, or homemaker, this course helps you become proficient in handling data, performing calculations, and presenting information clearly.
🌟 What You’ll Gain
✅ Mastery Over Excel Basics
Understand the layout, navigation, formatting, and essential tools.
✅ Strong Foundation in Formulas
Perform calculations, use functions like SUM, AVERAGE, COUNT, and troubleshoot errors.
✅ Data Organization Skills
Sort, filter, and structure data using tables and simple automation.
✅ Confident Use of Charts and Graphs
Create visually appealing graphs to present your work professionally.
✅ Real-World Practice
Build worksheets for attendance, expenses, reports, and more.
📋 Course Details
- Duration: 10 Weeks
- Schedule: Weekends (2 hours/day – Saturday & Sunday)
- Fee: ₹3,000/-
- Mode: Offline / Online / Hybrid
- Eligibility: Open to all (no prior experience needed)
🗓️ Weekly Course Structure
Week 1: Introduction to Excel & Interface Navigation
- Understanding the Excel workspace
- Workbook vs. Worksheet
- Rows, Columns, Cells explained
- Entering and editing data
- Keyboard shortcuts and productivity tips
Week 2: Formatting and Layout
- Cell formatting (bold, color, alignment, borders)
- Merge, wrap text, number formats (currency, date, % etc.)
- Format Painter and Conditional Formatting
- Basic page layout and print options
Week 3: Basic Formulas & Functions
- Introduction to formulas and cell referencing
- Common functions: SUM, AVERAGE, MIN, MAX, COUNT
- Order of operations (BODMAS in Excel)
- Using AutoSum and AutoFill
Week 4: Data Sorting & Filtering
- Sorting alphabetically and numerically
- Filter basics and custom filters
- Removing duplicates
- Practice with small data sets
Week 5: Working with Tables
- Creating Excel Tables
- Table styles and structured referencing
- Table filters and sorting
- Table-to-range conversion
Week 6: Charts and Graphs
- Creating column, bar, line, and pie charts
- Customizing chart elements (title, labels, legend)
- Choosing the right chart for your data
- Inserting sparklines
Week 7: Data Validation & Drop-down Lists
- Restricting inputs with validation rules
- Creating drop-down lists using Data Validation
- Error messages and tooltips
- Applying validation for marks entry, form inputs, etc.
Week 8: Basic Logical Functions
- IF, AND, OR basics
- Real-life applications of IF (pass/fail, salary calc)
- Nested IFs (intro)
- Hands-on examples
Week 9: Project Practice – Attendance & Expense Tracker
- Create a working Attendance Sheet with formulas
- Build an Expense Tracker with conditional formatting
- Practice using charts and data summaries
Week 10: Final Review, Projects & Assessment
- Recap of all key functions
- Final project: Create your own Excel report
- Oral presentation on what you built
- Certificate distribution and feedback
📝 Assessments & Activities
- Weekly hands-on assignments
- Mini Excel tasks (real data entry, tracking, formulas)
- Final assessment (Project & Viva)
- Performance feedback from trainers
🎁 Extra Perks
- Excel Shortcuts Cheat Sheet (PDF)
- Practice Excel Templates (Attendance, Budget, Sales, etc.)
- Access to Excel Learning WhatsApp Group
- Bonus: Excel Tips Video Pack (Lifetime Access)
🔐 Enrollment Process
- Register: Scan the QR code or click here to register via the Tricef app.
- Pay Securely: Use your mobile number to pay the ₹3,000/- course fee online.
🎓 Why Learn with Tricef?
💡 Experienced Trainers: Our instructors are passionate educators with rich experience in English language training.
🎯 Practical Approach: We focus on usable English—not textbook theory.
🤝 Supportive Atmosphere: You’ll learn in an encouraging, motivating environment that makes speaking English feel easy and natural.
📍 Center Address & Map
Tricef Institute of Language & Technology
Florence Cottage, 6/581, David Nagar, on Main Road,
Opposite to SRM Unavagam, KilPadappai, Padappai, Tamil Nadu 601301
📞 Phone: +91 76048 74233
🌐 Website: www.lingo.tricef.org
📍 View Us on Google Maps
Click here to open map