Workshop on Microsoft Office 2010/ 2013

Objective
Participants  should be able to use Microsoft Office 2010 / 2013 to create, edit, format, save, and print basic business documents, comfortable with calculations, basic MIS reporting, creating business Presentations.

Upon successful completion of this course, Participants will be able to:

  • Customise tables and charts.
  • Modify pictures in a document.
  • Use the mail merge function.
  • Use advance calulations
  • Dynamic formatting
  • Advanced data analysis
  • Dash board reporting
  • Create effective corporate presentations

Microsoft Word 2010 / 2013

Module 1

Getting Started with Word 2010 / 2013

Module  2

Managing Lists

Module  3

Text  & Paragraph formatting  options

Module  4

Working with Tables

Module  5

Formatting Documents

Module  6

Managing Styles

Module  7

Mail Merge

Microsoft Excel 2010 / 2013

Module 8

Getting started with  Excel 2010 / 2013

Module 9

Working with Routine Functions

Module 10

Security & Sharing Features

Module 11

Dynamic Formatting

Module 12

Database Management

Module 13

Specialized functions

Module 14

Working with reports

Module 15

Charts

Module 16

Macros

Module 17

More functions

Module 18

What if Analysis

Module 19

Data Validation

Microsoft PowerPoint  2010 / 2013

Module 20

Getting started with PowerPoint 2010 / 2013

Module 21

Images & Drawn Objects

Module 22

Charts

Module 23

 Multimedia

Microsoft Word 2010 / 2013

Module 1: Getting Started with Word 2010 / 2013

  • Identify the Components of the Word Interface
  • Customize the Word Interface
  • Display a Document in Different Views
  • Enter Text in a Document
  • Save a Document

Module 2: Managing Lists

  • Sort a List
  • Renumber a List
  • Customise a List
  • Bullets and Numbering
  • Format a Multilevel List

Module 3: Text & Paragraph formatting  options

  • Insert Bookmarks
  • Apply Character Formatting
  • Align Text Using Tabs
  • Modify the Layout of a Paragraph
  • Paragraph Indents
  • Adjust Line Spacing
  • Paragraph Borders And Shading

Module 4: Working with Tables

  • Creating A Table
  • Inserting And Deleting Rows And Columns
  • Positioning A Table
  • Row Height And Column Width
  • Table Borders And Shading
  • Formatting Cells In A Table
  • Calculations In Tables

Module 5:  Formatting Documents

  • Page And Section Breaks
  • Page Setup
  • Page Numbering
  • Headers And Footers
  • Footnotes And Endnotes
  • Managing  Columns
  • Manage watermarks
  • Page Background
  • Apply a Page Border and Color
  • Add a Drop Cap to the Beginning of a Paragraph

Module 6: Managing Styles

  • Applying Styles
  • Amending Styles
  • Creating New Styles
  • Using Style Sets

Module 7: Mail Merge

  • The Mail Merge Process
  • Possible Data Source Options
  • Select the Mail Merge Type
  • Select a Data Source
  • Edit the Recipient List
  • Add Merge Fields to the Document
  • Preview Your Mail Merge Results
  • Complete the Mail Merge

 

Microsoft Excel 2010 / 2013

Module 8: Getting started Excel 2010 / 2013

  • Customize the Quick Access Toolbar
  • Customizing common options in Excel
  • Absolute and relative cells
  • Customize the Excel Environment
  • Customize an Excel Worksheet
  • Enhance Worksheets Using Themes
  • Work with Comments

Module 9: Working with Routine Functions

  • Writing conditional expressions (using IF)
  • Using logical functions (AND, OR, NOT)
  • Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX)

Module 10: Security & Sharing Features

  • Protecting and un-protecting worksheets and cells
  • Hiding formulas
  • Saving files with passwords
  • Tracking changes
  • Merging workbooks

Module 11: Dynamic Formatting

  • Applying auto formatting option to worksheets
  • Applying conditional formatting to cells
  • Applying conditional formatting to rows
  • Applying conditional formatting to worksheets

