Ms Word & Excel (Combo Course)

Basic to Advance Ms Word and Excel Course

Advanced 5(15 Ratings) 760 Students enrolled Hindi
Created by Miss Kavita
Last updated Mon, 01-Aug-2022
+ View more
Course overview

Master Yourself In Advanced technique in MS Excel that will get you high paying job

  • Complete Data Entry, Cell Formatting, Working with Multiple worksheets and the Ribbon Interface.
  • Learn Practical methods
  • Discover the essentials of using formulas and functions
  • Learn How to Insert Shapes, Graphs and Pictures
  • Time Shaving shortcuts and formulas
  • Discover how to format dates and numbers in Excel
  • How to create Stunning Chart and Excel
  • How to create mail merge in MS Word
  • Learn to proect your word document from changes
  • Make your word documnets look amazing by inserting and editing tables.

What will i learn?

  • Master in Ms Word and Excel
Requirements
  • Microsoft Office Installed
Curriculum for this course
120 Lessons 18:36:18 Hours
Ms Word Module-1 to 15
18 Lessons 03:06:24 Hours
  • Intro of Ms Word
    Preview 00:10:35
  • Module-1 Font group in Home Tab
    Preview 00:10:52
  • Module-2 Clipboard in Home Tab
    00:08:50
  • Module-3 Tab Option Paragrph in Home Tab
    00:07:39
  • Module-4 Paragraph group in Home Tab
    00:19:18
  • Module-5 Style Group in Home Tab
    00:03:20
  • Module-6 Editing Group in Home Tab
    00:10:25
  • Module-7 A Table Option in Insert Tab
    00:22:24
  • Module-7 B Table option in Insert Tab Part-2
    00:06:44
  • Module-8 A page group in Insert Tab
    00:04:22
  • Module-8 B Picture option in Insert Tab
    00:15:57
  • Module-9 Online Picture and Screenshot option In Insert Tab
    00:04:44
  • Module-10 Shape option in Insert Tab
    00:13:26
  • Module-11 Smart Art Graphics in Insert Tab
    00:13:12
  • Module-12 Hyperlink in Insert Tab
    00:11:15
  • Module-13 Bookmark in Insert Tab
    00:06:08
  • Module-14 Header Footer in Insert Tab
    00:10:33
  • Module-15 Page Number option in Insert Tab
    00:06:40
Ms Word Module-16 to 30
15 Lessons 01:59:22 Hours
  • Module-16 Text Box and Word art option in Insert Tab
    00:12:05
  • Module-17 Quick Part option in Insert Tab
    00:07:55
  • Module-18 Drop Cap Signature line etc. in Insert Tab
    00:06:40
  • Module-19 Document Formatting in Design Tab
    00:06:30
  • Module-20 Watermark in Design Tab
    00:05:20
  • Module-21 Page Color in Page Backgroun group in Design Tab
    00:05:49
  • Module-22 Page Border in Design Tab
    00:06:55
  • Module-23 Page tab Part-1
    00:11:24
  • Module-24 Page Layout Tab Part-2
    00:12:22
  • Module-25 Table of Content in Refrence Tab
    00:05:19
  • Module-26 Insert Footnote and Endnote in reference Tab
    00:04:18
  • Module-27 Insert Citation in Reference tab
    00:04:42
  • Module-28 Insert Caption and Cross-Reference option in Reference Tab
    00:11:26
  • Module-29 Envelops and labels options in Mailing Tab
    00:06:59
  • Module-30 Mail-Merge in Mailing Tab
    00:11:38
Ms Word Module-31 to 43
13 Lessons 02:05:17 Hours
  • Module-31 Proofing, Spealling, Grammer, Theasurus and comment group in Review Tab
    00:11:25
  • Module-32 Track Chnage option in Review Tab
    00:11:21
  • Module-33 Compare and Combine Document in Review Tab
    00:06:41
  • Module-34 Different View in View Tab
    00:07:26
  • Module-35 Show, Zoom and Windows Group in View Tab
    00:08:28
  • Module-36 Macro Option in View Tab
    00:05:57
  • Module-37 Quick Access Toolbar
    00:06:52
  • Module-38 Use of Auto Correct Option
    00:04:32
  • Module-39 File Menu Part-1
    00:11:27
  • Module-40 File Menu Part-2
    00:16:02
  • Module-41 File Menu Part-3
    00:12:37
  • Module-42 File Menu Part-4
    00:18:38
  • Module-43 Insert Different Header in Different document
    00:03:51
Excel Module-1 to 15
16 Lessons 02:42:45 Hours
  • Introduction of Ms Excel
    00:11:52
  • Module-1 Font Group in Home Tab
    00:09:42
  • Module-2 Clipboard Group in Home Tab
    00:06:40
  • Module-3 Alignment Option In Home Tab
    00:10:46
  • Module-4 Center Across Selection in Alignment Group
    00:04:06
  • Module-5 Number Format in Home Tab
    00:12:17
  • Module-6 Conditional Formatting in Home Tab
    00:19:30
  • Module-7 Cell style option in Home Tab
    00:06:04
  • Module-8 Format as table in Home Tab
    00:07:39
  • Module-9 Insert and Delete option in Home Tab
    00:08:00
  • Module-10 Basic Five Function in Home Tab
    00:07:28
  • Module-11 Format option in cells group in Home Tab
    00:11:50
  • Module-12 Fill Option in Home Tab
    00:12:54
  • Module-13 Find and Replace and Goto option in Home Tab
    00:10:49
  • Module-14 Sort and Fillter option in Home Tab
    00:09:35
  • Module-15 Insert Chart in Insert Tab
    00:13:33
