Now you can Subscribe using RSS

Submit your Email

05 October 2017

Ms Excel Introduction

LAKS Tutorials

What is Excel ?

                                   
Basics of Ms Excel. Before learning MS Excel you just know what is excel ?
Excel is a software included in Ms Office package. Excel having cells those are divided by Rows and columns.Excel is also called as spread sheet program from Microsoft. Image shows the sample ms excel spread sheet.

ms-excel

The diagram show the Columns, Rows and Cell.

Basics of Ms-Excel

Excel having mainly 7 Sections

1. Ribbon.
2.Office Button
3.Formula Bar
4.Name Box
5.Zoom Bar
6.Work Book
7.Work Sheets

Ribbon:

The Ribbon section provides the all the tabs of Ms Excel sheets like Home,Insert,Page Layout,Formulas,Data,Review,View, Developer.

                     

Office Button: 

Office Button having the New,Open,Save,Save As,Print,Prepare,Send,Publish, Close of your work Book

Formula Bar:

In Formula Bar you can type or you can enter your excel formulas like, Sum,Average,V lookup all excel supported formulas

Name Box:

When enter any cell of the your work book that cell name appear in Name Box

Zoom Bar:

Zoom bar provides the you can maximise and minimise of the your workbook or spreadsheet. By using Zoom Bar.

Work Book

Another name of the excel file is work Book 

Work Sheets:

Work sheets is collection of cell where you keep the data. Each excel file contain Number of Work sheets.
ms excel basics
Conclusion: I hope you people got some information about the Basics of MS Excel.Basics of Ms Excel article explains the main parts of the excel what it contains. Laks Tutorial explains How to Open and Home Tab

09 September 2017

How to Save MS WORD | MS EXCEL |MS Power Point in PDF

LAKS Tutorials

How to Save MS-WORD or MS EXCEL and MS-POWER POINT documents in PDF

save as pdf

How to save ms office documents in PDF format. We are going to explain how to save your documents in pdf with simple steps.
  1. First check weather in your MS-Word documents save as in pdf format is available or not
  2. For checking weather saving pdf format option.You just go to your ms-office any documents and click save as button in that check pdf is available or not if available save as pdf else you just follow the procedure
Saving your Ms-Office documents in PDF format Procedure
  1. For saving ms documents in pdf format we are installing 2007 Microsoft Office Add-in: Microsoft Save as PDF or XPS
  2. Click the link for downloading the 2007 Microsoft Office Add-in: Microsoft Save as PDF or XPS http://www.microsoft.com/en-us/download/details.aspx?id=7
  3. After downloading you just install the software.
  4. Go to Your document and click on save as button there in list you got the pdf format click the pdf format and enter file name click save button your document is saved in pdf format.
  5. In the same repeat the step 3 for your M-Excel and Ms-Power Point documents

Why PDF ?

  • PDF(Portable Document Form) is mainly used for Read only documents
  • If you want to change or alter the data you want to use other electronic devices.
  • The main advantage of the PDF is security

20 July 2017

CTS Common Type System| Components of Dot Net framework

LAKS Tutorials
Most Important Component of the Dot net frame work is CTS (Common Type System). In Language specification specifies the syntactical rules. where as Cts verifies the data type.

Common Type System

In Manged code execution Dot net supports the 61 Programming languages among all these programming languages has its own data type system.
Every programming language has its own data type system, one programming language can not understand the other programming language data types system.But all the programming language data types are commonly executed by CLR. This is because of the CLR does not conatin any programming language data type or can't understand the ant other programming language data types rather CLR has its own data type system.
At the time of compilation all programming languages data types are converted CLR's data type language compiler. So CLR understand its data types.
Data type system of CLR is common to the programming languages supported by .net . This system is known as "Common Type System".
Commont Type System of CLR is Divided in to two categories. 1)Value Types, 2) Reference type.

Value Type :

The data types which are capable of storing the data directly into their memory locations are known as "Value Types". Ex: int a=10;

Reference Type:

The data types which can't store the data directly into their memory location rather reffers to other memory location were data is stored, are known as "Reference Types". Ex: String s="LAKS".

Difference Between Value types and Reference Types


Value Types Reference Type
Store the data directly into their memory location Stores the directly into their memoray locations rather refers to other memory locations where data is stored
Memory is alloted at compile time Memory is alloted at run time
memory allocation is made with in the stack Memory allocation is made with the heap
CLR  not provide the "Automatic memory management" CLR does not provide the "Automatic memory management"

