Wonder English
October 9, 2018
Adv Basics (Win, Word, Exl, PPT, Access, Internet)
October 9, 2018
Show all

Basic (Win, Word, Exl, Ppt)

1,430.00 799.00

Category:
Description

Windows Basics 7

 

Learn Basics Of Computer Starting From Scratch And Learn Complete Basics Of Windows Operating System With High Quality Videos And Complete Basics Video Training Of Windows Learn About Your Computer

  • Introduction To Computers
  • Parts Of A Computer
  • Using Your Mouse
  • Using Your Keyboard
  • Turning Off Your Computer Properly
  • Desktop Fundamentals
  • The Desktop
  • The Start Menu
  • The Taskbar
  • Windows Sidebar And Gadgets
  • Working With Windows
  • Using Menus, Buttons, Bars, And Boxes
  • Programs, Files, And Folders
  • Using Programs
  • Working With Files And Folders
  • Video Training Started
  • Microsoft Paint
  • Microsoft Paint  Interface Section
  • Microsoft Paint  Home Tab Section
  • Microsoft Paint  File Tab Section
  • Microsoft Paint  View Tab Section
  • Microsoft Paint App In Windows Tips And Tricks Section
  • Microsoft Notepad App Interface Section
  • Microsoft Notepad App Menu Options
  • Microsoft Wordpad App Interface Section
  • Microsoft Wordpad App Menu Section
  • Microsoft Wordpad File Tab Section

 

 

 

 

Windows 10 Complete Smarto Training

 

  1. Introduction And Overview Features Of Win 10
  2. Windows 10 Interface
  3. What Is An Operating System
  4. Lets Know Start Button Better
  5. Action Center A New Feature Of Win10
  6. File Explorer In Windows 10
  7. File Explorer Menu In Windows 10
  8. Share And View And File Explorer
  9. Windows 10 Universal Apps Menu
  10. Windows And Window
  11. Virtual Desktop As A Taskview Feature
  12. Microsoft Paint App In Windows 10
  13. Microsoft Paint App In Windows 10 Interface Section
  14. Microsoft Paint App In Windows 10 Home Tab Section
  15. Microsoft Paint App In Windows 10 File Tab Section
  16. Microsoft Paint App In Windows 10 View Tab Section
  17. Microsoft Paint App In Windows Tips And Tricks Section
  18. Microsoft Notepad App Interface Section
  19. Microsoft Notepad App Menu Options
  20. Microsoft Wordpad App Interface Section
  21. Microsoft Wordpad App Menu Section
  22. Microsoft Wordpad File Tab Section
  23. Local And Microsoft Accounts In Windows 10
  24. Microsoft Account Setup In Windows 10

25.User Account Creation In Windows 10

  1. Cortana In Windows 10
  2. Cortana As A Personal Digital Assistant
  3. Cortana Voice Commands
  4. Microsoft New Browser Edge
  5. Microsoft Edge Hub Tools
  6. Microsoft Edge Your Online Canvas
  7. Microsoft Edge More Settings
  8. One Drive Online Cloud Storage
  9. One Drive App In Windows 10
  10. File Types And Extension In Windows
  11. Dos Commands In Windows 10
  12. Dos Commands In Windows 10 Part Two
  13. Date And Time Settings
  14. Mouse Settings In Windows 10
  15. Personalization Settings In Windows 10
  16. Power Settings
  17. Printer Settings In Windows 10
  18. Sound Settings In Windows 10
  19. System Tray And Settings
  20. Sharing Data And Devices Using Windows 10
  21. Sharing Devices In Windows 10
  22. Sharing Drives In Windows 10
  23. Sharing Printer In Windows 10
  24. Remote Desktop Conneciton Using Windows 10
  25. Mail App In Windows 10
  26. Weather App In Windows 10
  27. Snipping Tool In Windows 10
  28. Maths Input Panel In Windows 10
  29. Calculator App In Windows 10
  30. Character Map App In Windows 10

 

 

 

 

Ms Office Basics Package

Ms Word

