Office AutomationCourse
We at Aonlinetraining offer interactive online courses (e-learning) for Office AutomationCourse .
Learn Office Automation Course , interactive training program beginining right from the basics of designing. Book a Free Demo Class Now
Students for Office Automation Course requires 40 hours to Study / Complete the course
Office Automation Course
Microsoft Word
Microsoft Excel
Microsoft PowerPoint
Phase I
- How to open a new document in Word 2007
- How to find a word
- How to replace a word
- How to save a file
- How to close a file
- How to open an existing file
- How to use cut and paste
- How to use copy and paste
- How to select the whole text
- Overview home tab
- How to clear formats
- How to go to different views
- Overview Insert tab
- How to exit from word
Phase II
- Work with insert option
- Cover page
- Blank page
- Page break
- Insert Table
- Insert excel sheet
- Insert Pictures from folders
- Insert clip-art
- Insert shapes
- Insert smart art
- Insert chart
- Use of hyperlink
- Bookmark
- Header and Footer
- Text box
- Word art
- Drop cap
- Insert object and symbols
Phase III
- Working in page layout
- Set up themes
- Color themes
- Text themes
- Page set up
- Use of columns
- Watermarks
- Page Color
- Page border
PHASE IV
- Work in references tab
- Insert foot note
- Insert end note
- Insert next note
- Bibliography
- Insert caption
Phase V
- Work in review tab
- Spelling and grammer
- Translate
- Thesaurus
- Comments
- Protect document
Phase VI
- Work in view window
- Split
- Arrange all
- Macros
- Zoom
- Show\hide items
- Document views
Module 1: Getting Started
- Understanding the Excel screen
- Navigating in a spreadsheet
- Understanding worksheets, columns, rows and cells
- Saving, opening, and closing workbooks
Module 2: Formatting a Spreadsheet
- Changing column widths and row heights
- Changing alignment of cells
- Undoing and redoing actions
- Formatting numbers
- Clearing formats
- Applying borders to cells
- Merging cells
Module 3: Formulas and Functions
- Entering formulas
- Copying data and formulas
- Using AutoSum
- Understanding functions
- Using simple aggregate functions (Sum, Count, Average, Min, Max)
- Copying formulas
- Applying conditions in a formula (The IF function)
- Working with ranges
Module 4: Editing Features
- Using cut , copy, and paste operations
- Using paste special with values
- Selection techniques
- Navigation techniques
Module 5: Working with Large Worksheets
- Freezing and unfreezing panes
- Splitting windows
- Inserting page breaks for printing
Module 6: Working with Charts
- Creating charts using Chart Wizard
- Creating different types of charts
- Including titles and values in charts
- Formatting of charts
Module 7: Previewing and Printing
- Previewing worksheets
- Page setup
- Printing of worksheets in multiple pages
- Repeating rows and columns for multiple pages
- Printing multiple worksheets
Module 8: Simple Database Operations
- Sorting tables
- Filtering data with auto filter
- Referring data from other worksheets
Introduction
- To Start the Program
- What is powerpoint
- Parts of powerpoint window
- Overview of Menu bar
Edit Menu
- Cut & Paste
- Copy & Paste
- Find
- Replace
View Menu
- Normal
- Slide Sorter
- Notes Page
- Slide Show
- Slide Master
- Title Master
- Black and White
- Toolbars
- Ruler
- Header and Footer
Insert Menu
- New Slide
- Slide Number
- Date & Time
- Comment
- Slide Number
- Data & Time
- Comment
- Picture
- Text Box
- Table
- Object
Format Menu
- Font
- Bullet and Numbering
- Slide Layout
- Slide Color Schema
- Background
- Design Templates
- Colors and Lines
Tool Menu
- Auto Correct
- Macro
- Customize
- Option
Slide Show Menu
- View Show
- Set Up Show
- Action Buttons
- Present Animation
- Custom Animation
- Slide Transition
- Custom Shows