CERTIFICATION COURSE IN
OFFICE AUTOMATION

Basic Functions -

Sum, Sum in Range, Sum of Specific Cells, sumif, Subtraction, Multiply & Product, Division, Mode, Count, Counta, Countif (wild Card), Average, Averageif, Min, Max, Simple Interest,

Text Functions -

Upper, Lower, Proper, Left, Right, Mid, Concatenate, Substitute

Maths Functions -

Even, Odd, Fact,

Date Time -

Now, Today,

Lookup & Reference –

Vlookup, Hlookup,

Basic –

New, Open, Save, Save As, Print Preview, Print, Close, Cut, Copy, Paste, Font, Font Size, Bold, Italic, Underline, Alignment, Margin, Orientation, Size, Print Area, Spelling

Home -

Paste Special -, Value, Conditional Formatting, Fill - Series, Justify, Flash fill, Sorting & Filtering, Insert, Pivot Tables, Charts, Hyperlink, Page Layout, Print Area, Print Titles, Formulas, Name Manager, Trace Precedents / Dependents, Show Formulas, Watch Window, Calculation Option

Internet

• Over view about Internet and Browser
• Various Browsers
• Various methods to open Browser
• Short way to open website
• Setting up the default website
• Creation of Bookmark – Just one click to open site
• Use of History
• Precautions of Fast Browsing
• Downloads
• Extensions – Utility to get extra advantages
• Short Keys – Work Fast
• Important contents of E-mail (Scheduling, Signature, Formatting, Group etc.)

Windows

• Basic of windows
• Know about your System Configuration
• Important short key windows
• Control Panel
• Desktop
• Device Manager
• Task Manager

Accounting Fundamental

Computerized Accounting on Marg Software

Communication Skills

Importance and effect of Communication skill

Perfect Resume Preparation

How to increase visibility to employer

Cracking the interview