Boxing and Un Boxing

Boxing :

Boxing is the process of converting a variable from "value type to reference type".

Un Boxing :

un boxing is the process of converting a variable from "reference type to value type".

16 July 2017

C ++ Introduction | Fundamentals of C++

LAKS Tutorials

Introduction of C++


C++ Programming language was developed by Bjarne Stroustrup and his team Bell Laboratories (AT &T USA) to help implement simulation projects in an object-oriented and efficient way. C ++ language was derived from C language. Here ++ is the increment operator in C.
In the year  1998 the ISO(International Organization for Standardization) approved standard for C++.

Characteristics of C++

C++ is not a purely object-oriented language but a hybrid that contains the functionality of the c programming language. Means that all the features of c language is available in C++.

  • Universally usable modular programs
  • Efficient, close to the machine programming
  • Portable programs for various platform
  • The main feature of C++ is supporting OOP (Object-Oriented-Programming)Concepts.
  • Basic concepts of Object-Oriented Programming

    It is necessary to understand some of the concepts used extensively in object-oriented programming.
  • Objects
  • Class
  • Data abstraction and encapsulation
  • Inheritance
  • Polymorphism
  • Dynamic Binding
  • Message passing

  • Advantages of OOP

    Object-Oriented programming offers several major advantages to software development.
  • Easy Re use Objects maintain themselves and can therefore be used as building blocks for other programs
  • Low maintenance requirement an object type can modify its own internal data representation without requiring changes to the application.
  • Reduced susceptibility to errors: an object control access to its own data. More specifically an object can reject erroneous access attempts.
  • 01 July 2017

    Applications of C

    LAKS Tutorials

    C language is more efficient and powerful we know that because of every where we can use c language or its features. We learn Application of C language.
    C programming is best known programming language. C programming is near to machine as well as human language so it is called as middle level programming language. C program also used to different  tasks such as networking related, OS related.

    Applications of C Programming

    1. C language is used for creating Computer Applications.
    2. Used in writing Embedded software.
    3. It is also used in developing verification software,test code for various applications and hardware products.
    4. C is used to implement different Operating System Operations.
    5. UNIX Kernel is completely developed in C Language.
    6. Firmware for various electronics,industrial and communications products which use micro controllers.
    7. For creating Compilers of different Languages which can take input from other language and applications convert into lower level machine dependent language.

    List of Applications of C Programming

    Operating Systems Language Compilers Modern Programs
    Simulators Network Drives Assemblers
    Utilities Print Spoolers Text Editors
    Language interpreters Embedded Systems Language compilers

    28 June 2017

    Components of Dot Net framework | CLS |Common Language Specification

    LAKS Tutorials

    Components of Dot net frame work. Laks Tutorial explains the components
    of Dot net frame work.
    1. CLR(Common Language Run Time)
      1. CLS (Common Language Specification)
      2. CTS (Common Type System)
      3. JIT (Just In Time Compiler)
      4. GC (Garbage Collector)
    2. Base Class Library 

    Common Language Specification

    Common Language Specification responsible to provide "Language Interoprability"

    Language Interaparability


    Providing code execution support that has been written in any other programming language is known as "Language Interoprability (LI)" Means write any program in some other languages like c,java,C#.net after writing the code will provide the execution of the code, which platform is supported for this execution that platform is known as "Language Interoporability".Language Interoparabilty is achieved by Managed Code and UnManaged Code.

    Managed Code

    The Code for which MSIL form is available after the language compiler compilation is executed directly by the CLR and is called as "Manged Code".The code execution process is called as "Manged Code Execution".
    In Manged code execution CLR will provide all the  features of .Net like Language Inseparability, Common Type System, JIT compilation.

    Un Manged Code

    Code that is developed early to dot net,for which there is no MSIL form is available is not executed directly by the CLR . Rather CLR will redirect the code to OS(Operating System ) for execution.This is called as "unmanaged code", and the code execution process is called as "un managed code execution". In UN Manged code execution CLR not provide any features of dot net like JIT compiler,CTS.

    CLS(Common Language Specification)

    Language Specification:

    Syntactical rules that we follow to write the programs in any programming language is known as Language specification. In Manged code execution process . Net supports 61 Programming languages every programming language has its own Language specification.
    Every programming language has its own language specification, one programming language can't understand the other programming language specification or syntactical rules but all these programming languages code executed by the CLR.
    CLR does not know or Can't understand any of the programming language language specification rather CLR acts its own language specification for MSIL.
    Any programming language compiler follow CLR's language specification and should generate MSIL accordingly.
    This language specification of CLR is common to all the supported dot net (61) programming languages. All Language Specification process is known as Common Language specification" in Dot net.

    09 June 2017

    B.Tech JNTU-Hyderabad Syllabus | Regulations

    LAKS Tutorials

    JNTU HYDERABAD Syllabus

    LAKS TUTORIALS provides the syllabus for the B.Tech students who are pursuing their graduation in respective colleges affiliated by the JNTU-Hyderabad.
    Jntu-Hyderabad-B.Tech Syllabus JNTU-H Syllabus for B.Tech All branches in pdf format. This collection is collected from the JNTU Hyderabad.We are uploaded B.tech R13,R15,R16 Regulations. All the Syllabus copies are updated format only.We are tried to provide all the copies of semester wise syllabus of B.tech. If we miss any of them please provide the comment below we update that as early as possible.The list of syllabus copies of B.tech with their regulations for easy understanding.All the students and faculty also who wants the syllabus copies of JNTU Hyderabad B.tech can be available in LAKS TUTORIAL website. 
    Laks Tutorial provides the syllabus for the R16 Regulation(who are joined in 2016-2017).We will add missing regulations and branches with in short time only.

    S.No Title
    1 R16 B.Tech.II year syllabus - COMPUTER SCIENCE ENGG
    2 R16 B.Tech.II year syllabus - INFORMATION TECHNOLOGY
    3 R16 B.Tech.II year syllabus - ELECTRICAL AND ELECTRONICS ENGG
    4 R16 B.Tech.II year syllabus - CIVIL AND ENVIRONMENTAL
    5 R16 B.Tech.II year syllabus - CIVIL ENGG
    6 R16 B.Tech.II year syllabus - ELECTRONICS AND COMMUNICATION ENGG
    7 R16 B.Tech.II year syllabus - ELECTRONICS AND COMPUTER ENGG
    8 R16 B.Tech.II year syllabus - MECHANICAL ENGG
    9 R16 B.Tech.II year syllabus - AERONAUTICAL ENGG
    10 R13 B.Tech.III-I year syllabus - COMPUTER SCIENCE ENGG
    11 R13 B.Tech.III-I year syllabus - INFORMATION TECHNOLOGY


    14 April 2017

    Installation of oracle | Database

    LAKS Tutorials

    Installation Oracle 10g In Windows7


    Installing oracle database we have to download the setup file of oracle for that download the Oracle latest version from oracle https://www.oracle.com/downloads/index.html After downloading the setup file of Oracle.Open the setup file for installing.
    installation of oralce
    Installation of Oracle
                                                     

    Installation procedure for Oracle

    1. Click on the setup file
    2. Oracle Setup file
      Oracle Setup File
                                                
    3. Click Next
    4. Click on Accept the terms and conditions
    5. Click Next
    6. Enter password for installation(password is your wish)
    7. Oracle passowrd
      Oracle-Password 
                                                   
    8. Click on Install
    9. Click on Finsih
    Completion of the steps as mentioned in the installation procedure,oracle creates a short cut named as Get Started With Oracle Database 10g Express Edition
    Oracle short cut key
    oracle short cut key
                                                                
    click on it it will open the oracle Home page in Your system default browser.It is asking Username and Password for that You enter Username is system, password is at the time of installation what you gave that password enter then click submit it will opens your oracle server installed in your computer.
    Completion of installation must and should set the path for the oracle in environment variables.

    Path Setting for the Oracle

    1. Goto My computer Click with right mouse button click on properties it will open the new window like
      environment variable
      environment variable
                                                         
    2. Click on Advanced system settings again new window will open from that window click Environment variables
    3. After clicking the Environment variables it will open the new window
      system variable
      system variable
                                                             
    4. In that under system variables check if the ORACLE_PATH is available no need to set else you have set that by clicking New opens a new window like
      system variable
      system variable
                                                        
      Here you type variable name as ORACLE_PATH and variable value is where your installed oracle that location up to bin folder (Example:C:\oraclexe\app\oracle\product\10.2.0\server\BIN;) after entering that click ok.
    5. In the same way under system variable edit or create new path same instead of ORACLE_PATH type path and value is same then click ok
    6. click ok again.
    All the steps done correctly your installation and path setting is completed successfully in your computer or laptop.

    Coprights @ 2016, Blogger Templates Designed By Templateism | Templatelib