Description
Information technology tools have become the part and parcel of every office environment, getting familiar with IT tools enable the individuals pave their way to success. This course is specially designed for beginners or intermediate users to enhance their skills.
- Introduction to MS Word
- Getting familiar with GUI components of Word 2016 (Ribbon, Groups, Menus)
- Document formatting techniques (Professionally recommended approaches).
- Page setup and choosing margins of the document.
- Different export options available in Word.
- Working with Mathematical equations and symbols.
- Working with shapes, pictures and objects.
- Working with table and table borders.
- Smart Art and charts in MS Word.
- Hyperlink, Bookmarks, Cross reference.
- Inserting header, footer, page number, date and time.
- Word Art, Drop Cap, Custom Text Boxes.
- Document themes and designs.
- Adding watermark and page borders.
- Adding table of contents, endnotes, footnotes, Citations & Bibliography
- Adding table of figures and Captions.
- Mail and Merge.
- Document Layouts.
- Macros.
- Customizing the Default Word GUI Options.
- Format painter and other special features.
- Introduction to MS Excel.
- Getting familiar with GUI components of Excel 2016 (Ribbon, Groups, Menus).
- Document formatting techniques (Professionally recommended approaches).
- Page setup and choosing margins and layouts of the document.
- Different export options available in Excel.
- Working with Excel grid, cells, columns and rows (resizing, inserting, deleting).
- Wrapping text and text orientations in a cell.
- Different number, date and time formats.
- Applying formulae and performing calculations.
- Conditional formatting, Formatting table and cells.
- Applying filters and sorts on excel data.
- Freezing Panes and its benefits.
- Inserting shapes, icons, smart arts and pictures.
- Charts and graphs in excel.
- Hyperlinks and mathematical equations.
- Variety of Excel formulae and functions.
- Performing calculation across the excel sheets and workbooks.
- Data validation in Excel, Subtotaling and scenario manager.
- Lookup references (VLOOKUP, HLOOKUP etc.)
- Making complex formulae in excel.
- Working with IF and nested IF statements.
- Protecting worksheet and workbooks, hiding and unhiding rows and columns.
- Workbook views and Layouts.
- Automating excel sheets for professional usage.
- Introduction to MS PowerPoint.
- Getting familiar with GUI components of PowerPoint 2016 (Ribbon, Groups, Menus).
- Document formatting techniques (Professionally recommended approaches).
- Page setup and choosing margins and layouts of the Slides.
- Different export options available in PowerPoint.
- Inserting shapes and animating them.
- Slide transitions options in PowerPoint.
- Slide Layouts.
- Working with smart art, charts, pictures, screen shots etc.
- Header, Footer, Date/time, word art, equations and symbols.
- Adding audio/video, recording options in PowerPoint.
- Choosing theme and variants, customizing slid size and background formatting.
- Presentation and master views in PowerPoint.
- Protecting, sharing and exporting options.
- Introduction to Databases & importance of databases.
- Database concepts (entities, records, attributes, relation, relationships etc.)
- Getting familiar with GUI components of MS Access 2016.
- Creating and saving new database.
- Database objects (Tables, Forms, Query, Reports and Macros).
- Different views options (of Tables, Forms, Query, Reports and Macros).
- Table properties & applying restrictions and validation on fields.
- Setting appropriate keys (Primary key, secondary etc.)