Microsoft Word Is Great Text Editing Software Which Is Used To Create Text Documents Like Biodata,Resume, Applications ,Eassy And Many More. It Has A Lot Of Tools Which Are Really Great And Very Easy To Learn , So Buy Your Favourite Tutorial Dvd. You Can Learn Basic And Advance Feature With This Dvd.

Home Tab

 

S.No Particulars Time
1 Lets Start From Home Tab 00.00.00
2 How To Make Selection In Word 00.00.16
3 Font-Options Group 00.01.18
4 Clipboard Group 00.09.24
5 Paragraph Group 00.11.30
6 Styles 00.21.32
7 Editing 00.23.03

 

 

Insert Tab

 

S.No Particulars Time
1 Pages Group 00.00.00
2 Tables 00.02.14
3 Table Tools Design 00.05.47
3 Table Right Click Properties 00.07.57
4 Illustrations 00.14.25
5 Picture Tools-Format Tab 00.15.05
6 Illustrations Continue 00.19.30
7 Drawing Tools-Format Tab 00.21.16
8 Links Group 00.29.00
9 Header And Footer 00.33.48
10 Text Group 00.37.16
12 Symbols 00.49.45

 

 

Mailings

 

S.No Particulars Time
1 Mail Merge With Example 00.00.00
2 Customize Mail Merge With Example 00.07.57
3 Mail Merge With Rules With Example 00.10.39
4 Envelope With Example 00.13.51
5 Labels With Example 00.16.53
6 Multiple Labels With Different Text 00.17.36

 

 

Microsoft Word Introduction

 

S.No Particulars Time
1 Microsoft Word Introduction 00.00.00
2 How To Open Microsoft Word 00.00.55
3 Screen Parts Of Microsoft Word 00.01.20

 

 

Page Layout

 

S.No Particulars Time
1 How To Apply Themes 00.00.00
2 Page Setup Group , Margin Settings 00.00.44
3 Page Break ,Section Breat,

Column Break

00.02.51
4 Page Background,Watermark 00.10.53
5 Fill Effects 00.13.10
6 Page Borders 00.14.51
7 Paragraph Group 00.15.58
 

Review Tab

 

S.No Particulars Time
1 Proffing,Spelling Grammar 00.00.00
2 Language Group 00.04.31
3 Comments 00.06.11
4 Tracking 00.07.48
5 Track Changes Accept, Reject 00.10.29
6 Protect Group 00.11.53
 

View Tab

 

S.No Particulars Time
1 Document Views 00.00.00
2 Show,Ruler,Gridlines,Navigation Pane 00.02.48
3 Zoom 00.03.27
4 Window 00.04.10
5 Macros Using Button With Example 00.06.00
6 Macros Using Keyboard  With Example 00.08.29

 

 

Microsoft Excel

 

 

Microsoft Excel Is Great Spread Sheet Based Software Which Is Used To Create Formulation Sheet And You Can Apply Formulas , Calculations Or Add Imortant Tools Like Graph , Charts And Many More. It Has A Lot Of Tools Which Are Really Great And Very Easy To Learn , So Buy Your Favourite Tutorial Dvd. You Can Learn Basic And Advance Feature With This Dvd.

 

Home Tab

S.No Particulars Time
1 Intro To Mircrosoft Excel 00.00.00
2 Excel Screen Parts 00.00.34
3 Let’s Start Home Tab 00.03.19
4 Selection In Microsoft Excel 00.03.34
5 Font Group In  Microsoft Excel 00.04.00
6 Alignment Group 00.07.57
7 Number Group 00.11.46
8 Styles 00.14.48
9 Table Tools ,Design Tab 00.19.54
10 Cell Styles 00.23.33
11 Cells Group 00.24.18
12 Editing Section 00.32.53
13 Formulas Introduction In Excel 00.34.17
14 Using Autosum 00.36.46
15 Using Insert Function 00.37.38
16 Avg , Min , Max , If Function 00.39.05
17 Fill Options In Excel 00.44.09
18 Fill Options With Dates , Number 00.47.00
19 Sort And Filter In Excel 00.49.00
20 Find And Select In Excel
 

Formulation Tab

