BASIC ADVANCED computer Diploma Training

Learn The Basic Softwares Used In the Industry With One month In-House Job

SKMTECHNOSOLZ has designed this particular course with one month Job for fresher’s & people new to computers so that they can gain hands-on training on computers plus job experience working with in-house professionals and know how to use computer related appliactions for offices..

Basic Computing

COURSE FEES : Rs 6000

ONE MONTH SALARY : Rs 1000 ( One Month Job With Experience letter & Attend Interviews For Jobs )

IN TOTAL YOU WILL ONLY BE PAYING : Rs 5000

ABOUT BASIC COMPUTER

Suite of products developed by Microsoft Corporation that includes Microsoft Word, Excel, Access, Publisher, PowerPoint, and Outlook. Each program serves a different purpose and is compatible with other programs included in the package. The suite of programs is compatible with both the Windows and Macintosh operating system. Microsoft Office is the most common form of software used in the western world.

BASIC COMPUTER STEP BY STEP MODULES

Module 1

1.Introduction to Microsoft Word 2013
2.Working with Documents and the Keyboard
3.Navigating Through a Word Document
4.Basic Text Editing
5.Text Formatting
6.Paragraph Formatting
7.More Ways to Format Text and Paragraphs
8.Style Formatting
9.Page Formatting
10.Templates
11.Working With Graphics and Pictures
12.Tables
13.Desktop Publishing
14. Long Documents
15. Technical Documents
16. Mail Merge
17. Proofing, Printing, and Publishing
18. Comparing, Merging, and Protecting Documents
19. Customizing and Expanding Word

Module 2

1.Introduction to MS Excel 2013
2.Navigating Excel 2013
3.Worksheets and Workbooks
4.Entering Information into MS Excel 2013
5.Introduction to Working with Cells, Rows, and Columns
6.Formatting Data and Cells
7.Formatting Rows and Columns
8.Editing Cells, Rows, Columns, and Worksheets
9.Introduction to Formulas and Calculations
10.Working with Formulas and Functions
11.Maintaining Worksheets
12.The What-If Analysis
13.Adding Images and Graphics
14.Charts and Diagrams
15.Creating Data Lists
16.Managing Data
17.Pivot Tables and Charts
18.Printing Worksheets and Workbooks
19.Templates
20.Protecting, Saving, and Sharing Workbooks

Module 3

1.Introduction to Microsoft Word 2013
2.The Basics of Creating Presentations
3. Applying Themes and Layouts to Slides
4.Working with Objects
5.Entering, Editing, and Formatting Text
6.Working in Outline View
7.Proofing Presentations
8.Notes
9.Inserting Pictures, Graphics, Shapes, and Other Things
10.Inserting Tables into Presentations
11.Charts and SmartArt
12.Adding Sound and Video
13.Adding Transitions and Animation
14.Master Slides
15.Printing and Running Slide Shows
16.Saving, Sharing, and Exporting Presentations

ADVANCED COMPUTER

COURSE FEES : Rs 6000

ONE MONTH SALARY : Rs 1000 ( One Month Job With Experience letter & Attend Interviews For Jobs )

IN TOTAL YOU WILL ONLY BE PAYING : Rs 5000

ABOUT ADVANCED COMPUTER

Ms. Office course trains students how to use MS Office applications use in office work such as creating
professional-quality documents; store, organize and analyze information; arithmetic operations and functions;
and create dynamic slide presentations with animation, narration, images, and much more, digitally and
effectively.

ADVANCED COMPUTER STEP BY STEP MODULES

MODULE 1

1.Creating, editing, saving and printing text documents
2.Font and paragraph formatting
3.Simple character formatting
4.Inserting tables, smart art, page breaks
5.Using lists and styles
6.Working with images
7.Using Spelling and Grammar check
8.Understanding document properties
10.Mail Merge

MODULE 2

1. Spreadsheet
2. Creating, editing, saving and printing spreadsheets
3. Working with functions & formulas
4. Modifying worksheets with color & autoformats
5. Graphically representing data : Charts & Graphs
6. Speeding data entry : Using Data Forms
7. Analyzing data : Data Menu, Subtotal, Filtering Data
8. Formatting worksheets
9. Securing & Protecting spreadsheets

MODULE 3

1. Opening, viewing, creating, and printing slides
2. Applying auto layouts
3. Adding custom animation
4. Using slide transitions
5. Graphically representing data : Charts & Graphs
6. Creating Professional Slide for Presentation.

MODULE 4

1. Understanding how to search/Google
2. Bookmarking and Going to a specific website
3. Copy and paste Internet content into your word file and emails
4. Understanding social media platforms such as Facebook & Many more
5. Learn with best practices

VBA MACRO

