MS Office 2016

MS Office 2016 course is offered by Mind Tec. We have been providing the best training that suits the specific requirements of the student and also the current market trends.

We provide Classroom training, Corporate Training as well as Online training so that one can take the training at the comfort of their own home or office.

We provide classes at various timings in the day that suits even the people who are currently working and would like to enhance their skills. We are among the leading Online and Corporate training Companies for the world!

Course Outline:

Windows Explorer

• Introduction about computer

• How to use keyboard & mouse

• Use of Desktop Wallpaper

• How to change Properes

• How to change Screen Saver

• How to Create Folder and File

• Copy and Paste – File and Folder

• Accessories (Notepad, MS Paint)

Internet concepts:

• How to Create Email Account

• How to Check a Mail

• How to Send a Mail

• How to A2ach file to a Mail

• How to Open Website

• Online Shopping

• Online From Registraon

Internet concepts:

• Introducon to M S – Word

• Office Bu2on, Font Clipboard

• Format Painter, Undo and Redo

• Font Face, Size, Styles and Color

• Back Ground Color, Change Case

• Sub & Super Script, Bullet List

• Text Alignments and Borders

• Line Spacing, Data Eding

• Tables Creang, and Table Tools

• Inserng Picture, Shapes & Charts

• Creang Hyperlink, Bookmarks

• Header & Footer, Page Numbers

• Watermark, Page Color & Borders

• Table of Contents, Footnotes

• Labels Design, Mail Merge, Macros

• Word Count, Document Views

• Protect Document, Window

• Zoom, Funcon & Shortcut Keys

Microsoft PowerPoint

• Introducon to M S – PowerPoint

• Creang Designing Slides & Numbers

• Creang Photo Album & Layouts

• Page Setup, Slide Orientaon, Themes

• Custom Animaons, Transion Sound

• Sound Effects & Music, Create Image

• Custom & Start Slide Show, Sorter

• Rehearse Timings, Arrange All

• New Window, Protect Presentaon

Microsoft Access

• Introducon to M S – Access

• Tables Creaon, Table in Design View

• Creang Data Base Forms

Microsoft Excel

• Introducon to M S – Excel

• Office Bu2on, Paste Special

• Paste Link, Values, Transpose

• Clipboard and Font Se<ng

• Cell Borders and Alignment

• Wrap Text, Merge & Center

• Cell Styles, Cell Size, Visibility

• Insert & Delete, Eding

• Organize Sheet, Charts

• Time and Date Funcons

• Financial Logical Funcons

• Text & Stascal Funcons

• Math and Trig Funcons

• Hyperlink, Header & Footer

• Page Margins, Orientaon,

• Print Area, Breaks & Size

• Page Background, Print Titles

• Scale to Fit, Sheet Opons

• Name Manager, Define Name

• Formula Auding, Sorng

• Group & Ungroup, Comment

• Protect Sheet, Book Views

• Funcon & Shortcut Keys

Advanced Excel

• V Lookup and H Lookup Formulas

• V Lookup & H Lookup Sheet to Sheet

• V Lookup & H Lookup Book to Book

• Match and Index Formulas

• Match and Index Sheet to Sheet

• Match and Index Book to Book

• Auto Filter and Advanced Filter

• Sum if and Count if Formulas

• Count A & Count Blank Formulas

• Subtotal Funcons and Formulas

• Creaon of Pivot Table, Charts

• Refresh Data & Database Formulas

• Cell Condional Forma<ng

• Import Data from Access, Notepad

• Export Tables from Excel to Word

• Creaon Customs List for Text

• Text to Columns, Remove Duplicates

• Data Validaon, Consolidate Tables

• Scenario Manager, Data Table

• Goal Seek, Macros, Freeze Panes

• Data and Number Series FillingDuraon

• 30 DaysCreang Object, Creang Payrolls

• Duraon