S.No Particulars Time
1 Using Autosum 00.36.46
2 Using Insert Function 00.37.38
3 Avg , Min , Max , If Function 00.39.05
4 Basics Of Functions And Formulas 00.00.00
5 Use Of Insert Function 00.02.25
6 How To Type Formulas 00.04.35
7 Basics Of Formulas 00.07.38
8 Total On Status Bar 00.15.15
Financial Formulas 00.16.48
9 Rate Function (Using Loan Installments Example) 00.17.11
10 Pmt Function (Using Monthly Repayment Example) 00.19.44
11 Future Value Function (Using Deposit Amount Example) 00.23.30
12 Nper Function ( Using Loan Time Calculation Example) 00.25.42
13 Db Function (Depriciation Calculation Example) 00.27.54
Logical Formulas 00.32.12
14 Logical If (Using Result Example) 00.32.25
15 Logical And (Using Age Example) 00.34.48
16 Logical If & And (Using Age Example) 00.37.00
17 Logical Combined If & And (Using Age Example) 00.38.06
18 Logical Or (Using Test  Example) 00.39.06
19 Logical If & Or (Using Age Example) 00.41.23
20 Logical Combined If & Or (Using Age Example) 00.41.52
Text Formulas 00.42.49
21 Trim Formula(Remove Extra Spaces Example) 00.42.53
22 Left Formula(Using In Extract Left Characters) 00.43.37
23 Right Formula(Using In Extract Right Characters) 00.44.30
24 Replace Formula( Using Character Removing Example) 00.45.12
25 Mid Formula (With Character Extractor Example) 00.46.39
26 Concatenate Function( With Text Joining Example) 00.47.53
27 Upper Function ( Use To Uppercase Characters) 00.49.06
28 Upper And Concatenate 00.49.44
29 Find Function 00.50.28
30 Left And Find Function( Use To Seprate Names) 00.51.50
Date Formulas 00.52.38
31 How To Set Date Formats 00.53.00
32 Date Function 00.53.25
33 Days 360 (Using Library Record Example) 00.54.25
34 Now Function 00.55.38
35 Day Function 00.56.14
36 Month Function 00.56.44
37 Year Function 00.56.52
38 Hour Function 00.56.53
39 Minute Function 00.56.55
40 Networkdays (To Count Networking Days ) 00.57.10
Lookup Formulas 00.59.04
41 Vlookup Formula ( With Exact Match Example) 00.59.06
 

Data Tab

S.No Particulars Time
1 Get External Data Group 00.00.00
2 From Access 00.00.36
3 From Web 00.01.48
4 Connections Group 00.05.49
5 Sort And Filter-Sort Options 00.08.04
6 Sort And Filter-Filter Options 00.10.27
7 Advance Filter Options 00.12.02
 

Insert Tab

 

 

 

S.No Particulars Time
1 Pivot Tables And Its Options 00.00.00
2 Table And Its Options 00.15.33
3 Charts And Its Options 00.18.09
4 Sparklines And Its Options 00.25.20
5 Filter Slicer 00.27.00
6 Links 00.27.05
7 Text Options 00.27.39
8 Symbols Group 00.35.58
 

Pagelayout Tab

S.No Particulars Time
1 Themes Group 00.00.00
2 Page Setup Group Settings In Excel 00.01.50
3 Orientation 00.04.46
4 Scale To Fit 00.07.55
5 Sheet Options 00.10.55
6 Arrange 00.12.32
 

Review Tab

S.No Particulars Time
1 Proffing 00.00.10
2 Language 00.05.02
3 Comment 00.05.49
4 Changes Group With Password Protection 00.08.05
 

View Tab

S.No Particulars Time
1 Workbook Views 00.00.12
2 Show Group 00.03.41
3 Zoom Group 00.04.05
4 Window Group 00.05.11
5 Macros Group In Excel 00.13.30
 

File Tab

S.No Particulars Time
1 File Tab Options , Contains , New, Open ,Save And Basics 00.00.00
File Tab Commands 00.07.59

 

Microsoft Powerpoint

