1997 To 2009 - Salang Nokri Gantari Mate ni Excel File


Microsoft Excel is a spreadsheet program. It has calculation tools, graphs, pivot tables, and a macro programming language called Visual Basic for applications. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and has replaced Lotus 1-2-3 as the industry standard for spreadsheets. Excel program is part of the MS Office software package.

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

1997 To 2009 - Salang Nokri Gantari Mate ni Excel File

It has a programming aspect, Visual Basic for Applications, that allows the user to employ a wide variety of numerical methods, for example, to solve differential equations of mathematical physics and then report the results to the spreadsheet. It also has a variety of interactive features that allow user interfaces that can completely hide the spreadsheet from the user, so the spreadsheet is presented as a so-called application or decision support system, through a Custom-designed user interface, for example, a stock analyzer, or generally, as a design tool that asks questions of the user and provides answers and reports.

In a more elaborate embodiment, an Excel application can automatically poll external databases and measuring instruments using an updated schedule, analyze the results, make a Word report or a PowerPoint slide show, and send these presentations. by regular email to a list of participants. Microsoft allows a number of optional command-line switches to control how Excel starts.

The Excel version of Windows supports programming through Visual Basic for Microsoft Applications, which is a Visual Basic dialect. VBA programming allows for spreadsheet manipulation that is cumbersome or impossible with standard spreadsheet techniques. Programmers can write code directly using the Visual Basic Editor, which includes a window for writing code, debugging code, and code module organization environment. The user can implement numerical methods, as well as automate tasks such as formatting or organizing data in VBA and guide the calculation using the desired intermediate results reported to the spreadsheet.

VBA was removed from Mac Excel 2008 as the developers did not believe that a timely release would allow the VBA engine to be ported natively to Mac OS X. VBA was restored in the next release, Mac Excel 2011, although the build lacks support for ActiveX objects, impacting some high-level developer tools.

Macro Recorder records user actions and generates VBA code in macro form. These actions can be automatically repeated by running the macro. Macros can also be linked to different types of triggers, such as keyboard shortcuts, a command button, or a graph. Actions in the macro can be executed from these trigger types or from the generic options on the toolbar. The VBA code for the macro can also be edited in the VBE.

Certain features, such as loop functions and screen prompting for their own properties, and some graphic display elements, cannot be recorded but must be entered directly into the VBA module by the developer. Advanced users can use user prompts to create an interactive program or react to events such as loading or changing sheets.

Recorded macro code may not be compatible with versions of Excel. Some codes that are used in Excel 2010 cannot be used in Excel 2003. Making a macro that changes the colors of the cells and making changes to other aspects of the cells may not be compatible with previous versions.

VBA code interacts with the spreadsheet through the Excel Object Model, a vocabulary that identifies the objects in the spreadsheet, and a set of supplied functions or methods that allow you to read and write to the spreadsheet and interact with its users. User-created VBA subroutines execute these actions and work like macros generated with the macro recorder, but they are more flexible and efficient.