About the Course
A survey says more than 90% of companies use Microsoft Office Suite. It has been estimated that although Microsoft Office contains more than 10,000 features, the average user is familiar with only about 150 of them.
That means that most people have left a whopping 98.5 percent of Office territory unexplored. In practical terms, it also means that most people aren’t taking advantage of the power of the Office suite. It means that most people work inefficiently by trying to make the techniques they know serve a wide range of situations, and it means that most people work ineffectively because they aren’t aware of techniques that could solve their problems. This course is designed to learn the some of these features and use Office more effectively and smartly.
Topics CoveredMS Word 2007
*Creating a new document
*Formatting Text: Working with various fonts and styles
*Working with Text Boxes
*Clip Art, Pictures & Shapes: Inserting, Editing, etc
*Line & Paragraph Spacing
*Headers & Footers
*Working with Tables
*Using Indents & Tabs
*Applying Styles & Themes
*Proofing Features: Auto Check & Auto Correct
*Printing: Page, Selection, Both Sides, Alternate, etc
*Page Layouts, Labels, Envelopes
MS Excel 2007
*Quick Overview: Use of Excel, its boundaries & features
*Data Formatting & Custom settings: *Number, Text, Date, Currency, Custom settings, etc.
*Conditional Formatting: Once defined, it will automatically change colour of values e.g. up or down, high or low, pass or fail, profit or loss etc.
*Filters, Queries & Data Sorting: Drill down your data to your desired level.
*Formula Writing & Fixing Errors: Financial, Logical, Text, Day and Time, Statistical, Mathematical etc. Sum, Average, Count, Minimum, Maximum, Concatenate, Count, Trim etc.
*Graphs & Charts: In this workshop you will learn how to create, modify & update graphs / charts like Column, Line, Pie, Bar, Area, Scatter, 3D etc.
*Hyper / Data Linking: Hyper & data linking, within or outside Worksheet / Excel File is an important feature. This helps update data automatically.
*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.
*Security & Protection: It will help you protect your cells, worksheet or an excel file from unauthorized use.
*Printing: Getting your print right. Print page, worksheet, particular content, etc. as per requirement in the correct format
MS Power Point 2007
*Overview: Overview of MS Power Point in terms of Screen layout, Menus, The *Ribbon, Quick Access Toolbar etc.
*Create 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.
*Format a 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.
*Use Templates & Themes: Take your presentation to the next level using templates and themes.
*Customize Your 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.
*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.
*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.
*Adding Animation: Slide effects, Slide Transitions, Slide Animations, Animation Preview, Setting up slide show etc. These animation effects will make your presentation look professional.
*Adding Charts: Creating chart, editing chart, Chart tools etc. Copying charts from Word and Excel etc. Graphics adds lot of value to your presentation.
*Printing Tips & Slide Sorter: You might need to include some notes so you could forget while presenting yourself.
MS Outlook 2007
*How to set up MS Outlook account
*How to use MS Outlook effectively
*How to use Calendar in Outlook
*How to search effectively on google.com
*Keywords to be used for effective search
*How to edit an image
*How to resize an image according to the need
*How to save an image for different purposes
Who should attendAnyone who has basic knowledge of Microsoft Office and wants to explore and enrich his/her knowledge and enhance their skills. Anyone who wishes to improve their work efficiency in their professional or business field
Pre-requisitesBasic knowledge of Office
What you need to bringAn open mind
Key TakeawaysAfter this course the participants shall be able to
* To work on Microsoft Word, Excel & Power Point very effectively
* To work with Outlook
* To work on Image Editing
* To effectively use google.com for their needs
* To save a lot of time