This comprehensive Microsoft Excel course is designed for individuals of all skill levels, from beginners looking to understand the fundamentals to advanced users aiming to master complex functionalities.
Participants will start with the basics, including navigating the interface, creating and formatting spreadsheets, and understanding essential formulas. As the course progresses, learners will explore more advanced topics such as data analysis with PivotTables, conditional formatting, chart creation, and automation using macros.
1. The 3
Freezing Techniques; working with Cell Reference.
a.
Relative Reference
b.
Absolute Reference
c.
Mixed Reference
2. Conditional
Formatting
a.
Number Conditional Formatting
b.
Text Conditional Formatting
c.
Editing existing conditional Formatting
d.
Conditional formatting with custom rules
3. Cut,
Copy, Paste and paste special
a.
Paste as values Paste
as format
b.
Paste as Link Paste
Data Validation
c.
Paste Transpose Paste
as Object
4. Format
Range as Table Object and Its benefits
5. Find,
Replace and Go To Special
6. Learning
Excel Function(s)
a.
Text Category Functions Date Category Functions
b.
Lookup Functions
Logical Functions
c.
IF and Nested IF Mathematical
functions
7. Summarization
of RAW Data
a.
Pivot Table
b.
Calculated Fields
c.
Calculated Items
d.
Pivot Chart
8. Formatting
of Worksheet and Cells
2025-11-15
2023-08-04
Excellent teaching by Abdul Sir
2024-07-01
Good
2024-06-09
good
2024-03-05
good
2024-07-04
good
2025-07-16
Informative
2024-08-06
Informative
2023-05-08
Really liked the way different visuals were explained
2024-02-12
Awesome training and an awesome trainer. One of the best training modules ever.
2024-03-14
Todays class was good. I appreciate his patience. making sure we are following him in the tool
2025-04-11
He is good & good explanation also.
2024-03-20
GOOD
2025-02-01
Great class to start.
2023-04-15
Good
2025-03-04
Good
2023-01-15
Excellent
2025-10-13
NA
2025-01-05
Abdul is answering everyone's questions with ultimate patience and explaining each topic with clarity.
2023-07-04
nicely explained
2024-10-07
Answers all queries very well
2023-07-06
Very Interesting session
2023-09-08
Very Knowledgeable Faculty
2025-07-08
Very experienced Faculty
2023-06-02
Experienced faculty
2024-04-17
Awesome Faculty
2024-12-03
good
2025-05-20
good
2024-10-13
excellent.
2025-05-01
Excellent
2024-04-09
in powerBI service the windows credential and gateway were not connecting even though the credentials were CORRECT.
2024-01-06
Not cover all topics
2025-09-01
Neatly organised and at good pace
2023-04-04
Need reference resources to explore and study rest of the menu options in PowerBI.
2024-03-15
Very patient and maintains good pace.
2024-03-09
Good Explanation
2023-06-20
Nice explanation
2023-06-10
Very jovial and funny and keeps the sessions alive while explaining concepts clearly
2025-11-03
Good informational session
2025-04-13
Very detailed explanation of Filters. Thank you!
2024-07-04
Way of teaching, and pace of teaching is good.
2025-10-16
Instructor was fantastic.
2024-10-12
Very Good
2024-02-16
excellent
2024-06-14
good
2024-04-05
good
2025-06-02
Interesting Session
2025-04-02
AMAZING SESSION
2024-10-06
AMAZING SESSION
2024-08-18
good session
2025-07-01
good
2025-06-20
Class was good. Detailed explanation slowly and study.
2023-11-16
Great Session
2025-09-11
Average
2025-03-01
excellent
2024-09-02
overall very interactive and amazing educator
2023-03-18
GOOD
2023-06-05
It's nice lecture on Data Modal.
2023-12-11
great instructor
2023-04-12
The instructor appears to exhibit strong bias, consistently failing to acknowledge my presence or address my inquiries. Consequently, I made the decision to withdraw from the prior class prematurely. Despite feigning engagement, it is evident that the instructor's responses are often tinged with bias.
2023-12-03
the instructor is here to train everyone to be competent,if he is too fast as i saw today,then the essence is lost.those who understand or have used or know the BI have to wait ,why are they here if they cannot be patient. the fast learners can afford to go to self learning but by coming to live class they have to allow all the other to learn at same pace.if its too fast then the essence of live class is missed,live class is for slow or new learners so they have the human and teacher input and get to clarify issues.Am not exact pleased and all all of us need to leave the class as being competent
2025-03-06
Class is good, however you should make some improvement in support system, I have raised ticket for the query two days back, still not resolved.
2023-10-16
good
2025-08-19
good
2024-12-18
Why does he have to repeat every sentence twice atleast twice.
2023-02-13
Excellent
2025-04-07
excellent
2024-08-10
excellent
2024-02-19
excellent
2023-04-03
It is good to know about new things.
2025-09-15
GOOD
2023-08-01
GOOD
2025-10-17
very patient in clearing our queries
2024-10-16
I don?t know about that, as I had the problem to connect audio. Please look into the matter, as I missed the class because of the inability to connect audio
2025-10-01
Today was a very interesting sessions with many functionalities of Power Bi. Truly enjoyed it! Thank you, Abdul!
2024-08-18
Hi, I am Rekha living in UK. I am really happy with the lecturer, and simple way of explaining practical. But unfortunately, I have to attend the class late (1 hour) due to time differences. Here and India time difference is 5 and half due to winter we are one hour advance from normal BST. I am working till 4pm and the exact start of the class is 3pm from here.
2025-01-07
best
2024-07-13
best
2024-10-13
best
2024-11-08
best
2025-04-18
best
2024-08-20
best
2023-07-10
best
2025-08-17
The Instructor was between Average & Below Average - needs improvement
2024-06-01
Good
2024-02-10
Good
2024-01-14
good
2025-06-17
iam just lost in this class
2025-04-11
enjoyed today's class
2025-04-20
great
2024-12-05
good
2023-09-05
You made this easy to understand and enjoy throughout the class. The course is structured in a very good way .
2023-12-04
Was interactive class
2023-10-07
might be good for beginner level, only basics are being taught, advanced dax queries are not being taught
2024-09-20
good
2025-12-20
the why of teaching is very good.
2025-03-14
excellent session...great teaching by Abdul. sir .he is amazing and very patient in explaining things...
2023-04-05
everything good ...please share excel formulas in notepad and tell something about microsoft office365
2023-11-20
Best way of teaching really enjoyed it
2025-06-15
over all good
2023-11-13
explanation was good
2023-12-01
over all teaching was the best
2023-07-18
very nice explanation
2025-03-06
na
2024-02-13
In between I'm facing some voice issues, but let me check recording.
2024-09-13
It was good
2024-12-12
Superb Training- Ideal for what was needed
2023-03-17
It's nice
2025-10-12
some concepts are not able to understand
2024-04-04
excellent
2024-01-05
ok
2024-02-14
Good
2024-05-08
Good
2023-06-07
Trainer is very knowledgeable and explains every aspect in very simple words so that everyone can follow.
2024-10-07
VERY CLEAR EXPLANATION OF DAX
2024-01-04
The instructor is easy to follow as his lectures are steady and comprehensive
2023-11-20
AWWESOME TEACHING METHOD WONDERFUL TUTOR
2023-09-09
good
2024-12-16
cleared all the doubts
2025-12-11
It is good experience.
2023-12-03
The instructions is clear and easy to follow
2025-08-07
Today's class was quite interesting. First, he explained how to use stairs of the building to go to top floor and at the end told us another option is lift ... Knowing the basics very important.
2025-05-05
good one
2024-05-15
highly patient trainer.. Expalins in details
2025-01-16
The instructor is very knowledgeable in the course at hand and goes all out to explain clearly. i am happy to be in this class.
2025-04-02
great
2024-06-10
clearly explained
2023-06-08
Clearly explaining each and every point, also addressing query's
2025-06-15
'If you learn you can earn'. Thank you very much.
2025-04-04
Simple and lucid expl by Abdul
2023-10-20
Excellent
2024-01-01
Excellent by Abdul
2025-02-15
Good and to the point
2023-04-02
Some people are really slow and don't understand the instructor's command due to which they lag behind eating up others time
2024-03-07
It was really good experience but if LMS access would have given before this class it would have even better to go through some prerequisite
2024-03-18
Thank You
2024-07-19
The instructor is very thorough in his knowledge and he really knows how to go in a flow in class that no one is lagging and neither the fast paced ones are bored . All Queries are answered ...looking forward to other classes as well as this was first weekend!!
2025-01-19
He delivers his teaching with clarity and at the right pace.
2024-12-15
Not able to catch up with the instructors pace ,moving fast,leaving less time for practice
2025-12-08
step by step professional teaching
2024-03-05
well explained class.
2023-01-19
He is taking all together
2024-04-15
good
2025-05-18
Good Session & adopt good Practical know
2024-10-14
excellent a deep intro about the Power BI introductions
2025-01-16
Need to cover full tOPIC
2025-03-06
He is going little too fast and does not entertain queries
2025-01-02
Getting into PowerBI and learning the real power of it. Examples and hands-on are going well.
2023-11-12
Class is going well. Overall quality till now is better than expected.
2025-05-10
The class was really good today. Got a new view.
2024-11-08
NA
2025-09-01
Excellent, really.
2024-12-09
Good Instructor
2023-01-14
Nice Session
2025-04-19
Pace can be increased, it will be good if some real dataset can be used rather than traditional superstore as many free YT videos using the same sample superstore data.
2023-12-20
A bit slow
2023-12-08
Everything is good and i am new to this formulas . I never had experience in writing any Excel functions also. So it is taking me little time to get all the things.. Thanks.
2024-12-07
None
2023-02-10
Good feedback today. Very interactive.
2025-03-01
The changes that were made created significant issues for me, and I 'lost' all my original work.
2025-09-13
A LOT of info to digest in a short amount of time. PBI is MUCH more complex (impo) than other reporting tools, such as SAP Crystal Reports. I have had severe time constraints on my PBI training (outside of the classes, of which I have missed none), due to priorities on my current project engagement. I have not had the time to fully devote to actually working on/with PBI as much as I would like (I learn best by doing & figuring things out vs just instructions - instructions show you HOW to do things, but that does not necessarily provide you with the WHY things work the way they do - that can only come from comprehensive and intense usage). This course is also critical to the engagement work I am doing, though I am concerned that with the current delivery demands of my engagement, I will not have sufficient time to devote to actually *learning* all the aspects of PBI that I need to within the given timeframe.
2025-11-03
can not judge by first day of class. one thing I wanted to know that I have been informed that the classes would be 3 hrs long but my instructor told today that it will be only for 2 hrs. pls do as you promised at admission time.
2023-12-14
It was a first day and trainer explained the introduction of the course and it was well explained
2024-09-02
Trainer is good and the way he is taking the classes it very interesting as of now He clear the doubts as well
2023-05-14
excellent
2023-09-09
Great pace, tonality, and doubt clearing
2025-08-12
Power Query should include at least two or three classes, as it is a crucial component. However, the current course only covers it in 30 minutes. I don?t believe this brief overview is sufficient for gaining expertise in Power BI. In fact, even free YouTube tutorials provide more comprehensive information than this course.
2025-01-09
i suggest to instructor Please unmute Mic all user ID we can able to ask query through voice instead of chat .
2024-12-15
Good work
2025-08-14
Impressive
2023-03-14
GREAT STYLE OF LECTURES
2025-09-17
he did not solve my queries
2023-02-09
our instructor teaching us
2023-09-10
Average
2025-08-18
Good
2024-08-15
Good
2024-11-16
speed is slow, not sure if whole syllabus will be done properly in given time
2024-11-03
speed can be increased
2025-02-07
good. early to say all.
2024-04-06
good
2023-06-12
good
2023-01-18
strict
2025-05-13
fine
2024-10-09
slow pace
2025-02-10
Pace has improved based on feedback
2025-01-16
Today's overall class was so engaging.
2025-11-13
The Class was very interesting, and the Instructor explained every topic so patiently.
2024-03-03
Visualization class was very interesting. Instructor explained it very well.
2025-04-05
2023-11-13
For each DAX function need much more sample workouts
2024-07-10
need more example for each topic one day only basic things was taken by the trainer for DAX , Data modelling .
2025-12-07
Good
2023-12-11
Good
2023-02-11
Good
2024-11-02
It was a good session.
2023-05-07
Very Clear and concise. Easy to follow.
2025-04-06
Best teacher
2023-01-12
Good knowledge has been shared
2024-05-03
interesting
2023-02-19
excellent
2023-07-06
Over all good
2024-12-13
EXCELLENT
2024-09-09
VERY PROFESIONAL TUTOR AWWSOME LECTURES WONDERFUL TEACHING METHODOLOGY
2023-01-01
Trainer sometimes doesn't address the query on real time basis,because we have to chat so if not addressed then and there will create some problem
2023-09-09
Please try to reduce Q&A time. Currently we do about 40% of out session time to Q&A, Please reduce it to 20% so we will get most of time to explore new learnings. Ask people to repeat/learn from video recordings or technical support tickets.
2024-10-13
Yesterday's Feedback was a suggestion not a negative feedback.
2023-12-06
it was best and informative class!!! satisfied.!
2024-10-12
Instructor explain very good and clear all the doubts .
2025-08-08
fine
2023-06-06
ok
2025-06-11
great
2023-04-08
satisfactory
2025-01-04
very well explained, easily understandable.
2024-10-16
very interesting session, was able to understand & follow the steps ..
2024-04-17
he did not solve my queries
2025-12-19
Good knowledge has been shared
2023-08-10
interesting
2023-05-13
Done some interesting work
2024-01-18
.
2023-02-20
.
2024-11-16
good
2023-10-14
good
2025-09-19
Good. Can follow properly. while watching and doing simultaneously, stuck somewhere, getting no help. I m a learner. Request : Lets learn minimum. more can be of my own. Basic learning is missing. If I m not performing, then whom to ask ? I cant do many basics as stuck off somewhere.
2025-11-10
good session. clarified properly.
2023-05-02
Instructor quality need to be improved
2024-07-04
Detail, pace, structure
2023-03-18
Great QA
2025-02-06
Pace has improved based on feedback
2023-12-01
Excellent Demo about the PowerBI Data Visualization
2025-11-12
slow pace
2024-08-16
Great experience again
2023-01-03
great expirence
2025-09-20
The class is good. I wish the instructor would finish with how to save the work so we are ready to continue with the next day. Overall, im liking the class. I dont take it personal as to feeling like Ive been used for money and the interest is not in my understanding. Its my funding. The class is good and so far correct. Im about application and real life
2024-11-01
INstructor seems to be teaching a distinct few students and talking at others. I spent 200 bucks, and I feel sometimes its not about me or my interest. Im remote, in USA and the emphasis is not on making sure remote students needs are met
2023-09-19
good session
2023-06-05
Really started showing the power of Power BI. Enjoyinh the class. It helps to see the concepts and then revisit later. I never realized it could do this much
2025-07-01
I could not do prt ppf the exercise due to my version of Power BI
2024-01-13
Porject files have been provided. Instructor was helpful and understanding
2025-05-19
Best,!!!!!!!
2025-07-13
Great
2023-02-02
Average
2024-09-02
Good
2024-06-11
Good
2024-04-09
good teaching
2023-06-12
Power Query should include at least two or three classes, as it is a crucial component. However, the current course only covers it in 30 minutes. I don?t believe this brief overview is sufficient for gaining expertise in Power BI. In fact, even free YouTube tutorials provide more comprehensive information than this course.
2023-03-14
Nice instructor , Too many students not able to intract with trainer
2023-08-14
Nice instructor , Too many students not able to intract with trainer
2024-10-18
What we expected from instruter we did not got any good answers
2025-08-09
Good
2025-01-07
Good
2023-04-11
little slow, Not sure if would complete syllabus in given time
2024-02-14
It was a good introduction session.
2023-09-16
It was a good session.
2024-09-13
I was a good session
2023-06-10
I was good session, looking forward for tomorrow's session
2025-11-04
Learned new things today
2024-08-19
Very simply explained.
2025-01-04
Todays class was very interesting. Instructor explained every topic very well.
2024-02-12
Todays class was interesting. Got to know about Gateways. Instructor explained very well.
2024-07-18
Todays concepts are very interesting. Instructor explained patiently.
2023-04-13
worked on mini project
2025-02-20
need more example for each topic one day only basic things was taken by the trainer for DAX , Data modelling .
2023-11-07
2024-02-02
Easy to learn very impressive
2023-12-08
Good work
2024-06-17
Impressive
2024-09-08
Good
2024-10-05
Good
2025-07-14
Good
2025-03-07
Good
2025-09-08
Good
2025-11-02
Good
2024-03-09
First two lectures was very good
2024-05-13
Good
2024-05-07
Good
2023-07-12
Good
2024-08-14
Excellent
2023-07-01
Excellnt
2025-03-12
Excellent pace & good and clear explanation of formulas
2024-09-19
Good Session
2023-08-15
Excellent session & excellent trainer
2023-05-14
Good session
2025-10-03
good
2025-01-05
He is good
2023-04-07
I will attend (rejoin) the class record so I may have a clear info's about Tody's classes
2025-05-18
Today, there were more technical issues, and I only understood 20%. so, I will double-check the records as usual and repeat the steps until I become familiar with them.
2024-05-01
good quality and covering important things
2025-04-09
can not judge by first day of class. one thing I wanted to know that I have been informed that the classes would be 3 hrs long but my instructor told today that it will be only for 2 hrs. pls do as you promised at admission time.