What you’ll learn in Excel
- 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
What you’ll learn in Word
- You will learn how to take full advantage of Microsoft Word
- All Tabs & Commands explained in full depth
- Begin with the basics of creating Microsoft Word documents
- Format documents effectively using Microsoft Word Styles
- Control page formatting and flow with sections and page breaks
- Create and Manage Table Layouts
- Perform Mail Merges to create Mailing Labels and Form Letters
- Track and Accept/Reject Changes to a Document
- Preparing documents for printing and exporting
- How to make Company Letter Head, Curriculum Vitae, Letter
- 20 Useful Keyboard Shortcuts
- 20+ MS Word Tips for make Office Work easier
What you’ll learn in Excel MIS
- How to approach an Excel dashboard project from idea to delivery
- Learn Pivot Table, Slicer and Timeline in full depth
- How to add interactivity to your Excel reports
- Impress management with reports that make the decision-making process faster
- Clever use of Excel core functionality for responsive spreadsheets
- Learn how to create a professional KPI dashboard from scratch
- Create impressive, non-standard Excel charts using smart techniques
- Build Pivot Table-based dashboards for easy interactivity
- Use powerful visual techniques so your content has more effect
- Make fully automatic Dynamic MIS Report and Dashboard
What you’ll learn in Data Entry Course
In this course you will learn to do data entry in MS Excel and MS Word. This course has been designed in such a way that even a child of class 8th to 10th can learn the work of data entry. In this course, we have told you many such methods, with the help of which you can do the work done in many days within a few minutes and it is obvious that if you are doing the work of many days within a few minutes, you can earn more money.
After doing this course, you can become a good data entry operator and it is not necessary that the methods I have told here are only for data entry operators, even if you work in an office or have a business. All these methods will be very useful for you.
You do not need much technical knowledge to do this course, you should only know how to run a little computer.
This Bundle Course Includes
- 55 Hours Course Duration
- Course Completion Certificate
- Downloadable Practice file
- Lifetime Access
- New update
Access on Mobile Computer
Course Features
- Lectures 210
- Quiz 1
- Duration 55 hours
- Skill level All levels
- Language Hindi
- Students 88
- Certificate Yes
- Assessments Self
Curriculum
- 7 Sections
- 210 Lessons
- Lifetime
- Excel for BeginnersLearn Microsoft Excel from Beginners to Advanced55
- 1.1Excel Shortcuts PDF & Practice Files – 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 Work 10330 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.3487 Excel – Create Data Entry form9 Minutes
- 2.3588 Excel – Highlight Active Cell Row and Column4 Minutes
- 2.3689 Excel – Unlock Protected Sheet without knowing Password6 Minutes
- 2.3790 Excel – Maintain Overtime & Overtime Wages22 Minutes
- 2.3891 Excel – 3 Formula to Calculate Rank9 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 Word from Beginners to Advanced34
- 3.01 Word – Ways to Start MS Word, Complete Structure33 Minutes
- 3.12 Word – Write, Delete, Select, Save Docs.13 Minutes
- 3.23 Word – Quick Access Toolbar8 Minutes
- 3.34 Word – File Menu Complete52 Minutes
- 3.45 Word – Cut, Copy, Paste, Format Painter, Clipboard22 Minutes
- 3.56 Word – Font Group & Setting29 Minutes
- 3.67 Word – Paragraph Group Settings & Style48 Minutes
- 3.78 Word – Find Replace Select16 Minutes
- 3.89 Word – Cover Page, Picture, Shapes35 Minutes
- 3.910 Word – Blank Page, Page Break, Table57 Minutes
- 3.1011 Word – Illustrations46 Minutes
- 3.1112 Word – Hyperlink, Bookmark, Comment18 Minutes
- 3.1213 Word – Insert Header Footer & Page Number23 Minutes
- 3.1314 Word – Text Group All Functions35 Minutes
- 3.1415 Word – Equation and Symbol9 Minutes
- 3.1516 Word – Design Tab Complete19 Minutes
- 3.1617 Word – Layout Tab Complete32 Minutes
- 3.1718 Word – Reference Tab Part 123 Minutes
- 3.1819 Word – Reference Tab Part 223 Minutes
- 3.1920 Word – Mailing Tab Part 129 Minutes
- 3.2021 Word – Mailing Tab Part 239 Minutes
- 3.2122 Word – Review Tab Part 118 Minutes
- 3.2223 Word – Review Tab Part 220 Minutes
- 3.2324 Word – View Tab Complete & Help20 Minutes
- 3.2425 Word – Make Company Letter Head25 Minutes
- 3.2526 Word – Make Curriculum Vitae25 Minutes
- 3.2627 Word – Prepare Letter7 Minutes
- 3.2728 Word – 20 Useful Magical Shortcuts23 Minutes
- 3.2829 Word – 4 Useful Tips and Trick19 Minutes
- 3.2930 Word – 3 Useful Tips24 Minutes
- 3.3031 Word – Restore Break Line Paragraph & Split MS Word Pages19 Minutes
- 3.3132 Word – 10 Most Useful Magical Tricks22 Minutes
- 3.3233 Word – 4 Small & Valuable Tips for Word12 Minutes
- 3.33MS Word All shortcuts PDF & Practice File – Download
- Excel MIS & Dashboard20
- 4.01 MIS – Pivot Table & Chart20 Minutes
- 4.12 MIS – Slicer & Settings42 Minutes
- 4.23 MIS – Slicer & Pivot Table Tips11 Minutes
- 4.34 MIS – Search Box in Slicer Function9 Minutes
- 4.45 MIS – Create Pivot Table from Multiple Sheets9 Minutes
- 4.56 MIS – Conditional formatting for Dashboard32 Minutes
- 4.67 MIS – Transfer Data from Master Sheet to Multi Sheets42 Minutes
- 4.78 MIS – Sparklines27 Minutes
- 4.89 MIS – Dynamic Target Line28 Minutes
- 4.910 MIS – Info-Graphics Male Female Chart33 Minutes
- 4.1011 MIS – Gantt Chart in Excel13 Minutes
- 4.1112 MIS – Comparison Chart of a Company (Line Chart)40 Minutes
- 4.1213 MIS – Save All Charts As Image2 Minutes
- 4.1314 MIS – Thermometer Chart11 Minutes
- 4.1415 MIS – Trends Arrow in Chart for Dashboard10 Minutes
- 4.1516 MIS – Important Tips for XL Chart13 Minutes
- 4.1617 MIS – Progress Circle Chart (Doughnut Chart)26 Minutes
- 4.1718 MIS – Dynamic MIS Report27 Minutes
- 4.1819 MIS – Dynamic MIS Report & Dashboard46 Minutes
- 4.19Practice File for Download
- Data Entry in MS Excel21
- 5.01 – Complete Excel Structure19 Minutes
- 5.12 – Cell Row Column Sheet – Insert Delete25 Minutes
- 5.23 – Excel Sum, Sub, Multiply, Divide Formula26 Minutes
- 5.34 – 3 Way to Calculate Percentage in Excel6 Minutes
- 5.45 – Data Entry Basics5 Minutes
- 5.56 – Data Entry Work in Excel17 Minutes
- 5.67 – Rotate Excel Data3 Minutes
- 5.78 – Fast Data Entry for School Record17 Minutes
- 5.89 – Data Entry Work in Excel11 Minutes
- 5.910 – Shift Raw Data into Multiple Columns4 Minutes
- 5.1011 – Write Large Number in Excel5 Minutes
- 5.1112 – Change format of Date and Number8 Minutes
- 5.1213 – Data Entry in Excel4 Minutes
- 5.1314 – Reference Problem in Excel5 Minutes
- 5.1415 – Data Entry form in Excel12 Minutes
- 5.1516 – Data Entry Tips3 Minutes
- 5.1617 – Excel Tips for Data Entry20 Minutes
- 5.1718 – Ways to Remove Duplicates Record19 Minutes
- 5.1819 – Clean Data & Improve Typing Speed2 Minutes
- 5.1920 – Convert any Printout Image PDF to excel6 Minutes
- 5.20Data Entry Practice File
- Data Entry in MS Word13
- 6.01 – Start, Complete Interface Word33 Minutes
- 6.12 – Write,Delete,Select,Save Docs.13 Minutes
- 6.23 – Cut Copy Paste Format Clipboard22 Minutes
- 6.34 – Blank Page, Page Break, Table57 Minutes
- 6.45 – Combine Word File,Formulas,Autosum,Voice Typing19 Minutes
- 6.56 – Magical Use of Mail Merge29 Minutes
- 6.67 – Data Entry in MS Word6 Minutes
- 6.78 – 2 Best Tool for Hindi Data Entry7 Minutes
- 6.89 – Data Entry Using Voice in MS Word2 Minutes
- 6.910 – Make 1000 Report Card in 1 Second24 Minutes
- 6.1011 – Mail Merge Big Problem & Solution13 Minutes
- 6.1112 – 4 Online Tool for Voice Typing7 Minutes
- 6.1213 – Type 1000 Pages Book & NoteBook in 1 Second9 Minutes
- Final Quiz for Certificate1
4 Comments
Lifetime ka kuch hai kya sir.
Yes
I want to do it’s one, data entry course
Sir EXCEL MEIN VBA CODE POWER QUERY KAISE USE KARTEE HAIN US PAR EK COURSE BANAAYE MAIN LE LUNGAA