Courses

Course Description

Days & Timings: Twice a week, one hour each day

Pay for 6 months get 1 month subscription free

Ages 6.5+

MS Office Three Modules (Complete Course)

1. MICROSOFT WORD
2. MICROSOFT EXCEL
3. MICROSOFT POWERPOINT

Module- 01  Word Expert

• Formatting Content
• Create custom styles for text, tables and lists
• Control pagination
• Format, position and resize graphics using advanced layout features
• Insert and modify objects
• Create and modify diagrams and charts using data from other sources
• Organizing Content
• Sort content in lists and tables
• Perform calculations in tables
• Modify table formats
• Summarize document content using automated tools
• Use automated tools for document navigation
• Merge letters with other data sources
• Merge labels with other data sources
• Structure documents using XML
• Formatting & Collaborating Documents
• Create and modify forms
• Create and modify document background
• Create and modify document indexes and tables
• Insert and modify endnotes, footnotes, captions, and cross-references
• Create and manage master documents and subdocuments
• Modify track changes options
• Publish and edit Web documents
• Manage document versions
• Protect and restrict forms and documents
• Attach digital signatures to documents

Module- 02  Excel Expert

• Organizing and Analyzing Data
• Use subtotals
• Define and apply advanced filters
• Group and outline data
• Use data validation
• Create and modify list ranges
• Add, show, close, edit, merge and summarize scenarios
• Perform data analysis using automated tools
• Create PivotTable and PivotChart reports
• Use Lookup and Reference functions
• Use Database functions
• Trace formula precedents, dependents, and errors
• Locate invalid data and formulas
• Watch and evaluate formulas
• Define, modify and use named ranges
• Structure workbooks using XML
• Formatting Data and Content
• Create and modify custom data formats
• Use conditional formatting
• Format and resize graphics
• Format charts and diagrams
• Protect cells, worksheets, and workbooks
• Apply workbook security settings
• Import data into Excel
• Export data from Excel
• Publish and edit Web worksheets and workbooks
• Create and edit templates
• Consolidate data
• Define and modify workbook properties
• Customizing Excel
• Customize toolbars and menus
• Create, edit, and run macros
• Modify Excel default settings

Module- 03  PowerPoint Expert

• Creating Content
• Create new presentations from templates
• Insert and edit text-based content
• Insert tables, charts and diagrams
• Insert pictures, shapes and graphics
• Insert objects
• Formatting Content
• Format text-based content
• Format pictures, shapes and graphics
• Format slides
• Apply animation schemes
• Apply slide transitions
• Customize slide templates
• Track, accept and reject changes in a presentation
• Add, edit and delete comments in a presentation
• Compare and merge presentations
• Managing and Delivering Presentations
• Organize a presentation
• Set up slide shows for delivery
• Rehearse timing
• Deliver presentations
• Prepare presentations for remote delivery
• Save and publish presentations
• Print slides, outlines, handouts, and speaker notes
• Export a presentation to another Microsoft Office program