Day-Wise Curriculum Overview
Day 1 – PivotTables Basics & AI Assistance
- Create PivotTables from datasets
- Understand fields, layouts, and grouping data
- AI-assisted PivotTable suggestions and insights
Day 2 – PivotTables Formatting & Analysis
- Sorting, filtering, and summarizing data
- Calculated fields and items
- AI suggestions for faster analysis and error-checking
Day 3 – PivotCharts for Visual Insights
- Create PivotCharts linked to PivotTables
- Formatting charts for clarity
- Use AI to highlight trends and patterns
Day 4 – Slicers for Interactive Filtering
- Add, customize, and connect Slicers to PivotTables
- Multi-PivotTable filtering
- AI recommendations for effective slicer setups
Day 5 – Intermediate Project: PivotTables & Slicers Application
- Apply PivotTables, PivotCharts, and Slicers on a dataset
- Integrate AI assistance for analysis suggestions
- Review and mentor feedback
Get These Bonuses for Free
Step-by-Step Practice Prompts
Practical exercises and ready-to-use prompts to help you apply concepts quickly.
Top AI & Productivity Tools for Students
A curated list of AI tools and apps to simplify assignments, projects, and daily learning tasks.
Lifetime Access to Session Recordings
Revisit lessons anytime to revise and reinforce your understanding.
Comprehensive Learning Materials
All course-related documents, examples, and resources for hands-on practice.
Mr. Roshan Singh
Founder: Scrollwell
Experience: 05+ years in Innovative Teaching
Specialization: Innovative Teaching, Marketing, Finance
About Roshan:
Roshan is an experienced Graphic designer, Skilled in Business Planning, Microsoft Word, Microsoft PowerPoint, Microsoft Office, and Social Media Marketing and an ace automobile engineer, and MBA at National Institute of Technology, Jalandhar and created Scrollwell. Impacted 55,000+ Teachers and students and young professionals through my work over the past 1 year in classroom boot camps and online courses. has consulted various schools, organisations and companies for education related services from span geographies in India
Boot Highlights
Intuitive & Detailed Explanations
"Inspiring lectures with clear, concise, and engaging explanations."
HD Videos + Crystal Clear Audio
"Inspiring lectures with clear, concise, and engaging explanations."
Practice Exercises, Real-Time Feedback
"Improve skills with interactive exercises and instant feedback."
Lifetime Access, Pocket Friendly
"Long-term value with budget-friendly options for continued access."
Project-based learning
"Hands-on learning through practical projects and real world application."
Completion Certificate
"Official recognition of completion for added credibility and motivation."
Frequently Asked Questions
Who can join this course?
Students, professionals, and beginners who want to enhance their Excel skills and handle complex data tasks.
How will the classes be conducted??
Sessions are online, including live demos, interactive Q&A, and practical exercises.
Do I need prior AI experience?
No prior AI knowledge is required. All AI tools are beginner-friendly and integrated step-by-step into the course.
Will I receive a certificate??
Yes, a Certificate of Completion is awarded after meeting 80% attendance and completing at least one project.
Can I access the course recordings later?
Yes, you’ll have lifetime access to all recorded sessions, templates, and resources.