1) Power Point Overview Overview of MS word in terms of Screen layout, Menus, The Ribbon, Quick Access Toolbar etc. 2) Creating a Presentation You can start a new presentation from a blank slide, a template, existing presentations, or a Word outline. Experience the steps to do this. 3) Formatting Presentation How to make your presentation look effective. Working on fonts, styles, effects, Word art, Alignment, Text direction etc will help you master in formatting presentations as per your need.. 4) Simple Presentation Making presentations starts with creating a simple presentation then taking it to the next level. Creating general presentation by using templates etc. These presentations are system built and easy to use and create. 5) Custom Presentation Do you want to apply worldwide accepted formats or if you have very less time to format presentations then creating own style presentation by adding logos, pictures, formats etc. 6) Adding Graphics A picture is worth a thousand words. It applies to making presentations as well. Adding pictures, Clip Art, Shapes, Smart Art, Photo album etc. These graphics can be animated. 7) Adding Tables Creating tables, modifying structure, Inserting Table from Word or Excel to prevent the rework. Tables can be modified and used in a colorful manner. 8) Adding Animation Slide effects, Slide Transitions, Slide Animations, Animation Preview, Setting up slide show, 9) Adding Charts Creating chart, editing chart, Chart tools etc. Copying charts from Word and Excel etc. 10) Adding Notes As a speaker you can add notes to presentation so you could refer to those notes while presentation. 11) Printing Tips You might need to include some notes so you could forget while presenting yourself. Creating speaker notes, Handouts etc will help you do this. 12) Slide Sorter Slide sorter helps you manage and sort slides based on your requirement & the sequence you need. | 1) Excel Quick Overview : Use of Excel, its boundaries & features 2) Data Formatting & Custom settings : Number, Text, Date, Currency, Custom settings. Data formatting & cleaning 3) Conditional Formatting : Once defined, it will automatically change color of values e.g. up or down, high or low, pass or fail, profit or loss etc. 4) Filters, Queries & Data Sorting : Drill down your data to your desired level. Sort data based on your choice e.g. like North, East, West, South rather than alphabetically. 5) Formula Writing & Fixing Errors: Financial, Logical, Text, Day and Time, Statistical, Mathematical etc Sum, Average, Count, Minimum, Maximum, Absolute, Concatenate, Count, CountA, CountBlank, CountIf, Day, Today, Even, Exact, Exp, Find, Int, IsBlank, Left, Len, Lower, Upper, Proper, Now, Power, Rank, Right, Round, Trim etc. 6) If-Then-Else & Nested If commands : Produce different set of results based on slabs, conditions. 7) Vlookup / Hlookup : You have large amount of data placed at different locations & you want to merge it based on common values & it’s relevance. 8) Graphs & Charts : In this workshop you will learn how to create, modify & update graphs / charts like Column, Line, Pie, Bar, Area, Scatter, 3D etc. 9) Hyper / Data Linking : Hyper & data linking, within or outside Worksheet / Excel File is an important feature. This helps update data automatically. 10) Grouping - Ungrouping : Sometime data needs to be grouped for summarized results & crisp view. Grouping & ungrouping feature will help you do so. 11) Pivot Tables : Summarize your data as per your desire. You need to select data in a range & produce consolidated results in user defined reporting formats. 12) Macros Recording, use, editing, linking : Record, edit & use Macros with little or no programming knowledge. 13) Security & Protection : It will help you protect your cells, worksheet or an excel file from unauthorized use. 14) Data validation : prevent wrong data entry in your specified format. | 1) MS Word Overview : Overview of MS word in terms of Screen layout, Menus, The Ribbon, Quick Access Toolbar etc. 2) Handling Documents : Creating, Editing, Saving new documents and using templates. 3) Formatting : Applying styles, Change Font Typeface and size, Font styles and effects, changing colors, highlighting text 4) Bullets & Numbering : Bullets and Numbering (Numeric and Alphabetical) is a useful feature of MS Word. In this workshop, learn how to use Bullets, Numbers etc and their relevance. 5) Drawing & Graphics Tools : How to use character case change, formatting, Clip art, Shapes, Word Art, Symbols & special characters, Equations, Watermarks 6) Mail merge : Mail Merge feature of Word saves your time when you're sending the same letter to different recipients. Like Thanks Letters, Payment Reminders, Salary Hike Letters etc. 7) Graphs : Creating & editing chart, Chart tools etc. Copying charts from Word & Excel etc. 8) Macros Recording, use, editing, linking : Record, edit and use Macros with little or no programming knowledge, automated recording of functions or actions helps a lot for quick execution with shortcut keys. 9) Tables : Creating tables, modifying structure, Inserting Table from Word or Excel to prevent the rework. Tables can be modified and used in a colorful manner. 10) Header / Footer : Applying Headers and Footers 11) Hyperlink : Hyper within or outside document. 12) Track Changes : Track Changes allows you to see what changes have been made to a document. 13) Thesaurus : Find related words with limited vocabulary. 14) Translation : Learn to translate contents of document to other languages. 15) Document Proofing : Spelling & Grammar checking, Auto correct etc 16) Creating Web Pages : Publish reports for websites 17) Table of Contents : Learn how to create table of contents. Table of contents are very useful when you are creating reports, writing books etc. | 1) Creating & Recording a Macro – First step towards learning Macros programming is to learn how to create & record macros. This is the 1st step towards macro programming. 2) Executing Macros through shortcuts and command buttons – Using such features based on user requirements. 3) Editing recorded syntax – How to edit or write your own Macro programs 4) Modules – Learn about modules which is an excellent feature of VBA programming. 5) Procedures – write & practice programming procedures. 6) Sub Procedures - write & practice programming procedures. 7) Functions – There are certain inbuilt or user defined functions. Explore those functions 8) Excel VBA tutorial – VBA tutorial will help you proceed in a step by step approach 9) Objects and collections - An object is a special type of variable that contains both data and codes. A collection is a group of objects of the same class. The most used Excel objects in VBA programming are Workbook, Worksheet, Sheet, and Range. 10) Workbook and workbook objects - A workbook is the same as an Excel file. The Workbook collection contains all the workbooks that are currently opened. Inside of a workbook contains at least one worksheet. 11) Range object & cells property - Range represents a cell, a row, a column, a selection of cells containing one or more contiguous blocks of cells, or a 3-D 12) Methods & properties -Each object contains its own methods & properties. A Property represents a built-in or user-defined characteristic of object. 13) Object variables and arguments - Sometime a method takes more than one argument. For example, the Open method for the Workbook object, takes 12 arguments. To open a workbook with password protection, you would need to write the code. 14) If Case, Loop Case & Select Case –Looping, Sub looping, looping through a range, For..Next loop etc. Execute multiple conditions with select statement. | 1) Introduction to MS Project - Introduction to MS Project application & it’s usage in current industry scenario’s, Introduction to Project & Project Management 2) Creating a Project Plan –Learn the steps involved in creating project plan. The more you have understanding on the concepts, more it will easy for you to plan a project. Understanding Project plans, How to create a New Project Plan, Assigning a specific Project Calendar as per our requirements, Adding Tasks to the Project Plan, Entering the Task Duration Estimates, Adding Resources in the Project Plan 3) Managing Tasks in a Project Plan - Understanding tasks, Outlining Tasks in a project plan, Adding a Recurring Task, Linking Dependent Tasks, Setting a Constraint to a Task, Setting a Task Deadline, Adding Notes to a Task 4) Managing Resources in a Project Plan - Understanding resources, Creating a Resource Calendar, Assigning Resources to Tasks, Assigning Additional Resources to a Task, Entering Costs for Resources, Entering Values for Budget Resources, Resolving Resource Conflicts 5) Finalizing the Project Plan - Understanding Critical path, Displaying the Critical Path, Shortening the Project Duration, Setting a Baseline, Printing a Project Summary Report. Understand all these features from practical and conceptual point of view. 6) Exchanging Project Plan Data with Other Applications - Overview of importing Project Information, Exporting Project Plan Data into Excel, Copying a Picture of the Project Plan Information 7) Updating a Project Plan - Entering Task Progress, Entering Overtime Work, Splitting a Task, Rescheduling a Task, Filtering Tasks, Setting an Interim Plan, Creating a Custom Table, Creating a Custom Report 8) Managing Project Costs – Managing project cost is one of the most important thing to manage on the project and isn’t easy too. But with MS Project, understand managing and updating project costs, Updating Cost Rate Tables, Grouping Costs, Linking Documents to a Project Plan 9) Project Reporting – MS Project gives you ready made & customized project reporting. Understand, create & define Project Reporting as per stakeholder’s, team, management requirements. |
