Course Details

Advanced Excel with Office 365

4.8
office automation Computer Training

Objective


After going through this lesson, you would be able to:

  • Explain basic organization of computer system
  • Explain different types of input and output devise
  • Define software and its classification
  • Distinguish between system software and application software
  • Describe computer language and its classification
  • What is a computer? Computer is a device that transforms data into meaningful information. Data can be anything like marks to receive as return for effort by you in various subjects. It can also be name, age, sexual union involving penetration of the vagina by the penis, weight, height, etc. of all the students in class


    Overview


    In this assignment we present an overview of the basic design of a computer system how the different part of a computer system is organized and various operation performed to perform a specific method. You would have observed that instructions have to be fed into the computer in a systematized order to perform a specific method. Computer members are divided into two major categories, namely, hardware and software. In this lesson we will discuss about hardware, i.e., the machine itself and its connected devices such as monitor, keyboard, mouse etc., as well as software that makes use of hardware for performing various functions.


    Career Opportunities:

    • BASICS OF COMPUTER
    • OPERATING SYSTEM
    • BASICS OF WORD PROCESSING
    • FORMATTING DOCUMENTS
    • MAIL MERGE
    • BASICS OF SPREADSHEET
    • FORMATTING WORKSHEETS
    • FORMULAS, FUNCTIONS AND CHART
    • CREATING PRESENTATION
    • INTRODUCTION TO INTERNET

    BASICS OF COMPUTER


      Computer is an electronic device which takes raw data (input) from the user and processes through set of instructions (called program) and gives the result (output).
    • Computer can process both numerical and non-numerical (arithmetic and logical) calculations.
    • Computer was invented by Charles Babbage.
    • The brain of computer is called Central Processing Unit (CPU).
    • Central Processing unit has 3 major parts: Memory Unit, Control Unit and Arithmetic Logic Unit.

    OPERATING SYSTEM


      An operating system (OS) acts as a bridge between user and computer hardware. OS is a resource allocator and manages all resources.
    • Windows is graphical operating system developed by Microsoft.
    • Examples of Windows OS- windows 7, windows 8, windows XP and windows 10 etc.
    • Icon is a small graphical representation of program or file.
    • An icon (file/folder/application program) can be opened by doubleclicking or right click on icon and select open option.

    BASICS OF WORD PROCESSING


      MS-WORD: It is an application component of MS-Office which is used to do document, brochure, invitation and book preparation. It enables us to prepare, modify, design and edit the desired documents. This application in MS-Office made our life easy in day to day documentation work.

    FORMATTING DOCUMENTS


      FORMATTING: It refers to the arrangement of the content in an organized way.
    • It addresses things like font selection, font size and presentation.
    • Presentation of a document includes formatting like spacing, margins, font style, indentation and creation of lists.
    • You can type text in text area. To change to separate paragraph press Enter.
    • You can enter text in existing document also. Using arrows present in keyboard or with the help of mouse you can place cursor as per your requirement.

    MAIL MERGE


      MAIL MERGE: It can be used to create personalized messages automatically for documents such as:
    • Marketing emails
    • Envelopes
    • Mailing labels
    • Newsletters
    • Custom catalogues
    • Form letters and more!

    BASICS OF SPREADSHEET


    • Spreadsheet is also known as Worksheet.
    • When you open MS-Excel, you are opening a workbook.
    • A workbook contains number of worksheets.
    • Examples of Spreadsheet: MSExcel, Lotus 1-2-3(discontinued), Google Sheet, Lotus symphony etc.

    FORMATTING WORKSHEETS


      Formatting tools
    • In the Home tab
    • In the mini toolbar (It appears when you right click on a cell)
    • In the Format cell dialog box
    • Home Tab: Select Home tab, here you can do formatting of text, cells or worksheet. Mini Toolbar: Using mini toolbar you can do common formatting as
    • Font Type
    • Font Size
    • Accounting Number Format
    • Comma Format
    • Font Colour
    • Format Painter
    • Borders
    • Fill Colours & many more

    FORMULAS, FUNCTIONS AND CHART


    Functions Defined
    =sum() Returns the Sum of the selected cells
    =Average() Returns the Average of the selected cells
    =Max() Returns the Highest value of the selected cells
    =Min() Returns the Lowest value of the selected cells
    =Count() Returns the number of values of the selected cells

    CREATING PRESENTATION


    • Ribbon: An area across the top of the screen that makes almost all the capabilities ofPowerPoint available in a single area.
    • Tab: An area on the Ribbon that contains buttons organized in groups. The default tabs are Home, Insert, Design, Animations, Slide Show, Review and View.
    • Quick Access Tool Bar: A customizable tool bar at the top of an active document. By default the Quick Access Tool Bar displays the Save, Undo and Repeat buttons and is used for easy access to frequently used commands.
    • Title Bar: A horizontal bar at the top of an active document. This bar displays the name of the presentation and application. At the right end of the Title Bar Minimize, Restore and Close button appears.

    INTRODUCTION TO INTERNET


    • Internet: It is an inter-connection of large and smallnetworks around the globe.

    One to One Training

    Software Provided