Microsoft Powerpoint Is Great Presentation Creator Based Software Which Is Used To Create Presentations. You Can Create Comapny Presentations, If You Are Teacher You Can Create Lectures For Students And Add Imortant Tools Like Graph , Charts And Many More. It Has A Lot Of Tools Which Are Really Great And Very Easy To Learn , So Buy Your Favourite Tutorial Dvd. You Can Learn Basic And Advance Feature With This Dvd.

 

Home Tab

S.No Particulars Time
1 Intro To Mircrosoft Powerpoint, Screen Parts 00.00.00
2 How To Create Slide 00.06.09
3 Slides Group 00.06.49
4 Font Group And Its Options 00.13.47
5 Paragraph Group And Its Options 00.17.34
6 Drawing Group And Its Options 00.22.54
7 Editing Group And Its Options 00.27.41
8 Clipboard Group And Its Options 00.31.41
 

Insert Tab

S.No Particulars Time
1 Table Group And Its Options 00.14.00
2 Design Tab Under Table Tools 00.02.12
3 Layout Tab Under Table Tools 00.04.25
4 Images Group And Its Options 00.09.24
5 Format Tab Under Picture Tools 00.09.49
6 Illustrations Group And Its Options 00.15.27
7 Format Tab Under Drawing Tools 00.15.43
8 Links Group And Options 00.19.08
9 Text Group And Options 00.26.48
10 Symbols Group And Options 00.34.40
11 Media Group And Options 00.37.25
 

Review Tab

S.No Particulars Time
1 Intro To Review Tab 00.00.00
2 Proofing Group And Options 00.00.11
3 Language Group And Options 00.03.44
4 Comments Group And Options 00.06.57
5 Compare Group And Options 00.10.16
 

Slide Show

S.No Particulars Time
1 Start Slide Show Group And Options 00.00.16
2 Set Up Slide Show Group And Options 00.03.41
3 Rehearse Timing 00.07.58
4 Montiors 00.16.10
 

Animation Tab

S.No Particulars Time
1 Preview Tab And Options 00.00.11
2 Animation Group And Its Options 00.00.53
3 Advanced Animaton Group And Options 00.03.35
4 Timing Group And Options 00.08.21
5 Sound Enhancements In Effects 00.10.17
 

Design Tab

S.No Particulars Time
1 Page Setup Group And Options 00.00.10
2 Themes Group And Options 00.01.20
3 Background Group And Options 00.02.58
 

 

Transition Tab

S.No Particulars Time
1 Preview Group And Options 00.00.08
2 Transition Group And Options 00.00.18
3 Timing Group And Options 00.01.22
 

View Tab

S.No Particulars Time
1 Presentation Views 00.00.14
2 Master Views 00.02.33
3 Edit Themes 00.04.28
4 Background 00.04.58
5 Page Setup 00.05.10

 

 

 

 

 

 

 

 

 

 

 

 

Advance Microsoft Word

Microsoft Word Is Great Text Editing Software Which Is Used To Create Text Documents Like Biodata,Resume, Applications ,Eassy And Many More. It Has A Lot Of Tools Which Are Really Great And Very Easy To Learn , So Buy Your Favourite Tutorial Dvd. You Can Learn Basic And Advance Feature With This Dvd.

Home Tab

 

S.No Particulars Time
1 Lets Start From Home Tab 00.00.00
2 How To Make Selection In Word 00.00.16
3 Font-Options Group 00.01.18
4 Clipboard Group 00.09.24
5 Paragraph Group 00.11.30
6 Styles 00.21.32
7 Editing 00.23.03

 

 

Insert Tab

 

S.No Particulars Time
1 Pages Group 00.00.00
2 Tables 00.02.14
3 Table Tools Design 00.05.47
3 Table Right Click Properties 00.07.57
4 Illustrations 00.14.25
5 Picture Tools-Format Tab 00.15.05
6 Illustrations Continue 00.19.30
7 Drawing Tools-Format Tab 00.21.16
8 Links Group 00.29.00
9 Header And Footer 00.33.48
10 Text Group 00.37.16
12 Symbols 00.49.45

 

 

Mailings

 

