Advanced MS Office Course

Computer Basic Classes Near Me
0 student

Course Overview

Free Demo Download Brochure

Request For Free Demo

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.
Curriculum is empty

0.00 average based on 0 ratings

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%