For Queries. Please Contact Us at 044 4322 7001; 97911 79307
What We Teach - MS Office
MS WORD
- Creating a Basic Document
- Explore the User Interface
- Open and View a Document
- Customize the Word Environment
- Obtain Help
- Enter Text
- Save a Document
- Preview and Print a Document
- Editing a Document
- Navigate and Select Text in a Document
- Insert, Delete, or Rearrange Text
- Undo Changes
- Search and Replace Text
- Formatting Text
- Change Font Appearance
- Highlight Text
- Formatting Paragraphs
- Set Tabs to Align Text
- Control Paragraph Layout
- Add Borders and Shading
- Apply Styles
- Create Lists
MANAGE FORMATTING
- Adding Tables
- Create a Table
- Modify the Table Structure
- Format a Table
- Convert Text to a Table or Tables to Text
- Inserting Graphic Objects
- Add Visual Effects Using Symbols and Special Characters
- Insert Illustrations
- Controlling Page Appearance
- Control Page Layout
- Apply a Page Border and Color
- Add Watermarks
- Add Headers and Footers
- Proofing a Document
- Check Spelling, Grammar and Word Count
- Enhance Textual Meaning Using the Thesaurus
- Customize AutoCorrect Options
MS EXCEL - EXCEL BASICS
- An overview of the screen, navigation and basic spreadsheet concepts
- Understand Excel terminology workbooks, worksheets, rows, columns, cells
- Various selection techniques
- Understanding the various mouse cursors
- Working with Ribbon Tabs, Groups and Dialog Boxes
- Standard and Contextual ribbons
- Use the task pane
- Understand and use the File Tab
- Saving, File types, File compatibility (earlier versions)
- Useful keyboard commands
- Quick Access Toolbar & Mini Toolbar
- Get Help!
ENTERING DATA
- Various ways to Enter, Edit and Delete information (Text, Numbers, Dates)
- Use Auto List feature
- Date and Time are storage in Excel
- Enter Dates and Times
- Date/time formatting
- Methods to Move and Copy data
- Use the Fill Handle to copy data and create simple lists
- Create series of information
- Insert, Delete and Hiding Rows & Columns
- Insert, Delete and Move Cells
- Insert, Delete, Move and Copy Sheets
- Various navigation techniques
- Creating & Editing Formula & Functions
- Define Formula
- Create & Edit Formula
- BODMAS : Mathematical Order
- Copy & Move Formula
- Use Basic Functions - Sum, Average, Max, Min, Count, Counta
- Use Autosum tool
FORMATTING AND PROOFING
- Formatting of Cells with Number formats, Font formats, Alignment, Borders, Fill colours and Patterns
- Quick formats and themes
- Sheet tab formatting and Renaming
- Copy and Clear Formats
- Merging cells
- Spell Check, Find & Replace and AutoCorrect
PRINTING AND PAGE SETUP
- Page Orientation
- Add Headers and Footers
- Print a selection
- Set a print area
- Clear a print area
- Multiple File & Large Workbook Tools
- Split screen tool
- Freeze panes
- Arrange workbook windows
- Zooming tools
- GoTo tool
MS POWERPOINT
- PowerPoint Overview
- User interface overview Ribbons, Tri Pane View (Normal)
- File Tab and usage
- Navigation Pane
- The PowerPoint views and how to access them
- Using Help
- PowerPoint Views
- The Normal View
- The Slide Sorter View
- The Notes Pages View
- The Reading view
- The Slide Show View
- The View in Black and White
- Viewing the Slide Miniature
- Accessing Print Preview
- How to access Outline View
- Creating a New Presentation
- Creating A New Presentation and Saving
- Create a presentation from inbuilt templates
- Placeholders
- Adding New Slides - entering & editing Text (slide view)
- Understanding Slide Layouts and changing / reapplying a layout
- Understanding the text levels
- Entering bulleted text
- Adding Freeform Text (text Boxes)
- Creating Blank Slides
- Formatting Text
- Text Selection
FORMATTING TEXT
- Formatting Backgrounds (Slide and Placeholder)
- Formatting Numbered and Bulleted Lists
- Format Painter
- Entering text in Outline
- Changing text levels
- Shortcut keys for navigating in outline
DRAWING TOOLS
- The Insert Ribbon
- The design & format ribbons
- Drawing basic shapes freehand
- Creating regular shapes
- Formatting Shapes including 3D, Shadows and Fill Effects
- Enter and format Smart Art
- Set Shape Options
- Connect shapes
- Graphics and Clipart
- Insert Clip Art
- Moving and Resizing
- Format Ribbon and Clip Art
- Grouping and Ungrouping Clip Art
- Tables and Charts
- Create and use a table
- Add text
- Insert columns and rows
- Format a Table
- Create a chart
- Edit the Chart Type
- Edit the Chart Options
- Format a chart
- Create an organisation Chart (Smart Art)
- Create an organisation Chart (Shapes)
- Edit and Format an Organisation Chart
- Saving presentations
- Saving as a presentation
- Saving as a slideshow
- Saving as a video
- Publish to web / SharePoint
- Save to other formats
- Printing Presentations
- Print Preview
- Printing Slides
- Printing Hand-outs
- Printing Notes Pages
- Printing Outline View