Office automation course, best computer institute in jaipur, computer course, advance computer course nearby, MS excel, MS word, MS power point Learn computer

Office-Automation

Duration: 02 Months | Session : 15
Eligibility: 10th, B.COM, B.A, BCA, M.COM

Interest recruiters by adding Tally Prime in your Resume! Master Tally Prime

TIFA Education is the leading and most Prolific TIFA Education Pvt Ltd Jaipur providing an affordable in-person Tally Prime Course and guidance by trained Accounts faculty. We guide people from every background to change their lives via our career-oriented courses in Jaipur. Our Online and offline course primarily focus on college students and full/part-time employees.

Interested To Know More? Speak To Our Expert Academic Counsellor Now! CALL NOW

Course Highlight :-


ALL ABOUT COMPUTER

Introduction | Hardware | Application Software | System Software | Concept of Computing |Benefit of Computer | Use of Computer | Concept of Computers

Introduction of Internet | Internet Access | Types of Internet Connections | Intranet | Search WebPages | Create E-mail | E-Commerce | Google Drive

Start Computer | Component of Computer System | Input Devices | Output Devices | Checking Computer System Configuration in Window | Operating System Simple Setting

E-Governance in Rajasthan | E-Mitra | Bhamashah Scheme | Rajasthan Sampark | E-Public distribution System E-PDS | Geographical Introduction System Rajdhara | Bhamashah Swasthya Bima Yojana-BRSY | Bhamashah Rojgar Srijan Yojana-BRSY

Operating System | GUI – Desktop | Windows: Basic Applications/Utilities | Windows-File Explorer | Staring Application | Copy/Paste/Rename File | Copy/Paste/Rename Folder | Scan File/Folder with Antivirus

Single Sign on Facility – SSO | Availing Citizen Services | E-Mitra Services through Portal | Bhamashah Scheme | Rajasthan Sam Park | E-Public distribution System E-PDS

MICROSOFT EXCEL

Introduction | Getting Started | Explore Window | Office Button | Quick Access Toolbar | Mini Toolbar | Title, Zoom and View

Worksheet Create, Save, Copy, Hide, Unhide, Delete, Close, Open | Worksheet, Row, Column and Cells | Data Insert, Select, Delete, Move | Cut, Copy, Paste and Spell Check | Undo, Redo and Find & Replace | Insert Symbols and Comments

Creating Formula | Copying Formula | Reference Formula | Function Arguments Formula | Error Show in Formula

Text Alignment | Text Decoration | Merges & Wrap | Rotate Cells | Borders and Shades | Setting Colours | Setting Fonts | Setting Cell Type | Applying Formatting | Style | Theme

Operators Functions | Numeric Functions | Text Functions | Statistical Functions | Date & Time Functions | Mark Sheet Table Simple Level | Mark Sheet Table Advance Level

Logical Functions {AND, OR, NOT} | Conditional Functions {IF, Nested IF, IF Error} | Mathematical Functions {COUNTIF, COUNTIFS, SUMIF, SUMIFS, SUMPRODUCTION} | Lookup Functions {VLOOKUP, HLOOKUP, MATCH, INDEX, CHOOSE} | Financial Functions {PV, FV, PMT, IPMT, PPMT, RATE}

Insert Smart Art | Add Text Smart Art | Insert Pictures | Insert Clip Art | Format Picture | Insert Word Art | Format Word Art | Insert Lists | Insert Shapes | Format Shapes

Sheet Options | Adjustment Margins | Page Orientation | Header and Footer | Insert Page Breaks | Set Background | Freeze Panes | Print Setup | Security | E-Mail | Mail-Merge

Creating Charts | Editing Charts | Formatting Charts | Combination Charts | Using 3D Charts| Using Secondary Axis in Graphs | Sharing Charts with Power Point/MS. Word | Dynamically Charts | Charts Modified/Updated

Creating Pivot Table | Formatting Pivot Table | Customizing Pivot Table | Slicers Pivot Table | Grouping Data in Pivot Table | Pivot Table Charts

Define Name Range | Data Sorting and Filtering | Data Validation

Create Macros | Run Macros | Edit Marcos | Save Marco

Home Tab | Insert Tab | Page Layout Tab | Formulas Tab | Data Tab | Review Tab | View Tab

Home Cleaning Checklist | Packing Checklist | Contact List | Customer List | Simple Interest Loan Calculator | Loan Amortization | Salary Sheet (Days Wise) | Salary Wise (Time Wise) | Timesheets Calculators | Age Calculators | Do List (Drop Down List) | Simple Budgets | Home Budgets | Simple Invoices | Expenses Reports | Home Inventory| Money Tracker | Stock Maintain Inventory | Attendance Sheet | Allowance & Deduction Calculation

