Microsoft office excell

 

 This program is one of the important software for office, as it serves to solve the problems that involve numbers. In the basic step of Microsoft Excel, firstly, I learnt about basic cells that cell content use to calculate, analyze and organize data. You can select and delete cells, insert content and cell content and also copy, cut, paste, drag, drop and fill cell using the fill handle. And then, you can modify and format columns, rows and cell. Secondly, you can create simple and complex formulas and working with basic functions, sorting, outlining, filtering data and formatting tables and finally you can save and print the worksheet.

Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display. It allows sectioning of data to view its dependencies on various factors for different perspectives (using pivot tables and the scenario manager

In advanced session, you need to use Sparkline; that is miniature charts that fir into a single cell and place a large number of them in your worksheets. It has three types of Sparkline such as line, columns and win/lose line. And then, Pivot Tables that makes the data in worksheets much more manageable by summarizing the data and allowing user to manipulate in different ways. The one is working with chart and track changes. All of these features are allowed to organize data, complete calculations, make decision, graph data and develop report.