S.No Particulars Time
1 Mail Merge With Example 00.00.00
2 Customize Mail Merge With Example 00.07.57
3 Mail Merge With Rules With Example 00.10.39
4 Envelope With Example 00.13.51
5 Labels With Example 00.16.53
6 Multiple Labels With Different Text 00.17.36

 

 

Microsoft Word Introduction

 

S.No Particulars Time
1 Microsoft Word Introduction 00.00.00
2 How To Open Microsoft Word 00.00.55
3 Screen Parts Of Microsoft Word 00.01.20

 

 

Page Layout

 

S.No Particulars Time
1 How To Apply Themes 00.00.00
2 Page Setup Group , Margin Settings 00.00.44
3 Page Break ,Section Breat,

Column Break

00.02.51
4 Page Background,Watermark 00.10.53
5 Fill Effects 00.13.10
6 Page Borders 00.14.51
7 Paragraph Group 00.15.58
 

Refrences

 

S.No Particulars Time
1 Table Of Contents 00.00.00
2 Footnotes, Endnotes 00.03.17
3 Citations And Bibliography 00.06.00
4 Captions 00.07.56
5 Index 00.09.47
6 Table Of Authorities 00.12.17
 

Review Tab

 

S.No Particulars Time
1 Proffing,Spelling Grammar 00.00.00
2 Language Group 00.04.31
3 Comments 00.06.11
4 Tracking 00.07.48
5 Track Changes Accept, Reject 00.10.29
6 Protect Group 00.11.53
 

View Tab

 

S.No Particulars Time
1 Document Views 00.00.00
2 Show,Ruler,Gridlines,Navigation Pane 00.02.48
3 Zoom 00.03.27
4 Window 00.04.10
5 Macros Using Button With Example 00.06.00
6 Macros Using Keyboard  With Example 00.08.29

 

 

 

 

Advance Microsoft Excel

Microsoft Excel Is Great Spread Sheet Based Software Which Is Used To Create Formulation Sheet And You Can Apply Formulas , Calculations Or Add Imortant Tools Like Graph , Charts And Many More. It Has A Lot Of Tools Which Are Really Great And Very Easy To Learn , So Buy Your Favourite Tutorial Dvd. You Can Learn Basic And Advance Feature With This Dvd.

 

Home Tab

S.No Particulars Time
1 Intro To Mircrosoft Excel 00.00.00
2 Excel Screen Parts 00.00.34
3 Let’s Start Home Tab 00.03.19
4 Selection In Microsoft Excel 00.03.34
5 Font Group In  Microsoft Excel 00.04.00
6 Alignment Group 00.07.57
7 Number Group 00.11.46
8 Styles 00.14.48
9 Table Tools ,Design Tab 00.19.54
10 Cell Styles 00.23.33
11 Cells Group 00.24.18
12 Editing Section 00.32.53
13 Formulas Introduction In Excel 00.34.17
14 Using Autosum 00.36.46
15 Using Insert Function 00.37.38
16 Avg , Min , Max , If Function 00.39.05
17 Fill Options In Excel 00.44.09
18 Fill Options With Dates , Number 00.47.00
19 Sort And Filter In Excel 00.49.00
20 Find And Select In Excel
 

Formulation Tab

