Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
0 Hour(s) 38 Minute(s)
Language
English
Taught by
Gaurav Tatwawadi
Rating
Course Overview
Master Excel functions, lookups, pivot tables, data analysis and shortcuts to improve productivity and decision making
This course is designed for people who are completely new to Microsoft Excel or have only basic knowledge of it.
By the end of this course, you will be able to confidently use Excel for most real-world tasks — from everyday calculations and data organization to analysis and reporting.
In this course, you will learn:
• Basic Excel concepts and commonly used functions
• Advanced functions such as IF, SUMIF, COUNTIF, along with financial and statistical tools
• Lookup functions including VLOOKUP and HLOOKUP
• Data analysis techniques using Goal Seek and Pivot Tables
• Formatting techniques to make your spreadsheets clean, structured, and professional
• Time-saving shortcuts to improve speed and efficiency
Excel is one of the most important tools used across industries today. Whether you are a student, working professional, entrepreneur, finance graduate, manager, filmmaker, or executive, Excel skills can significantly improve how you work with data and make decisions.
This course will help you:
- Simplify repetitive tasks
- Organize and analyze information effectively
- Create basic dashboards and reports
- Improve productivity in your day-to-day work
While macros are introduced at a conceptual level, the primary focus of this course is to help you build a strong Excel foundation. Once you are comfortable with the core concepts covered here, you will be better prepared to explore advanced automation and VBA in the future.
Course Content
- 1 section(s)
- 6 lecture(s)
- Section 1 Microsoft Excel
What You’ll Learn
- Basic excel functions, Pivot table, Vlookup Hlookup, shortcuts, Formatting, basics of VBA
Skills covered in this course
Reviews
-
ggaurav rawat
Could have used bit more examples, but its good
-
KKausar Multani
it is an awesome course for a beginner like me as i was not familiar with excel before, another thing is the speed of this course.......he is teaching so smoothly not too fast and not too slow ......and personally i also liked his accent because the words are quite clear and easily understandable.
-
PParas Bhatia
it was a good n simple way of learning excel.
-
MMukthar Ahamed S
Was not up-to the level of expectation and the amount charged. Could be better by giving more detailed explanation on the Level 4
