Description

In this Course, You will complete Microsoft Office Package 

इस टुटोरिअल के अंदर एक्सेल जॉब से रिलेटेड बहोत सारे फॉर्मूला को एक्सप्लेन किया है और प्रॅक्टिकली उसका कैसे इस्तेमाल करना है, वो भी बताया है |

एक्सेल की बहोत सारी टिप्स भी हमने इस टुटोरिअल में शेयर कि है |

 

Note

 

Course Benefits

• निचे दिए गए 225+ टॉपिक्स आप सीखोगे।
• Computer Fundamental + MS-Word Full Course + Advance Excel Full Course + PowerPoint Full Course + MS-Access Full Course + Microsoft Outlook + Internet + Publisher  बेसिक से एडवांस

 

Materials Include

 250 + Video Tutorials
  200 + Practice Files
  Keyboard Shortcuts Pdf
  50 + Hours Course
  Lifetime Access
  1 PC License

 

Course Content

Computer Fundamental (6 video)

 1 – Computer Parts Introduction

 2 – CPU Hardware Parts

 3 – Desktop Icon Settings

 4- Keyboard and Mouse Information

 5 – Software Installation

 6 – Change Computer Password

Microsoft Word Full Course (26 Video)

 1 – Introduction of Word

 2 – Home Tab Font Group

 3 – Home Tab: Advance Font, Clipboard Group

 4 – Word Paragraph group

 5 – Create Page cover in Word

 6 – Create and Design Table

 7 – Insert and Format Picture

 8 – Draw Shape, Insert Chart & Smart art

 9 – Header and Footer in Word

 10 – Insert Symbol and Object

 11 – Design Tab in Word

 12 – Page layout Tab in Word

 13 – References Tab in Word

 14 – Mailings Tab in Word

 15 – Review Tab in Word

 16 – View Tab and File Menu in Word

 17 – Option Settings in Word 1

 18 – Option Settings in Word 2

 19 – File Option Settings 3

 20 – Customize Ribbon in Word – Create your own tab

 21 – Mail merge with Excel Data in Word

 22 – Create Professional Resume in Word

 23 – Create Letter in Word Typing Exam

 24 – Word – Create Pro Visiting Card

 25 – Word -Create Pro ID Card

 26 – Word – Create Professional Certificate