Excel Module-16 to 30
15 Lessons 02:30:53 Hours
  • Module-16 Use of Pivot Table Tool
    00:17:41
  • Module-17 Insert Pivot Table
    00:12:56
  • Module-18 Slicer Option in Insert Tab
    00:11:41
  • Module-19 Timeline option in Insert Tab
    00:07:11
  • Module-20 Hyberlink in Insert Tab
    00:10:53
  • Module-21 Header and Footer Option in Insrt Tab
    00:09:10
  • Module-22 Insert Pivot Chart
    00:13:21
  • Module-23 Page layout Tab Part-1
    00:10:48
  • Module-24 Page Layout Tab Part-2
    00:11:26
  • Module-25 Define Names option in Formula Tab
    00:07:24
  • Module-26 Formula Auditing group in Formula Tab
    00:14:37
  • Module-27 Calculation group in Formula Tab
    00:05:28
  • Module-28 Advance Fillter in Data Tab
    00:07:33
  • Module-29 Text to Columns option in Data Tab
    00:06:43
  • Module-30 Flash Fill option in Data Tab
    00:04:01
Excel Module-31 to 45
15 Lessons 01:26:33 Hours
  • Module-31 Whole Number, Input Messag, Error Alert msg in Data Validation in Data Tab
    00:06:09
  • Module-32 Decimal, List option in Data validation in Data Tab
    00:06:35
  • Module-33 Date and Time option in Data Validation in Data Tab
    00:05:36
  • Module-34 Text, Length, custom option in Data Validation in Data Tab
    00:05:06
  • Module-35 Consolidate Option in Data Tab
    00:08:17
  • Module-36 Scenario Manager option in What if analysis option in Data Tab
    00:04:34
  • Module-37 Goal Seek option in What if Analysis
    00:02:37
  • Module-38 Data Table Option in What if Analysis in Data Tab
    00:04:00
  • Module-39 Group, Ungroup and Subtotal option in Data Tab
    00:05:22
  • Module-40 Relationship option in Data Tab
    00:07:20
  • Module-41 Protect Sheet, Protect Workbook option in Review Tab
    00:04:52
  • Module-42 Allow users to edit Range in Review Tab
    00:04:02
  • Module-43 Track Changes option in Review Tab
    00:05:22
  • Module-44 Auto Fill Option
    00:09:50
  • Module-45 View Tab Part-1
    00:06:51
Excel Module-46 to 60
15 Lessons 02:54:48 Hours
  • Module-46 View Tab Part-2
    00:08:18
  • Module-47 How to lock Individual Cells
    00:03:36
  • Module-48 File Menu Part-1
    00:15:33
  • Module-49 File Menu Part-2
    00:13:23
  • Module-50 File Menu Part-3
    00:16:17
  • Module-51 Go to Special option in Home Tab
    00:24:29
  • Module-52 Paste Special Option
    00:15:20
  • Module-53 Operation options, Paste Link option in Paste Special
    00:09:08
  • Module-54 Macro in View Tab
    00:04:12
  • Module-55 Sum Series Formulas
    00:14:00
  • Module-56 Use of Sumsq function
    00:02:14
  • Module-57 Average, Average A, Average If Formulas
    00:09:47
  • Module-58 Count Series Formulas
    00:12:17
  • Module-59 Date Series Formula
    00:20:47
  • Module-60 How use Date if Formula to Calculate Age
    00:05:27
Excel Module-61 to 70
10 Lessons 01:50:16 Hours
  • Module-61 IF, And, OR Formulas
    00:10:16
  • Module-62 Find Grade with Nested If Function
    00:08:13
  • Module-63 Calculate Salary in Excel
    00:09:04
  • Module-64 Math Series Formulas
    00:23:10
  • Module-65 PMT, IPMT, PPMT Formulas
    00:09:48
  • Module-66 Pv, FV Formulas
    00:08:36
  • Module-67 Text Series Formulas Part-1
    00:15:41
  • Module-68 Text Series Formulas Part-2
    00:09:09
  • Module-69 Time Series Formulas
    00:03:09
  • Module-70 Lookup, HLookup, VLookup Formulas
    00:13:10
Book Section
3 Lessons 00:00:00 Hours
  • Ms Word Shortcut PDF
    .
  • Ms Excel Shortcut PDF
    .
  • Excel Formulas Worksheet
    .
+ View more
Other related courses
About instructor

Miss Kavita

Ms Office Trainer

16 Reviews | 764 Students | 2 Courses
Ms Word Ms Excel Ms PowerPoint Ms Access
Hi, Everyone My Name is Kavita, I have more then 5 years of experience in Computer Teaching. 
Student feedback
5
15 Reviews
  • (2)
  • (0)
  • (0)
  • (2)
  • (11)

Reviews

  • Prosenjit Shaw
    This is best learning platform.. Teachers are best they are ready to give their 101% support.. thanks you sir waiting for your upcoming courses.. Best Excel & word at a very affordable price..
  • aryan khan
    Is price m toai isse best course kahi bhi nahi milega or jis tarha se in video Mai chote chote point ko bataya gaya hai wow I love this course waiting for tally course...Aryan Khan
  • Kavya Sharma
    best excel and word course in minimal rate ..
  • Lakshay Kaushik
  • Anjan Kumar Pandey
    Excellent, please share practice sheets, which are using in topics
  • Ajay Kumar
  • Sanjeev Kumar
    5
  • Shubham Nain
  • ASHWINI DEORE
    VERY HELPFULL COURSE WITH EASY METHOD ALSO GOOD STUDENT SUPPORT ON HELPLINE NUMBER
  • Ashvish Ashvish
    Good
  • Parth Virani
    Very good course..
  • Rajesh Chaurasia
    Good education in ms Excel
  • Konain raza
    Teaching level is best easy to understand
  • Amit kumar
  • RAM KUMAR
₹3500 ₹199
Includes: