+91 9999420393
011 40109421
info@talentmagnifier.com
PG Available for Outsider
|
Open 7 Days a Week

Basic & Advanced Computer Training Course

Basic Computer with Microsoft Office
Summer Vacation Course
Computer Fundamental
Microsoft Word | 
Excel
Microsoft PowerPoint | Outlook
Advanced Microsoft Excel
Advanced Tally ERP 9

Read More

In today’s technologically advanced world, not having the computer knowledge can make any individual feel inferior regardless of other activities and skills the person may have. Having basic computer knowledge is of Paramount importance for an individual if they want to succeed in their career as they will have to work on the computer at any given point of their job. This is why most students tend to pursue on Summer vacation join basic computer courses & classes where they learn how to operate a computer and perform trivial tasks efficiently. Talent Magnifier understands the importance of basic computer knowledge and thus, developed a fundamental course of Computer training for students who want to learn basic computer skills including MS Office. We are the leading computer institute in Delhi NCR who offer best Microsoft Office Training Course in Delhi along with other computer courses two candidates who are eager to learn and operate a computer easily. We offer best computer operator training classes for kids and candidates provided by highly skilled and experienced trainers. The Basic Computer Training Course in Delhi is targeted towards school students and any individual who doesn’t have any knowledge of computer and wants to master basic skills of the computer such as MS Excel, PowerPoint, outlook, etc. Therefore, if you also want to achieve success in your career then you need to begin the learning basic computer skills from Talent Magnifier.

PROGRAMME HIGHLIGHTS

Valid Certification

When the course is completed you will get a certification that will help you enter or progress in the corporate world.

Seasoned Faculty Members

Our trainers are industry professionals who have deep expertise in imparting training and working in the corporate world.

100% Placement Assistance

We ensure that you get many opportunities to give interviews to ensure that you get a good job. Our placement assistance team is highly efficient.

Lab Facility

You get the opportunity to work in a real lab where a few technical tests would help you learn better.

Awesome Workshops

Real time projects help you learn new concepts better and top class case studies let you learn from real-life examples.

Administrative Support

A skilled admin team helps you to plan your schedule better and get rid of all the doubts. They also offer support during admission and placement processes.

Talent Magnifier is a leading computer institute in Delhi who provides the most reliable and best basic computer courses to Aspiring candidate who are looking to learn the ability to perform nominal tasks using computer. The fundamental course of Computer training will begin with Microsoft office training course where the candidates will learn how to use Microsoft Word for developing a document including page layout, automated task, page breaks and margin, mail merge and printing, referencing, etc. The Microsoft training course is designed to help the candidate attain expertise on how to craft an appropriate document easily. After that, basic MS Excel training will be provided to the candidate where they will learn calculating a large amount of data using various formulas. The advanced Excel course will help the participants to master functions such as formatting spreadsheets, repeating heading, autosum and auto calculate, date and time formatting, logical functions, mathematical functions, lookup and reference functions, statistical and text functions, conditional formatting, pivot charts and tables, data validation and data analysis. The next module will cover Microsoft PowerPoint and MS Outlook training where the participants will learn how to develop a PowerPoint presentation and customize email as per the requirement. In the last section of the basic computer training, the candidate will be provided knowledge and expertise on Advanced Tally ERP 9 Training Course where they will learn how to perform accounting functions such as recording sales and purchase, developing invoices, creating a balance sheet and financial statements, updating sales record, tax deduction at source, journal entries and much more efficiently and accurately. The advanced tally course will help the applicants to become a professional accountant easily.

The basic computer course will be taught by experienced and highly certified instructors who will guide the students to operate computer and MS Office along with other basic computer tools so that they can pursue a successful career ahead. The training consists of real-time live practical training, instructor LED classroom, project and assignment, workshops and handouts, wide admin support, flexible class timings and 100% job placement assistance. Therefore, anyone who is looking to make a career in the computer or technical field, then they should immediately join our basic computer training.

A computer is a Universal tool which is utilized by all the business organization and individuals for a vast variety of jobs which include recording data, developing report, calculating number, storing and organizing information, accounting purposes, data analysis, and much more. No business organization or individual who aspires to work can survive without having basic computer knowledge and skills. This is why learning basic computer knowledge from best computer institute in Delhi can provide you with enormous benefits in the future. Some other reasons why you should attend basic computer course are as given below:

  1. Having basic computer skills will help you choose a suitable job profile in your career as per your skills and preference.
  2. Joining Microsoft Office training course will help the candidate to become a professional Microsoft engineer who can perform various functions such as developing an intriguing PowerPoint presentation, developing striking Microsoft Word document, performance spreadsheet functions such as Calculation and data validation, and much more.
  3. Attending advanced Excel course would help the participant to become a professional Excel operator and find a suitable job at any multinational agency.
  4. You can also become a professional accountant who can perform all the accounting functions using Tally ERP 9 by pursuing advanced Tally course.
  5. You can also become a Microsoft certified system engineer (MCSE) after gaining basic Microsoft Office skills from basic computer course which is a high paying job in the international market.
  6. Having basic computer skills will give your career a foundation to learn other high paying and respective skills such as programming, web design, web development, etc.