Advance Excel Full Course (156 Video)

 1 – Excel Introduction

 2 – Basic Formula in Excel

 3 – If Formula in Excel

 4 – If and If or Formula

 5 – Nested IF Formula in Excel

 6 – Nested if Calculate Discount

 7 – Salary Sheet Basic Formula

 8 – Salary Sheet Nested if

 9 – Attendance Sheet

 10 – Attendance Sheet Count if Formula

 11 – Sort, Custom Sort & Filter

 12 – Conditional Formatting Basic

 13- Conditional Formatting Advance

 14- C F Highlight Alt Rows

 15 – Advance Filter

 16 – Advance filter Macro

 17 – Auto Sort Macro

 18 – Text to Columns

 19 – Flash Fill in Excel

 20 – Remove Duplicate and Consolidate

 21 – 3D Formula

 22 – Data Validation

 23 – Scenario Manager

 24- Goal Seek

 25 – Data Table

 26 – Home Tab 1

 27 – Home Tab 2

 28 – Home Tab 3

 29 – Home Tab 4

 30 – Find and Replace

 31 – Go to Special

 32 – Paste Special

 33 – Pivot Table Introduction

 34 – Pivot Table Filter Use

 35 – Pivot Table Options

 36 – Slicer and Timeline

 37 – Pivot Chart in Excel

 38 – Auto Refresh Pivot Table

 39 – Table in Excel

 40 – Insert Tab – 1

 41 – Insert Tab – 2

 42 – Excel Chart

 43 – Excel Chart and Formatting

 44 – Excel Sparkline Chart

 45 – Hyperlink in Excel

 46 – Insert Tab 3

 47 – Watermark in Excel

 48 – Page layout Tab Themes and Margins

 49 – Page layout Tab Print Settings

 50 – Page layout Tab 2

 51 – Page layout Tab 3

 52 – Formula Tab Name Manager

 53 – Formula Tab Formula Auditing

 54 – Data Tab Get External Data

 55 – Data Tab Subtotal

 56 – Data Tab Solver add ins

 57 – Review Tab

 58 – View Tab

 59 – Macro Recording

 60 – Create your own Tab

 61 – VLOOKUP 1 Intro

 62 – VLOOKUP 2 Use of Range Lookup

 63 – VLOOKUP 3 Double VLOOKUP

 64 – VLOOKUP 4 Nested VLOOKUP

 65 – VLOOKUP 5 VLOOKUP Project

 66 – VLOOKUP 6- Unique Example of VLOOKUP

 67 – CountA and Count Blank Formula

 68 – Count if Formula

 69 – Count if Formula

 70 – Sum if and Sum ifs

 71 – Average if and Average ifs

 72 – Frequency Formula

 73 – Index and Match

 74 – Lookup Formula

 75 – Sum Product , Left and Find formula

 76 – Right and Find

 77 – Mid and Find Formula

 78 – Repeat and Substitute Formula

 79 – PMT, PV, FV Formula

 80 – IPMT AND PPMT

 81- V lookup with Match

 82 – Text Formulas

 83 – Date in Quarter

 84 – Dated if Formula

 85 – Date Formula

 86 – Switch Date

 87 – More Date Formulas

 88 – Ranking Formula

 89 – Concatenate and Vlookup

 90 – Sheet Tips

 91 – Excel To Powerpoint

 92 – Change Excel Icon

 93 – Number to Word

 94 – Custom Cells Tips

 95 – Picture Lookup

 96 – Picture Game

 97 – Data Entry form

 98 – File Menu

 99 – Excel Settings

 100 – Short formulas

 101 – Excel – Database function DGET Formula of Excel

 102 – Excel – DSUM Formula in Excel

 103 – Excel – DAVERAGE Formula

 104 – Excel – DCOUNT, DCOUNTA Formula

 105 – Excel -DMAX Formula, DMIN Formula, DPRODUCT Formula

 106 – Excel – Vlookup on Multiple Tables

 107 – Excel – Offset Formula Introduction

 108 – Excel – Offset Formula Calculate Sum of Last 6 Days

 109 – Excel – Offset Formula Real Job Use

 110 – Excel – Sumifs, Index, Match Real Job Use

 111 – Excel – Practical use of Isblank and Istext Formula

 112 – Excel – Counting Words in Excel Interview Question

 113 – Excel – Build Login in Excel Formula

 114 – Excel – Create Dynamic List Using Index, Match Formula

 115 – Excel – Conditional Formatting with Text and Or Formula

 116 – Excel – Unique Example of Conditional Formatting

 117 – Excel – Auto Sort data using Countif, Match and Index Formula

 118 – Excel – Condition Inside Rank using CountIFS Formula

 119 – Excel – Camera, Autofilter, Form – 3 Hidden Features

 120 – Excel – Max IF and Min IF Formula using Array

 121 – Excel – Choose Formula in Excel

 122 – Excel – Swap range in Excel

 123 – Excel – Reverse Lookup Using Choose Formula

 124 – Excel – Reverse Lookup using Match and Index

 125 – Excel – Find & Vlookup Real Job Query

 126 – Excel – Vlookup Duplicate Names Issue

 127 – Excel – Vlookup with Choose formula and array

 128 – Excel – Text Join Formula in Excel 2019

 129 – Excel – IFS Formula in Excel 2019

 130 – Excel – MaxIFS and MinIFS in Excel 2019

 131 – Excel – Filter Formula of Office 365

 132 – Excel – Sort Formula of Office 365

 133 – Excel – Real Job use of Aggregate Formula in Excel

 134 – Excel – Xlookup In Office 365

 135 – Excel – Xlookup In Office 365

 136 – Excel – Xlooup Work Reverse

 137 – Excel – Xlooup In Office 365

 138 – Excel – Xlooup In Office 365

 139 – Excel – Xlookup in Office 365

 140 – Excel – Xlookup in Office 365

 141 – Excel – Xlookup in Office 365

 142 – Excel – Xlookup in Office 365

 143 – Excel – Xlookup in Office 365

 144 – EXCEL – XMATCH Formula office 365

 145 – Excel – Create Searchable Drop Down List In Office 365

 146 – Excel – Analyze Data And Get Ideas Office 365

 147 – Excel – Map Chart In Office 365

 148 – Excel – Dynamic Conditional Formatting

 149 – Excel – Unique Formula In Office 365

 150 – Excel – Sequence And Random Array Formula In Office 365

 151 – EXCEL – Assignment 1 With Answer 365

 152 – EXCEL – Assignment 2 With Answer 365

 153 – EXCEL – Assignment 3 With Answer 365

 154 – EXCEL – Assignment 4 With Answer 365

 155 – Excel  Interview Questions – 1

 156 – Excel  Interview Questions – 2

