
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.
