What you’ll learn
- Creating effective spreadsheets
- Managing large sets of data
- Mastering the use of some of Excel’s most popular and highly sought after functions (SUM, VLOOKUP, HLOOKUP, INDEX, MATCH, SLICER, PIVOT TABLS, FLASH FILL, IF, AVERAGE, COUNTA, SUMIF, SUBTOTAL, VALUE, and many more…)
- Create Dynamic MIS report with Excel PivotTables
- Learn how to work with charts in excel
- 160+ Keyboard Shortcuts to make your excel superstar
- 40+ Excel Magical Tips and Tricks to make your office work easier
- 40+ Excel basic and Advanced formulas
This course Includes
- 26+ Hours Course Duration
- Course Completion Certificate
- Downloadable Practice file
- Lifetime Access
- New update
Access on Mobile Computer
Course Features
- Lectures 122
- Quiz 1
- Duration 26+ Hours
- Skill level All levels
- Language Hindi
- Students 1513
- Certificate Yes
- Assessments Self
Curriculum
- 3 Sections
- 122 Lessons
- Lifetime
Expand all sectionsCollapse all sections
- Excel for BeginnersLearn Microsoft Excel from Beginners to Advanced55
- 1.1Excel Shortcuts PDF for Download
- 1.21 Excel – 4 ways to Start Excel2 Minutes
- 1.32 Excel – Excel Complete Structure19 Minutes
- 1.43 Excel – Write, Enter, Delete, Modify, Select Value12 Minutes
- 1.54 Excel – File Menu Complete21 Minutes
- 1.65 Excel – Quick Access Toolbar – Save, undo, Redo, Add or Remove Command11 Minutes
- 1.76 Excel – Cut, Copy, Paste, Format Painter, Clipboard18 Minutes
- 1.87 Excel – Font & Settings41 Minutes
- 1.98 Excel – Alignment & Settings29 Minutes
- 1.109 Excel – Number Format & Settings36 Minutes
- 1.1110 Excel – Complete Conditional Formatting33 Minutes
- 1.1211 Excel – Format As Table, Cell Style14 Minutes
- 1.1312 Excel – Insert and Delete Cell, Row, Column, Sheets25 Minutes
- 1.1413 Excel – Format Commands All Options33 Minutes
- 1.1514 Excel – Autosum Fill & Clear Function35 Minutes
- 1.1615 Excel – Sort and Filter Find and Select16 Minutes
- 1.1716 Excel – Illustrations12 Minutes
- 1.1817 Excel – Insert Charts, Filter, Element and Style10 Minutes
- 1.1918 Excel – Hyperlink, Text, Symbol Complete19 Minutes
- 1.2019 Excel – Page Layout & Setup32 Minutes
- 1.2120 Excel – Text To Column Function8 Minutes
- 1.2221 Excel – Remove Duplicate Function6 Minutes
- 1.2322 Excel – Consolidate Function – Summarize Data8 Minutes
- 1.2423 Excel – Goal Seek Function with 2 Examples13 Minutes
- 1.2524 Excel – Group Ungroup Subtotal Function7 Minutes
- 1.2625 Excel – Comments All Option6 Minutes
- 1.2726 Excel – View Tab Complete13 Minutes
- 1.2827 Excel – Start new Line in Same Cell5 Minutes
- 1.2928 Excel – Absolute Reference – Why we lock Cells/Range12 Minutes
- 1.3029 Excel – Save 1000s Excel Charts as image2 Minutes
- 1.3130 Excel – How to Use Flash Fill4 Minutes
- 1.3231 Excel – Sort Data Row Wise4 Minutes
- 1.3332 Excel – Filter Secret Tips and Tricks10 Minutes
- 1.3433 Excel – Convert Excel to Image6 Minutes
- 1.3534 Excel – Data Entry Work in excel6 Minutes
- 1.3635 Excel – Write Big Number in Excel8 Minutes
- 1.3736 Excel – How to Use Macro in Excel10 Minutes
- 1.3837 Excel – Remove Extra Space from Excel Sheet4 Minutes
- 1.3938 Excel – How to Save Excel File as PDF3 Minutes
- 1.4039 Excel – Use Hyperlink on Same Sheet5 Minutes
- 1.4140 Excel – Link Excel File to MS Word Automatic Update4 Minutes
- 1.4241 Excel – How to Protect Excel File7 Minutes
- 1.4342 Excel – 7 Ways to SUM, Subtract, Multiple, Divide26 Minutes
- 1.4443 Excel – Percentage Calculation (3 examples)5 Minutes
- 1.4544 Excel – Index Formula8 Minutes
- 1.4645 Excel – Match Formula5 Minutes
- 1.4746 Excel – Count, Counta, CountBlank Formula6 Minutes
- 1.4847 Excel – Vlookup Formula8 Minutes
- 1.4948 Excel – Sumif and Sumifs Formula11 Minutes
- 1.5049 Excel – If Formula9 Minutes
- 1.5150 Excel – Hlookup6 Minutes
- 1.5251 Excel – Rand & RandBetween Formula4 Minutes
- 1.5352 Excel – SumProduct Formula3 Minutes
- 1.5453 Excel – Create Check Box6 Minutes
- 1.5554 Excel – Split Data from One Column to Multiple Column4 Minutes
- Advanced Excel67
- 2.1How to Use ChatGPT for Excel Work30 Minutes
- 2.255 Excel – Pivot Table & Pivot Chart20 Minutes
- 2.356 Excel – Refresh Pivot Table (4 Method)6 Minutes
- 2.457 Excel – Create Pivot Table from Multiple Sheets8 Minutes
- 2.558 Excel – Split Data from Master Sheet to Multiple Sheets24 Minutes
- 2.659 Excel – Slicer9 Minutes
- 2.760 Excel – Prepare Dynamic MIS Report15 Minutes
- 2.861 Excel – Maintain Multiple Stock / Inventory46 Minutes
- 2.962 Excel – Prepare Attendance Register16 Minutes
- 2.1063 Excel – Search Box Using7 Minutes
- 2.1164 Excel – Google Translate formula5 Minutes
- 2.1265 Excel – 3 Best Method to Transpose6 Minutes
- 2.1366 Excel – 5 Way to Remove Duplicates Data19 Minutes
- 2.1467 Excel – 4 Way to Add Zero Before any Number7 Minutes
- 2.1568 Excel – Excel Sheets Tips and Tricks14 Minutes
- 2.1669 Excel – Make Automatic Update Drop Down List19 Minutes
- 2.1770 Excel – Calculate Running Total6 Minutes
- 2.1871 Excel – Create Notification or Reminder for Due Dates11 Minutes
- 2.1972 Excel – Excel 165 + Keyboard Shortcuts2 Hours
- 2.2073 Excel – Fully Automatic GST Invoice57 Minutes
- 2.2174 Excel – Save Each Invoice in PDF format automatically11 Minutes
- 2.2275 Excel – Unstack Excel Data from One Column to Multiple Column6 Minutes
- 2.2376 Excel – Convert any Image or Printout to Excel6 Minutes
- 2.2477 Excel – Mail Merge with Decimal Problem Solution14 Minutes
- 2.2578 Excel – Recover Unsaved Excel file8 Minutes
- 2.2679 Excel – Prevent/Stop Duplicate Entries in Excel14 Minutes
- 2.2780 Excel – Excel Trick to Find Wrong Mobile Number5 Minutes
- 2.2881 Excel – 7 way to Jump on any Excel Sheet2 Minutes
- 2.2982 Excel – Amazing Use of 1 Number Value5 Minutes
- 2.3083 Excel – Hide Formula6 Minutes
- 2.3184 Excel – Convert any Text to lower Proper UPPER case in same cell6 Minutes
- 2.3285 Excel – Highlight a Particular Word or Number5 Minutes
- 2.3386 Excel – Data Filtering Problem9 Minutes
- 2.3491 Excel – 3 Formula to Calculate Rank9 Minutes
- 2.3587 Excel – Create Data Entry form9 Minutes
- 2.3688 Excel – Highlight Active Cell Row and Column4 Minutes
- 2.3789 Excel – Unlock Protected Sheet without knowing Password6 Minutes
- 2.3890 Excel – Maintain Overtime & Overtime Wages22 Minutes
- 2.3992 Excel – Double Vlookup Formula11 Minutes
- 2.4093 Excel – Amazing Use of Hlookup Formula12 Minutes
- 2.4194 Excel – Fuzzy lookup8 Minutes
- 2.4295 Excel – Picture Lookup in Excel10 Minutes
- 2.4396 Excel – Subtotal formula14 Minutes
- 2.4497 Excel – Sumif Vs Sumifs10 Minutes
- 2.4598 Excel – Value Formula8 Minutes
- 2.4699 Excel – Index + Match Formula15 Minutes
- 2.47100 Excel – Quotient and Mod Formula6 Minutes
- 2.48101 Excel – Add Search Box in Slicer Function9 Minutes
- 2.49102 Excel – Compare Two List with Match Formula6 Minutes
- 2.50103 Excel – Import 1000 Excel Contact to Mobile7 Minutes
- 2.51104 Excel – Convert Formula – Easy way to convert units9 Minutes
- 2.52105 Excel – Forecast Formula5 Minutes
- 2.53106 Excel – Average Vs Averageif Formula6 Minutes
- 2.54107 Excel – Countif Formula in Excel4 Minutes
- 2.55108 Excel – Concatenate Formula8 Minutes
- 2.56109 Excel – Average, Averageif and Averageifs Formula12 Minutes
- 2.57110 Excel – Make Searchable Drop Down List6 Minutes
- 2.58111 Excel – Insert Right Tick and Cross Tick10 Minutes
- 2.59112 Excel – Excel 12 Tips And Tricks21 Minutes
- 2.60113 Excel – 06 Tips and Tricks19 Minutes
- 2.61114 Excel – 06 Tips and Tricks14 Minutes
- 2.62115 Excel – 02 Tips and Tricks7 Minutes
- 2.63116 Excel – 07 Tips and Tricks14 Minutes
- 2.64117 Excel – 05 Tips and Tricks11 Minutes
- 2.65118 Excel – 05 Tips and Tricks10 Minutes
- 2.66119 Excel – 04 Tips and Tricks18 Minutes
- 2.67120 Excel – Excel Tips for Copy formula4 Minutes
- Microsoft Excel Final Quiz1
2 Comments
I want your course
Sir g ma Pakistan se hu sir please merako apna WhatsApp number do sir merako Excel ka poora Crouse cahye please sir apke video merako buhoot ache lagthe ha