PowerPoint Full Course (15 Video)

 1 – Introduction of PowerPoint

 2 – Creating Slides in PowerPoint

 3 – Design Tab in PowerPoint

 4 – Transitions Tab in PowerPoint

 5 – Loop Slide in PowerPoint

 6 – Animation Tab in PowerPoint

 7 – Animation Pane in PowerPoint

 8 – Presenter View in PowerPoint

 9 – Slide Show Tab In PowerPoint

 10 – Create Photo album, Add Music & Videos

 11 – Excel To PPT Animation

 12 – Amazing PPT

 13 – Count down Timer in PowerPoint

 14 – Five Power Tips of PPT

 15 – Video Inside Text in PowerPoint

Microsoft Access Full Course (35 Video)

 1 – MS-Access Introduction

 2 – Creating Table in MS Access

 3 – Delete & Add Columns in Access

 4 – Create Lookup Wizard from List

 5 – Break Lookup Relationship

 6 – Calculation in Access

 7- IF Formula in Access

 8 – IF AND, IF OR in Access

 9 – Import Tables from Excel, Notepad in Access

 10 – Filter and Sort in Access

 11 – Advance Filter in Access

 12 – Records Group in Access

 13 – Find and Replace in Access

 14 – Access – Create Query using Query Wizard

 15 – Access – Design Query on Existing Query

 16 – Access – Create Parameter Query

 17 – Access – Query with Relationship

 18 – Access – Query with Calculated Field

 19 – Access – Pivot Table in Access – Cross Tab Query

 20 – Access – Find Duplicate Query

 21 – Access – Unmatched Query

 22 – Access – Export Access data

 23 – Access – Hide Table and Query from Navigation

 24 – Access – Add Totals in Query

 25 – Access – SQL View of Query

 26 – Access – Create form using Form Wizard

 27 – Access – Design Form using Design Tab

 28 – Access – Conditional Formatting in Form

 29 – Access – Customize Button in Forms

 30 – Access – Insert Charts in Form

 31 – Access – Create Reports from Report Wizard

 32 – Access – Design and Format Report

 33 – Access – Design and Conditional Formatting in Report

 34 – Access – Parameter Reports

 35 – Access – Create Print Preview Button of Report

Microsoft Outlook (10 Video)

 1 – Outlook Introduction Configure

 2 – Outlook Email 1

 3 – Outlook Email 2

 4 – Outlook Create Appointment

 5 – Outlook Set Meeting

 6 – Outlook Create Contact

 7 – Outlook Set Task in Outlook

 8 – Outlook Create Contact Group

 9 – Outlook Mail Merge Outlook contacts

 10 – Outlook Create Folder and View Settings

Internet And Email (9 Video)

 1 – Google Search Engine

 2 – Creating Email ID

 3 – Sending Email

 4 – Use Google Drive

 5 – Network Information & Settings

 6 – Govt. Websites

 7 – Internet Security & Settings

 8 – Hindi Typing In Chrome

 9 – Hindi Typing In Chrome -2

Microsoft Publisher (10 Video)

 1 – Publisher – Introduction

 2 – Publisher – Insert Text Box

 3 – Publisher – Insert Picture

 4 – Publisher – Insert Catalog Pages and Table

 5 – Publisher – Insert Calendar and Page Parts

 6 – Publisher – Create Advertisements

 7 – Publisher – Insert file from word

 8 – Publisher – Header and Footer

 9 – Publisher – Page Design Tab

 10 – Publisher – Mail Merge