Course Overview
This course is designed for those candidate who want to learn advance MS Office (Word, Excel, PowerPoint, Outlook & Access).
Course Module
Computer Fundamental
- How to PC start, Log off, Restart, Shut down? What is computer & how it works done?
- Keyboard introduction
- Hardware software concept
- Input and output device, What is booting process?
- What is Computer Memory? & Types of memory
- What is Bit, Byte? Measurement of KB, MB & GB
- What is OS? & Types of OS
- Introduction of Desktop, Icons, Taskbar, Start Button.
- How to open & Close any window. Use of maximize, minimize and close button.
- “Change the Desktop properties( Theme, Background, Window color, Screen saver, Desktop icon, Mouse pointer,” Account picture)
- Taskbar & start menu properties
- What is File & folder?
- Create folder, Open & close method file & folder
- Rename folder, Delete any file & folder & restore it.
- Change icon of folder, & also hide unhide of it.
- Different views in the folder
- Cut, Copy, Paste options of folder
- How to set Gadgets? & it’s all options.
- How to search any file & folder? , Advance Search ( Date vise, Size vise)
- Control Panel options ( Set single click & double click, Set system date & time, Set Currency formats)
- What is Briefcase?
- What is Notepad? (File , Edit, Format, View menu with all its options)
- What is Paint? ( Home & View tab with all its options)
Excel
- How to start Excel?
- Introduction of Excel.(Spreadsheet)
- Use of MS-Excel
- Difference between workbook and worksheet
- Information About Excel’s screen components like Formula bar, Cell, Row, Columns, cell address, cell Range
- What is Formula and how to apply it?
- Insert sheet, delete sheet, move or copy sheet & also tab color of sheet
- How to merge more than one Row & Column?
- Apply function like Minimum, Maximum, Sum, Average in Mark sheet table.
- Result , Grade function in Mark sheet table
- Insert Chart of Mark sheet & all its tools
- Apply Conditional formatting on Text & Numbers
- Create Bill table
- How to apply Freeze pane?
- Group Ungroup effect on Row & Column
- Create Interest table Yearly, Monthly, Daily
- Also find interest on multiple amount using Data table
- Give Protection to worksheet
- Give Security to workbook
- Apply Across worksheet
- Create Electric Bill
- Create Salary table
- Create Attendance sheet of student details
- How to apply Scenario manager?
- How to convert Text to column?
- Apply Filter, Advance filter on Text & Numbers
- Text function
- Date & time function
- Numerical function
- Sum, Sumif, Sumifs, Count, Countif, Countifs
- Vlookup Function
- Hlookup Function
Power Point
- How to start Power point?
- Introduction of Power point & its uses
- Different View of Slide
- How to create New slide & How to apply different-different slide Layout
- Apply Background to slide
- Set theme to slide
- Give slide transition
- Give custom animation to select picture, text and chart
- And also remove animation
- Rehearse timing to all the slides
- Hide Unhide slide
- Set custom slide show
- How to insert header & footer?
- Create Photo album as a slide show
- Give Hyperlink to one slide to another or existing file
- How to insert action button to give hyperlink?
- Apply Group Ungroup effect to clip-art picture
Internet
- What is Internet?
- How it works?
- Various use of internet
- Supported Brower’s to start internet
- Search engine (Google) & Download all types of details from Internet
- What is Mail ID? & How it create? Like YAHOO, GMAIL
- All options of mail account
- Use of MAP
- Free online greetings website
- Online free message website
Word
- How to start Word?
- Introduction of word, Use of word document, & Overview of word.
- All over view of word by view tab
- All shortcut keys of word
- Shortcut keys using menu options. How to set ruler & margin?
- Line spacing options
- Using ruler, margin & line spacing options create letter practically
- How to use Bullets & numbering?
- Use of Watermark.
- Use of page border & page color
- How to insert from clip-art? & all its tools.
- Also insert picture from file & its tools.
- Insert shape & how to editing , Formatting to it
- Insert word art text & all its tools
- How to insert header & footer?
- Give different header to different page
- Start page number to particular page using header & footer
- How to insert smart art? & also its tools
- Insert table & its all tools for editing & formatting table
- Using table tools create mark sheet table for example
- Insert symbol & give shortcut key to it
- Insert arrow & how to change arrow direction?
- Insert Text box & How to hide border of text box?
- Using arrow, textbox, & clip-art picture give example of it
- How to apply Drop cap effect?
- Also apply column effect
- How to insert table of content?
- How to insert table of figure?
- Give protection to document
- Also give security to document
- How to insert index using Mark entry?
- Give hyperlink to exciting file
- Give hyperlink to in this document using bookmark
- Create Mail merge
- Create Format of documentation using all options of word
Access
- How to start Access?
- Introduction of Access database & its uses
- Create table.( Mark sheet, Bill, Fees )
- How to make change in Table design? How to add or delete Columns?
- Insert records in tables
- Explain what is Primary key?
- What is Form? How to connect table with Form?
- Create Form of created table
- Explain design view & visual basic view
- Write formula in form
- Also How to run the form
- Create Report of table using wizard
- Also create grouping in report
- Create Query in design view( Make table ,select, update , delete , Append )
- Run the Query & see result
- Join tables using Relationship
- Also give validation in tables
- Different format of date field
Outlook
- What is Outlook? How it is useful.
- Concept of Outlook Shortcuts like Inbox, Calendar, Tasks, Contacts, Notes, Deleted Items Etc.
- Make use of Calendar & Task
- Create a Notes, Put it on Desktop
- Different View of Contacts How to save file In Contacts
- Use of Inbox, Outbox and Drafts.