Excel Course In Hindi

2 years ago
39

आज रात हम अपना पहला वीडियो प्रकाशित करेँगे, जिस मैं आप को एक्सेल क्या होता है ये हम बतांएंगे। जो की हमारे कोर्स की पहली क्लॉस होंगी। Tonight we will publish our first video, in which I will tell you what is Excel. Which will be the first class of our course.

Please Subscribe, Like & Share
We Start Our Class Shortly

Please subscribe my channel for leaning lots of course totally free. Details Below:-

All is totally free, no need pay any money to anyone. We give all class totally free!!! Any Query please contact on my WhatsApp: - +918874005400 We Happy to help you:- Please Subscribe Youtube Channel & Don't Forget To Watch All Video. 
Lesson We'll Cover (Extra Free Class) • Complete Knowledge of Power BI • Complete Knowledge of Tableau • Complete Knowledge of PowerPoint • Complete Knowledge of SQL• Complete Knowledge of Operations Management
1) 1st Lesson We'll Cover Introduction to Excel 
• How to Formatting Work In Excel 
• How to Formatting Options Work In Excel 
• How to Number Formatting Work In Excel 
• How to Excel Shortcuts Work In Excel 
• How to Format Painter Work In Excel 
• How to Insert Delete Columns & Rows Work In Excel 
• How to Autofill Work In Excel 
• How to Sorting Work In Excel 
• How to Filter Work In Excel 
• How to Text Filter Work In Excel 
• How to Number Filter Work In Excel 
• How to Date Filter Work In Excel 
2) 2nd Lesson We'll Cover Masterclass Excel Formulas 
• How to Reference Work In Excel References Types 
• How to SUM Formula Work In Excel 
• How to If Formula Work In Excel 
• How to Multiple If Formula Work In Excel 
• How to Or & And Formula Work In Excel 
• How to If + And Formula Work In Excel 
• How to If + Or Formula Work In Excel
• How to Not & If + Not Formula Work In Excel 
• How to Count IF Formula Work In Excel 
• How to Average IF Formula Work In Excel 
• How to Sum IF Formula Work In Excel 
• How to Count IFs Formula Work In Excel 
• How to Average IFs Formula Work In Excel 
• How to Sum IFs Formula Work In Excel 
• How to Formulas Statistical Work In Excel 
• How to Large, Small & Rank Work In Excel 
• How to VLOOKUP – Exact Match Work In Excel 
• How to VLOOKUP – Approximate Match Work In Excel 
• How to HLOOKUP Work In Excel 
• How to Two Way Lookups Work In Excel 
• How to Index Work In Excel 
• How to Match Work In Excel 
• How to Index + Match Work In Excel 
• How to Text Formulas Work In Excel 
• How to Date & Time Formulas Work In Excel 
3) 3rd Lesson We'll Cover Excel 
• Data Data 
• Visualization Inserting a Chart in Excel 
• Changing Elements in a Chart Types of Column & Bar 
• Charts Line 
• Chart Data Method 
• Chart Elements Format Area
• Chart Pie 
• Chart Donut 
• Chart Histogram & Pareto 
• Chart Scatter Plots 
• Waterfall Chart 
• Heat Maps 
• Conditional Formatting Combo 
• Chart Sparkline 
• Dynamic Charts 
• Dropdown Chart Control 
• Spin Button Chart 
• Funnel Chart Slope 
• Chart Dumbbell 
• Chart Highlight Points in Time Highlight Min & Max 
4) 4th Lesson We'll Cover EXCEL PIVOT TABLE MASTERCLASS
• Pivot Table Importance of Tables
• Introduction to the Source Data 
• Inserting a Pivot Table 
• Pivot Table 
• Understanding the Field List 
• Clear, Select & Move Refreshing your 
• Pivot Table Number Formatting in Pivot Table 
• Conditional Formatting in Pivot Table 
• Sorting in Pivot Table 
• Filtering in Pivot Table 
• Grouping in Pivot Table 
• Pivot Table Layouts 
• Calculated Fields Case Study 
5) 5th Lesson We'll Cover Excel Tips & Tricks 
• Smooth line 
• Strikethrough shortcut Upper 
• Add bullet point 
• Adding input messages 
• Change default font
• Clear all formatting 
• Paste from clipboard 
• Copy chart formatting 
• Copy worksheets easily 
• Display units 
• Find blank cells Lower 
6) 6th Lesson We'll Cover Master in Modern Excel 
• Covered Formulas 
• New XLookup Formula 
• New FILTER Formula 
• New SORT & SORTBY 
• Formula Combining 
• ALL formulas 
• MAX & MIN 
• IFS Advance 
• IFS Map Charts 
• New Stock Data Type

Loading comments...