M.S Office Basic to Advance

COURSE DURATION - COURSE FEE 3 MONTHS

COURSE FEE 3 MONTHS ₹5000

INTRODUCTION

Learning basic computer skills with MS Office is essential because it provides a widely used set of tools for creating documents, managing spreadsheets, designing presentations, and sending emails. it equips you with fundamental digital literacy skills needed for everyday tasks and career opportunities.

WHO CAN JOIN THIS COURSE?

Anyone can join a basic computer course, including:

1. Students – School and college students.
2. Beginners – Anyone with little or no knowledge of computers.
3. Working Professionals – Employees who need computer skills.
4. Homemakers – learn for personal or professional use.
5. Senior Citizens – use computers for communication and online services.
There are no strict eligibility criteria; basic courses are open to everyone.

COURSE FEATURES

1. Live video class
2. Real project
3. Assignments for practice
4. Study materials
5. Query solution
6. Monthly test
7. Certificate
8. Job assistance
9. Internship with corporate data
10. Pocket friendly fee

ABOUT OUR TEACHER

1. Taught more than 5000+ student's
2. Awareded as best teacher in computerise accounting and taxation training

A. COMPUTER BASICS

1.Introduction of Computer
2.Functionalities of Computer. Computer Generations
3.Types of Computers
4.Computer Components
5.Memory
6.Storage Devices
7.Data Measurements Unit
8.Computer Ports Descriptions
9.Computer Hardware & Software
10.Computer Operating System
11.Mobile Operating System
12.Computer Networking
13.Computer Virus

B. WINDOWS 11

1. Introduction of GUI (Graphical User Interface) Based Operating System – Windows 11
2.System Requirements for Windows 11
3.Windows 11 Screen Interface
4.Desktop Screen Interface
5.Desktop Background
6.Start Menu
7.Search Box / Cortana
8.Virtual Desktops
9.Web Browsing – Edge
10.Networking
11.Windows Explorer Screen Description
12.Control Panel
13.Restarting/Sleep/Updating/Shutting Down Computer
14. Windows Snapping
15.Working with Windows Accessories
16.Notepad
17.Calculator
18.Paintbrush
19.WordPad

MICROSOFT OFFICE-365

C. MS-WORD

1. Introduction to Microsoft Office & its Components
2. Description of MS-Word Window
3. Quick Access Toolbar
4.File Button
5. Home Tab
6.Layout. Insert Table
7.Table Tool
8.Insert Tab
9.Links
10.Comments
11.Header & Footer
12.Text
13.Symbols
14.Design Tab
15.Document Formatting
16.Page Background
17.References Tab
18.Mailings (Creation of Multiple Letters, Using Mail Merge)
19.Review
20.View
21.Macro

D. MS EXCEL

1.Introduction of Excel
2.Elements of Excel Window
3. Limitation of Excel
4.File
5.Entering Text
6.Writing Style -Fonts
7.Modifying Rows / Columns / Cells Clipboard
8. Undo and Redo
9.Formatting of Data
10.Styles
11. Insert
12. Comments
13. Check print Preview
14. Hyperlink
15. Hyperlink with Bookmark
16. Number Formatting
17. Different Views of Worksheet
18. Page Layout
19. Introduction of Simple Calculation
20. Cell Reference Operator
21. Introduction of Simple Calculation
22. Copying Formulas by Using Cell Reference
23. Introduction on Function Library
24. Calculation
25. Formula Auditing
26. Math’s Functions
27. Statistical Formulas
28. Text Functions
29. Date & time functions
30. Logical function
31. Sort
32. Filter
33. Text to Column
34. Remove Duplicates
35. Consolidate
36. Vlookup
37. Hlookup
38. Goal Seek
39. Scenario
40. Data Table
41. View
42. Review
43. Spell Check
44. Protect Sheet
45. Editing

E. ADVANCE EXCEL

1.Macro
2.Conditional formatting
3.Conditional formatting with logical functions
4.Financial Functions
5.Database Function
6.Array Formula Introduction
7.Left Formulas
8.Advance Date and Time Function
9.Advance use of Vlookup/Hlookup (In backward)
10.Advance Filter
11.Advance use of Data Table
12.Flash Fill
13.Data validation
14.Subtotal
15.Introduction of charts
16.Pivot Charts & Tables

F. MS POWERPOINT

1.Introduction to PowerPoint Slides
2.Organizing Slides
3.Working with Slides
4.Slide Transition
5.Slide Notes
6.Slide Sections
7.Printing of Slides
8.Print Layouts
9.Print a Presentation
10.Slide Presentation
11.Slide Show Presentation Tools & Features
12.Show Taskbar
13.Slide Options
14.Drawing Tools
15.Presenter View
16.Slide Show Setup
17.Audio in Slide
18.Video in Slide
19.Recording Slide Show
20.Activating PowerPoint In Built Shortcut

G. INTERNET AND E-MAIL COMMUNICATION

1.Introduction of Internet
2.Internet Domain Name System
3.Different Domain Names
4.Web Services
5.World Wide Web
6.Internet Service Providers
7.Internet Protocols
8.Websites Overview
9.Website Types
10.Web Browser
11.Search Engines
12.Downloading
13.Uploading
14.Video Conference
15.Electronic Mail – E-mail
16.Introduction to Gmail
17.Digital Signature
18.Firewall
19.Working with Google Suits
20.Working with Google Apps