These are some of the benefits you can enjoy by learning fundamental computer skills from Talent Magnifier training institute in Delhi. If you have any doubts or questions that you need to ask, feel free to give us a call @ 9999420394 or visit our training center in Delhi.

The basic computer course is a customized and highly reliable training program developed by Talent Magnifier which is targeted towards freshers students who wants to gain fundamental computer knowledge and skills so that they can enhance their career ahead. Below are provided major features of the training program which you will enjoy:

  • Certified and respected corporate trainers with over 10 years of experience
  • Updated and job oriented course material
  • Flexible batch timings
  • Theoretical and practical sessions
  • Project and assignment on Real world cases
  • Instructor LED classroom with projector
  • Interview preparation
  • Valid certification at the end
  • 100% job placement support

There are a total of 3 module with a total duration of 70 hours. The course fee is 15000 which can be paid either in full or in three installments. Candidate can choose to attend separate module as per their preference for which the course duration and fees may vary.

Course Details

Basic & Advanced Computer Practical Training Course

Module 1.1 - Computer Fundamental
  • Applications
  • Generations
  • Types
  • Components (Hardware)
  • CPU & Its Component
  • Input devices
  • Output devices
  • Concept 0f Memory
  • Memory Units
  • Mother Board
  • Ram (Random Access Memory)
  • ROM (Read Only Memory)
  • Understanding Operating System
  • Internet and Intranet
Module 1.2 - Microsoft Word
  • Navigating
  • Format Painter
  • Font(Size, Color, Format)
  • Paragraph
  • Undo and redo
  • Automated tasks
  • Editing text
  • Moving and copying text
  • Finding and replacing text
  • Character and paragraph formatting
  • Understanding Page Layout (page setup, Background)
  • Themes
  • Using tabs
  • Basic tables
  • Spelling and grammar
  • Mailing (Mail Merge, Create Contacts)
  • References (Table of Contents, Footnote, Captions)
  • Previewing and printing
  • Margins
  • Page breaks
  • Tabs
Module 1.3 - Microsoft Excel
  • Navigating to accomplish tasks
  • Sorting data
  • Hiding columns and rows
  • Entering data
  • Date and time formatting
  • Spell check
  • Undo and redo
  • Inserting and deleting rows and columns
  • Basic formulas and Charts(Column, Pie)
  • Simple cell references
  • Functions
  • AutoSum and Auto Calculate
  • Cutting, copying, and pasting data
  • Pasting values and formulas
  • Filling series
  • AutoFill
  • Copying
  • Formatting spreadsheets
  • Margins, headers and footers
  • Print options, setting print areas
  • Repeating headings
  • Adjusting column widths
  • Number formatting with toolbar buttons
  • Working with text in spreadsheets (formatting, wrapping, aligning, paragraph returns, merging and centering)
Module 1.4 - Microsoft PowerPoint
  • Views, navigation
  • Using outline view
  • Changing indent levels
  • Adding and formatting text
  • Applying design styles
  • Setting font styles
  • Auto-layouts
  • Using the Slide Master
  • Adding and formatting pictures
  • Creating auto-shapes
  • Image layering
  • Creating organizational charts and formatting
  • Working with text placeholders
  • Drawing shapes
  • Using transitions and animation
  • Duplicating and rearranging slides
  • Viewing and navigating in the presentation
  • Tips for professional presentations.
Module 1.5 - Microsoft Outlook
  • Setting preferences
  • Customizing views
  • Signatures
  • Auto archiving
  • Out of office reply
  • Advanced toolbar
  • Viewing e-mails in groups
  • Custom views
  • Adding columns
  • Creating search folders
  • Follow up flags
  • Printing calendars and options
  • Using e-mail voting buttons & features
  • Deleting auto-complete e-mail addresses
  • Creating rules
  • Printing attachments
  • Organizing contacts with categories
  • Managing and tracking client interactions with Outlook activities
  • E-mailing contact cards
  • Using Tasks (creating, organizing, assigning and tracking)
  • Using Journaling
  • Setting additional preferences
  • Setting calendars and folders
  • Sharing permissions
  • Planning meetings
  • Using and creating Public Folders
Introduction to Advanced Excel:-
  • Mathematical Functions:-
Sum, Sumif, Sumifs, Count, Counta, Countblank, Countif, Countifs, Average, Averagea, Averageif, Averageifs, Subtotal, Aggregate, Rand, Randbetween, Roundup, Rounddown, Round, Sumproduct
  • Date & Time Function:-