S.No Particulars Time
1 Using Autosum 00.36.46
2 Using Insert Function 00.37.38
3 Avg , Min , Max , If Function 00.39.05
4 Basics Of Functions And Formulas 00.00.00
5 Use Of Insert Function 00.02.25
6 How To Type Formulas 00.04.35
7 Basics Of Formulas 00.07.38
8 Total On Status Bar 00.15.15
Financial Formulas 00.16.48
9 Rate Function (Using Loan Installments Example) 00.17.11
10 Pmt Function (Using Monthly Repayment Example) 00.19.44
11 Future Value Function (Using Deposit Amount Example) 00.23.30
12 Nper Function ( Using Loan Time Calculation Example) 00.25.42
13 Db Function (Depriciation Calculation Example) 00.27.54
Logical Formulas 00.32.12
14 Logical If (Using Result Example) 00.32.25
15 Logical And (Using Age Example) 00.34.48
16 Logical If & And (Using Age Example) 00.37.00
17 Logical Combined If & And (Using Age Example) 00.38.06
18 Logical Or (Using Test  Example) 00.39.06
19 Logical If & Or (Using Age Example) 00.41.23
20 Logical Combined If & Or (Using Age Example) 00.41.52
Text Formulas 00.42.49
21 Trim Formula(Remove Extra Spaces Example) 00.42.53
22 Left Formula(Using In Extract Left Characters) 00.43.37
23 Right Formula(Using In Extract Right Characters) 00.44.30
24 Replace Formula( Using Character Removing Example) 00.45.12
25 Mid Formula (With Character Extractor Example) 00.46.39
26 Concatenate Function( With Text Joining Example) 00.47.53
27 Upper Function ( Use To Uppercase Characters) 00.49.06
28 Upper And Concatenate 00.49.44
29 Find Function 00.50.28
30 Left And Find Function( Use To Seprate Names) 00.51.50
Date Formulas 00.52.38
31 How To Set Date Formats 00.53.00
32 Date Function 00.53.25
33 Days 360 (Using Library Record Example) 00.54.25
34 Now Function 00.55.38
35 Day Function 00.56.14
36 Month Function 00.56.44
37 Year Function 00.56.52
38 Hour Function 00.56.53
39 Minute Function 00.56.55
40 Networkdays (To Count Networking Days ) 00.57.10
Lookup Formulas 00.59.04
41 Vlookup Formula ( With Exact Match Example) 00.59.06
42 Vlookup Formula ( With Approximate Example) 01.06.43
43 Vlookup Range Acceptance 01.09.58
44 Hlookup Formula 01.10.58
45 Match Formula 01.14.12
46 Index Formula 01.16.13
47 Index And Match Formula Together 01.18.02
48 Transpose (Rows To Columns) 01.20.15
Maths And Trignomatery
49 Abs Function 01.21.18
50 . 01.22.00
51 Power Function 01.22.33
52 Fact Function 01.23.11
53 Rand Function 01.24.02
54 Rand With Range 01.24.44
55 Ranbetween 01.25.21
56 Sumif(Using Number As Condition) 01.26.02
57 Sumif(Using Character As Condtion) 01.28.27
More Functions 01.29.55
1 Defined Names And Using Name Manager 01.30.09
2 Formula Auditing 01.34.09
3 Calculaton Group 01.42.05
 

Data Tab

S.No Particulars Time
1 Get External Data Group 00.00.00
2 From Access 00.00.36
3 From Web 00.01.48
4 Connections Group 00.05.49
5 Sort And Filter-Sort Options 00.08.04
6 Sort And Filter-Filter Options 00.10.27
7 Advance Filter Options 00.12.02
8 Data Tools 00.16.46
9 Outline Group 00.58.34
 

Insert Tab

 

 

 

S.No Particulars Time
1 Pivot Tables And Its Options 00.00.00
2 Table And Its Options 00.15.33
3 Charts And Its Options 00.18.09
4 Sparklines And Its Options 00.25.20
5 Filter Slicer 00.27.00
6 Links 00.27.05
7 Text Options 00.27.39
8 Symbols Group 00.35.58
 

Pagelayout Tab

S.No Particulars Time
1 Themes Group 00.00.00
2 Page Setup Group Settings In Excel 00.01.50
3 Orientation 00.04.46
4 Scale To Fit 00.07.55
5 Sheet Options 00.10.55
6 Arrange 00.12.32
 

Review Tab

S.No Particulars Time
1 Proffing 00.00.10
2 Language 00.05.02
3 Comment 00.05.49
4 Changes Group With Password Protection 00.08.05
 

View Tab

S.No Particulars Time
1 Workbook Views 00.00.12
2 Show Group 00.03.41
3 Zoom Group 00.04.05
4 Window Group 00.05.11
5 Macros Group In Excel 00.13.30
 

File Tab

S.No Particulars Time
1 File Tab Options , Contains , New, Open ,Save And Basics 00.00.00
File Tab Commands 00.07.59

Have any query? Fill this form to Get a Callback

From where you came to know about us?
Call Now