Basic Computer Classes In Malleshwaram

Computer Class In Malleshwaram , Basic Computers In Malleshwaram

MS WORD

CADD Nest Best MS Word Training

MS Word computer course in CADD Nest institution gives you the advantage of learning from the beginning to gain deep knowledge about basic computer skills. Only if you know the basic operational techniques you can develop them further and study other complex applications of software. Using computer applications can explore how to make impressive presentations using slide shares and construct reports effectively.

Best MS Word Training in CADD Nest

In this digitalized world, learning Ms word in computer abilities is crucial to surviving for any individual. Our’s is one of the best computer training centre To stay updated with the emerging trends and to expand your possibilities, learn basic essential computer knowledge from CADD Nest ,who provides best basics of computer training

Why Study Excel in CADD Nest computer institution

Getting the best Excel Training in CADD Nest.

CADD Nest Institution helps you to develop new skills and better knowledge that are vital for your work areas.MS Word It is the most commonly used word processor software it is a component of the Microsoft Office suite, but you can buy it separately and is available for both Windows. The latest version of Ms Word is 2021.

MS Word Used to make professional-quality documents, letters, reports, mailing label, product packaging, resume, invoice, postcard, business card, receipt, newspaper, catalog etc., It has advanced features which allow you to format and edit your files and documents in the best possible way…

There are also many personal uses of MS Word. Here are just a few:

invitation
card
gift tag
recipe card
place card
certificates

Word contents

Creating, editing, saving and printing text documents
- Entering text in a document
- Previewing a document
- Saving a document
- Creating a folder
- Printing a document
- Closing a document and exiting Word

Font and paragraph formatting
- Select text
- Undo and redo commands
- Use drag and drop to move text
- Copy, cut and paste Use the clipboard
- Clear formatting
- align text
- Line and paragraph spacing
- bulleted and numbered lists
- borders and shading
Simple character formatting

Inserting Elements to Word Documents
- Inserting tables, smart art, page breaks, using shapes, inserting Clipart and pictures, inserting header& footer, inserting page numbers, using text box, inserting symbols, inserting date and time

Working with tables
- Inserting tables
- Draw tables
- Excel Spreadsheet
- Quick tables
- Convert a table to text
- Resize parts of a table
- Align text in a table
- Insert columns and rows
- Borders and shading
- Merge table cells
- Split Cells
- Delete Columns and rows
Working with Columned Layouts &Section Breaks
- Columns
- Section breaks
- Creating columns
- Newsletter style columns
- Changing part of a document layout or formatting
- Remove section break
- Add columns to remainder of a document
- Column widths
- Adjust column spacing
- Insert manual column break
- Remove section break
- Add Columns to Remainder of a document
- Column width
- Adjust column spacing
- Insert manual column break

Changing the Layout of a Document
- page margins
- change page orientation
- Headers and footers.
- change indentations
- Insert and clear tabs.
- Align Document
- Change Size
- Use Line Numbers
- Page Break
Reviewing Document Editing and Proofing Tools
- Spell and grammar checking
- Changing language
- Using comments and inserting comments
- Tracking documents
- Using Restrict Editing’s
- Find and replace text
- Use the Research Task pane
- Document views
- Shortcut Menus
Using a template
Using mail merge
Using macros

MS Excel

CADD Nest Best MS Excel Training

CADD Nest provides Best Excel Training. Excel facilitates you with a hassle-free data organizing structure for value enhancement. It comprises excel spread sheets that allow employers to calculate, organize and manipulate data. Since the world is generating a copious number of data every minute, studying cutting-edge excel from our best advanced excel training in CADD Nest is going to open rewarding job opportunities for you.

Using a spread sheet system. This software is part of the Microsoft Office suite and is compatible with other applications in the Office suite. Like other Microsoft Office products, it is an electronically data base system management.

Why Study Excel in CADD Nest computer institution

Getting the best Excel Training in CADD Nest.

CADD Nest Institution helps you to develop new skills and better knowledge that are vital for your work areas. It can maximize your productivity, as you can single-handedly manage the data and complex calculations. Raw data is difficult to understand, but through advanced excel, you can easily complete your chores within no time. It will save your time and workload and optimize your accuracy. It makes you a desirable candidate with multiple and relevant skills.

MS Excel is a commercial spread sheet application that is produced and distributed by Microsoft for Microsoft Windows operating systems. It features the ability to perform basic calculations, use graphing tools, create pivot tables and create macros, among other useful features.

Spread sheet applications such as MS Excel use a collection of cells arranged into rows and columns to organize and manipulate data. They can also display data as charts, histograms and line graphs.

This software is part of the Microsoft Office suite and is compatible with other applications in the Office suite. Like other Microsoft Office products, it is an electronically data base system management.

Excel contents

Spreadsheet basics
Creating, editing, saving and printing spreadsheets
Working with functions & formulas
Modifying worksheets with color & auto formats
Graphically representing data: Charts & Graphs
Speeding data entry: Using Data Forms
Creating marks report
Formatting worksheets
Securing & Protecting spreadsheet
Creating salary sleep
Creating Balance sheet