MS WORD

Introduction | Getting Started | Explore Window | Office Button | Quick Access Toolbar | Mini Toolbar | Title, Zoom and View

Create New Document | Save Documents| Opening Document | Closing Document | Insert Text | Select Text | Delete Text | Move Text | Cut, Copy & Paste | Undo & Redo Change | Find & Replace | Spell Check | Insert Special Symbols | Insert Comments

Setting Text Fonts | Text Decoration | Change Text Case | Change Text Colour | Text Box | Text Alignment | Text Size | Set Tabs | Indent Paragraphs | Create Bullets | Set Line Spacing | Border and Shades | Create New Style | Customized Style | Apply Style | Apply Formatting

Adjust Page Margins | Header and Footer | Add New Page Numbers | Insert Page Breaks | Insert Blank Page | Cover Pages | Page Orientation | Page Size | Page Margins

Create Table | Add Rows & Columns Table | Delete Rows & Columns | Merging & Split Cells | Move Table | Resize Table | Split Table | Borders & Shades Table | Convert Text to Table

Insert Smart Art | Add Text Smart Art | Insert Pictures | Insert Clip Art | Format Picture | Insert Word Art | Format Word Art | Insert Lists | Insert Shapes | Format Shapes

Home Tab | Insert Tab | Page Layout | References | Mailing | Review | View

Resume Cover Letter | Resume | Application | Letter

MS POWER POINT

Introduction | Getting Started | Explore Window | Office Button | Quick Access Toolbar | Mini Toolbar | Title, Zoom and Placeholder

Create New Presentation | Save Presentation | Opening Presentation | Close Presentation | PowerPoint Sidebar | Presentation views | Running Slide Show

Add New Slides | Adding Text in Boxes | Adding New Text Boxes | Deleting Exiting Slide | Rearranging Slides | Adding Slide Notes | Managing Sections | Working with Outlines | Setting Backgrounds | Slide Orientations | Adding Slide Numbers | Adding Header & Footer

Font Management | Setting Text Fonts | Text Decoration | Change Text Case | Change Text Size | Change Text Colour | Text Alignments | Indent Paragraphs | Set Line Spacing | Borders and Shades | Applying Formatting | Using Slide Master | Save Design Template

Add Pictures to Slide | Editing Added Pictures | Format Added Picture | Add Shapes to Slide | Editing Added Shapes | Format Added Shapes | Add Text to Shapes | Arrange Shapes/Images Groups/Ungroup Objects | Add Audio & Video | Add & Format Table | Add & Format Charts | Add & Format Smart Art

Animation Effects | Custom Animation Effects | Slide Transition Effects | Set Slide Transition Sound | Set Slide Transition Speed | Advance Animations Effects | Advance Transition Effects

Home Tab | Insert Tab | Design Tab | Animations Tab | Slide Show | Review | View

Create Video File | Create Image File | Printing Presentation | Broadcast Slide Show | Packaging Presentation | Setting Document Password | Email Slide Show

ASSIGNMENT

Digital Marketing Highlight

  • Salary Sheet (Day/Time Wise )
  • Attendance Sheet
  • Stock Maintain
  • Allowances Calculation & Deduction
  • Pan Card, Aadhar Card Downlond & Updation
  • Pan Card, Tan Apply Form
  • SSO ID
  • Bill Print
  • Courier Ticket Track
  • Mailing
  • Profile Presentation
  • Mail Merge
  • Billing With GST
  • Practical Session

Program highlights

Experience and Inspiring Trainers:

Our instructors bring their industry experienced years to use during the course. They are both expert and enthusiastic about presenting an impelling training as they are aware of every aspect of training. They can also advise you on all the options to make sure you get the best result possible.

Real-time Practice and Projects:

Our Tally Prime Courses are both thorough and efficient. We usually work on industry-associated projects. If you have a project or an idea then you can share it with our instructor after completion of the course and they will help you to work on it.

Prerequisites for Office Automation course:

It is essential to know the basics of computing knowledge. And profound knowledge of Accounts will be helpful.

Certificate:

After ending this training, you will also get a course completion certificate in the Office Automation to gain recognition from newly adaptable new skills.

Support and Careers Advice:

Our instructors are always willing to help you with any issues or questions concerning Advance Accounts Spring-Hibernate. We qualify students for facing Interview questions on a given technology and help to build their online portfolio. As more than 70% of students are placed in reliable and reputed MNCs.

Program Highlight

  • Learn from Expert
  • 100% Placement Guarantee
  • 0% interest EMI option
  • Practical Training
  • Learn accounting tool & software
  • One to one mentorship
  • Resume and interview training
  • Certification