Basic Excel Foundation Course In Hindi
Learn with Manoj Kumar
9 modules
Hindi
Certificate of completion
Lifetime access
Master the fundamentals of Excel for data manipulation and analysis.
Overview
Learn the basics of Microsoft Excel, a powerful spreadsheet software used for data manipulation and analysis. This course will cover essential skills such as navigating the Excel interface, creating and formatting spreadsheets, performing calculations, and using common functions and formulas. By the end of the course, you will be able to efficiently manage and organize data, create professional-looking charts and graphs, and perform basic data analysis.
Key Highlights
Navigate and understand the Excel interface
Create and format spreadsheets
Perform calculations and use formulas
Create professional charts and graphs
Analyze data effectively
What you will learn
Learning Outcome 1
Understand the basic functionality of Excel and navigate its interface with ease.
Learning Outcome 2
Create and format spreadsheets, enter data, and manage worksheets efficiently.
Learning Outcome 3
Perform calculations using basic arithmetic operators, functions, and formulas.
Learning Outcome 4
Create professional-looking charts and graphs to visually represent data.
Learning Outcome 5
Analyze and manipulate data effectively using Excel's built-in features and tools.
Modules
Introduction to Excel
3 attachments • 13.42 mins
Working with Worksheets
4 attachments • 45.15 mins
Creating and renaming worksheets
Entering data and formatting cells
Managing rows and columns
Using basic function and formulas
Formatting and Styling
3 attachments • 36.2 mins
Applying cell formatting and Conditional formatting
Basic formula applying
Creating and applying styles
Working with Tables
3 attachments • 23.83 mins
Freezing and Printing Tricks
Sorting and filtering data
Advanced filters
Charts and Graphs
1 attachment • 37.9 mins
Creating Basic charts
Formulas and Functions
4 attachments • 53.82 mins
Understanding formulas
Using basic functions
Working with references and ranges
V-Lookup Function
Data Analysis and Visualization
3 attachments • 24.83 mins
Visualizing data using spark lines
Creating PivotTables and PivotCharts
Visualizing data using slicers
Data Import and Export
3 attachments • 12.12 mins
Importing data from external sources
Exporting data to different formats attached with workbook
Share file in different format
Advanced Tools and Techniques
5 attachments • 1 hrs
Conditional formatting with formulas
how to maintain stock in excel sheet format
Full Year and Monthly Stock Balance with In/Out Record
Using macros for automation
Attractive dashboard | Simple & Dynamic Graph
Certification
When you complete this course you receive a ‘Certificate of Completion’ signed and addressed personally by me.
FAQs
How can I enrol in a course?
Enrolling in a course is simple! Just browse through our website, select the course you're interested in, and click on the "Enrol Now" button. Follow the prompts to complete the enrolment process, and you'll gain immediate access to the course materials.
Can I access the course materials on any device?
Yes, our platform is designed to be accessible on various devices, including computers, laptops, tablets, and smartphones. You can access the course materials anytime, anywhere, as long as you have an internet connection.
How can I access the course materials?
Once you enrol in a course, you will gain access to a dedicated online learning platform. All course materials, including video lessons, lecture notes, and supplementary resources, can be accessed conveniently through the platform at any time.
Can I interact with the instructor during the course?
Absolutely! we are committed to providing an engaging and interactive learning experience. You will have opportunities to interact with them through our community. Take full advantage to enhance your understanding and gain insights directly from the expert.
About the creator
Learn with Manoj Kumar
Rate this Course
₹ 999.00
₹1999
Order ID:
This course is in your library
What are you waiting for? It’s time to start learning!
Wait up!
We see you’re already enrolled in this course till Lifetime. Do you still wish to enroll again?