MS power point

Why take power point Course in CADD Nest institution

CADD Nest institution gives you the advantage of learning from the beginning to gain deep knowledge about basic computer skills. As a presentation tool PowerPoint can be used to organize and structure your presentations, create a professional and consistent format, provide an illustrative backdrop for the content of your presentation, and animate your slides to give them greater visual impact.

Best MS Power Point Training in CADD Nest

In this digitalized world, learning basic computer abilities is crucial to surviving for any individual. Our’s is one of the best computer training centre To stay updated with the emerging trends and to expand your possibilities, learn basic essential computer knowledge from CADD Nest ,who provides best basics of computer training.

Power point contents

Opening, viewing, creating, and printing slides
Add new slides to a presentation.
Inserting pictures, shapes, SmartArt and tables
Add sound and video to a slide presentation.
Applying auto layouts
Adding custom animation
Using slide transitions
Graphically representing data: Charts & Graphs
Creating Professional Slide for Presentation
Display a speaker-lead and self-running presentation

Why take Basic Computer Course (DOM) Diploma in Office Management Course in CADD Nest

basic computer courses in CADD Nest institution gives you the advantage of learning from the beginning to gain deep knowledge about basic computer skills. Only if you know the basic operational techniques you can develop them further and study other complex applications of software. Using computer applications can explore how to make impressive presentations using slide shares and construct reports effectively.

DOM (DIPLOMA IN OFFICE MANAGEMENT)

The Computer Applications and Office Management degree and certificate programs are designed to provide students with the computer application and office administration skills required for employment in a wide variety of fields

Best Basics of Computer Training in CADD Nest

Our basic computer course covers all the basic concepts that you need to know as a budding professional. Both fresher’s and professionals who wish to learn the nuances of the technology in our centre for basic computer. We enable you with a smooth learning experience and have flexible learning hours.

The option to choose weekdays or working days lies up to your choice. This is a beginner’s course, so we commence the course with the basics of computers like the parts and different types of the computer to familiarize from the elementary. Then, you will learn about Operating computers, Windows 10, application software, the internet, Browsing, emails, fundamentals of computers, Ms office tools word, excel, power point and so on.

DOM Contents

Keyboard Instruction

Typing
- Type Faster
- Typing Master
Kannada Typing
- Nudi 6.1

Computer Fundamentals
Generations of Computer

Windows
- Notepad
- WordPad
- MS Paint
- Calculator
- Date and Time Properties
- Control Panel
Word
- Home
- Insert
- Page Layout
- References
- Mailings
- Review
- View
- Developer
- Project Related to word

S Excel
- Excel Introduction
- Working with Formulas
- Creating Salary Slip
- Creating Marks Report
- Creating Balance Sheet
- Project Related to Excel
S PowerPoint
- PowerPoint\Assignment

Internet Concept\Computer Networks
Abbreviations

Best Tally Prime Course in CADD Nest

Tally Prime is one of the most prevalent courses to pursue in India. This accounting software is primarily employed in small and medium enterprises. If you wish to learn a secured and pertinent course of the modern digital world, then learn with CADD Nest

Why study Tally prime course in CADD Nest

Tally Prime helps you to manage your business simpler. It is an ideal of GST software with customizable functions and control. It lets you engage in more professional financial-related talks and improves your productivity. Even though the tool Tally Prime is simple in its look, it proposes complex solutions that are essential for you as an accountant. Studying this vocation will make you a master in the field and enables you to stand out in the crowd. It covers manufacturing, costing, payroll, accounting, finance, inventory, sales, and many more areas.

TALLY PRIME

Introduction to TALLY PRIME
- How to Setup TALLY PRIME?
- Fundamentals Accounting Principal and Concepts
- Why Accounting Principle Important?
- Basic Concept of Accounting
- Golden rules of Accounting
- Financial Accounting
- Shortcut keys in TALLY PRIME
- Hidden Keys – Across TALLY PRIME
- Hidden Keys—Vouchers
- Other Keyboard Shortcuts
Company Info
- Create, Shut, Edit, Close Company
- Restore and Backup
- Security
- Import DATA
- Import MASTER
- Export DATA
Introduction to Gateway of TALLY
- Ledger Creation
- Voucher Types
- Accounting Vouchers
- Payment
- Receipt
- Contra
- Service Tax
Transactions
- Single Entry
- Double Entry
  - Project 1-Assignment 1(single Entry)
  - Project 1-Assignment 2(double Entry)
- Cost Centers & Cost Category
  - Project 2-Assignment 1(Double Entry)
  - Project 2- Assignment 2(Double Entry)

Professional Tax
- Project 3-Assignment 1(Double Entry)
- Project 3-Assignment 2(Double Entry)

Budget Creation
- Project 4- Assignment 1
- Project 5-Assignment 2

Purchase order and Sales Order
Receipt Note and Delivery Note
Debit and Credit note
Payroll
Godown Creation
Stock Item Creation
Company Configuration

Taxation
- TDS (Tax Deducted @ Source)
- TCS (Tax Collected @ Source)

