Android Mobile Applications

  • Android Mobile Applications
    1. Make a Start with Excel
      First Look at excel. Excel rows and Columns Enter text and number in the cell. How to edit text in a cell. How to centre text and number in the cell. Fonts formatting in excel 2007. How to change the colour of cell. How to save your word in excel. Currency symbol in excel. How to merge cell. Review number one.
      A more complex spreadsheet
      How to use the auto fill in excel. Entering simple addition formula. The sum function in excel. The sum function continued. Copy and paste. How to use paste special. How to multiply in excel. Finishing your spreadsheet for this section. How to add comments to a cell. Review number two.
      Excel 2007 Charts
      How to sort data in excel. Create an excel chart. Move and resize your chart. Charts styles and layouts. Charts title and series titles. Chart layout panel in excel 2007. The format chart panel. Create a pie chart in excel. Add labels to a pie charts Format pie chart segments. Create a 2D line chart in excel. Format your axis titles.
      Formulas in Excel 2007
      The sum function. How to multiply in excel 2007. Subtract and divide. Combination and arithmetic operations. A budget spreadsheet.
      Functions in Excel 2007
      The average function. The data function. Time function in excel. A time table project. Financial functions. The students average projects.
      Conditional Logic in Excel
      The IF Function. Conditional Formatting in excel 2007. Count IF. Sum IF.
      Processing Data in Excel
      Data table in excel 2007. A second data table. Excel scenario. Goal seek. Absolute cell references. Named ranges in excel 2007. Create a custom name in excel. Excel pivot charts. Pivot tables part two. The LOOKUP function. The VLOOKUP function in excel.
      Advanced Excel 2007
      How to create an excel template. Data forms in excel 2007. Drop down lists in excel 2007. Add your own error messages. Excel and web interaction. Hyperlinks in excel 2007. Object linking and embedding. Reference other worksheets. Insert drawing objects.
      DURATION : 15 days

Welcome To Indian Institute of Software Technology

Indian Institute of Software Technology was founded in 2000 by a group of highly Qualified Technocrats as a center of education, training and software development at Delhi.

We are leading training institute with a mission to provide comprehensive and accurate training information to all prospective value conscious training buyers for any domain. Our business is dedicated to delivering good quality, inexpensive services that will prove the quality of work at all level in an organization. We strongly believe in “Business goes where it is invited and stays where it is well treated”.