Date, Day, Month, Year, Edate, Eomonth, Networkdays, Workday, Weeknum, Weekday, Hour, Minute, Second, Now, Today, Time
  • Text Functions & Data Validation :-
Char, Clean, Code, Concatenate, Find, Search, Substitute, Replace, Len, Right, Left, Mid, Lower, Upper, Proper, Text, Trim, Value, Large, Small, Filters (Basic, Advanced, Conditional), Sort (Ascending, Descending, Cell/ Font Color), Conditional Formatting, Data Validation, Group & Ungroup, Data split.
  • Statistical Function & Other Functions :-
Isna, Isblank, Iserr, Iseven, Isodd, Islogical, Isytext, Max, Min, Len, Right, Left, Mid, ,Maxa, Maxifs, Median, Minifs, Mina, Vara, Correl, Geomen
  • Logical Functions:-
And, Or, If, Iferror, Not, Nested If
  • Lookup & Reference Functions:-
VLookup, HLookup, Index, Match, Offset, Indirect, Address, Column, Columns, Row, Rows, Choose, Arrays Concept In Lookup Formula’s, Past Special, Past link
  • Pivot Table and Charts:-
Import and Export data, Protect/Unprotect sheets/workbooks. Worksheet formatting and Print Display
  • Data Collection Method With Data Quality:-
Collaboration & Security Like Share Your Workbook On Share Drive With Quality
  • Analysis:-
Single/Multidimensional Analysis, Like Three Dimensional (3D) Tables, Sensitive Analysis Like Data Table, Manual What-If Analysis, Threshold Values, Goal Seek, One-Variable Data Table, Two-Variable Data Table
  • Advanced Chart Technique:-
How To Make Dynamic Charts, Bar Charts, Pie Charts, Scatter Chart, Line Chart, Column Chart, Speedometer Chart, Gantt Chart.
  • Advanced Dashboard.
  • Report Development
  • Live Project Session.
  • Upgrading to Tally.ERP 9 Release 6.0
  • Start Using Tally.ERP 9 for GST Compliance
  • Activating GST for Your Company
  • Setting Up GST Rates
  • Updating Stock Items and Stock Groups for GST Compliance
  • Updating a Service Ledger for GST Compliance
  • Updating Sales and Purchase Ledgers for GST Compliance
  • Updating Party GSTIN.
  • Creating GST Ledgers(CGST, SGST, IGST)
  • Creating Income and Expense Ledgers
  • Recording Sales and Printing Invoices
  • Recording Purchases
  • Recording a Tax Payment
  • Other Scenarios
  • Contra and Journal Voucher
  • Masters: Inventory
  • Implementation of GST in Tally
  • Cost Categories
  • Party Ledger Analysis
  • Stock Analysis and Reports
  • Cash and Bank Reports
  • Financial Reports
  • Export, Import,
  • Tax Deducted at Source (TDS) in Tally
  • Tax Collected at Source (TCS) in Tally
  • Payroll Accounting in Tally
  • Printing Reports
  • Sales - Nil Rated, Exempt, SEZ, and Deemed Export
  • Recording Sales Returns
  • Recording Purchase Returns
  • Recording Export Sales
  • Reverse Charge under GST
  • Recording an Advance Receipt from Customer
  • Recording an Advance Payment to Supplier
  • Recording a Journal Voucher for TDS Adjustment
  • Recording a Journal Voucher for Refund of Tax Credit
  • Recording a Journal Voucher for Transitional Credit
  • Recording Journal Vouchers for Other Liabilities
  • Recording Journal Vouchers for Reversal of Tax Credit
  • Recording journal vouchers for manufacturing unit.
  • BRS (Bank reconciliation statement)
  • GST Reports (GSTR3B, GSTR1, GSTR2, GSTR3)
  • GST Computation

Course Time & Duration Details

Course ModulesDuration (Hours)Duration (Weekend)
(Saturday- Sunday)
Duration (Weekdays)
(Tuesday - Friday)
Module 1,2&365 - 70 Hours3 - 4 Months1.5 - 2 Months
Module 1 & 245 - 50 Hours2.5 - 3 Months1 - 1.5 Months
Module 1 & 350 - 55 Hours2.5 - 3 Months1 - 1.5 Months
Module 125 - 30 Hours1.5 - 2 Months1 Month

Learners Reviews & Placement

FAQ

The target audience is school kids and candidates who don't have any expertise and knowledge of computer.
Yes, the training consists of Advanced excel and advanced Tally ERP 9 training which would help you become a professional accountant in the future.
If you miss any class are you do not understand a topic, then we can arrange a backup class for you where you can clear your doubts.
You can contact Talent Magnifier at 9999420394 | 9999420393 or visit our centre in Delhi in order to resolve your query.
We provide Interview preparation and valid certification to the candidate in order to get a competitive edge during the interview. We also send the participants to our associated companies for job interviews.
Yes, we provide both weekdays and weekend classes to the candidate as per their preference and choice.