Learn Excel Online: Free Course with AI Tutor & Certificate
Analyze data and build interactive charts from scratch. This free Excel course takes about 6 hours to complete across 43 video lessons. You'll start with basic data entry and progress to advanced formulas, giving you practical skills to manage worksheets and format cells efficiently.
What you'll learn in this Excel course
Five concrete outcomes you'll walk away with, each mapped to modules in the curriculum below.
Navigate and utilize the Excel interface effectively.
Format cells, manage data, and create charts and graphs.
Manage and analyze data using sorting, filtering, and pivot tables.
Understand and apply advanced formulas and functions, including logical and statistical functions.
Collaborate, protect workbooks, and import/export data from external sources.
Excel course syllabus
01 Introduction to Excel
- What is Excel?
- Navigating the Excel Interface
- Understanding Workbooks and Worksheets
- Basic Excel Terminology
02 Basic Data Entry
- Entering Text and Numbers
- Using Autofill
- Editing and Deleting Data
- Saving and Opening Workbooks
03 Formatting Cells
- Changing Font and Size
- Applying Cell Borders and Colors
- Number Formatting
- Aligning Text
04 Basic Formulas and Functions
- Introduction to Formulas
- Using Basic Functions (SUM, AVERAGE)
- Copying Formulas
- Understanding Relative and Absolute References
05 Working with Rows and Columns
- Inserting and Deleting Rows and Columns
- Adjusting Row Height and Column Width
- Hiding and Unhiding Rows and Columns
- Freezing Panes
06 Managing Worksheets
- Moving and Copying Worksheets
07 Data Sorting and Filtering
- Sorting Data
- Filtering Data
- Using Advanced Filter Options
08 Introduction to Charts
- Creating a Simple Chart
- Customizing Chart Elements
- Using Sparklines
09 Basic Data Analysis Tools
- Using Conditional Formatting
- Introduction to PivotTables
- Using Data Validation
- Creating Basic Data Tables
10 Printing and Sharing Workbooks
- 1 Setting Print Areas
- 1.1 Defining Print Areas|Explain how to select specific areas of a worksheet for printing.
- 2 Adjusting Page Layout
- 2.1 Setting Margins and Orientation|Discuss how to adjust margins and page orientation for printing.
- 2.2 Adding Headers and Footers|Explain how to include headers and footers in printed worksheets.
- 3 Printing Worksheets
- 3.1 Printing Selected Worksheets|Explain how to print specific worksheets from a workbook.
- 3.2 Printing Entire Workbooks|Discuss how to print all worksheets in a workbook at once.
- 3.3 Troubleshooting Printing Issues|Highlight common printing problems and how to resolve them.
- 4 Sharing Workbooks
- 4.1 Saving Workbooks for Sharing|Explain how to save workbooks in formats suitable for sharing, such as PDF.
- ==================
Real-world projects you'll work on
Practice the exact kind of work Excel professionals do on the job.
Data Analysis and Visualization for Sales Performance at a Global Tech Giant
Financial Modeling and Forecasting for a Leading Startup's Growth Strategy
Optimizing Inventory Management and Supply Chain Efficiency for a Multinational Retail Corporation
Collaborative Decision-Making and Data Security for a Cutting-Edge Tech Startup
Skills you'll gain
Add these to your LinkedIn profile and resume the day you finish.
Who should take this Excel course?
And exactly what you need before starting (spoiler: almost nothing).
This course is for
- College students looking to add practical spreadsheet skills to their resumes before graduation.
- Working professionals in India who want to speed up their daily reporting and data management tasks.
- Career switchers moving into data entry, business analysis, or administrative roles.
Prerequisites
- No prior spreadsheet experience is required to begin this course.
- A computer or laptop with Microsoft Excel (or a free alternative like Google Sheets) installed.
- A stable internet connection to watch the video lessons and take AI quizzes.
How learning works on LearnTube
The structure of a bootcamp, the price of free.
AI curates your path
Our AI picks the top 1% of video content for each topic and arranges it into a structured, goal-based curriculum. No more tutorial roulette.
Learn, then get quizzed
After every lesson, your AI tutor asks you a question and gives personalised feedback on your answer, so gaps get fixed immediately.
Finish with proof
Complete the course, build the capstone project, and claim a certificate recognised by 900+ hiring partners.
A complete Excel course: free, structured and job-focused
Format cells, manage large datasets, and create visual charts to track performance. You'll build these exact skills through our free online Excel classes. The curriculum begins with a simple "What is Excel?" lesson and moves through 10 structured modules. You will learn to use basic formulas and functions, work with rows and columns, and apply data sorting and filtering techniques to organize information. We also cover managing worksheets, basic data analysis tools, and printing and sharing workbooks to ensure your reports look professional.
Practical application is central to this Microsoft Excel training. You'll complete hands-on projects based on real business scenarios to test your new abilities. These include data analysis and visualization for sales performance at a global tech giant, as well as financial modeling and forecasting for a startup growth strategy. You will also tackle optimizing inventory management and supply chain efficiency for a multinational retail corporation.
LearnTube makes mastering this tool highly interactive and accessible. We pair curated YouTube videos with an AI tutor that tests your knowledge as you go. You will take a quick quiz after every single lesson to reinforce your memory and catch mistakes early. The entire learning experience is free, allowing you to study at your own pace. Once you complete all 43 video lessons, you can choose to purchase an optional certificate to display on your resume.
Jobs you can target after learning Excel
Excel is a gateway skill for some of the fastest-growing roles in tech.
Inputs, updates, and maintains accurate records in company databases and spreadsheets.
Analyzes company data to help management make informed financial and operational decisions.
Evaluates financial data and builds forecasting models to guide investment strategies.
Generates daily performance reports and manages information systems for corporate teams.
Typical entry-level salary ranges in India as of July 2026. Actual compensation varies by city, company and experience.
Earn a Excel certificate employers recognise
Finish the course and claim a certificate you can share anywhere.
- Learn 100% free: every lesson, quiz and the AI tutor cost nothing
- Claim your certificate when you complete the course (an optional paid add-on)
- Recognised by 900+ hiring partners across India
- One click to share on LinkedIn and add to your resume
Why learners choose LearnTube
Real reviews from Google. You learn free, you get assessed free, and you pay only if you want the certificate.
Though I have 11 years of experience as an HRBP, the course helped me refresh my knowledge and gave me insights into new trends in the market. The modules were clear and easy to understand, and the quizzes were well designed. I have added the certificate to my LinkedIn profile.
I had a lot of doubts while learning, but the AI chatbot answered them in detail with simple summaries. The videos on the platform saved me a lot of time as I didn't have to search YouTube and watch random content.
Just earned my certificate in HR Management from LearnTube.ai! The platform is user-friendly and the assessment was a great way to validate my knowledge. Feeling proud of this accomplishment!
I enrolled in a LearnTube personalized course to get into a Data Analytics role. It helped me learn SQL in depth and gave me hands-on experience with Power BI. I attached the LearnTube certificate to my CV, it added credibility to my profile, and I'm currently in the interview process.
The interface is user-friendly and intuitive, making it easy to navigate the course. I encountered no errors during my time using the platform, which was a refreshing change from other online learning platforms.
Just cleared the Business Analyst assessment and got certified! Loved how the course simplifies big concepts like data-driven decision making into short, practical lessons. The automated quizzes kept me on track the whole time. Perfect boost for my resume!
The certificate gave me a real edge during my B.Tech. By the time I graduated, I had skills that set me apart from my peers, and the certification opened up more job opportunities. It gave me the confidence to stand out during interviews.
I manage many software projects as a General Manager and was looking for a good certification program to stay competitive. After researching many programs, I chose LearnTube and it was much better than I expected. The material is well-organized and practical, and what I liked most is the lifetime access.
Frequently asked questions
Everything learners ask before starting this Excel course.
Is this a free excel course with certificate?
It's entirely free to learn. You can watch all 43 video lessons and take the AI quizzes at no cost. The official certificate of completion is an optional paid add-on you can purchase after finishing the modules.
How long does it take to learn Excel?
This specific tutorial takes about 6 hours to complete. You can progress through all 10 modules at your own pace, making it easy to fit the video lessons and hands-on projects into a busy schedule.
Can I watch the Excel online classes on my phone?
Yes. The LearnTube platform is fully optimized for mobile devices. You can watch the curated video lessons, interact with the AI tutor, and complete your quizzes on any smartphone or tablet with an internet connection.
What projects will I build in this Excel training?
You will complete practical assignments. These include analyzing sales performance data for a tech company, building a financial forecasting model, and optimizing supply chain efficiency for a retail corporation using basic data analysis tools.
Do I need prior experience for this Excel course for beginners?
No prior knowledge is needed. The curriculum starts with a basic "What is Excel?" lesson and slowly introduces data entry, cell formatting, and simple formulas before moving on to advanced charts and filtering techniques.
Is Microsoft Excel still a good skill to learn?
Yes. Almost every modern business relies on spreadsheets for organization and reporting. Mastering these tools makes you highly valuable for roles in finance, marketing, human resources, and operations across the Indian job market.
Will I learn how to create charts and graphs?
Absolutely. The eighth module is dedicated entirely to an introduction to charts. You will learn how to turn raw spreadsheet data into clear visual formats that make complex information easy to read and present.
Learners also explore these free courses
Pair Excel with a complementary skill to stand out even more.
Start learning Excel today, for free
43 lessons, an AI tutor that never gets tired, and a certificate at the finish line. All you need is an hour a day.
Start Learning Free