Basic Diploma in Computer Application

IF you want to take #Advance Basic Coaching & Diploma in Computer Application then #Chandigarh Computer Centre is the best name in #Patiala. Where you will get the best and complete coaching about Advance Basics
MS WORD
KEYBOARD
Alphabetic Keys,Number Keys,Symbolic Keys,Special Keys (Backspace, Enter, Cursor, Tab, Shift, Home, End, Delete etc.),Function Keys F1 to F12
Customize Tools
Home tools
Clipboard, Font, Paragraphs, Editing (find, replace)
Insert
Pages,Tables, Illustrations (pictures, shapes charts, screenshot),Links (Hyperlink, bookmark)
Header and Footer and Page Number, Text, symbols
PAGELAYOUT
Themes, color themes,Page Setup (Margins, Orientation, Size, Columns, Breaks ),Page Background (Watermarks, Page Border)
References
Table of Contents, Manage Sources
Mailings
Envelopes,Labels,Mailings (Offline Mails) 1 application and addresses are different
Review
Proofing,Comments Details,Protect Document (lock the file, encrypt with password file)
View
Document Views,Show (ruler, gridlines and navigation pane),Switch Windows and view Side by Side Macros
Shortcut Keys all are provided

Microsoft Excel
Excel is a Workbook and is a mathematical formula functions +, - * / % etc
1 workbook is a Spreadsheet,Spreadsheet is also known as inbuilt Column and Rows,Single Column and Single Rows are Cell Address,Cell Address ( to intersection of Column and row)
Operation and functions in Ms Excel
Drag and Drop,Move,Inside the selected Cell,Increase or Decrease the height and width of Rows and Columns,Numbers Drag, Date, time Weeks, Months etc
First of all We are put the Formulas
Sum, Percentage, Grades, sum, maximum, minimum, average, count, subtract, multiply these are simple formulas
Advance formulas
2 type of Product List, 3 Types of Salary List,Upper, Lower, Proper, Sumif , Count if , Transfer list (Sheet1!a1), Concatenate, HLookup, Vlookup, Round (up and down) and ASAP Utilities of office 2007 software etc,Define Names, Formula Auditing
Data
Get external Data, Sort and Filter, Data Tools, Outline
Protect Workbook
3 Types of Workbook,2 columns lock ,Single sheet lock and lock the file and encrypt the password file
View
Workbook Views ,Show Zoom, Windows, Macros
Insert
Pivot Table,Data Chart,Hyperlink etc
Home and Pagelayout
Font, Alignment, Number, Styles, Cells, Editing, Themes, Pagesetup, Scale to fit,
Shortcut keys all are provided
MICROSOFT POWERPOINT
Powerpoint is a Number Slide Presentation,Slide Layout (create the different Types of Layout),Change Layout,Cut and Paste the Slides and Materials (Pictures, Shapes, Charts),Copy and Paste the Slides and Materials(Pictures, Shapes, Charts),Duplicate Selected Slides , Reuse Slides,Font and Paragraphs the Slides of the Materials,Create the tables in Powerpoint, Shapes, Pictures, Chart, Word art etc ,Header and Footer, Date and Time , Slide Number,Different Types of Design and Background, Format Background etc,Create the Animation of the Shapes, Pictures, Charts, matters, Tables etc,And After that different different Slides of Transitions Latest ,Timing Effects,Slide Show (custom Slide show, rehearse timings etc),Hyperlinks to the 1st slide to link the second slide another another
Microsoft Access
Access is a Database File. Data is used to unorganized facts or figures which we are recorded in computer is called data. Database is a basement of the data (Heading and Records) (2 types of heading (Field Name, Data Structure), Records: Each Student will be record of the Data. Database File, Two types of views
Datasheet view (Heading and Records) to show the only columns
Design Veiw Only Headings to display the only Rows etc
Records,(cut and paste the records, copy and Paste the Records), New Records, Save.Data table (copy, cut, rename, delete),Filter, Ascending and descending order, Create Table, Table Design,Query (one to one Relation Ship and One to many relationships) etc,Forms, Reports etc,Import the data (Excel, Access, Text), Export the Data(Word, Excel, Access)
For more information Please Contact_Us:-Chandigarh Computer Centre, Patiala, SCO- 49, Leela Bhawan Market, Patiala, Punjab @9988910115,9780353335, 0175-2222723