Module 12: Database Management

  • Sorting tables
  • Using multiple-level sorting
  • Using custom sorting
  • Filtering data for selected view (AutoFilter)
  • Using advanced filter options

Module 13: Specialized Functions

Using conditional Aggregate Functions like

  • Dsum,
  • Dmax,
  • Dmin etc.

Module 14: Working with Reports

  • Creating subtotals
  • Multiple-level subtotals
  • Creating Pivot tables
  • Formatting and customizing Pivot tables
  • Using advanced options of Pivot tables
  • Pivot charts
  • Consolidating data from multiple sheets and files using Pivot tables
  • Using external data sources
  • Using data consolidation feature to consolidate data
  • Slicing Pivots

Module 15: Presenting Data Using Charts

  • Create a Chart
  • Modify Charts
  • Format Charts
  • Create a Chart Template
  • Share Excel Charts
  • Sparklines

Module 16: Overview of Macros

  • Recording and executing macros
  • Understanding different types of references in macros
  • Assigning macros to toolbars or menu items
  • Editing macros using VBA Editor
  • Writing function using VBA Editor

Module 17: More Functions

  • Date and time functions
  • Text functions
  • Financial Functions

Module 18: What-If Analysis

  • Using goal seek
  • Using data tables
  • Creating and editing scenarios

Module 19: Data Validation

  • Specifying a valid range of values for a cell
  • Specifying a list of valid values for a cell
  • Specifying custom validations based on formula for a cell

 

Microsoft PowerPoint 2010/ 2013

Module 20: Getting started with PowerPoint 2010 / 2013

  • Design Considerations
  • Color Schemes
  • Background Effects

Module 21: Images & Drawn Objects

  • Drawing Objects
  • Object Backgrounds
  • Rotating or Flipping Objects
  • Selecting Objects
  • Converting Pictures Background Graphics
  • Arranging Objects
  • Cropping Images
  • Editing Images
  •  Advanced Editing
  • Remove Background

Module 22: Charts

  • Combination Charts
  • Editing Charts
  • Animating Charts
  • Creating a Flowchart

Module 23: Multimedia

  • Inserting Sounds
  • Inserting Movies
  • Introducing Animation
  • Animation Sequences

Converting Presentations to Movies

The Workshop content consists of an approximately equal mixture of lecture and hands-on lab. 

Recommendation: It is strongly recommended to bring your own LAPTOP during the training on which you can install and run programs if you would like to do the optional, hands-on experiments/exercises after the trainings/ workshops.

Certificates will be provided by ISO 9001:2008 certified I-Medita Learning Solutions Pvt. Ltd. Company which is registered with Ministry of Corporate Affairs for providing IT Trainings all over India and IBNC India which is a trademark championship that has already been executed in 106 Engineering colleges till March 2015.

  • Participation Certificate: Given to each candidate who participate in the workshop
  • Appreciation Certificate: Given to the College/ Institution who help in conducting the workshop.
  • Excellence Certificate: Given to the winner of the Zonal Center Championship.
  • Coordination Certificate: Given to those active & strong students and faculty coordinators who help in making the workshop and training successful.

IBNC Team gives you freedom to ask your relationship manager at IBNC India for certificate samples in advance so that you could be aware of the certificate you will be receiving before hand the trainings/workshops.

IBNC DVD to each participant to help them learn more about the workshop containing e books, presentations, videos and softwares after the training.

  • One on one interaction in the class with the Trainer.
  • Study material designed by panel of experts from industry.
  • Lead trainer will also have supporting trainers with him/her so that they can help you fall in love with the technology.
  • We believe in learning with fun!
  • The skills we develop are those that employers within the industry are looking for.
  • Covering theoretical and practical concepts in such a way that it is fun to learn the technology and easy to make unique projects.
  • Your skills and certifications are recognized anywhere in the world your career takes you.
  • Successfully trained over 15000 students till now in India.
  • Watch video testimonials given by students: www.youtube.com/ibncindia
  • Check out our facebook page to see live comments from our prestigious students.
  • IBNC makes sure that you should get the full worth of the money you have paid during the trainings anywhere in India.

Please contact IBNC India Team to know more about careers in this technology.