OFFICE AUTOMATION

office automation

Office Automation at Anil Computers ,Udaipur, Rajasthan, India.

Hardware Introduction, MS Word 2010 & 2013 or Higher

(Mail Merge, Macro, Hyperlink, Bookmark, Password, Macro, Footnote – Endnote, Track Changes, Table Formats, PDF Creation, 5 Types Tabs, Speed Checking, Many Short Comamnds, Heading Styles, Letter Paid, Resume, Project Report, Cover Pages etc.)

Introduction Of Ms Word 
MS Word - How to Create a New Document , Open File, Using Save & Save as Option In MS Word
Difference save & save as
How to Print Particular Page Or Paragraph in MS Word
how to cancel print command 
How to Use Copy, Cut, Paste Option In Ms Word
diffrence paste or paste shortcut
Page Setup
Font Setting
Paragraph Setting
Page Background
Insert Table
Picture
Clipart
Shape
Smart Art
Screenshot
Insert Cover page
Blank Page
Page Break
Header & Footer
End note & Foot note
Text Box
Drop Cap
Date & Time
Object
Hyperlink
Bookmark
View Menu- Rular, Gridlines, Navigation Pane, Zoom
Editing - Find, Replace, Select
Clipboard - Copy, Cut, Paste, Format Painter
Protect the File
Create PDF File
Restrict Editing
Spelling and Grammer
Styles

Function key

Tab Setting

Mail Merge

Envelopes

Lables

Comment

New Window

Macros

Logo Design

Table of Content

How to compare two document

Cross Reference

Professional MS Excel 2010 & 2013 or Higher

(Vlookup, Hlookup, Scenario, Pivot Table, Validation, Macro, Forms, Filters, Advance Filter, Paste Special, Conditional Formates, Styles, Many Formulas, Freeze, Goal Seek, Many Short Commands, Adv. Pagesetup, Work List, Attendance, Mark sheet, Loan interest Calculation, Inventory, EMI Calculator, Exam Records, Personal Calendar etc.)

Introduction of ms excel
Auto Fill
Insert row and column
Change row height and column 
Delete row and column
Hide and unhide row and column
Merge and center
Wrap text
Sheet option
Arrange window
Use cut, copy and paste
How to use Format painter
Excel font: changing font, font style, bold,italic, and underline
Text Alignment
How to use Undo and Redo option
Custom sort part 1
Spelling and Grammar
Protect cell
Protect sheet
Comment
Advance printing method
How to insert Water mark
Hyperlink
Remove page break
Grouping Column
Bullet marks
Custom sort part 2
Header and Footer
Chart part 1
Chart part 2
Password protection
Advance page setup
Lock cell
Text Rotation
Number block
Auto sum
Product
Blank formula
Change Case
Freeze panes
Quick Access
Change currency
Average Formula
Fact Formula
And formula
or formula
Round
Sqrt
Count 
Today
Now
Mod
Min and Max
Even or odd
Discount
Percentage 
Mini Toolbar
Select Blank cell
Find and replace
How to create Border
Convert Excel file to pdf 
Absolute cell reference
Char Function
Clear Function
Code Function
Dollar Function
Left & Right  Function
Right Function
Mid Function
Replace Function
Rept Function
Search Function
Trim Function
ABS Function
INT Function
Roman Function
Round, Round up or Round down
PMT Function
PV Function
Rate Function
NPER Function
Future value Function
Due and Advanced Amount
Scenario Manager
Data Table
Remove if Zero
Pivot Table
Sub Total
Attendance Sheet
Insert New tab
Paste Special
Age calculator
Concatenate
Sparkline
Text to cloumn
Format as table
Fill Blank cell in excel
Count if
Vlookup
Hlookup
Pass or fail formula
Goal seek
Excel Error
Find Formula
Rand and Randbetween
Substitute
Mix cell reference
Marksheet
Nested if 
Cube Root
Exact
Istext and isnontext
Comma Style
Sumif Formula
MIS Report
Indirect Function
Index with Match
Sumproduct
Array
Create New Template
Forecast Formula
Simple Interest 
Pivot Chart
Index Function
Data Validation 
Dget Formula
E Date
Lookup Formula
Small Formula
Consolidate Multiple Sheet
How to use even or odd with if formula
Is even or is odd formula
Macros
DB Formula (Depriciation)
Frequency Formula
Large formula
Formula Auditing
GCD Formula
LCM Formula
Calculation Option
Conditional Formatting
Conditional formatting (part 2)
Conditional formatting (part 3)
Dmax and Dmin
Average if
Daverage 
Dcount
Floor & Celling
If Error
How to convert number to word
How to split name or surname
Full screen
Best triks in excel form subtotal
Excel Master Tricks
Excel Magic Tricks
Important setting part 1
Important setting part 2
Important setting part 3
How to create Bill Format
Create Salary Slip

MS Power Point 2010 & 2013 or Higher

(Photo Album, Business Presentation, Animation Show, Custom Show, Project Presentation, Time Table, Information Board, Co. Profile, Training Presentation etc.)

Introduction of powerpoint
New Presentation
New slide
Changing Slide Order
Themes
Photo Album
Slide Number
Insert Video or Audio
Transitions
Animations
Clock Project
Creat a Clipart image
Convert Power Point file to video
Using Section Option in Slides
Motion Path
Handwriting Text Effect
Advance Clock Project

Advanced Windows

(Many Short Keys to work Smartly, Calculator, Defragmenter, Scan disk, Anti Virus Scan, What is Turn off & Log off, Character Map, Disk Cleanup, Devices Formatting, Fonts Installation, Printer Installation, Software Uninstallation, Why computer speed go slow & than what will You do etc.)

Advance Internet

– Theory of Internet
– E-mailining
– Downloading
– You Tube
– Attachments
– On Line Form Filling
– SMS sending
– Result Searching
– Chatting
– E-mail ID creation
– Video Conferencing
– Searching
– Save data on mail Address
– Attachments
– Skypee
– Team Viewer
– Face Book
– E Ticketing
– E- Cards
– Password Changing
– Google Earth etc.
– Google Map
– Online Mobile Recharge
– Govt. Sites etc.

Windows Explorer

Printing

Winzip

Kundali Pro

Scanning

- Storage Devices (CD, DVD, Pen Drive, Ext. HDD etc.)