GST (GOODS AND SERVICE TAX)
- Voucher Entry Creation
- GST Entry and Auto Collection
- e-Way bill in TALLY PRIME

Bank Reconciliation Statement (BRS)
- Bank Charged and commission Charged by the bank
- Direct Payment through Bank
- Direct payment into Bank by a Customer
- Interest and dividend Collected by Bank

Export DATA in TALLY PRIME

Multicurrency in TALLY PRIME

E-mail| using Gmail, Yahoo, outlook to send Invoices, Receipt, Reports, and Reminder Letters

Best Advance Excel Training

CADD Nest provides Best Advance Excel Training. Excel facilitates you with a hassle-free data organizing structure for value enhancement. It comprises excel spreadsheets that allow employers to calculate, organize and manipulate data. Since the world is generating a copious number of data every minute, studying cutting-edge excel from our best advanced excel training in CADD Nest is going to open rewarding job opportunities for you.

using a spread sheet system. This software is part of the Microsoft Office suite and is compatible with other applications in the Office suite. Like other Microsoft Office products, it is an electronically data base system management.

Why Study Advance Excel

Getting the best Advance Excel Training in CADD Nest.

Spread sheet applications such as MS Excel use a collection of cells arranged into rows and columns to organize and manipulate data. They can also display data as charts, histograms and line graphs.

Advance Excel Training in CADD Nest Institution Course Details

Advance Excel Course Contents

Excel Introduction
- Application of Ms Excel
- Excel Workbooks and Worksheets
- Entering And Editing Worksheet Data
Customizing common option in excel
- Customizing the Ribbon
- Using and Customizing AutoCorrect
- Changing Excel’s Default Option
Protecting and unprotecting worksheet and cells

Functions working with Formulas
Mathematical Functions
- Sum, Sumif, Sumifs, Sumproduct, Sumsq, Sumx2my2, Sumx2py2,Sumxmy2
- Count, Counta, Countif, Countifs, Countblank
- Average, Averagea, Averageif, Averageifs
- Dsum,Dmin,Dmax,Dmin,Daverage,Dproduct
Logical Functions
- IF,AND,OR,NESTEDIF,NOT,TRUE,FALSE,XOR,IFERROR
Financial Functions
- PV,FV,PMT,PPMT,IPMT,NPV,RATE,NPER,ISPMT
Text Function
- length function
- right Function
- left function
- mid function
- substitute function
- proper function
- rept function
- concatenate function
- choose function
- char function
- search function
- value function
- bhattext function
- code function
- trim function
- upper
- lower function
Date and Time Function
- Date,Datevalue,Day,Datedif,Days360,Edate,Eomonth,Month,Hour,Minitue,S-econd,Networkdays,Networkdays.Intl,Now,Time,Timeva-lue,Weekday,Weeknum,Workday,Yearfrac,Year,Today

Formatting and Proofing
- Currency Format
- Format Painter
- Formatting Dates
- Custom and Special Formats
- Formatting Cells with Number formats, Font formats, Alignment, Borders, etc
- Basic conditional formatting
Lookup and reference
- V Lookup and H Lookup
- Multi sheet lookup
- Multi workbook lookup
- Dynamic update lookup
- Lookup and if error
- Double V Lookup
- V Lookup Exact match With N/A
- V Lookup VS Exact Match Function
- V Lookup using Choose Function
- Worksheet using Indirect Function
- V Lookup Using Column Function
- V Lookup Using Concatenate Function
Basic Chart
- column chart/bar chart
- line chart
- pie
- area
- scatter
- tree ,map and waterfall
- combo chart
- histogram
- radar
- bubble
- surface
- doughnut
- stock
Pivot Table and Pivot Chart
- Creating basic pivot table
- Creating pivot chart
- Creating advance pivot table
- Modifying pivot table data
- Filtering pivot tables
- Grouping and ungrouping Data
- Pivot table using Array Function
- Pivot table using Option
- Pivot table using slicers
- Pivot table using Sparkline
- Pivot table using concatenate function
- Pivot table using various Time Line
- Pivot table using Field, Item and sets
- Pivot table using 3D map
- Quick analysis tool
- Manage primary and secondary Axis
- Auto complete a data range and list
- Managing MIS Report
Sort and Filter
Sort
- Sort A to Z
- Sort Z to A
- Using Custom Sort
Filter
- Filter by selected Cell value
- Filter by selected Cell Color
- Filter by selected Cell Font Color
- Filter by selected Cell Icon
Advance Filter Using Different Criteria

What If Analysis
- Scenario manager
- Goal Seek
- Data Table
- Solving Tool
Cell Reference
- Relative reference
- Absolute reference
- Mixed reference
- 3D reference
Data Validation
- Number, Date & Time Validation
- Text and List Validation
- Custom validations based on formula for a cell
- Dynamic Dropdown List Creation using Data Validation – Dependency List
Printing Workbooks
- Setting Up Print Area
- Customizing Headers & Footers
- Designing the structure of a template
- Print Titles –Repeat Rows / Columns
Macros In Excel

Creating Dashboard In Excel

Project Based on Topics

Latest Update