From Intermediate to Expert – Automate, Analyze, and Impress with Excel
This course is perfect for learners who have a basic understanding of Excel and want to upgrade their skills to a professional level. Learn to handle large data sets, perform powerful data analysis, use advanced formulas, create dashboards, and automate tasks using macros and pivot tables.
🌟 What You’ll Gain
✅ Deep Knowledge of Advanced Functions
Use VLOOKUP, HLOOKUP, INDEX-MATCH, and nested logical functions.
✅ Data Analysis & Summarization
Master Pivot Tables, slicers, charts, and advanced filters.
✅ Automation with Macros
Record and run macros for repetitive tasks.
✅ Dashboard Design Skills
Build interactive and professional-looking dashboards.
✅ Corporate-Level Excel Proficiency
Gain the skills demanded in MNCs and analyst roles.
📋 Course Details
- Duration: 10 Weeks
- Schedule: Weekends (2 hours/day – Saturday & Sunday)
- Fee: ₹4,000/-
- Mode: Offline / Online / Hybrid
- Eligibility: Completion of Excel – Basic or equivalent knowledge
🗓️ Weekly Course Structure
Week 1: Advanced Formulas Recap
- Nested IF statements
- Logical functions: IF, AND, OR revisited
- Absolute and mixed cell references
- Troubleshooting formula errors (TRACE, EVALUATE)
Week 2: Lookup Functions Mastery
- VLOOKUP and HLOOKUP
- INDEX & MATCH (faster, flexible alternative)
- Using lookup formulas with data validation
- Common lookup mistakes and how to avoid them
Week 3: Advanced Text and Date Functions
- TEXT, LEFT, RIGHT, MID, LEN, FIND, CONCAT, TEXTJOIN
- DATE, TODAY, NOW, DATEDIF, NETWORKDAYS
- Cleaning messy data (TRIM, CLEAN, SUBSTITUTE)
Week 4: Pivot Tables & Pivot Charts
- Creating and customizing Pivot Tables
- Grouping, sorting, and summarizing data
- Inserting Pivot Charts
- Slicers for interactivity
Week 5: Data Tools & What-If Analysis
- Goal Seek
- Scenario Manager
- Data Tables (one-variable and two-variable)
- Solver tool introduction
Week 6: Data Cleaning & Protection
- Remove Duplicates, Flash Fill
- Text-to-Columns
- Protecting sheets, locking cells, passwords
- Hiding formulas and sheets
Week 7: Introduction to Macros
- Recording your first Macro
- Assigning Macros to buttons
- Relative vs. Absolute Macros
- Macro examples: attendance automation, email formatting
Week 8: Dashboard Design (Part 1)
- What makes a good dashboard?
- Designing with purpose: layout and formatting
- Using PivotTables, slicers, and charts together
- KPI Indicators and sparklines
Week 9: Dashboard Design (Part 2)
- Building a full interactive dashboard project
- Using scroll bars, drop-downs, and buttons
- Final dashboard creation and presentation
Week 10: Final Assessment & Certification
- Build an automated report with formulas and macros
- Create a mini dashboard with live data
- Present your project to the class
- Certificate distribution and personalized feedback
📝 Assessments & Activities
- Weekly advanced worksheet assignments
- Formula debugging challenges
- Macro recording & implementation tasks
- Final project: Dashboard + Macro automation
- Viva on applied Excel knowledge
🎁 Extra Perks
- 100+ Ready-to-use Excel Templates (Dashboards, Finance, HR, etc.)
- PDF Handbooks: Advanced Functions + Lookup Cheats
- Macros & VBA Beginner’s Toolkit (Code Snippets & Use Cases)
- Lifetime Access to Excel Pro Tips Library
- Internship/Live Project Support (optional for students)
🔐 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 ₹4,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