Microsoft Excel Course - Hindi
Offer Price
Buy Now
₹ 499 ₹ 1,000
- Recorded Sessions
- Live Doubt-Clearing sessions
Microsoft Office Tools
Microsoft Excel Course - Hindi
Hindi
An introduction to MS Excel and comprehensive explanation of all the fundamental concepts like tables, charts, conditional formatting and pivot table.
Duration
6 Hrs
Level
Beginner
Students
372
372
About this course
Harness the full potential of Microsoft Excel. Be comfortable navigating the Excel user interface and formatting data. Use formulas and functions to analyse data and present the results in a user-friendly way. Automate choices and data lookups using functions. Create charts and tables that effectively summarise raw data. Easy-to-use spreadsheets, data validation, find and correct errors. Navigation aids for large workbooks using pivot table & power pivot tricks.
Meet the Trainer
Priyash Nigam
Founder - ZergonBiz
My Sincere advice to learners is to focus on your learning and then seek the outcome. Digital Marketing is a vast field and it is bound to be relevant further in future with continued Digital transformation & digitalization.
View Profile
Priyash Nigam
Founder - ZergonBiz
I am a Facebook Blueprint Certified trainer having 7+ years of comprehensive experience in the space. I have enabled Marketing teams of many corporations in the digital domain through my vast knowled...
Read More
Course Content
Sections
1
Lectures
28
Duration
6 hrs
1
-
Introduction To MS-Excel Preview
-
MS-Excel Fundamentals & the ways to use it 19 Min
-
Understanding Ribbon and its components 18 Min
-
Conditional Formatting 12 Min
-
Worksheets; Data Sorting 16 Min
-
Excel Features Hide & Unhide 8 Min
-
Numbers and Formulas (basics) 16 Min
-
Inserting images and shapes in Excel 10 Min
-
Data importing and exporting techniques 6 Min
-
Excel Pivot Tables 24 Min
-
Part 2 Pivot Table 12 Min
-
Part 3 Recommended Pivot Table 16 Min
-
Part 1 Charts – Introduction 9 Min
-
Part 2 Charts – Introduction 15 Min
-
Bar Chart 6 Min
-
What is Scatter plot & How to create Data Series? 9 Min
-
Spark Lines 7 Min
-
Combination Chart 12 Min
-
Thermometer Chart, Gantt Chart, Pareto Chart & Doughnut Chart 22 Min
-
Bubble Chart 2 Min
-
Functions & Formulas 20 Min
-
Logical operations 'AND' & 'OR' 8 Min
-
Formulas 9 Min
-
How to protect your workbook? 16 Min
-
Workbook Print 5 Min
-
Excel Templates 11 Min
-
Freeze Panes 7 Min
-
Inventory List 10 Min
Skills you will gain
Back Office OperationsOrganising & Evaluating DataData EntryMicrosoft Excel
Benefits of this course
Work with different functions and tools available within Excel
Learn how to insert and modify shapes in a sheet
Understand how to generate charts, edit data within them and format them
Learn how to edit, format and manipulate data
Certificate
Upon completion, you'll earn a valuable certificate, demonstrating your proficiency and dedication
