Excel from Basics to Analysis Course
Learn Excel from Basics to Analysis and make Data Analysis using Excel
Updated on Oct, 2026
Language - English
AI Assistant
Lectures -33
Resources -40
Duration -1 hours
Lifetime Access
Lifetime Access
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
About the course:
In this course, there are video class sessions, downloadable Excel files for practice, and steps PDF files. There are 14 class sessions. You can watch the class session video for a particular topic and then download the Excel file for practice, and then practice in it with the help of the step-by-step PDF file, likewise, do it for all topics and subtopics. This course was prepared with Microsoft Office 2019. I wish you success. Happy Learning.
Course Content:
Class Session 1 - Introduction to Excel
Class Session 2 - Filling a Series
Class Session 3 - Filter
Class Session 4 - Format Change
Class Session 5 - Cleaning Data in Excel
Class Session 6 - Five Functions
Class Session 7 - IF, IFS
Class Session 8 - Sum IF, Sum IFS, MaxIFS
Class Session 9 - Hlookup
Class Session 10 - Vlookup
Class Session 11 - Pivot Table
Class Session 12 - Pivot Chart
Class Session 13 - Slicer
Class Session 14 - Timeline
Goals
Understand the basics of Microsoft Excel for Analysis and perform Data Analysis using Microsoft Excel.
Prerequisites
Basic Computer Knowledge.
Curriculum
Check out the detailed breakdown of what’s inside the course
Course Introduction Video
1 Lectures
-
Course Introduction
01:52
01:52
Introduction to Excel
2 Lectures
Filling a Series
2 Lectures
Filter
2 Lectures
Format Change
2 Lectures
Cleaning Data in Excel
4 Lectures
Five Functions
3 Lectures
IF, IFS
3 Lectures
SumIF, Sum IFS, MaxIFS
2 Lectures
Hlookup
2 Lectures
Vlookup
2 Lectures
Pivot Table
2 Lectures
Pivot Chart
2 Lectures
Slicer
2 Lectures
Timeline
2 Lectures
Instructor Details
Sirajudeen AbdulRahim
I am Sirajudeen Abdul Rahim. I have completed Accountancy in all three levels of the Chartered Accountancy Examination from "The Institute of Chartered Accountants of India".
Course Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now