COURSE FEES : Rs 6000

ONE MONTH SALARY : Rs 1000 ( One Month Job With Experience letter & Attend Interviews For Jobs )

IN TOTAL YOU WILL ONLY BE PAYING : Rs 5000

ABOUT VBA MACRO

VBA Macros use the Visual Basic Application in Excel to create custom user-generated functions and speed up manual tasks by creating automated processes. Additionally, VBA can be used access the Windows Application Programming Interface (API). One of its main uses is to change and customize the user interface by creating personalized toolbars, menus, dialog boxes, and forms.

VBA MACRO STEP BY STEP MODULES

MODULE 1

1. Visual Basic Editor (VBE) in Excel
2. The Project Window in the Visual Basic Editor of Excel
3. The Properties Window in the Visual Basic Editor of Excel
4. The Code Window in the Visual Basic Editor of Excel
5. Developing Macros in the VBE
6. Testing Macros in the VBE
7. Excel Macro Recorder
8. Macros Help and Assistance
9. VBA Events
10. VBA Security and Protection

MODULE 2

1. VBA Coding Tips
2. Dealing with Errors
3. Working with the Application
4. Working with the Workbooks
5. Working with the Worksheets
6. Moving Around the Worksheet
7. Working with Message and Input Boxes
8. Excel VBA Vocabulary to Filter and Sort Data
9. Working with Variables
10. Working with Statements
11. Working with Functions
12. Working with external data and SQL
13. Working with Windows and other Microsoft Programs FROM Excel

MODULE 3

1. Forms (Userforms) in VBA for Excel
2. Userforms Properties and VBA Code
3. Properties and VBA code for Command Buttons
4. Properties and VBA code for Labels
5. Properties and VBA code for Text Boxes
6. Properties and VBA code for Combo Boxes
7. Properties and VBA code for List Boxes
8. Properties and VBA code for Check Boxes, Option Buttons and Frames
9. Properties and VBA code for Spin Buttons
10. Excel Image Controls

TALLY ERP TRAINING

COURSE FEES : Rs 6000

ONE MONTH SALARY : Rs 1000 ( One Month Job With Experience letter & Attent Interviews For Jobs )

IN TOTAL YOU WILL ONLY BE PAYING : Rs 5000

ABOUT TALLY TRAINING

Building mobile apps is now an exciting career that involves most types of developers these days. So, SKMTECHNOSOLZ is launching a new course on TALLY.ERP 9 to train individuals.

Tally.ERP. Tally’s main product is its enterprise resource planning software called Tally.ERP 9 with single and multi-user licences. For large organisations with many branches, Tally.Server 9 is offered. The software handles accounting, inventory management, tax management, payroll etc.

TALLY.ERP STEP BY STEP MODULES

MODULE 1

1.Introduction
2.Types of Accounts
3.Accounting Principles or concepts
4.Mode of Accounting
5.Rules of Accounting

MODULE 2

1.Introduction of Tally.ERP 9
2.History of tally
3.Versions of tally
4.Company Features
5.Configuration
6.Getting functions with Tally.ERP9
7.Creation / setting up of Company in Tally.ERP9
8.Double entry system of book keeping

MODULE 3

1.Chart of Groups
2.Groups
3.Multiple Groups
4.Ledgers
5.Multiple Ledgers

MODULE 4

1.Stock Groups
2.Multiple Stock Groups
3.Stock Categories
4.Multiple Stock Categories
5.Units of Measure
6.Godowns
7.Stock Items

MODULE 5

1.Introduction
2.Types of Vouchers
3.Chart of Vouchers
4.Accounting Vouchers
5.Inventory Vouchers
6.Invoicing

MODULE 6

1.Bill wise details
2.Cost centers and Cost Categories
3.Multiple currencies
4.Interest calculations
5.Budget and controls
6.Scenario management
7.Bank Reconciliation

MODULE 7

1.Order Processing
2.Recorder Levels
3.Batch-wise details
4.Bill of Materials
5.Batch-Wise Details
6.Different Actual and Billed Quantities
7.Price Lists
8.Zero Valued Entries
9.Additional cost details.
10.POS

MODULE 8

1.VAT
2.Vat Reports
3.CST
4.Vat Reports
5.TDS
6.TDS Reports
7.TCS
8.TCS Reports
9.EXCISE
10.Excise Reports


BOOK A CAREER counselling SESSION

Call Or Whatsaap Us we will Give you a call back

Bhuvana S

HR Councelor

+91 748 381 1438

Sabrina Basha

HR Councelor

+91 984 518 6181

Adam Jron

HR Councelor

+91 966 766 7406

Bharat Raj

HR Councelor

+91 962 036 2620

Send us your details & we will get back to you +917483811438